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.
| Author |
Topic |
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
 Posted - 2012-07-24 : 12:23:27
|
| I need to create login for SQL server authentication. I have sql server 2005.Can someone plz help me.I have tried with create new login from Logins under security.But didn't work.kalyan Ashis Dey |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-24 : 12:26:47
|
| Please elaborate on what you mean by it didnt work? did you get some error?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
Posted - 2012-07-24 : 12:31:06
|
| yes i am getting error.While try to login getting "The user is not associated with trusted sql server connection(error 18542)"kalyan Ashis Dey |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-24 : 13:02:26
|
| can you see the created user beneath security-> logins in management studio?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
Posted - 2012-07-24 : 13:06:54
|
| yes.kalyan Ashis Dey |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-24 : 13:21:44
|
| have you assigned any default schema/db for user?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
Posted - 2012-07-25 : 02:46:02
|
| Yes i have selected default schema as dbokalyan Ashis Dey |
|
|
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
Posted - 2012-07-26 : 08:14:47
|
| any update?kalyan Ashis Dey |
|
|
|
|
|
|
Login creation