Configuring the Distributor Replication

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Configuring the Distributor Replication

Author

Topic

manju3606
Yak Posting Veteran

78 Posts

Posted - 2011-07-26 : 03:08:12

Hi,

I'm Configuring the Distributor Replication and I'm getting the error

Configuring...

- Configuring the Distributor (Error)
Messages
SQL Server could not configure
'mssqlserver' as a Distributor. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

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

------------------------------

Destination path
C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\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)

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

- Enabling Publisher 'mssqlserver' (Stopped)

Manju

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-26 : 09:47:55

Are you local admin on the box?

What step in the configuration were you at when it happend?

What Version and Editions are the publisher, distributor and subscribers?

manju3606
Yak Posting Veteran

78 Posts

Posted - 2011-07-26 : 11:51:27

Hi,
I'm Configuring the Distributor Replication in a SA log in
and i am using sqlserver-2005 Enterprise Edition

I'm getting the error when Configuring the Distributor final step
when i clicking the finish button then i am getting that error

Thank you so much russell

Manju

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-07-26 : 12:19:07

Are you trying to make C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data the snapshot folder? If yes, don't. Then whatever folder you do use, make sure it is shared.

Did the distributor_admin account get created?

Is the SQL Agent account a domain account or local system account?

Is this Transactional Replication you're setting up?

Have you read this?

manju3606
Yak Posting Veteran

78 Posts

Posted - 2011-07-26 : 14:47:10

SQL Agent account is local system account
and know i'm getting this error

TITLE: Microsoft.SqlServer.ConnectionInfo
------------------------------

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

------------------------------
ADDITIONAL INFORMATION:

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

------------------------------

Destination path C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\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)

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

------------------------------
BUTTONS:

OK
------------------------------

Manju

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources