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-10-02 : 10:11:15
|
| I keep getting this error on my one my databases. I've used the update one which fixes temporaraly, but always comes back when I least expect it. I also ran Chads orphan users script. We're using SQL authentication and not NT. It says X user is not a valid user for database which they have no connection to. I ran update one on both databases for their respective user. If anyone can shed some light I'd greatly appreciate it.SQL2K , SP3 ERROR: Microsoft Data Transformation Services (DTS) Package - Unable to find the source database for Transfer on the source server. (Microsoft SQL-DMO (ODBC SQLState: 08004) (80004005): [Microsoft][ODBC SQL Server Driver][SQL Server]Server user X is not a valid user in database X .) has occured in modGlobals.sqlTracePackageError on line 0 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-02 : 12:51:53
|
| sp_change_users_login will only help if the user has been granted access to the database. It seems as if this user has been removed from the database, so you'll need to sp_grantdbaccess for that user then provide permissions.Tara |
 |
|
|
MediaPirate
Yak Posting Veteran
52 Posts |
Posted - 2003-10-02 : 13:42:04
|
| Tara- I could understand that if the user was trying to access their database. However, let me clear it up if I can. Say I have John and he's trying to connect to his database Johndatabase. John is listed as a 'dbo' for Johndatabase , but sometimes out of the blue when John try's to connect he gets:[Microsoft][ODBC SQL Server Driver][SQL Server]Server user John is not a valid user in database Janesdatabase .) has occured in modGlobals.sqlTracePackageError on line He's not trying to connect to Jane's database, just his own. So I check Jane's user to make sure it's set as DBO on her own database and it is. The only temp fix I've been able to do is the Update_One .. but it comes back after some time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-02 : 13:47:54
|
| It sounds like you've got something messed up in the system tables. What I would do is drop John's account and then recreate it from scratch. This should fix everything.Tara |
|
|
|
|
|
|
Orphan User Error?