Post reply

DB Permissions

  • May 22, 2007 at 4:09 am

    #196033

    Hi,

    We are currently having problems with db permissions on one of our databases. The server that the db is on is in a cluster. When failover occurs the db loses its permissions, is there any way we can resolve this? When there is a failover the db must automatically keep the permissions. Can anyone pls help.

    Regards

    IC

  • May 22, 2007 at 4:34 am

    #707991

    It sounds as if your instance of SQL Server isn't properly clustered.  However, without more specific information, it's difficult to help you.  What error messages are you getting?  Is this just for one database or the whole instance?  What sort of permissions are you talking about?

    John

  • May 22, 2007 at 4:44 am

    #707993

    We have assigned db_owner rights to a user and it seems as if those rights are not being taken over. I far as the error messages are concerned, I would'nt know, the system administrator is responsible for the failovers.

    IC

  • May 22, 2007 at 4:58 am

    #707997

    What makes you think those rights are not being taken over?  Can the user still connect to the database?  How are you trying to connect?

    John

  • May 22, 2007 at 5:36 am

    #708004

    hi sorry. my questions below are not related to current discussion but they are something similar. not sure where to post my questions -

    i have a list of of users who can physically login to the SQL server. there is builtin/admin, sa, and some service accounts. but there is a user account and a user group. what is the implication of this? does this mean that the user account and the users in the user group can modify data in my database? how will i check that the users cannot directly modify my data.

    thanks.  

  • May 22, 2007 at 6:45 am

    #708041

    Please start a new thread.  Follow the link below, then choose the most appropriate forum and click on New thread.

    http://www.sqlservercentral.com/forums/default.aspx

    John

  • May 23, 2007 at 5:36 am

    #708288

    The SQL Server Instance is clustered. Permissions wouldn't be lost on a failover, as the entire instance fails over to the other node of the cluster.  As mentioned earlier, it doesn't seem as though SQL Server was installed properly on the failover cluster, or even the cluster wasn't properly configured.

    This is the first I've heard of this type of error on a cluster.

    Unfortunately it looks like you might need to uninstall/reinstall SQL Server, before doing so, you should see if you can send us the specific error messages.

    http://msdn2.microsoft.com/en-us/library/ms179530.aspx

    http://msdn2.microsoft.com/en-us/library/ms189910.aspx

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply