Post reply

SQL Server 2008R2 Security Options For Connectivity

  • May 14, 2019 at 7:04 pm

    #3642072

    If I have a DB named TEST on a SQL Server 2008R2 instance and I need to execute the below command I can connect using either a Windows Domain user that has been granted applicable access to the SQL Server instance or a SQL Login on the instance that5 also has been give applicable access to the DB.  There is no third method or alternative option to connect to SQL Server to execute this query then these 2 correct?

     

    SELECT * FROM TEST.dbo.testtable

    Kindest Regards,

    Just say No to Facebook!

  • May 14, 2019 at 8:14 pm

    #3642094

    You can connect with Windows Authentication or SQL login. You can use different processes or whatever but for the login itself, there really aren't other alternatives. Windows or SQL.

    Sue

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

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