When I tried to connect MSSQL server 2008 from Visual studio express 2012 web, it always return an error : "A network-related or instance-specific error occurred while establishing a connection to SQL server".
To solve the problem, go to start menu and search Services.
Run it and find "SQL Server Browser", change the Startup Type from "Disabled" to "Automatic" (if you don't know, right click on the item and choose properties).
After that Start the service(Right click and click start). The result should be same as below.
I also changed the startup type for "Sql Server Agent" from "Disabled" to "Automatic".
And try again the connection at visual studio.
If didn't works, try ask google. :D
After that Start the service(Right click and click start). The result should be same as below.
I also changed the startup type for "Sql Server Agent" from "Disabled" to "Automatic".
And try again the connection at visual studio.
If didn't works, try ask google. :D
_________________________________________________________________
_________________________________________________________________
No comments:
Post a Comment