can not load xpstar.dll

hi,
i have sql server sp3 running upon win 2000 adv server sp 4. the server is
configured for merge replication with another machine with same
configuration (sql server sp3 running upon win 2000 adv server sp 4). few
days back i recieved this error when i was trying to connect SQL server
remotely from one macine to the other.
Microsoft SQL-DMO(ODMC SQL State:42000) Error 0: cannot load the dll
xpstar.dll, or one of the DLLs it refferences. Reason: 126(the specified
module could not be found)
even if i could connect, i get the same error upon almost every activity on
the remote sql server. i found no reasonable solution to the problem on the
internet. finnally i uninsalled the sql server and then installed fresh sql
server and sp3. the problem was resolved. but afetr few days, i m facing
the same problem back again. i have repeated the same course of action.
i need to know any why this is happning so i could reach to the root of the
problem. installing back the sql server is not an optimal solution. need
help and fast.
thanx in advance.
Atif Chowhan
When you check you will find that xpstar.dll is actually there and loaded. The file missing is probably shfolder.dll. This folder resides in %systemRoot%\system32, copy it from any other server.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.