SQL connection OUTSIDE of domain

[bairda]

Hi! I have an infopath form that receives data from a SQL db and populates
several form fields. The form works great on any machine inside of the
network. However, any client connecting from a location outside the network
gets a SQL connection error.

I have checked the connection string in the mainfest.xsf file and tested it
in other applications with no problems. The form is running on a local
Sharepoint server with the SQL db also local to that server.

I have seen several posts from people with similar problems. However I
never saw a definitive solution.

Any ideas?

Thanks,
-Alex Baird-

 

[bairda]

Anyone???

 

[bairda]

Ok...found my own solution. This may help someone else, but this was my
workaround....

I had to add a new user to the SQL db, give it owner rights and use that
instead of the "sa" account I had been using. I am using SQL authentication
and this seems to work fine. This solved ALL of the problems.

If you still get errors after doing this, make sure that you "enable" the
"access data sources across domains" in the IE tools/security settings. If
this isn't enabled you will get errors when accessing the db from the
outside.

Hope this helps someone!
-Alex Baird-