connect adp project to sql express via LAN James Page 06.03.2006 12:15:02 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

Re: connect adp project to sql express via LAN "Alex Dybenko" <alexdyb.PLEASE[ at ]cemi.NO.rssi.SPAM.ru> 06.03.2006 13:53:48 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 "James Page" <JamesPage[ at ]discussions.microsoft.com> wrote in message news:82943115-AD90-49BF-93BC-BAFD7EF40B40[ at ]microsoft.com... [Quoted Text] > 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

Re: connect adp project to sql express via LAN James Page 06.03.2006 14:11:33 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??

Re: connect adp project to sql express via LAN James Page 06.03.2006 15:22:27 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

Re: connect adp project to sql express via LAN "Alex Dybenko" <alexdyb.PLEASE[ at ]cemi.NO.rssi.SPAM.ru> 06.03.2006 16:44:34 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 "James Page" <JamesPage[ at ]discussions.microsoft.com> wrote in message news:E9ABE179-ECF7-470D-A33A-FC50BF1E3A86[ at ]microsoft.com... [Quoted Text] > 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?? > >