Could not configure server as a distributor (SQL 2005)

Arghh ...

I have searched all the newsgroups and applied or tried all the suggestions, with no success. I have completely uninstalled and reinstalled SQL 2005.

Can someone point me in the right direction? Here is the error I receive when I try to 'Configure Distribution' in the SQL 2005 management studio.

Any/all help is greatly appreciated.

Tery
PS. The destination path mentioned in the error is definitely a correct path.

TITLE: Microsoft.SqlServer.ConnectionInfo

SQL Server could not configure 'LAPTOP' as a Distributor.

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

An error occurred during the execution of xp_cmdshell. A call to 'CreateProcess' failed with error code: '5'.
Invalid destination path C:\Program Files\Microsoft SQL Server\MSSQL\Data.
Changed database context to 'master'. (Microsoft SQL Server, Error: 15121)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15121&LinkId=20476

BUTTONS:

OK

error code 5 means "Access is denied", looks like you run into some permission issue. Make sure the SQL Server service account has enough permission on the SQL Server data folder, you can check the permission of Data folder to see if you service account account is there (or add it to local administrators group to see if things improve). This could happen due to various reasions, for example, you changed SQL Server service account after SQL Server installation (through control panel->services but not SQL Server configuration manager)

Hope that helps,

Zhiqiang Feng

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

That was exactly the problem!

Thank you for taking the time to help me.

Tery

|||

Hello

I got the same error while configuring the Tran Replication. I am the Domain admin, i added my user in to Built in Admins and try with sa permissions also. Still i am unable to create Distribution database.

please advice, Thanks