November 11, 2009 at 6:08 pm
SQL 2005 SP2
-Database Replication failed last week after working great for 6 months.
-Recreated Database Replication(couple of different ways) Same errors
-Snapshot agent fails - "Executed as user: XXXXX\sql_admin. The system cannot find the path specified. [SQLSTATE 42000] (Error 14151). The step failed.
-Log Reader Agent fails- The last step to run was step 3 (Detect nonlogged agent shutdown.).
-Checked permissions for \Repldata folder - Sysadmin or domain admin(both Administrators) - same issue,
-Tired creating a share\Repldata folder - same issue.
-Checked folder permissions for Snapshot.exe-same issue
-Tried to manually start Snapshot.exe Fails(see below)
D:\Programs\Microsoft SQL Server\90\COM>snapshot.exe
System.TypeInitializationException: The type initializer for 'Microsoft.SqlServe
r.Replication.StringResources' threw an exception. ---> System.ApplicationExcept
ion: The native replication resource dll failed to load.
at Microsoft.SqlServer.Replication.NativeResourceStringLoader..ctor()
at Microsoft.SqlServer.Replication.StringResources..cctor()
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Replication.ReplMessage..ctor(Exception e)
at Microsoft.SqlServer.Replication.HistoryMessage..ctor(Exception e)
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.SnapshotGeneration
AgentMessageFactory.CreateAgentMessage(Exception e)
at Microsoft.SqlServer.Replication.AgentCore.LogMessage(Exception e)
at Microsoft.SqlServer.Replication.AgentCore.ThreadFailedHandler(Exception e)
The type initializer for 'Microsoft.SqlServer.Replication.StringResources' threw
an exception.
-Tried to Snapshot.exe -RegServer - same error as above
-Checking out all forums for any type of resolution - priceless! But still fails
Any help will be greatly appretiated!
November 12, 2009 at 2:14 pm
Is this a named instance?
-Roy
November 13, 2009 at 7:23 am
Roy,
No it is not, it is the default instance.
November 13, 2009 at 7:59 am
What kind or replication are you doing?
Is this a clustered SQL Server?
Is the publisher and distributor on the same server?
November 13, 2009 at 8:09 am
Check this link out...
http://msdn.microsoft.com/en-us/library/ms151868%28SQL.90%29.aspx
I am not sure if this will help.
Also someone here in SSC had a problem like this. Check the thread out.
http://www.sqlservercentral.com/Forums/Topic765285-291-1.aspx
-Roy
November 13, 2009 at 8:40 am
To answer some questions:
Erich,
Transctional Replication
Not a cluster
Yes the publisher and distributor are the same server.
Roy,
The Windows account that is used is the SQL sysadmin and an administrator on the server. I would think I would get a permissions type error rather than "Path not found"
November 13, 2009 at 8:43 am
Can you browse to the snapshot location from the server?
November 13, 2009 at 8:50 am
Erich,
Yes, I can browse to it - NO problems. Tried changing permissions, thinking that this may the problem - same issue, no changes.
November 13, 2009 at 8:53 am
Roy,
Yes I saw the post:
Also someone here in SSC had a problem like this. Check the thread out.
http://www.sqlservercentral.com/Forums/Topic765285-291-1.aspx%5B/i%5D
I was able to run the .exe manually and the error is posted above.
November 13, 2009 at 8:59 am
So just so I understand.
Are you dumping the snapshot on the same server with publication and distributor or is it a remote server?
November 13, 2009 at 9:34 am
Erich,
Yes the snapshot is on the same server with the publication and distributor.
November 13, 2009 at 9:39 am
Are you referring to the drive as C:\SQLShapShot or \\. I am assuming your SQL Server Service and SQL Agent are running as an account with permissions on the server. Any chance space might be an issue? Have you tried changing to a different path or drive letter?
I have had similar problems, but with servers in different domains not on the same server.
November 13, 2009 at 9:57 am
Erich,
I have tried referring to the drive as a share or \\ - both failed.
You are correct about the permissions, space is not an issue. Yes, I have previously tried changing different paths, just tried changing different drive - same problem.
November 13, 2009 at 10:04 am
I don't suppose your service account might be locked out?
I am sorry to not be of more help. Have you seen anything useful in the event logs on the server from when you try and run the snapshot agent?
November 13, 2009 at 10:15 am
Erich,
The account is not locked out
On the contrary, you are validating everything that I have done and I appreciate your help.
The event logs show Event Id 14151, "The system cannot find the path specified. The step failed."
That is the reason I went and ran "snapshot.exe" from command line and it failed.
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply