I'm a SQL newbie and so don't know how to set up logins for a website to connect with SQL Server (Express). I have so far set up a login as lornawheel in the Master DB (lornawheel is not an administrator) and I have set up another login in my So-Scottish DB and also given that the name lornawheel but mapped it to the Master login. However, when I try to set up a System DSN, on Servername\SQLExpress using SQL authentication, it gives me the error:
SQL Server Error: 4064...Cannot open user default database. Login failed.
I have checked that SQL server is set to use Windows and SQL logons.
Everything is on the same server (Windows 2003). What else do I need to do in SQL and is there a way in SQL to test these logins? I don't think I want to give lornawheel administrator priveleges because this is the user I want to use in my asp connection string (classic asp).
I need this working urgently for a presentation so any ideas would be greatly appreciated.