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 |
|
gongxia649
So Suave
344 Posts |
 Posted - 2007-04-19 : 10:01:47
|
| 2 issuesi login using windows authentication. looks like i cant create a new sql server authentication login. what can i do?and when i try to login with my sa login it pops the errror 18452. does this mean i didnt install mixed mode? i cant remeber. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-19 : 12:46:16
|
| 1. Are you getting an error? 2. What is error 18452? As mentioned a couple of days back, we don't have error numbers memorized.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-19 : 17:00:31
|
| Ensure you enabled sql authentication, can do that in em -> properties -> security tab. |
|
|
|
gongxia649
So Suave
344 Posts |
Posted - 2007-04-20 : 09:22:00
|
| reinistalling with mixed mode solved the issue. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-20 : 09:39:53
|
| But don't have to reinstall. |
|
|
|
gongxia649
So Suave
344 Posts |
Posted - 2007-04-20 : 10:49:41
|
| how is the solution without reinstalling it? and i didnt have mixed mode installed previously. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-20 : 12:38:17
|
| To switch the mixed mode in SQL Server 2005, connect to your server in Management Studio, right click on it, properties, Security page. rmiao gave the steps in his first post for SQL Server 2000, should have been easy enough to figure it out for 2005.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
logins