Wednesday, March 21, 2012

Remote SQL connection

Hello everyone, I am trying to connect to a remote SQL 2005 database from Microsoft SQL Server Management Studio.
I enabled the remote connection on the server and creating a user on the server.
I am trying to connect to the server from my workstation using sql server authentication with the login name already created on the server.

I am receiving this error: cannot connect to "server name"
cannot open user default database. Login failed.
Login failed for user "username".(Microsoft SQL Server, Error: 4064)

Can anyone help?

under your server registration properties... do you have authentication set to "SQL Server Authentication"?

You aren't behind a firewall that blocks connections to your remote? (they do this on corporate networks)...

No comments:

Post a Comment