RE: access across domains
From: baiwei (v-baiwei_at_fareast.microsoft.com)
Date: 11/18/03
- Next message: Sue Hoegemeier: "Re: linked server security problem?"
- Previous message: Tony Ma: "linked server security problem?"
- In reply to: jason: "access across domains"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 18 Nov 2003 11:37:36 GMT
Hi Jafinck,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
As my understanding, from your SQL Server, you want to register a remoter
SQL Server from a domain which is different from the one your SQL Server is
in, but you find that from the local SQL Server Enterprise Manager you
cannot get any information of the remote SQL Server and cannot register it,
right? If I have misunderstood, please feel free to let me know.
>From my experience, you can still register the SQL Server instance in a
different domain through Alias:
I will provide this method for you:
Assume you have Server_A in Domain_A and Server_B in Domain_B. You want to
register Server_B in Server_A.
1. Make sure the connection between this two computers is OK.
To test general connectivity:
PING < Server_B ip>
To test we can connect to default SQL Server port 1433:
TELNET < Server_B ip> 1433
If we can connect, the screen will go blank. The server is awaiting more
commands. Hit any key to return.
If we CANNOT connect, you will get an error.
ˇ°Connecting To < ip > ..Could not open connection to the host, on port
1433
No connection could be made because the target machine actively refused
it.ˇ±
NOTE:
Port 1433 is the default port number for SQL Server. You can check the
actual port number by Server Network Utility. You can get the actual port
number in use by check the properties of TCP/IP (which should be in the
ˇ°Enabled Protocolsˇ±).
2. Use the Client Network Utility on Server_A side to create an Alias for
Server_B.
Open the Client Network Utility.
In ˇ°Aliasˇ± Tab, add a new alias. Check the ˇ°TCP/IPˇ± in ˇ°Network
Libraryˇ±; The ˇ°Server Nameˇ± in ˇ°Server Parameterˇ± should be the IP
address of Server_B; Suppose the Server Alias is ˇ°ServerBˇ±.
ThatˇŻs all for this step.
3. Register Server_B
In SQL Server Enterprise Manager, right the Server_A, choose the ˇ°new SQL
server registrationˇ±. By choose the ˇ°ServerBˇ± in the list of
Registration Wizard, you will register the information of Server_B.
I hope my information will help you to solve your problem. If you need more
help and support, please feel free to post new message here.
Sincerely Yours
Baisong Wei
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
- Next message: Sue Hoegemeier: "Re: linked server security problem?"
- Previous message: Tony Ma: "linked server security problem?"
- In reply to: jason: "access across domains"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
