Post reply

How to know if Server uses integrated security

  • June 25, 2010 at 3:27 am

    #234252

    Hi,

    I created a login dialog to connect to different SQL Server (version 2000 - 2008).

    I list all Server available in our network. I know the name, instance name and version of found servers.

    Some of these servers uses integrated security and some not.

    How can i determine if selected Server uses Windows integrated authentication or not?

    Of course, i can try to login with integrated security and wait until the login success or server generate an error. But I think, there must be a better way to test this.

    Thanks in advance

  • June 25, 2010 at 3:48 am

    #1184877

    All SQL Servers have integrated security (you can't turn it off), it depends on whether the server your users are connecting to have permissions for the database(s) they need to access granted via integrated security.

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

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