Windows Authentication

  • When using SSMS, we can use SQL authentication to access SQL Server instances. But when we use the Windows authentication, the login field is grayed out.

    Does anyone know how to enable the Windows login field?

    Any input will be greatly appreciated.

  • You don't. SSMS connects in the context of the security account in which it was started. If you didn't use RunAs to start it under a different Windows account, that means it will connect to the database using the account you're currently logged on to Windows as.

    K. Brian Kelley
    @kbriankelley

  • Brian is correct. The tool is using credentials (current or RUNAS ones) so there is no need for a login.

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

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