ss problem continues.

From: john michale (polite1974_at_hotmail.com)
Date: 05/19/03 

Date: Sun, 18 May 2003 23:50:50 -0700

I m running Advance server 2000. It is not on domain but
on workgroup.
The client machines are on domain.
I need to enable ssl encryption for a specific client.

i installed root certificate authority on sqlserver 2000.
created certificate.
i installed this certificate from location
http://myserver/certsrv on the client machine

i can see the certificate on the client under trusted root
certification authorities tab. I can connect only with the
following connection string.
ConnectString = "SERVER=192.168.4.6;DRIVER=SQL
Server;uid=myidpwd=mypassword;Address=192.168.4.6;Network=D
BMSSOCN;DATABASE=M2"
where 192.168.4.6 is the ip of advance server having
sqlserver2000 installed.
connection establishes with both with or with out using
force protocol encryption.
I get error "data source not found and no default driver
specified" when i use following connection string.
cn.Open "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Initial
Catalog=M2;Data Source=RehanPCMS;Encryption for Data=True"
It happens with or without force protocol encryption
checkbox, checked or unchecked.

If i connect via sqloledb as
cn.Open "Driver=SQLServer;Server=RehanPCMS;uid=myid;pwd=myp
assword;Network=DBNETLIB.DLL"
where RehanPCMS=192.168.4.6 i.e name of advance server.
i get error "Login faild for user '(null)'. REason: Not
associated with a trusted Sql server connection."
It happens either i select checkbox for force protocol
encryption or not.
Please help. it is very urgent.

Relevant Pages

  • RE: Multiprotocol Encryption Through a Firewall
    ... Remote SQL Server 2000 (MSDE 2000) through a firewall with only a single ... connection to a remote SQL Server and I wanted to share the ... Encryption checkbox. ...
    (microsoft.public.sqlserver.connect)
  • Re: Viewing internal web site on SBS2003 from Xp clients
    ... Ethernet adapter Server Local Area Connection: ... Connection-specific DNS Suffix. ... > Are your client machines pointing to SBS for DNS? ...
    (microsoft.public.backoffice.smallbiz2000)
  • RE: Losing Connection
    ... viewer shows that the same error was recorded at 1:59am, ... >around the same time the connection is lost? ... >|>What is the OS of the client machines? ... >|>errors in the event viewer on the server? ...
    (microsoft.public.win2000.networking)
  • Re: New Replication Project
    ... with 5 access clients connecting to an access db on server. ... Is the connection good enough to run Windows Terminal Server ... I would never use replication if there is an always-on WAN ... Client machines with an MS Access front end linked to MS Access ...
    (microsoft.public.access.replication)
  • Re: Windows 98 & Windows XP ODBC connection
    ... > I have an SQL database which sits on a Win 2000 server and is accessed by ... SQL Server Clinet Tools and MSDE on to a Win XP Pro machine. ... now to connect from the Win 98 client machines but cannot get the ODBC ... connection from any other Win 2000/XP machien but not from any 98 machine. ...
    (microsoft.public.sqlserver.clients)