First, I am not a SQL expert. I am using SQL 2005 express and RMS 2.0
But right now, in SQL 2005 express, i set up a user, and i have that user defaulting to my demo RMS database.
Everything works fine.
But now I have restored a client's RMS database. But when i log in with my default user it goes to the original database i set up.
I am thinking about setting up another user in SQL and have this user default to my client's database.
So if I have 5 client's database's, I will have 5 different SQL users.
What does everyone else do?
*This post is locked for comments