dbTalk Databases Forums  

Merge Replication Error: 'Failure to connect to SQL Server with provided connection

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Merge Replication Error: 'Failure to connect to SQL Server with provided connection in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
CFTK
 
Posts: n/a

Default Merge Replication Error: 'Failure to connect to SQL Server with provided connection - 03-05-2007 , 02:11 AM






Hi!
I´m trying to create a merge replication publication for a SQL Mobile
Application .
Everything works fine creating the publication and I'm able to do
the
http://xxx.xxx.xxx.xxx/aaaaaaa/sqlcesa30.dll, and it display's the
"sql server mobile server agent 3.0".

But when I run the application on the PDA and it´s doing the
replication it appears the following error:
'Failure to connect to SQL Server with provided connection
information . SQL Server does not exist , access is denied because
the
IIS user is not a valid user on the SQL Server , or the password is
incorrect' .


any idea of which could be the reason...?


Thanks in advance!!!


Reply With Quote
  #2  
Old   
CFTK
 
Posts: n/a

Default Re: Merge Replication Error: 'Failure to connect to SQL Server with provided connection - 03-06-2007 , 02:51 AM






We found the solution: to put also the name of the Sql Server Instance
as the publisher: Sql_Server\Sql_Server_Instance

On Mar 5, 9:11 am, "CFTK" <crodriguezdepa... (AT) gmail (DOT) com> wrote:
Quote:
Hi!
I´m trying to create a merge replication publication for a SQL Mobile
Application .
Everything works fine creating the publication and I'm able to do
thehttp://xxx.xxx.xxx.xxx/aaaaaaa/sqlcesa30.dll, and it display's the
"sql server mobile server agent 3.0".

But when I run the application on the PDA and it´s doing the
replication it appears the following error:
'Failure to connect to SQL Server with provided connection
information . SQL Server does not exist , access is denied because
the
IIS user is not a valid user on the SQL Server , or the password is
incorrect' .

any idea of which could be the reason...?

Thanks in advance!!!



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.