November 11, 2009 at 4:42 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:13 pm
Is this from a named instance or a default instance?
-Roy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply