Problems Connecting to Remote SQL Server

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)

Problems Connecting to Remote SQL Server

Author

Topic

davislw
Starting Member

2 Posts

Posted - 2003-01-04 : 16:02:40

When I try to connect to an instance of SQL Server 2K on my laptop from my desktop I get a variety of connection related errors when preforming various tasks:

Registering an instance from remote computer (laptop) - "Login failed for user ServerName\Guest" Strange one considering the guest account on both computers is turned off.

Copying a database from desktop server to laptop server - "Cannot connect to the server SEVERNAME\INSTANCENAME. Please check the server name and try again." The server names are in fact correct.

The odd thing is both computers see each others' instances from Service Manager but of course when I click on a remote instance I get a message box that says "Access is denied." Both servers use Windows Authentication and I have tried switching to SQL Server authentication and creating new user accounts with full administrative privliges. Nothing worked and I am out of ideas. I hope someone can help me here. :)

By the way, both computers are running Windows XP Pro with MSDE 2000 and connected on a 10 mbps LAN.

Lonnie

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2003-01-07 : 12:41:16

you may want to try one thing here.
1. Are you using standard or trusted logins?
Standard should not have a problem.
2. For trusted login
Your login into your desktop, do the domains trust enable you to do that?
The SQL Server Service account of the remote server is the key here.
feel free to comment on this.

davislw
Starting Member

2 Posts

Posted - 2003-01-09 : 19:05:05

I am using standard logins and the computers are not apart of a domain. Seems like it should work. Does the fact that the default instance is not loaded on the remoter computer have anything to do with it?

Lonnie

quote:

you may want to try one thing here.
1. Are you using standard or trusted logins?
Standard should not have a problem.
2. For trusted login
Your login into your desktop, do the domains trust enable you to do that?
The SQL Server Service account of the remote server is the key here.
feel free to comment on this.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources