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 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2004-10-20 : 04:18:57
|
Just 2 days ago (which was the reason for my "absence" in the forum), all servers shutdown due to loss of power and UPS was not able to hold up (according to our netadmin). We had some really major operations issues going around,not to mention the primary server/cluster totally failed. SqlServerAgent doesn't start automatically (but was set to do so) and replications, jobs, alerts, the works were failing. Although it was really lucky for us that users can still logon and issue requests to the server.So, I spent the entire day transferring the entire load to a hot standby (and thank God I decided to set this up before, even if netadmin told me it was a waste of space). To cut the story short, after everything was transferred, I encountered this problem in all databases. All accounts, though with permissions coming from the "old" server, were encountering permission errors.I really don't know the cause but rebuilding the accounts (dropping and adding them back) did the trick (now i'm modifying all of the user scripts to anticipate this, if it will happen again).Question: Any Idea what went wrong? The cluster service for network name failed, log tells us that a duplicate name exists, (but accdg to our netadmin, the name is unique).P.S. users were not orphaned, no problem with aliases and maps, permissions were still there in the list, except that some users can't be viewed using the enterprise manager but if I add the user, it says user is already existing.--------------------keeping it simple... |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-10-20 : 05:07:31
|
I've seen something like this before... In the end, I think I had all permissions etc. scripted, and have this kind of syntax:--loginsIF EXISTS(Select * From master..Syslogins Where name = 'loginname') exec sp_revokelogin 'loginname'exec sp_addlogin '',''--User DB'sIF EXISTS(Select * From sysusers Where name = 'DBUser') exec sp_dropuser 'DBUser'exec sp_adduser 'DBUser','DBUser','db_datareader' *##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-20 : 06:54:02
|
| it was kinda weird coz, the users are there including the permissions, but it seems the permissions were not applied. --------------------keeping it simple... |
|
|
|
|
|
|
|
|
weird problem with logins