Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
SQL Server - Access is Denied
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011-07-16
09:57 AM
2011-07-16
09:57 AM
SQL Server - Access is Denied
I just purchased a readyNas Pro 2.
got the iSCSI set up and running.
moved my SQL Server 2008 databases over to the device.
When I try to reattach my databases, I receive a "Access is Denied".
What do I need to do to make this happen ?
Thanks
got the iSCSI set up and running.
moved my SQL Server 2008 databases over to the device.
When I try to reattach my databases, I receive a "Access is Denied".
What do I need to do to make this happen ?
Thanks
Message 1 of 3
Labels:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011-07-25
03:20 PM
2011-07-25
03:20 PM
Re: SQL Server - Access is Denied
Have you opened the iSCSI initiator on the server 2008 system to verify that the targets are still actually connected? If the SQL server itself is freaking out because the databases are now in a different path, unfortunately I can't help with that(as that's specifically a SQL issue, but one of our forum users might have some input).
Message 2 of 3
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2011-07-26
01:30 PM
2011-07-26
01:30 PM
Re: SQL Server - Access is Denied
That sounds permissions related. After checking that you can see the database files, check that the service account running the SQL services has permissions to the data. If you dont care about security then set the SQL directory and files to everyone/full control.
Message 3 of 3