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 |
|
dvlnblk
Starting Member
1 Post |
 Posted - 2007-03-09 : 13:22:33
|
| I have SQL 2005 and I need to set up a database with a username and password but it appears to only let me do so using Windows authentication. How can I do this? Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-03-09 : 13:28:39
|
| go to server properties and change the authentication mode to mixed mode, yours is set to allow windows authentication onlyHTH--------------------keeping it simple... |
 |
|
|
|
|
|
New Database