Unable to add SQL Server Registration

Posted on 2007-10-08
Last Modified: 2008-09-13
I have installed Win2003 Std  64-bit and SQL 2000 Std 32-bit SP4 and configured licensing to 5 devices.

I have configured the SQL server port to 7204 and I want to add a SQL Server registration. I have added the remote server under the alias with the correct IP and port no. and when I am trying to add the remote SQLServer registration using the correct credentials I am getting an error message 'SQL Server does not exist or access is denied ConnectionOpen:Connect()'

I have tried to connect to the remote server via telnet and the connection succeeds therefore no issues with FW etc and have also verified using netstat -ano that both servers are listening on the correct ports.

Any suggestions pls.

Question by:TylerDu
    LVL 14

    Expert Comment

    Just in case..

    "I have tried to connect to the remote server via telnet"

    To port 7204, or to telnet default port?

    Perhaps try using odbcping to check connectivity

    Author Comment


    I have connected to port 7204. I have also made a check via a udl file using the server alias and connection succeeded.

    Using osql or sql server registration, connection to the server is not succeeding

    I have checked the DB Library options from the sql server client utility and i am not having any information for the nwdblib.dll file. Maybe this could be the source of the problem?

    Any suggestions?
    LVL 14

    Expert Comment

    I guess it might be. Try re-installing the client side stuff.

    Author Comment

    I have reinstalled it but with no luck.

    The issue was solved by formatting and installing win 2003 32-bit and sql 32-bit..... as the installation was still new and it was much better time wise rather than to troubleshoot it.

    LVL 14

    Expert Comment

    At least it's sorted ;)
    LVL 1

    Accepted Solution

    PAQed with points refunded (500)

    EE Admin

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    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.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    732 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

    23 Experts available now in Live!

    Get 1:1 Help Now