Data Backup and Recovery Discussions

SMSQL - Migration of SQL system databases fails

radek_kubka

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

2 REPLIES 2

welch

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

radek_kubka

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)

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public