Post reply

trusted connections using Excel

  • September 12, 2011 at 5:14 am

    #256982

    Hi -

    Just wondering if I am connecting to Excel and I specify a username and trusted connection = yes in the connection string, does the connection log on using the specified username or the username currently logged onto windows?

  • September 12, 2011 at 7:06 am

    #1379964

    "Trusted" means that the credentials of whoever is currently logged in (you) running the program will be used to connect to SQL Server. I have never actually tried specifying a user name in a connections string with set up for trusted connection but my guess is it would be ignored or perhaps generate an error.

    The probability of survival is inversely proportional to the angle of arrival.

  • September 12, 2011 at 7:13 am

    #1379971

    thanks - it doesn't cause an error and looks like its ignored. Just wanted to confirm.

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

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