Attached DB becomes Read-Only

Results 1 to 2 of 2

Thread: Attached DB becomes Read-Only

  1. #1
    Join Date
    Dec 1969

    Default Attached DB becomes Read-Only

    Hi,<BR><BR>I just attached a DB to the server and it showed up as read only. I&#039;m on the server itself, so I have admin access. <BR><BR>I found this answer on the net, but I don&#039;t really know how to go about doing it:<BR><BR>"It&#039;s the service account that SQL Server is running under that needs access to the files, not your account. Give that account permissions to the new directory and see if it works."<BR><BR><BR><BR>Can someone explain that a bit further? <BR><BR>Thanks!<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Attached DB becomes Read-Only

    Been a while since I&#039;ve done this so I may be wrong<BR><BR>on SQL Server go to <BR>Security/ logins<BR><BR>select the BUILTIN/Administrators<BR>and select &#039;Database Access&#039; check the box in there!<BR><BR>As I said been a while!<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts