Setting up a local database with administrator rights

  • When setting up a local MS SQL Server database on a PC, what rights should be used?  We used Administrator rights.  But when these administrator rights were removed from the machine, the database that we set up locally was no longer available for access.  Is it possible to sort this out?  Or did we set up the database incorrectly?

  • So, are you saying the login used to start the service for MSSqlServer was removed?  Or just the Administrator rights were removed from the login?

    I believe that the service must be run from the Local System Account or an account that has Adminstrator rights (local or domain).

    Steve B.

  • The Administrator rights were removed from the login.

Viewing 3 posts - 1 through 2 (of 2 total)

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