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 2000 Forums
 SQL Server Administration (2000)
 login issue

Author  Topic 

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-07-10 : 17:42:55
Hi friends

I installed sql2000 dev edition on XP professional.i created a login in sql.but whenver try to login to sql it says "this login is not associated with trusted connection" and i cant login!!

am wondering how to fix that.
Thanks

Cheers

nr
SQLTeam MVY

12543 Posts

Posted - 2005-07-10 : 19:22:12
You need to change the server to allow sql server logins as well as integrated security.
Right click on the server in enterprise manager.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-07-10 : 19:31:19
Thank u very much "nr"
i was looking for it everywhere

Cheers
Go to Top of Page
   

- Advertisement -