connect adp project to sql express via LAN

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

Guest

Hi all

I need a bit of advice - I've created a FE using ADP the BE is on SQL Express.

Connecting to the BE on the same computer is fine, but i now need to connect
to the BE via a LAN.

I can't seem to find a simple guide on how to do this. any pointers would be
welcome.

Thanks
 
Hi Alex

Tried that but access won't connect. Using the following:

server name = h1\sqlexpress (the instance name on the server machine)
windows integrated security = on

Access comes back and says:

"Test connection failed because of an error in initializing provider.
[DBNETLIB][ConnectionOpen (conect()).]SQL Server dows not exist or access
denied."

Am I missing something fundamental here??
 
Back
Top