Login failed for user '(null)'.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Author

Topic

shifis
Posting Yak Master

157 Posts

Posted - 2005-05-24 : 19:15:17

Hi
I am trying to do a replication, but it didn't work. I got the next error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I am using on the subscription on the Securyti tab the next:
Impersonate the SQL Server Agent account on 'SIS-TERESITA' (trusted connection)

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-05-24 : 22:25:58

investigate the following:

1. is the account for the sql services on the publisher existing on the subscriber and do they have the same privileges?

2. is the builtin/adminstrators account denied or deleted from the logins? if yes, then you have to change to a logon in the security tab

3. is the publisher allowed to connect to the subscriber over the network? if no, allow

HTH

--------------------
keeping it simple...

shifis
Posting Yak Master

157 Posts

Posted - 2005-05-25 : 10:57:35

Good morning!

I am new doing this replication thing, the only references that I have is a book and a carpert of a training ( Microsoft SQL Server 2000 Database).

1. is the account for the sql services on the publisher existing on the subscriber and do they have the same privileges?

This are the user that I have on the subcriber:

BULTIN\Administrators Windos Group Permit master English
distributor_admin Standard Permit master English
logRepli Standard Permit master English
sa Standard Permit master English
SIS-TERESITA\Administrator WindowsUser Permit master English

and the user in the Publisher are:

BULTIN\Administrators Windos Group Permit master English
CIERHDBA Standard Permit master English
distributor_admin Standard Permit master English
sa Standard Permit master English
SQL_SMART\Administrator WindowsUser Permit master English

2. is the builtin/adminstrators account denied or deleted from the logins? if yes, then you have to change to a logon in the security tab

(HOW CAN I CHECK THIS)

3. is the publisher allowed to connect to the subscriber over the network? if no, allow

(HOW CAN I CHECK THIS)

Thanks for your help

shifis
Posting Yak Master

157 Posts

Posted - 2005-05-25 : 11:15:53

Maybe this can help

This is the message that the Publisher shows on the Agent history

Publisher : SQL_SMART Agent:SQL_SMART-bdPOS-SIS-TERESITA-12

Error:
The process could not read file '\\SQL_SMART\e$\DB\Microsoft SQL Server\MSSQL\ReplData\unc\SQL_SMART_bdPOS_bdPOS\20050524182004\tbITEMS_1.sch' due to OS error 1326.

Last Command
\\SQL_SMART\e$\DB\Microsoft SQL Server\MSSQL\ReplData\unc\SQL_SMART_bdPOS_bdPOS\20050524182004\tbITEMS_1.sch
Transaction sequence number and command ID of last execution batch are 0x000000070000030D000B00000002 and 4.

Category Source Number
OS 1326

and this is the message that apper on the suscriptions Job History

The process could not read file '\\SQL_SMART\e$\DB\Microsoft SQL Server\MSSQL\ReplData\unc\SQL_SMART_bdPOS_bdPOS\20050524182004\tbITEMS_1.sch' due to OS error 1326. The step failed.

and

The job failed. The Job was invoked by User SIS-TERESITA\Administrator. The last step to run was step 1 (Run agent.).

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-05-25 : 22:32:26

the builtin/administrators are users coming from your local machine's administrator group, from what you posted, they're permitted

ok, there are several things that you have to check:

first, check if the account that runs your sqlserveragent service is a member of the local admin group on both machines
- it seems that the services are running on local system account,
they should be running on a domain account that is member of the local admin group

come back with what you've checked

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources