Saturday, August 3, 2013

Can' Connect to SQL Server 2008 R2 Advanced Services

Network should not be the problem, right.


Is the instance actually running?


Check Services in the already mentioned "SQL Server Configuration Manager" for the state. If stopped, then Start.


Also, if the Instance name is any other than MSSQLSERVER, and I would assume, since this is an Express Version, that it might well me something like <ComputerName\EXPRESS>, then this as, what you have to enter in the Servername-box.


You may also just use the drop down, and it will list all running instances on your local computer.




Andreas Wolter | Microsoft Certified Master SQL Server


Blog: www.insidesql.org/blogs/andreaswolter


No comments:

Post a Comment