I am trying to setup a snapshot replication from our SQL 7 database to another SQL Server 7 test server. I am new to this but I think I set up the publisher, distributor, and created the publication correctly. However, when I try to do the push subscription I get the following:
The process could not connect to Subscriber XXX.
I check the connection and user and then tried again and got:
The initial snapshot for publication XXX is not yet available.
After playing around with it some more, I am back to the connection error.
I can odbcping the test server, but if I try to put in a user or password I get a "Could not connect to SQL Server" error.
Can someone please explain exactly what users I should be using on which systems. Can I use the Windows NT users? That is what I am trying to do. SQL Server agent was originally using the system account which I changed to the Administrator account that we use in NT.
Any help on the problem and solutions and if it is with the user, exactly which user should be used and where the reside would be extremely helpful. Thank you
The process could not connect to Subscriber XXX.
I check the connection and user and then tried again and got:
The initial snapshot for publication XXX is not yet available.
After playing around with it some more, I am back to the connection error.
I can odbcping the test server, but if I try to put in a user or password I get a "Could not connect to SQL Server" error.
Can someone please explain exactly what users I should be using on which systems. Can I use the Windows NT users? That is what I am trying to do. SQL Server agent was originally using the system account which I changed to the Administrator account that we use in NT.
Any help on the problem and solutions and if it is with the user, exactly which user should be used and where the reside would be extremely helpful. Thank you
