topic Re: SMSQL - Migration of SQL system databases fails in Data Protection

SMSQL - Migration of SQL system databases fails

radek_kubka — Thu, 05 Jun 2025 05:53:36 GMT

Hi,

I'm struggling to migrate SQL system databases using SMSQL 6.0.1 due to 'Access Denied' error. The environment I'm tinkering with is actually on Lab On Demand, so we are talking about Widows Server 2012 & SQL 2012.

I've read this thread:

https://communities.netapp.com/message/80985#80985

and this KB article:

https://kb.netapp.com/support/index?page=content&id=2016403&locale=en_US

One thing from KB which gives me a headache:

"Add the SQL Server (instance) service account user to the local administrators group"

How do I do that? When I try adding "NT Service\MSSQLSERVER" the relevant dialog window simply says "the name cannot be found". Internet research didn't bring me much further so far.

Any hints?

Regards,
Radek

Re: SMSQL - Migration of SQL system databases fails

welch — Fri, 27 Sep 2013 04:47:08 GMT

Try changing the SQL Server service account to a known account. You could use the administrator account in LOD.

Re: SMSQL - Migration of SQL system databases fails

radek_kubka — Tue, 01 Oct 2013 12:52:05 GMT

I tried this & it makes SMSQL completely unusable.

Interestingly enough, system databases migrate just fine when I play with another LoD environment where Windows Server 2008 is used (https://labondemand.netapp.com/index.php?labID=Insight_2012_MS-3-179_AlwaysOn_Availability_Groups_Setup_for_SQL)