after moving tempdb SQL Server 2005 won't start

Greetings.

After altering the database to move tempdb to a new location SQL Server 2005 will not start. The error log follows. I can't seem to set the permission of the directory. Any suggestions on what to do next would be appreciated.

alan

2007-03-01 13:32:21.23 spid9s Clearing tempdb database.
2007-03-01 13:32:21.25 spid9s Error: 5123, Severity: 16, State: 1.
2007-03-01 13:32:21.25 spid9s CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data'.
2007-03-01 13:32:21.25 spid9s Error: 17207, Severity: 16, State: 1.
2007-03-01 13:32:21.25 spid9s FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data'. Diagnose and correct the operating system error, and retry the operation.
2007-03-01 13:32:21.25 spid9s Error: 17204, Severity: 16, State: 1.
2007-03-01 13:32:21.25 spid9s FCB::Open failed: Could not open file D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data for file number 1. OS error: 5(Access is denied.).

what error says is the Startup account of MSSQLSERVER Service does not have permission to the new location of Tempdb ie. 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data'.. Give proper permission and try

Madhu

|||

Thanks.

I tried it, including changing the inheritance properties of the directory, but still get an error message. After changing the permissions, nothing is added to SQL Server error log.

alan

|||

It might be worth deleting any tempdb files that already exist in the new folder. It could be that the SQL Server service account doesn't have permissions to overwrite the existing files - this can happen if the files aren't set to inherit permissions. The tempdb database files will be re-created when SQL Server starts.

Chris