SQL error message

[Vidya]

Hi,
I have an infopath form as a link in a website. When I click on the link I
should have the new form opened where I can load the data. Then there is a
submit feature that allows me to submit it to an MSSQL database.
Now, when I click on the form, I get the error message - connection failed.
SQL server does not exist or access denied. All the other users are able to
open the forms and submit.

Can someone help ?
This is urgent.

Thanks in Advance.
Vidya

 

[S.Y.M. Wong-A-Ton]

The error "SQL server does not exist or access denied" can be caused by
several things, but the main thing to check is the connection string that you
are using. Make sure that you are connecting to the correct server (IP
address or server name), and make sure that the user has access to the
database. You might have to add him/her to a group in the database or
something similar to give access.

 

[Vidya]

Thanks a lot ! I figured out the problem. It was a network issue where the
network was not able to resolve the SQL Server by name. I was able to ping it
by IP address but name did not work. So they had it fixed for me.

But your reply to my post gave me the direction. Thanks again for your time!!

Regards.

 

[S.Y.M. Wong-A-Ton]

No worries. Glad you solved it.