• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

How do I test a MS SQL Server 2000 to MS SQL Server 2000 Remote connection

I tried the following from a post on the Web.
Steps to Register Server properly
1) Go to Start/Programs/Microsoft SQL Server/Client Network Utility
2) Make sure TCP/IP is in the Enabled list and on top
3) Click on the ALIAS tab
4) Click ADD
5) Enter 'yourdatabasename' for the Alias
6) Select TCP/IP for the Network Library
7) Change Server Name under Connection Parameters to "sqldb.domain.com" (This depends on your server configuration)
(use your domain name), Click OK
8) Click OK again to Close Client Network Utility
9) Go to Start/Programs/Microsoft SQL Server/Enterprise Manager
10) Expand Microsoft SQL Servers
11) Right click on SQL Server Group
12) Select New SQL Server Registration
13) Click Next
14) Highlight 'yourdatabasename' Alias and click ADD
15) Click Next
16) Under Connect Using select SQL Server Login, click Next
17) Enter your username
18) Enter your password
19) Click Next, Click Next again, Click Finish, Click Close

The port 1433 is open on the website of the destination server.

But I get the message :
"Registration complete
Status:
Main-Web: Specified server not found Connection open(Connect())

Thanks
Claude
0
ClaudeColaco
Asked:
ClaudeColaco
  • 4
  • 4
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is the sql server running?
is it a names instance, eventually?
can you try to use the ip address instead of the alias for the registration?
can you telnet to the ip address + port 1433?
0
 
ClaudeColacoAuthor Commented:
Hi

1. I confirmed that the server is running
2. Alias - XXX-WEB\WEB,  Server - XXX-WEB\MDG.abc.com
3. I tried to using  the ip and got the same results
4. Yes I can telnet to ip address + port 1433

Thanks
Claude
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
your alias must not contain a \ in it's name ...
can you please clarify, eventually with screenshots, the real instance name, the alias config, and the registration screen?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
ClaudeColacoAuthor Commented:
Hi

I tried after removing the \ from the Alias. Same results.  It was server name in the remote server.
Sorry I cannot give the actual domain name

Thanks
Claude
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you can modify the screenshot to replace/hide the actual domain name...
0
 
ClaudeColacoAuthor Commented:
Hi

Hear are the screen shots

Thanks
Claude
Fig1.JPG
Fig2.JPG
Fig3.JPG
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please create an alias without "-"...
also, try to create the alias with the ip address.

now, I see that MDG is the instance name, so the .domain.com must be on the server name:

MAIN-WEB.domain.com\MDG
and not
MAIN-WEB\MDG.domain.com
0
 
ClaudeColacoAuthor Commented:
Hi Angel

That's what you are!

Your suggestion worked with a slight change of server name.
It worked with:
domain\MAIN-WEB\MDG

Thank you for being so patient
Claude
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now