Post reply

SQL Server trusted connection and VPN

  • May 28, 2008 at 7:39 pm

    #125520

    Hi

    I am working remotely using VPN and want to connect to SQL Server using my credentials thru trusted connection. I have set up an account on my pc with my work pin as account name and my work password. When i try to edit the server registration to use trusted connection i get an error as follows.

    Login failed for user '(null)'. Not associated with a trusted connection.

    SQL server doesn't seem to picking up any info at all, hence the null.

    Does anyone have any ideas on how to set this up.

    Thanks

  • May 28, 2008 at 7:56 pm

    #821532

    try this..

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269587

    also make sure that the account you created on your pc has an access to your database server. (create a sql login for the said accnt)

  • May 28, 2008 at 8:01 pm

    #821533

    Does your machine authenticate with a domain when you VPN in?

  • May 28, 2008 at 8:02 pm

    #821535

    Thanks, i found a solution that works well:

    C:\WINDOWS\system32\rundll32.exe keymgr.dll, KRShowKeyMgr

    Then you can add a new server to the cached credentials - e.g. click Add then

    Server box: name of server e.g. MYSQLSERVER

    User name box: domain and name of valid user on MYSQLSERVER e.g. MYDOMAIN\username

    Password ... password for that user in that domain

    OK that then try connecting and Windows should use those credentials rather than the credentials you used to log into local machine

    My problem now is i have a pc with xp home on it and the key manager doesn't give you the option of adding a server.

  • May 28, 2008 at 8:03 pm

    #821536

    Yes i get a message saying that the machine has successfully authenticated

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

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