Error 14053: Cannot load the DLL replincrementlsn extended procedure...

I am setting up a transactional replication between two MSSBS2K servers, both running MSSQL2K. Both are on different domains, but are currently in the same network (until all data is replicated, then the subscribe will move to a remote site and pull changes periodically).

Everything is working on the publisher/distributor side, but when I attempt to subscribe to the distributor, I get the following message:

Error 14053: Cannot load the DLL replincrementlsn extended procedure, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
The subscription could not be updated at this time.
The subscription could not be created.

Has anyone experienced this? I have scoured the Internet for this error, and have come up basically empty. All I found either suggest checking for the existence of the sp_replincrementlsn and sp_replincrementlsn_internal (both of which exist) or suggest an incomplete SP install. Neither of these is the case.

Personally, I tend to suspect a permissions issue when trying to launch the appropriate DLLs is generating this less-than-intuitive error message, but I cannot determine how to go about resolving this. I am using SQL authentication to connect, and both servers use local (to their domain) non-system accounts to log in. This works fine for launching queries across the servers. Could there be a deeper permissions issue at play here?

I'm at a dead end, and I need to get this issue resolved ASAP, as this server needs to be deployed yesterday. Any help you can provide will be most appreciated!Did you have any options on the install of SQL Server, or was it all a big black box install courtesy of Microsoft? On the surface, I would suspect that replication was not installed on the SQL Server. Do a search on your box for xprepl.dll. Let us know what comes back.|||Yes, xprepl.dll is installed in the C:\Program Files\Microsoft SQL Server\MSSQL\Binn folder.

This install is a Windows Small Business Server 2000 install that I performed personally. I installed MS SQL based on the standard defaults. Just to be sure, though, I just now re-ran the installer and verified that the "Replication" checkbox is checked by default.

Did you have any options on the install of SQL Server, or was it all a big black box install courtesy of Microsoft? On the surface, I would suspect that replication was not installed on the SQL Server. Do a search on your box for xprepl.dll. Let us know what comes back.|||Update: Never could get past that error. Went with merge replication instead of transactional replication and it works fine. Only caveat is that this did require I move the new server under the same domain as the publisher/distributor server (rather than as a separate domain in the same forest). Small price to pay for getting this replication up and going.

error 0: cannot load the dll, xpstar.dll

hi
i use sql 2000 server and windows 2003 standart server.
i have problem, when i open the database in sql server,
i see this error message
"error 0: cannot load the dll, xpstar.dll .. reason 126"
what can i do?
thankskucuktosbiii (aliyorulmaz2006@.gmail.com) writes:

Quote:

Originally Posted by

i use sql 2000 server and windows 2003 standart server.
i have problem, when i open the database in sql server,
i see this error message
"error 0: cannot load the dll, xpstar.dll .. reason 126"
what can i do?

NET HELPMSG 126 says "The specified module could not be found." That
would indicate that the DLL or a file it depends on is missing.

I search on Google on "XPSTAR" and 126 and found a few hits that
agreed with this diagnosis. The one at
http://forums.microsoft.com/MSDN/Sh...753428&SiteID=1
looks particularly promising.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Acces

Hi,
When I run Microsoft SQL Server Enterprise Manager and click on the
Properties of the SQL Server Registration, I get this error. Error 0: Cannot
load the DLL xpstar.dll, or one of the DLLs it references. Reason: 5(Access
is denied.). The SQL Server has the latest service pack SP3a. How can I
solve this problem? I used Google but didn't found a solution. Thanks in
advance.
Kind regards,
Sven Aeyels.Sven,
1. Does the SQLServer account has relevant privilege on the /Binn folder
where most of the DLLs reside?
2.Any more info in the event viewer?
3.Did you install any software after SQLServer which might have messed up
the DLLs? Even otherwise try to Run Component Checker tool to check any
discrepancies in the MDAC.More info:
'INFO: Component Checker: Diagnose Problems and Reconfigure MDAC
Installations'
http://support.microsoft.com/?id=307255
4.See if a MDAC reinstall solves the issue.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Sven Aeyels" <sven_aeyels@.hotmail.com> wrote in message
news:eJBfsqgSEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Hi,
> When I run Microsoft SQL Server Enterprise Manager and click on the
> Properties of the SQL Server Registration, I get this error. Error 0:
Cannot
> load the DLL xpstar.dll, or one of the DLLs it references. Reason:
5(Access
> is denied.). The SQL Server has the latest service pack SP3a. How can I
> solve this problem? I used Google but didn't found a solution. Thanks in
> advance.
> Kind regards,
> Sven Aeyels.
>|||Hi,
Thanks for the info. I reinstalled the MDAC and the problem is gone.
I think the problem started when I installed the Security Update for
Microsoft Data Access Components (KB832483). Are there any known issues with
this update? Thanks in advance.
Kind Regards,
Sven Aeyels.
"Sven Aeyels" <sven_aeyels@.hotmail.com> wrote in message
news:eJBfsqgSEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Hi,
> When I run Microsoft SQL Server Enterprise Manager and click on the
> Properties of the SQL Server Registration, I get this error. Error 0:
Cannot
> load the DLL xpstar.dll, or one of the DLLs it references. Reason:
5(Access
> is denied.). The SQL Server has the latest service pack SP3a. How can I
> solve this problem? I used Google but didn't found a solution. Thanks in
> advance.
> Kind regards,
> Sven Aeyels.
>