Hi,
I am using snapshot replication and want to create pull /
push replication but I always encountered same problem :
Login failed for user . . .
I think I had already set my user as an Administrator but
it didn't work.
Thanks in advance !
Michael Rawi
Michael,
in the subscriber database, right-click the distribution agent and select
properties.
On the security tab, choose to impersonate the SQL Server Agent.
You can change the service accounts to use the same domain user or have the
windows login of the subscriber's agent as a separate login on the
publisher.
HTH,
Paul Ibison
sql
Showing posts with label encountered. Show all posts
Showing posts with label encountered. Show all posts
Tuesday, March 27, 2012
Sunday, February 19, 2012
Can't load dll xpstar.dll
Has anyone encountered this error with SQL 2000?
It appears to be causing connectivity issues with SRS and other applications
which talk to the database.Yes...if the full error message is:
Cannot load the DLL xp_star.dll, or one of the DLLs it
references.
Reason: 126(The specified module could not be found.).
If so, you are likely missing one of the files that
xp_star.dll has a reference to. You can use a dependency
tool like Dependency Walker (Depends.exe) to list all the
dependency for xp_star.dll and narrow down which of the
files is missing.
-Sue
On Wed, 26 Apr 2006 10:55:02 -0700, LRWilson
<LRWilson@.discussions.microsoft.com> wrote:
>Has anyone encountered this error with SQL 2000?
>It appears to be causing connectivity issues with SRS and other applications
>which talk to the database.
It appears to be causing connectivity issues with SRS and other applications
which talk to the database.Yes...if the full error message is:
Cannot load the DLL xp_star.dll, or one of the DLLs it
references.
Reason: 126(The specified module could not be found.).
If so, you are likely missing one of the files that
xp_star.dll has a reference to. You can use a dependency
tool like Dependency Walker (Depends.exe) to list all the
dependency for xp_star.dll and narrow down which of the
files is missing.
-Sue
On Wed, 26 Apr 2006 10:55:02 -0700, LRWilson
<LRWilson@.discussions.microsoft.com> wrote:
>Has anyone encountered this error with SQL 2000?
>It appears to be causing connectivity issues with SRS and other applications
>which talk to the database.
Can't load dll xpstar.dll
Has anyone encountered this error with SQL 2000?
It appears to be causing connectivity issues with SRS and other applications
which talk to the database.Yes...if the full error message is:
Cannot load the DLL xp_star.dll, or one of the DLLs it
references.
Reason: 126(The specified module could not be found.).
If so, you are likely missing one of the files that
xp_star.dll has a reference to. You can use a dependency
tool like Dependency Walker (Depends.exe) to list all the
dependency for xp_star.dll and narrow down which of the
files is missing.
-Sue
On Wed, 26 Apr 2006 10:55:02 -0700, LRWilson
<LRWilson@.discussions.microsoft.com> wrote:
>Has anyone encountered this error with SQL 2000?
>It appears to be causing connectivity issues with SRS and other application
s
>which talk to the database.
It appears to be causing connectivity issues with SRS and other applications
which talk to the database.Yes...if the full error message is:
Cannot load the DLL xp_star.dll, or one of the DLLs it
references.
Reason: 126(The specified module could not be found.).
If so, you are likely missing one of the files that
xp_star.dll has a reference to. You can use a dependency
tool like Dependency Walker (Depends.exe) to list all the
dependency for xp_star.dll and narrow down which of the
files is missing.
-Sue
On Wed, 26 Apr 2006 10:55:02 -0700, LRWilson
<LRWilson@.discussions.microsoft.com> wrote:
>Has anyone encountered this error with SQL 2000?
>It appears to be causing connectivity issues with SRS and other application
s
>which talk to the database.
Subscribe to:
Posts (Atom)