SQL2012 RC0 install to 2003 file share - install fails due to incorrect tempdb file perms - by Randy Rabin

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 720745 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/25/2012 7:29:35 AM
Access Restriction Public

Description

I'm trying to install SQL to a file share located on a Windows2003 server. The installation proceeds to a certain point, then fails. I've tried both nonclustered and clustered installs.

The installation appears to fail because the SQL instance cannot start up; more precisely it starts, then shuts down again. In looking through the errorlog, I'm seeing an Access Denied error on tempdb.mdf. I have checked the share and file-level permissions, and as far as I can tell they are set appropriately - I'm using a domain account to run the SQL services, and that same account has full permissions to both the share and the physical folder tree on the target server.

After the install fails, I'm left with the SQL services showing under Config Manager. When I try starting SQL from there, same result - it starts, gets Access Denied, and shuts down again.

However when I go to the file share, and explicitly grant permissions on tempdb.mdf and templog.ldf to the service domain account, I can then start SQL Server successfully.

As a final test, I deleted these two files, started SQL one more time, and once again it failed with the same error.

*****************************************************************
Followup: Creating the file share on a Windows2008 R2 server worked. The install completed successfully.
Sign in to post a comment.
Posted by Microsoft on 2/19/2013 at 3:27 PM
Installing to file shares requires the service account to have control permissions to the share.