Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-17 : 08:57:39
|
Temple writes "I have setup a job that backups a database once a month. This job needs to be kicked off by a computer room operator. I am trying to setup an id with a fixed server role (processadmin) and a fixed database role (db_backupoperator). When I attempt to use the id the job will not start. It tells me "Server user 'guest' is not a valid user in database 'mydatebase_name'." The login name and the user name are the same and it has a login in the database. If I setup the guest account in the database it will work. But I do not want to leave the guest account out there (security issue). Anyone have any suggestions.
Thanks in advance for your help." |
|
|
|
|
|
Fixed Roles