how to create a login - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to create a login

Author

Topic

shan1430
Yak Posting Veteran

86 Posts

Posted - 2008-05-20 : 21:31:30

hi,
i tried to create a sql authenticated login by right click security,new login and follow the steps needed but once i finish creating, i could not login using the account. Why is it so? Can help me? Let my user name = " pe " and my password= " 123456 ". Help me. Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-20 : 22:48:39

Is the login created? Got any error when connect with that id?

shan1430
Yak Posting Veteran

86 Posts

Posted - 2008-05-20 : 23:53:48

it says user is not a sql trusted...

suresha_b
Yak Posting Veteran

82 Posts

Posted - 2008-05-21 : 01:07:39

The reason is, your SQL Server is in "Windows Authentication mode". To confirm this (in 2005) right click -> Properties -> Security.

There itself you can change it to "SQL Server and Windows Authentication mode". It will take effect after restarting SQL Server.

Suresh

shan1430
Yak Posting Veteran

86 Posts

Posted - 2008-05-21 : 02:51:15

i have changed it to SQL Server and Windows Authentication mode but still same problem

suresha_b
Yak Posting Veteran

82 Posts

Posted - 2008-05-21 : 02:57:00

After changing to SQL Server and Windows Authentication mode, did you restart the SQL Server service?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-21 : 22:54:12

Did you ever create that sql login?