Home Forums SQL Server 2005 Administering I want to have SQL Server Mgmt Studio to have the ability to run as a different Windows user. Some has it while others has run as Administrator. RE: I want to have SQL Server Mgmt Studio to have the ability to run as a different Windows user. Some has it while others has run as Administrator.

  • durai nagarajan (2/14/2013)


    working method like connection in sql authentication any way we have to give user and pwd credentials, windows authentication hope wont work on adminstrator access.

    A connection method of Windows Authentication may or may not work when running SSMS as Administrator. Just like any other Windows account it will depend on whether there is a Login for it in the SQL Server instance. SQL Server Authentication is always an option is the instance is setup to allow it.

    registered servers again will depend on the servers accessed right? , is there any other defference?

    Registered Servers is a personal manually maintained list of servers you can create in SSMS so it is stored per user. See the View > Registered Servers menu.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato