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.


    Saturday, October 4, 2014 10:06 AM


  • 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.


    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