Cannot Regster remote Sql Server 2000

15 pts.
Tags:
Microsoft SQL Server 2000
Remote SQL Server
i can access remote server by remote desktop and i can ping server also, but fail to register remote sql server,Please Help

Answer Wiki

Thanks. We'll let you know when a new response is added.

Check the ports that SQL Server is using? Are you using the default ports? After you determine what port SQL Server is Listening on then you can attempt to register the server using that port. If you still can not register the server then try to telnet to that server on the SQL Server port and if that fails you may have a firewall issue and you will need to get with your networking team. If you need more help let me know

<a href=”http://www.tek-tips.com/faqs.cfm?fid=5481″>This page </a>has a list of things to look at which will help you troubleshoot your remote connection issue.

Also have a look at the output of master..sp_configure with no parameters which will displays all configuration options and check for remote access which has to be 1 (by default)

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following