How to Configure SQL Server 2008 to Allow Network Connections
This is a very common problem after you do a new install of SQL Server on a server. The moment you try to access it over the network, following error pops up:
"A network related or instance specific error occurred, while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL server is configured to allow remote connections.(provider: SQL Network Inrerfaces, error:26 - Error Locating Server/Insatance Specified)(Microsoft SQL Server)"In SQL 2003, there used to be surface area configuration manager that you could use to enable network access to your SQL server. In SQL Server 2008, the interface has been changed a little bit. There is no surface area configuration manager per se. Here is the procedure you will follow in SQL 2008.
- From start menu of SQL Server 2008, run SQL Server Configuration Manager
- From left side view of SQL Server Configuration Manager, expand SQL Server Network Configuration
- In the right view, you will find list of protocols for SQL Server. By default only Shared Memory is enabled. Others are disabled. Enable the other protocols to get your SQL server to accept connections over the network.
I made a video of this for more details hope you enjoy it. [Like they say, “Visual is better!!”]
I am facing ERROR 40. What i have to do?
Hello sir,
i have still this error when i tried to connect 2 computer in Lan (not cross joining).I checked tcp\ip,sql browser,firewall,2 computer r pinging.but this error is not solved what should i do…..it’s urgent
Hello,
Your article is very interesting. Thank you very much.
I wonder if you can help me with a connection problem to a SQL Server 2008 database.
I have a C # application that accesses a database in SQL Server 2008. Works perfectly on the same station, on a local network station works fine as well, but I can’t access the database from outside of my local network.
Internet access for database station is through a router D-Link and this is my connection string:
mySqlConnectionString = “Data Source=82.137.13.142,1433;Network Library=DBMSSOCN;Initial Catalog=ser_database;User ID=sa;Password=pass;”
82.137.13.142 is my external ip (not the real one 🙂 )
I set the windows firewall to allow sql server on port 1433
I made all possible settings that I found on the internet and still does not work.
I don’t know what else to do .
You have some advice for me?
Thank you!
do you have DMZ configured on your network?
yes, I have DMZ configured. I tried with virtual server, port forwarding, I disabled firewall on the database station, i disabled antivirus program…. doesn’t work 🙁
I even put the database computer directly on the internet (without router).
may not be correctly the connection string that I used?