Friday, March 23, 2012

How to connect remote SQL Server?

I wnat to connect to remote sql server 2005, I do the following steps:

Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
Turn on the SQL Server Browser service.
Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.

sp_addlogin 'Wind','ack@.123','db'

but still can't login,tips as follwing:

Login failed for user 'Wind',The user is not associated with a trusted SQL Server connection.

Error:18452

Why? Must use "SQL Server Authentication" connect?

YOu are trying to connect with SQL Server Authenitcation, but you only have Windows Authentication enabled. See the Screencast on my site for more information how to switch the Authentication mode.

Jens K. Suessmeyer

http://www.sqlserver2005.de

No comments:

Post a Comment