set up a different sql user for each RMS database?

(0) Share

Report

Posted on by egger29

395

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

I have the same question (0)

All responses (1)

Answers (0)

Fernando España 362 on at

Like (0)

Report

Re: set up a different sql user for each RMS database?

you do not need different sql server users, you need change connection settings in Store Operations Administrator for connect different database in you sql server.

Was this reply helpful? Yes No