Visual Studio 2008 Connection to SQL Server 2008
Posted on 2010-04-04
Using Visual Studio 2008 Server Explorer I don't see SQL Server 2008 instance when I try to Add a New Data Source connection. I see a SQL Express instance but not the MSSQLServer instance. I can see and access databases using SQL Management Studio -- no problem. Visual Studio Add Connection wizard doesn's show it and I have tried Refresh. [Whu does ot see SQL Express if that servce is stopped.]
Visual Studio 2008 was installed first (after Microsoft Office 2007) and then SQL Server 2008 installation was successful. I assume SQL Express instance was added by Visual Studio. SQLExpress service is stopped; MSSQLServer and SQL Browser are both Started.
Beginning to expect my installation order was wrong but I didn't see any errors or problems.