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.		

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=VDrZ7nPyp