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 |
|
MediaPirate
Yak Posting Veteran
52 Posts |
 Posted - 2003-08-14 : 14:33:23
|
I've got another one  .. I'm having trouble with one of my users who's trying to create a DTS package on the server. When he tries saving the package it gives him:Error Source : Microsoft OLE DB Provider for SQLError Description : Server user 'x' is not a valid user in the database 'msdb' Now, I tried to create the DTS package for him. I receive the same error, and I checked to ensure I was specifying his database and his username and password. If I save a "local user" then it works. I figured maybe his user became corrupted in the msdb database so I deleted it and recreated.. I still get the error. We're using SQL authentication. SQL 2000, SP3 .. Again, you guys are great thanx! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-14 : 17:13:58
|
| What permissions does the user mapped to his login have in msdb?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
MediaPirate
Yak Posting Veteran
52 Posts |
Posted - 2003-08-14 : 18:23:49
|
| His user has no permissions to the MSDB database. The only user who has permissions on this database is 'SA'. However, this is the only user effected and nobody else has access to this database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-14 : 18:27:50
|
| I believe that the user needs to be able to write to sysdtspackages in msdb database. Probably need insert privilege. I'll test this out.Are other users able to save packages to the server?Tara |
|
|
|
MediaPirate
Yak Posting Veteran
52 Posts |
Posted - 2003-08-15 : 11:08:27
|
| The only difference I've found is, this SQL server's MSDB database doesn't have the guest user. However, our other SQL servers do. The strange thing is, the guest user isn't even a login anymore. I thinks I smell foul play :-( |
|
|
|
MediaPirate
Yak Posting Veteran
52 Posts |
Posted - 2003-08-15 : 11:19:10
|
| Ok, future note to all.. thats the proble.. you have to have the guest user with public access to the msdb database to save local DTS packages as a user. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-15 : 12:38:36
|
| Thanks for the information, I didn't know that.Tara |
|
|
|
|
|
|
Annoying error.