After creating login i am unable to connect to database using server authentication.
I need steps to create login for server authentication in toad for sql server.
After creating login i am unable to connect to database using server authentication.
I need steps to create login for server authentication in toad for sql server.
Hi,
You can create a new login by following steps
1 Connect to a SQL Server
2 Select 'Sserver Security' in Object Explorer , right click 'Logins' and select 'Create Login'
3 After select 'Create Logins' , you can input new login name ,password ,and choose Auth Type in General
4 In Server Roles , you can choose menbership type for SQL Server
5 In User Mapping , you can choose membership for databases (the default database is master)
6 Click 'OK'
Hi Skila.Zheng,
I think you have given steps sql server management studio but i want in Toad for sql server which is also a IDE.Could u please give me the steps
Hi Skila.Zheng ,
I think you have given steps sql server management studio but i want in Toad for sql server which is also a IDE.Could u please give me the steps
You can follow the instructions mentioned in this article: http://www.sqlserverlogexplorer.com/fix-microsoft-sql-server-login-failed-error-18456/