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.
| 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 |
|
|
|
|
|
|
Configuring the Distributor Replication