Connection To SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access03 app that I splitted its back-end and put it in SQL.
Whenever I try to access anything in the app., I got the error message
"Connection Failed". I created for the users logins in SQL and gave them
appropriate rights to the database where the app's tabels are located. Any
ideas??
 
How did you link the front-end to back-end? Do you have linked tables, or
are you strictly using pass-through queries?

If you're using linked tables, are you using a DSN? Assuming yes, does the
DSN work?
 
Yes, I used file dsn to link the tables. What it's weird is that I can
establish a connection to the SQL server from my computer with no problems,
only users in remote locations can't. It's a network issue, I'm sure, it's
just frustrating for me.
 
TS,
no clue how to help, however I have had to create 2 different DSN's for my
users.
When I deploy an update I create 2 versions one for those internal and those
external that have access to the network as if they were internal and then
another for those that are Completely External. The "internal" one I use the
DSN I created using the drop down box to select the SQL Server and the one
for the "Completely External" folks I had to create a seperate DSN with an IP
address to get them to the SQL Server. Also they connect through the SQL
Sever authentication and have to use a user name and password to connect
whereas the "Internal" folks do not they just log right in as they are being
checked with windows authentification etc... Does that help you any maybe?
Take Care & God Bless ~ SPARKER ~
 
Thanks for your help. I'm going to try to use the IP address as oposed to the
DNS name of the SQL server for the external users to connect and hopefully
it'll work
 
Let me know how it works out for you. Don't forget to create a security group
with your SQL Server and use the user name and pass for this new external
connection that utilizes the IP Address as opposed to the Server name...
 
Back
Top