Please help me - 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

SQL Server 2005 Forums

SQL Server Administration (2005)

Please help me

Author

Topic

shaik.zakeer
Posting Yak Master

117 Posts

Posted - 2008-05-06 : 04:16:20

Hi

I can able to create logins.its showing even in logins also.

but i am unable to login using those username & password.

plz tel me how to create logins and how to login?

very urgent

Thanks

shaik.zakeer
Posting Yak Master

117 Posts

Posted - 2008-05-06 : 04:19:05

i m getting error like this

"cannot connect to the server name

login failed for user name. the user is not associated with a trusted sql server connection"

Error - 18452

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-06 : 04:21:05

Looks like the server's using windows authentication only and you're trying to log in with sQL authentication (username and password)

Either you need to create logins from windows (Domain\Username) or you need to set the server to mixed authentication.

--
Gail Shaw

shaik.zakeer
Posting Yak Master

117 Posts

Posted - 2008-05-06 : 04:35:13

i am creating logins using sql server authentication only....

Thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-05-06 : 04:58:56

But the server seems to be set to allow windows authentication only. Please check your server settings.

shaik.zakeer
Posting Yak Master

117 Posts

Posted - 2008-05-06 : 05:53:05

i have changed to mixed mode ....even after that also it showing same error...........

Thanks