× NETGEAR will be terminating ReadyCLOUD service by July 1st, 2023. For more details click here.
Orbi WiFi 7 RBE973
Reply

SQL Server - Access is Denied

eskrima
Follower

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
Message 1 of 3
Grievous
Aspirant

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
greyt
Aspirant

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
Top Contributors
Discussion stats
  • 2 replies
  • 3824 views
  • 0 kudos
  • 3 in conversation
Announcements