CODEWITHSUNDEEP
sqlsql-serverwindowssql-server-2005windows-7
user998163
user998163

Reputation: 483

SQL Server 2005 not accessible

I try to connect to my local installed microsoft sql server 2005. In the firewall I allowed port 1433 for inbounding traffic. There is only the windows firewall active.

In my SQL Server, I allowed remote connections for the instance of my Server and for the SQL Browser.

When I open the console as admin and Type:

Sqlcmd

I get a message, that says: "Error establishing a connection.....allow remote connections". What could be the issue?

Upvotes: 0

Views: 79

Answers (2)

user2574678
user2574678

Reputation: 709

Are you sure the firewall is open and that sql server is running on port 1433?

Have you tried to telnet to the sql server port from your local workstation using windows command line i.e.

telnet servername|ipaddress 1433

(telnet might not be installed on your windows as default, easy to enable via windows add/remove programs.

If the telnet is successful you will get a black box with a blinking cursor, this proves that the local can connect to the server)

Upvotes: 0

user3316696
user3316696

Reputation:

Open the SQL Server Configuration Manager and select your server's Network Configuration node.

Be sure that TCP/IP is enabled inside the protocols subnode.

Upvotes: 2

Related Questions