NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
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
2 Replies
Replies have been turned off for this discussion
- 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).
- 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.
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
