MSSQL remote connection error

Posted on 2007-08-02
Last Modified: 2008-09-13
I'm unable to connect to MSSQL 200O server remotely. I can connect to MySQL running in the same server without any problem. Also I dont have any firewall in the server. Plus i have enabled remote connection in SQL server 2000.

Server Details

MSSQL 2000 Service pack 3
Port 1433

I am using enterprise manager to connect to the server from my local computer. When i try to connect i am getting

SQL Query Analyzer
Unable to connect to server

Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

Please help!!

Question by:supportpro
    LVL 11

    Expert Comment

    No typos in the IP?
    Do you have a valid login and password?
    Is the SQL Server running?
    LVL 28

    Accepted Solution

    Try running "NETSTAT -a" and make sure the system is "LISTENING" on port 1433.  If not, then the problem is on the server, perhaps the service failed to start correctly.  If it IS listening, then the problem is on the client.  

    The next step is to try to connect from the client to the server with this: "TELNET servername 1433".  This should get either a black screen or some response other than an obvious error message.  If you get an error here, and the first item succeeded, then the problem is on the workstation.  If you get a Firewall popup, then the client firewall is affecting the problem -- disable it.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now