March 2, 2005 at 12:32 pm
Hello. I'm trying to setup a transactional/updatable push subscription. Whenever I try to modify the subscription I get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. I login to SQL both on the client and server side under my domain account which has admin status on both boxes and SQL servers. I've setup Enterprise Manager (with help from the client network utility) to register both servers under the multiprotocol network library with windows authentication. TCP/IP and named pipes are also enabled. I've tried straight SQL authentication too as both client and server are setup for both SQL and Windows. I'm not explicitly trying to login as 'sa'. I've tried setting up this subscription several times going as far as blowing away the publication on the server and the subscription databases on the client. I've used sp_link_publication with various settings to explicitly try to log in as someone other then 'sa'. I've used sp_subscription_cleanup and checked with sp_helpsubscription_properties to verify the cleanup everytime I blow away the subscription. When I set up a new publication and push the subscription again, sp_helpsubscription_properties comes up blank. If I run sp_link_publication with a username and password other then 'sa' I still get the same error message for 'sa'. Then sp_helpsubscription_properties shows the info I entered, but a publication_type of 0 (snapshot, not transactional!) Could I have a problem authenticating my DTC service? I've also played with having services on either/or/both the client and server run under my domain account instead of the localsystem. I'm starting to feel I'm chasing my tail here! HELP!! TIA~~
March 2, 2005 at 1:50 pm
Hi, try to change sa password and then reconfigure ODBC connection.
Branko G
March 3, 2005 at 4:43 am
http://support.microsoft.com/default.aspx?scid=kb;en-us;320773
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply