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 |
|
sven2
Yak Posting Veteran
57 Posts |
 Posted - 2012-03-08 : 11:50:52
|
| Hello,the SQL Express that I am using has setup for mixed mode. So everybody can login with there windows credentials and this is working fine. Now I have to change a user so he also can login with a SQL express password. How do I do this? I thought I could change it under security but when I select the security for this user the SQL identification is not accessible.Best regards,Sven. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-08 : 12:12:48
|
| did you add a new sql login for him? didnt understand whay you mean by SQL identification is not accessible. if its mixed mode you can do it both ways using domain account or sql account provided you set it up in server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sven2
Yak Posting Veteran
57 Posts |
Posted - 2012-03-08 : 14:34:07
|
| Hello,if I create a new login and I select SQL server authentication then I get an error xxxxx is not a valid name because it contains invalid characters. If I use windows authentication and i use the same name there is no problem.So i don't know why I can't setup a SQL server authentication.Best regards,Sven |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-08 : 14:43:27
|
| whats the name you selected? was it format somedomain\somename?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Mixed mode SQL server 2008