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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.