remote sql server connection using Query Analyser

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

remote sql server connection using Query Analyser

Author

Topic

lingamgr
Starting Member

2 Posts

Posted - 2005-07-14 : 14:53:17

I do have SQL Server. I would like to connect to another SQL Server which is in another office. I know the IP address of the Node and SQL Server Name. I do have a user login name and password to access the remote SQL Server.

But I would like to connect to remote SQL Server through Query Analyser of my SQL Server. So that I could query certain information from that server.

Would you please give me snap-in of how to connect.

thanking you
g.r.lingam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-07-14 : 14:56:55

Snap-in?

Anyway, just open up Query Analyzer, type in the IP address, select SQL authentication and type in your username and password.

Tara

lingamgr
Starting Member

2 Posts

Posted - 2005-07-15 : 12:19:17

Before posting this query, I have already tried the procedure that you have mentioned. I give you the complete picture of the problem
Dear Tara

I have webserver and many standalone clients connected in a network using Class C IP address. I have installed SQL Server 2000 in all the systems due to requirements. i.e. every clients has its own SQL Server instance running.

I have set "allow the remote server to connect through RPC" property (SQL Servers )of both Web Server and a Client from where I would like to connect to the SQL Server instance running in WebServer. The default port of both the system is 1433.

Through query analyser, using ipaddress\sqlservername, I am able to access the SQL Server Instances of the client machine where I am unable to connect to Webserver's SQL Server Instance from Client machine but I am able view the Webserver's SQL Server instance in Query analyser of Client machine.

The error status is : Msg: Level 16:state 1

snap-in means, the screen shots of dialog box of query analyser where we have to make necessary changes. If not query analyser, atleast the screen shots of Enterprise Manager.

thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-07-15 : 12:37:23

Please provide the entire error message.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources