Connecting to an SQLServer

[raviva]

Can someone please explain me how to connect from my SQLServer to a remote SQLServer. Both the servers are 2000. I have tried linked servers but it is quite confusing.

Thanks,

[FredSovenix]

Can someone please explain me how to connect from my SQLServer to a remote SQLServer. Both the servers are 2000. I have tried linked servers but it is quite confusing.

Thanks,

First, you need to resolve any connectivity issues between the two servers. Is the remote SQL server on a host that can be resolved via DNS, or do you have to specify an IP address? Are they on the same subnet? Is the remote server listening on port 1433 for requests (Network Configuration applet)?

If you only have an IP address, then I suggest using the Client Configuration applet to create an alias for the remote server and map it to the IP address and port number.

Once your connectivity issues are resolved, adding a linked server is a snap; if they are in different domains that have no trust relationship, you have to use native SQL server authentication; otherwise, if one server can access the same Active Directory as the other, you can use Windows authentication.

Hope this helps. Please post additional details if you need additional help.

Cheers!

[ck9663]

Can someone please explain me how to connect from my SQLServer to a remote SQLServer. Both the servers are 2000. I have tried linked servers but it is quite confusing.

Thanks,

Are you trying to connect inside an sp? from sql server console (enterprise manager)? query analyzer?

-- CK

[raviva]

Are you trying to connect inside an sp? from sql server console (enterprise manager)? query analyzer?

-- CK

I am trying to connect from enterprize manager...

[ck9663]

You have to register the new server.

-- CK

[raviva]

You have to register the new server.

-- CK

Thanks. However, can you a bit more specific. I have added a new datasource, but of no use. I have the IP address of the other server.

Thanks

[ck9663]

1. Open your enterprise manager
2. Expand your sql servers
3. Right-click on of the groups
4. Choose New SQL Server Registration
5. Follow the instruction.... ..

-- CK

[raviva]

1. Open your enterprise manager
2. Expand your sql servers
3. Right-click on of the groups
4. Choose New SQL Server Registration
5. Follow the instruction.... ..

-- CK

Thanks, but the server which I want to connect doesnt appear in the available servers list. I wonder, if I have enough data regarding that server. I know the server name, IP address. Are these parameters enough, or additional what information I need. Further, what needs to be done to appear our target server name in the available servers list. Sorry, but I am very much confused.

Thanks.

[ck9663]

Just type the IP or server name on the Available Server text box instead of looking for it on the listbox. Click Add.

Make sure that you are within the same network or at least your two network can communicate with each other.

- CK

[raviva]

Just type the IP or server name on the Available Server text box instead of looking for it on the listbox. Click Add.

Make sure that you are within the same network or at least your two network can communicate with each other.

- CK

Thank you very much. It worked.