Monday, February 13, 2012

2005 Express Error: Could not open a connection to SQL Server

Hi, I can't connect to my remote SQL Server 2005 Express - can anyone
help?
SETTINGS:
Server Type: Database Engine
Server Name: {my remote IP}
Authentication: SQL Authentication
User Name: {my Username}
Password: {my Password}
ERROR:
Error: Testing the registered server failed. Verify the server name,
login credentials, and database, and then click test again.
Additional Informtion: An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections. (provider: Named Piper
Provider, error:40 - Could not open a connection to SQL Server)
(Microsoft SQL Server, Error: 53)
TROUBLESHOOTING:
- Windows firewall is not enabled on the server.
- When I test "telnet {my remote IP} 1433", i get "Could not open
connection to the host, on port 1433: Connect Failed".
- When pinging my ip, I get 0% loss.
- I have established via the SQL Server Surface Area Configuration
tool that Local and remote connections, using both TCP/IP and named
pipes, is enabled.
- The SQL Server Browser service is started.
Cheers.
Sorry, I also established through the SQL Server Configuration Manager
> SQL Server 2005 Network Configuration > Protocols for MSSQLSERVER
that TCP/IP is enabled and Listen All is set to Yes. Under the 'IP
Addresses' tab, TCP Port for IP1 and IP2 (which are different from my
server IP ?) is set to 1433,2433.
|||Do you have \SQLEXPRESS on the end of the server name? Is the SQL Browser
running on the server where SQL Express is running?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"iporter" <isporter@.gmail.com> wrote in message
news:1175251815.059956.99630@.o5g2000hsb.googlegrou ps.com...
> Sorry, I also established through the SQL Server Configuration Manager
> that TCP/IP is enabled and Listen All is set to Yes. Under the 'IP
> Addresses' tab, TCP Port for IP1 and IP2 (which are different from my
> server IP ?) is set to 1433,2433.
>

No comments:

Post a Comment