Post reply

Not asking for trusted connection in mixed mode

  • January 13, 2004 at 12:23 pm

    #65913

    Hi there,

    This would be my first post here, and I hope I make it a good one!

     

    I currently administer a SQL server here at my office. The server is set up for Mixed Authentication. However, one user chooses (and needs to, for various reasons) to use SQL Server Authentication. He, awkwardly, also links all the tables into Access. Upon connecting to the tables, it continuously beings up a dialog box for username and password (not surprisingly.. and also a good feature, IMO). However, along with that, he has to uncheck the Default "Use Trusted Connection" checkbox. This doesn't seem so bad to me, but I guess to continously have to do it becomes a pain. Anyways, as the admin, it ultimately comes back to me to fix.

     

    So my question is - is there any way to default uncheck that box when it shows up? According to Microsoft, it seems like there would not be a way.

     

    Any help is appreciated!

     

    Thanks,

    Ian

  • January 13, 2004 at 12:49 pm

    #489837

    It's been a while, but I'm pretty sure that when the tables are linked you have the option to store password information with that connection.  It's a check-box or something like that.  I'll look around for it and see if I can find better instructions.  One note with this though is that the password is stored in plaintext in one of the access system tables and anyone with access and a little knowledge could look it up in the db.

    Thanks

    Tom

  • January 13, 2004 at 12:50 pm

    #489838

    It is a save password checkbox on the link tables selection window.

    Tom

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

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