Unable to open the physical file xxxx. Operating system error 2

在新UAT服务器上，需要将tempdb放置在SSD（固态硬盘）上。由于SSD（固态硬盘）特性，所以tempdb的文件只能放置在D盘下面，而不能是D盘下的某一个目录下面。

ALTER DATABASE tempdb

MODIFYFILE(name='tempdev', filename='D:/tempdb.mdf') ;

GO

ALTER DATABASE tempdb

MODIFYFILE(name='templog', filename='D:/templog.ldf') ;

GO

修改了tempdb的目录后，重启数据库服务，结果出现错误信息：“FCB::Open failed: Could not open file D:/tempdb.mdf for file number 1. OS error: 2(The system cannot find the file specified.)" ，具体错误信息如下所示：

2015-05-27 ;11:56:44.88 spid9s The resource database build version is 12.00.2000. This is an informational message only. No user action is required.

2015-05-27 ;11:56:45.49 spid9s Starting up database 'model'.

2015-05-27 ;11:56:45.67 Server The SQL Server Network Interface library successfully registered the Service PRincipal Name (SPN) [ MSSQLSvc/GEK-MIS01UAT.gfg1.esquel.com ] for the SQL Server service.

2015-05-27 ;11:56:45.67 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/GEK-MIS01UAT.gfg1.esquel.com:1433 ] for the SQL Server service.

2015-05-27 ;11:56:45.83 spid9s Clearing tempdb database.

2015-05-27 ;11:56:45.84 spid9s Error: 5123, Severity: 16, State: 1.

2015-05-27 ;11:56:45.84 spid9s CREATE FILE encountered operating system error 5(access is denied.) while attempting to open or create the physical file 'D:/tempdb.mdf'.

2015-05-27 ;11:56:45.94 spid9s Error: 17204, Severity: 16, State: 1.