0

I'm trying to configure replication on a new install (moving to SQL 2012) and I keep getting the same error even after messing with the service name, folder permissions, etc...

Using the Configure Distribution Wizard, I'm getting the following error:

SQL Server could not configure 'SQL01' as a Distributor Additional information: An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Connectioninfo)

Destination path E:\MSSQL\Data is not valid. Unable to list directory contents. Specify a valid destination path. Changed database context to 'master'. (Microsoft SQL Server, Error: 14430)

I logged in as the local Administrator. I connected to SQL using the local Administrator account. I tried running SQL Server/Agent as NETWORK SERVICE as well as making a local user and using the local user. The local user has full permissions to E:\MSSQL\Data folder which is where all the databases are kept.

Windows Server 2008 R2 SQL Server 2012 SP2

Thank you, Adrian

  • In your destination path E:\Microsoft SQL Server\DATA is not valid. Unable to list directory contents. Specify a valid destination path. – Md Haidar Ali Khan Feb 1 '15 at 6:42
  • After replication once you must reboot the windows server. – Md Haidar Ali Khan Feb 1 '15 at 6:51
  • E:\MSSQL\Data is a valid path, it contains all the databases. – Adrian P Feb 1 '15 at 7:09
  • Use the 'sa' account to configure the Replication topology. – Md Haidar Ali Khan Feb 1 '15 at 8:42
  • This problem occurs because the SQL Server system administrator account name is changed. The Configure Distribution Wizard requires the account name to be sa. – Md Haidar Ali Khan Feb 1 '15 at 8:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.