Toad World® Forums

Unable to connect using 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

Capture3.png

5 In User Mapping , you can choose membership for databases (the default database is master)

Capture4.png

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/