locked
cannot login to sql server using domain account RRS feed

  • Question

  • hi all,

     i added my domain account\username and password using credentail manager like below shown in box.

    now how can i logon to sqlserver using this domain account...so that i can access client servers and databases(using vpn)..

    pls help asap

    thanx in advance..

    control panel-->System and Security-->Credential Manager.


    lucky

    Saturday, October 4, 2014 10:06 AM

Answers

  • Hi,

    You need to create login for your domain account in SQL Server to login to SQL Server, 

    You can execute below commands to create login.

    create login [Domain\username] from windows;

    now you can assign roles to the above user by running below script.

    exec sp_addsrvrolemember 'domain\username', 'rolename'

    refer below link how to create login for domain user.

    https://www.youtube.com/watch?v=VDrZ7nPyp5I


    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page


    Saturday, October 4, 2014 10:30 AM