Friday, February 24, 2012

Obtain "trusted connection" ?

Hi all!

I have a new computer, clean, I installed WinXP, and I want to connect a SQL Server (other computer in the same network)
For this I installed the client tools from SQL SERVER 2000 kit. Ok.
When I try to connect to the server, I can't connect through "trusted connection", only whit user name and password.
I mention that I set the sql server in mixed mode autentification.

When I try to connect from other computer (my laptop, or other computer from this network) I can connect both types of connection: trusted and with

sa (for example)

The question is:

How I can set up a "trusted connection" at SQL Server?

The computer is completely new, clean and has win xp with sp2.

Any opinion are considered.

Thanks in advance.

koci.You still need to add the login of the trusted connection to the server logins and grant it permission to use specific databases. SQL Server will not let you in purely on good looks and charm, even in the "trusted" mode.|||SQL Server will not let you in purely on good looks and charm, even in the "trusted" mode.

I have it on good authority that SQL Server will let you in if you know how to mix a good margarita. :D

Regards,

hmscott|||Thank's for the answers, I solved the problem.:)

No comments:

Post a Comment