Friday, February 17, 2012

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

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.

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

Good Luck

No comments:

Post a Comment