SQL 2005 Connection Problem

I have a Citrix farm running on 2003 Server with all the latest updates.
I have a SQL box on the same swithc without a firewall between them.
I have both SQL Server 2000 and 2005 installed on the SQL box.
I have a test VB6 program that uses this test connection:

Dim LIBSDSN As String
Dim connLib As New ADODB.Connection
If connLib.State = 1 Then connLib.Close
Err.Clear
LIBSDSN = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Libs;Data Source=" & Trim(Me.txtSvrName) & ";User Id=acs3\administrator;Password=R#queste6"
'LIBSDSN = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Libs;Data Source=" & Trim(Me.txtSvrName) & ";User Id=acs3\sblackford;Password=123!@#qwe"
connLib.CursorLocation = adUseClient
If connLib.State = adStateClosed Then connLib.Open LIBSDSN
If Err.Number <> 0 Then MsgBox Err.Number & vbCrLf & Err.Description Else  MsgBox "Success"

It works perfectly on the SQL box for both 2000 & 2005, BUT, from the Citrix box it only works correctly on the 2000 instances... I get the old "Server does not exist or access is denied" error.

The 2005 install is the Dev. edition, and I have run:

sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO

and it changed the default from 0 to 1. Stopped the Server and restarted. No success....

HELP!!!


Start Free Trial