Cannot establish connection to SQL Server

sql-server sql-server-2008 iis iis-7 remote-connection
user990635 picture user990635 · Dec 6, 2011 · Viewed 11.7k times · Source

I am trying to access SQL DB that is located on my computer from an application that is located on a server (has IIS7).
I set the ConnectionString in the WebConfig with the IP of my computer and I always get this error:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I wanted to enable remote connections as it was mentioned in the error. These are the things that I tried in order to make it work:

  1. Made sure that "Allow remote connections" to this server is checked in the properties window of my server
  2. Enabled TCP/IP in the SQL Server Configuration Manager
  3. Right clicking on the TCP/IP and in "Properties" set the port to 1433 and removed the "0" in the Dynamic Ports
  4. Created a new rule in the Windows Firewall to allow the connection from port 1433
  5. Added sqlservr.exe from the MSSQL/Binn folder to "Allow a program through Windows Firewall"
  6. Restarted the service

None of it helped. What else can I do?

EDIT:
Connection string: 

<connectionStrings>
    <add name="someName" connectionString="Database=someDB;Server=<my computer's IP>;User=userName;Password=123" providerName="System.Data.SqlClient"/>
</connectionStrings>

Answer

Niranjan Singh picture Niranjan Singh · Dec 6, 2011

I am showing SQL Express setting this should be same in standard and other versions. check this and follow the first link for connection specification and testing for this problem.

enter image description here

Check these links for checking error exists regarding this particular topic and fixing this:
Resolving “A network-related or instance-specific error"
SQLAuthority- could not open connection

Related questions

How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More
How to check if a column exists in a SQL Server table?

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How can …

Read More