Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Location
    Tarragona, Sp
    Posts
    6

    Angry Unanswered: 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.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by blindman
    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.

    Regards,

    hmscott
    Have you hugged your backup today?

  4. #4
    Join Date
    Sep 2005
    Location
    Tarragona, Sp
    Posts
    6
    Thank's for the answers, I solved the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •