Hi all; I am trying to login to an online sql database from enterprise manager;
First of all is this possible and second of all, how do I go about doing it from enterprise manager (by the way I am using MS SQL 2000)
THanks for any assistance
It *may* be possible, depending on how the remote SQL Server is set up,(I.E., if it's got the TCP/IP network library enabled) and if there areno firewalls blocking communication between you and it.If you can connect to it, it's just a matter of right-clicking on oneof your SQL Server group nodes in the tree, and selecting "New SQLServer Registration". Then, give the wizard the IP address or URLto your remote SQL Server, follow the rest of the wizard's steps, andyou're connected.
No comments:
Post a Comment