OLEDB connection to SQL Server 2000 fails - 20599 error 
Author Message
 OLEDB connection to SQL Server 2000 fails - 20599 error

Hi all;

I've been battling the same connectivity issues as a lot of people.  Can't
use the native SQL connection with the ntwdblib.dll anymore.  Don't want to
proliferate ODBC DSNs to every workstation.  So I thought I had the solution
with OLE DB and the P2SOLEDB.dll.

I'm using VB 6 with the crystl32.ocx and Crystal Reports 8.5 against SQL
2000 with NT authentication.  My workstation is NT 4.0.  Some of the
workstations I'm deploying to are NT 4.0, others Windows 2000.

I'm getting the error on an NT 4.0 machine.  I tried the suggested fix on
the Crystal KB to set the Connect property of the Crystal Report control to
"UID=<<Use IntegratedSecurity>>" but that didn't seem to have any effect.

I've looked at the dependencies of the p2soledb.dll and all the required
files are on the target machine.

Anyone have any ideas?

TIA

Marcia



Tue, 10 May 2005 02:34:08 GMT  
 OLEDB connection to SQL Server 2000 fails - 20599 error
The problem is the SQL server NT integrated security.

Check seagates site and look for "NT Security" or "cannot open SQL Server"



Quote:
> Hi all;

> I've been battling the same connectivity issues as a lot of people.  Can't
> use the native SQL connection with the ntwdblib.dll anymore.  Don't want
to
> proliferate ODBC DSNs to every workstation.  So I thought I had the
solution
> with OLE DB and the P2SOLEDB.dll.

> I'm using VB 6 with the crystl32.ocx and Crystal Reports 8.5 against SQL
> 2000 with NT authentication.  My workstation is NT 4.0.  Some of the
> workstations I'm deploying to are NT 4.0, others Windows 2000.

> I'm getting the error on an NT 4.0 machine.  I tried the suggested fix on
> the Crystal KB to set the Connect property of the Crystal Report control
to
> "UID=<<Use IntegratedSecurity>>" but that didn't seem to have any effect.

> I've looked at the dependencies of the p2soledb.dll and all the required
> files are on the target machine.

> Anyone have any ideas?

> TIA

> Marcia



Sat, 14 May 2005 01:09:29 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Run-time error 20599: Cannot open SQL Server

2. Cannot find SQL Server (error 20599)

3. error 20599 cannot connect to sql server

4. RDC and VB : error 20599 (unable to open SQL server)

5. Error 20599 Cannot find SQL server

6. Error 20599 - Cannot open SQL Server

7. Error 20599 - cannot open SQL Server

8. Error 20599: Cannot open SQL Server

9. HELP: Error 20599: Cannot open SQL server

10. Error 20599 (Cannot open SQL Server)

11. Error 20599 Cannot find SQL Server...........

12. Error 20599 Cannot open SQL server

 

 
Powered by phpBB® Forum Software