All security permission in my new SQL server.

From: Niitmalad (Niitmalad_at_yahoo.co.in)
Date: 06/22/03

  • Next message: Shaithilya: "Problem with SQL connection.. Failed to create SSPI context." 
    Date: Sun, 22 Jun 2003 08:52:42 -0700

    Hi friends

    My boss have asked for the disasterrecovery and our
    system admin have created the same server configration on
    another server. We have install the SQL server on the
    same and restore the backup but now i see there is no
    permissions available to the users.

    please guide me so that I can restore the permission on
    the same server so that in case of failover i do not have
    to give the permission just restore will help me to start
    with the new server.

    your earlier guidence will help me to solve the problem.

    thanks and best regards
    NiitMalad

  • Next message: Shaithilya: "Problem with SQL connection.. Failed to create SSPI context."

    Relevant Pages

    • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
      ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
      (microsoft.public.sqlserver.setup)
    • Re: Long delay before Drives & Files appear in My Computer & Address Bar
      ... > SERVICE JEFF-DZP8HX39G2 The machine-default permission settings do not ... > grant Local Activation permission for the COM Server application with ... > Ratcliff JEFF-DZP8HX39G2 The Adobe LM Service service was successfully ... > within the required timeout. ...
      (microsoft.public.windowsxp.help_and_support)
    • Re: Two Disaster Recovery Questions
      ... I support the Professional Association for SQL Server ... > recovery site ... > second restore at the recovery site. ...
      (microsoft.public.sqlserver.server)
    • Re: Cant restore master db!!
      ... I tried starting the server as you & Hari instructed; the server started in single user mode. ... the restore has to be issued from the Veritas software interface. ... SQL Server returned the following error message: ...
      (microsoft.public.sqlserver.server)
    • Re: SQL Server execute permission denied on object
      ... This is a permission problem: the Login account or the required permissions ... have not been set up properly on the remote database. ... Recently the SQL part was moved to a new server. ... SQL Server execute permission denied on object ...
      (microsoft.public.access.adp.sqlserver)
    Loading