Connecting an ADP to a remote MSSQL database on the same network

[brosner]

I installed MSSQL 2000 on my desktop (running NT 2000). No problem. I created an adp and attached it to a database within MSSQL 2000, no problem.

When I go into MS Access, on another PC (running Windows XP Pro) on the same network, and try to create a using 'Project(Existing Data)' and connect it to MSSQL 2000 on my desktop, I fill in the Data Link Properties '1. Select or enter server name', no problem, '2. I click on Use Windows NT integrated security ',no problem. On '3. Select the database on the server', I get the following message -
SQL Error [DBNETLIB]{ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

I've been to more websites then I can count to try and resolve this error to no avail. Could someone give me a simple solutions, or at least some direction on this.

Thanks in advance for any help you can provide.

Burt

[iburyak]

Try to create DSN instead and use it instead of Server name.

Good Luck