connect adp project to sql express via LAN

[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

 

[Alex Dybenko]

Hi,
idea is the same - in connection properties enter SQL Server name,
login/password and select database

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

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??

 

[Guest]

I've found the answer at this location:

http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx

If there is another way please let me know

Thanks

 

[Alex Dybenko]

Hi James,
you also have to make sure that TCP/IP enabled on SQL Server. I think lesson
you found will guide you through whole process

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com