Dear Sirs. I Have a Pc were i have made the development, where i have sql 2005, sql server mobile etc. I have made a program with a merge replication. It works fine on lan using wireless. I have maped a public ip address opened the tcp 80 port and doing nat to the pc. I able to do the http://xxx.xxx.xxx.xxx/aaaaaaa/sqlcesa30.dll, it ask for authentication, and after display's the "sql server mobile server agent 3.0". but when i ran the aplication (it sync's ok on a wireless lan, only changing the ip address to the public address) it apears : Failure to connect to SQL Server with provided connection information. SQL Server4 does not exist, access is denied because the IIS user is not a valid user on the SQL server, or the password is incorrect"
Thanks .
Paulo Costa
Is this public IP a different machine? If so, it authenticaion mode needs to be set and your application needs to use that approprate authentication mode. Additionally the credentials you use in your application need to be trusted and/or validated by this IIS machine. Please verify that you are doing this and reply back if you still have issues.
No comments:
Post a Comment