?
Solved

Unable to add SQL Server Registration

Posted on 2007-10-08
7
Medium Priority
?
580 Views
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.

regards,
Quintin
0
Comment
Question by:TylerDu
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:twoboats
ID: 20039489
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

http://support.microsoft.com/kb/138541
0
 

Author Comment

by:TylerDu
ID: 20039830
Hi,

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?
Thanks.
0
 
LVL 14

Expert Comment

by:twoboats
ID: 20040762
I guess it might be. Try re-installing the client side stuff.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:TylerDu
ID: 20052048
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.

0
 
LVL 14

Expert Comment

by:twoboats
ID: 20063979
At least it's sorted ;)
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22469645
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

862 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