Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Still No Remote Access - Connectivity Problem in sqlserver 2005 EE and vs 2008

Even After successfull Installation of the two Techno's and successfull availability of server name in the "connecting to server" dialog box of the Sql Server Management Studio- Still YOu need to Make somechanges in the settings to get Going.

When in vs 2008 you make a connection to the database you created in the sql server management studio-You are able to get the "Connection String" successfully- and you use the connection string in the programming to connect to database.
But when you debug the page an error occurs:- Microsoft SQL Native Client: An error has occurred while establishing a connection to the server.
This means that sql server is not allowing remote connections.

Now i will tell you the complete settings that you need to perform to get your sql server and vs2008 working together.

1. Open the " sql server configuration manager" from the configuration tools in the sql server 2005 under programs of your start menu.
2. click on sql server 2005 network configuration; click on protocols for sql express; enable tcp/ip and named pipes in the right panel.
3. Now open " sql server surface area configuration" from the configuration tools in the samelist; click on the surface area configuration for services and connections; in the left panel click on the "remote connections-under the database engine head"; see the changed display in the right panel-click on the "local and remote connection" radio button and then click on "using both tcp/ip and name pipes"- radio button.
Again in the left panel click on the sqlserver browser; see the changed display in the right panel; in the "startup type"- choose : "automatic" which was earlier set to "disabled". Click on stop to stop the service and then click on start to start the service so that all settings are taken up and refreshed.


Still all in not well!!!

4. Now you have to set your firewall settings in exception for sqlserver and sqlbrowser.

To do that:
5. type "firewall.cpl" in the run available in your windows strat menu.
click on the "exception" tab and then click on "add program"- browse for sql server and sql browser; normally the address for these two are:C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe    ,      C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe    respectively depending on the name of the server. If not you have to browse to the location.
Allow exceptions by clicking on the square boxes for these two programs and clicking ok.

Now everything's done. Congratulations your "vs 2008 and sqlserver2005 is ready with full features, services and connectivity"







DisclaimerThis site is not intended to replace professional opinion or recommendation. Its content are provided “as is” and without any liability for any damage or loss whatsoever related to this Blog’s use. The Logos, Trademarks and Graphics used in this Blog are solely the property of their respective owners. TechMyQuery doesn't in any way claim any representation neither is endorsed to promote any entity. 


This post first appeared on TechMyQuery, please read the originial post: here

Share the post

Still No Remote Access - Connectivity Problem in sqlserver 2005 EE and vs 2008

×

Subscribe to Techmyquery

Get updates delivered right to your inbox!

Thank you for your subscription

×