Post reply

Obtain "trusted connection" ?

  • February 2, 2006 at 5:39 am

    #168055

    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.

  • February 2, 2006 at 6:41 am

    #618365

    Hello Koci,

    Have you created the necessary login on the SQL box?

    Then in the client tools -> client network utility -> Alias tab -> Add button -> Give the server alias name (if it is a default instance fine otherwise you need to provide \\domainname\\namedinstance in then connection parameters (server name)

    select the network libraries as TCP/IP

    click on ok button. then open the Enterprise manager and register the server with the trusted login.

    Thanks and have a nice day!!!


    Lucky

  • February 2, 2006 at 7:25 am

    #618387

    1. You must have a login on SQL Server that is set for Windows Authentication only.

    2. The login must be the same that you use to log into the network.

    3. The domain you are on must be a) the same domain that SQL Server is on or b) a trusted domain.

    What makes a trusted domain or trusted account? A trusted domain is two or more domains that authenticate logins through the same domain controller, or each domain's domain controller is a backup for the other domain. A trusted account is one that can be authenticated by the domain.

    -SQLBill

  • February 6, 2006 at 3:24 am

    #618915

    Thank's for the answers, I solved the problem.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply