none
Change the default location of databases fails with access denied RRS feed

  • Question

  • I use Sql Server management studio 18.3.1 to change the default directory path for databases for Sql Server 2016 LocalDb instance. But i receive the error:

    RegCreateKeyEx() returned error 5, 'Access is denied.' (Microsoft SQL Server, Error: 22002)

    I tried to add the user NT SERVICE\MSSQLSERVER to the folder where i moved the databases, but it didn't work.

    I also ran Sql Server management studio as an administrator, but still the access denied.

    Any suggestions?

    Wednesday, November 20, 2019 9:11 PM

All replies