[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2009-05-12
8
Medium Priority
?
245 Views
Last Modified: 2012-05-06
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
Comment
Question by:ClaudeColaco
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24371655
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
 

Author Comment

by:ClaudeColaco
ID: 24371716
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24371831
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 does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:ClaudeColaco
ID: 24371869
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24372115
you can modify the screenshot to replace/hide the actual domain name...
0
 

Author Comment

by:ClaudeColaco
ID: 24372318
Hi

Hear are the screen shots

Thanks
Claude
Fig1.JPG
Fig2.JPG
Fig3.JPG
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24372482
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
 

Author Comment

by:ClaudeColaco
ID: 24373317
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
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…

650 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