Opereating System returned 5(Access is denied) while attempting to RestoreContainer::ValidateTargetForCreate on

I got the following error while creating a database:

Opereating System returned 5(Access is denied) while attempting to RestoreContainer::ValidateTargetForCreate on

Cause: The user running the MSSQLSERVER service does not have proper access to the path.

Solution: Give proper access to the 'user' running the MSSQLSERVER service.

SQL Server backups in network location

I had to take backup off-server to a network location. So, created a job tried running manually; it ran just fine. I scheduled the job check during the run time, it fail! Job history
(

Expand SQL Server Agent under Instance

Expand Jobs

Right click the job and choose View History

)

showed the \ did not have permission on the location. Gave the domain user full access to the location, still did not work. I check the user under which the SQL Server (InstanceName) service was running, it was a different domain user; once this domain user had FULL CONTROL to the network location, the job started backing up in a network location specified by UNC.

Here is a reference: Microsoft Article

Hope this help someone.

astu...

SQL Server 2008 Alias

SQL Server Alias setup in the client setup and NOT the server setup. It took sometime to understand the fact. The other thing that tricked me was 32-bit and 64-bit version of the tool, cliconfg.exe. It depends on the application you are trying to setup the alias for - meaning, if the application is 32-bit use c:\Windows\SysWOW64\cliconfg.exe and if it is 64-bit application just use normal cliconfg.exe (assuming that you are in 64-bit machine).

cliconfg.exe is a Windows OS tool and therefore does not need additional installs.

1. Run the application, either from c:\Windows\SysWOW64\cliconfg.exe (for 32-bit)
    or c:\Windows\System32\cliconfg.exe or just press windows + r and type cliconfg and hit enter (for 64-    bit)
2. In SQL Server Client Network Utility window > General tab, enable TCP/IP (or desired protocol)
3. In Alias tab, click Add
4. In Edit Network Library Configuration window, give in Server alias, Server Name, and Server name
5. Click OK
6. Click OK

astu...