I have a database connection question.
I recently moved the RMS store database from one server to another. We had a server hardware failure.
I took a backup of the database and retored it on the new server. I setup a new user account for the staff in the store to connect to the database via Store Operations and it all works smoothly. To set the user connction for each computer we edited the Configuration dialogue box in Store Administator and clicked on Test Connection. It worked so Administrator was closed down.
Store Operations Manager works as expected.
We have since opened Store Administrator and tried to Connect to Database. The error is as follows:
"Cannot execute as the database principal because the principal 'guest' does not exist. This type of principal cannot be inpersonated or does not exist. "
It is suggesting that the connection is made as 'guest' but I have specified a different user. It's possible that when Administrator makes it's connection it assumes the 'guest' role from some stored function or something coded into the Administrator application or in a stored procedure in the database. I looked for stored procedures in the database and couldn't see anything that I thought might be a problem.
So I'm left wondering if the 'guest' user on the database server requires a certain level of permission in SQL 2012 that may have already been assumed/default in SQL 2000.
At the point of the hardware failure I used a simple PC as a remedial stop-gap until we purchased the new server. This ran SQL 2008 and the problem was not evident there.
Finally, this is not a problem when connecting to the database via SQL Management Studio, so it leads me to believe it is particular to the RMS Administrator program in some way.
Thanks for your help.
