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 |
|
nachi
Starting Member
7 Posts |
 Posted - 2005-10-17 : 12:02:26
|
| I have moved the database from one machine to another machine and created all the jobs again by generating the sql script from the old machine. Now I'm not able to run the job if i make owner of the job as 'sa'. with all other users i'm able to run the job except 'sa'.Anybody have faced this kind of problem? Please help me... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-17 : 14:53:43
|
| What is the error?Tara |
 |
|
|
nachi
Starting Member
7 Posts |
Posted - 2005-10-18 : 02:11:41
|
| This is the error i'm getting "Cannot open database requested in login '<xyz>'. Login fails." |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-18 : 12:37:49
|
| You need to change the default database for the user that is having this problem.Tara |
|
|
|
|
|
|
Need help?