RE: Not able to make table design changes
From: Trillium (anonymous_at_discussions.microsoft.com)
Date: 03/17/04
- Next message: Rich: "Installation"
- Previous message: Dave: "Security between multiple instances"
- In reply to: Bryan Ivie: "Not able to make table design changes"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 17 Mar 2004 14:11:21 -0800
Thanks for the reply.
I did go through the orphan user initially but still have this problem.
If I completely remove the user from the sysusers table it still comes up with:
Save Incomplete
- Unable to preserve security settings for user '\USER'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is no such user or group '\USER'.
when I try and save the table after making a design change. But instead of \User is has \(a few wierd symbols)
It of course doesn't say that but actually has some symbols instead of the user name.
I have gone every which way with the orphan users. Made sure SID matched up in the master database. Removed the account from the sysxlogins table in master database and user database. Rebuilt the account and so on.
Thanks for any help,
Trillium
- Next message: Rich: "Installation"
- Previous message: Dave: "Security between multiple instances"
- In reply to: Bryan Ivie: "Not able to make table design changes"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
