Hi,

I have had to rebuild my development machine and re-install everything.  No problem just time!

Got it all in and am now reinstalling the web sites and DB's but I am unable to create a new MS SQL Login that works!

I have done the following... (and feeling pretty stupid over such a simple task)

1. Open MS SQL Manamgement Studio R2
2. Click on the "Connect" image
3. Login using Windows Authentication as myself
4. Right click on Security | New | Login
5. Enter the name (mojouser)
6. Select SQL Authentication button
7. Enter the password (mojo123)
8. Enter password again
9. Select User Mapping menu item (top left)
10. Select DB (mojoportal)
11. Add username
12. Add "dbo" under Schema
13. Press Ok to save....

Select Connect button again...

Enter UID & PWD select SQL Authentication NOT Windows...

FAILS with 18456 error...???

So what am I missing or doing wrong?

Thanks

Okay well I do feel like an idiot...

My issue was that I had not gone the the Server Properties and set the connection type from Windows Authentication to Windows & SQL authentication....

Problem solved.

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/6dda698b-6199-4d3e-b6c2-387319f78c1e/