Hi, I have had problems with my web application. Everthing is fine if I'm Working in my notebook (Windows XP Professional). But if I deploy that on Windows Server 2003, the error message shows:
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 Interfaces, error: 26 - Error Locating Server/Instance Specified)
Scenario: Web Aplication: C#, 3-Tier, SQL SerVer 2005, .NET Framework 4.0
Connection String : "Data Source=MyServerName;Initial Catalog=MyDatabase;Integrated Security=True;"
I already checked on Windows 2003 Server..
(OK) 1) Make sure your server name is correct, e.g., no typo on the name.
(OK) 2) Make sure your instance name is correct and there is actually such an instance on your target machine.
(OK) 3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server.
(OK) 4) Make sure SQL Browser service is running on the server.
(OK) 5) Firewall exceptions : ports 1433, 1434 and sql "exe" files.
(OK) 6) SQL Server 2005\Server Auhentication\SQL Server and Windows Authentication mode
(OK) 7) SQL Server 2005 Surface Area Configuration\Database Engine\Remote Connections\Local and remote connections\Using TCP/IP only.
What do I have to do ?
Regards,
Marcio L.R.
View Complete Post