Can no longer connect to SQL Server 2000 using ADO after XP SP2

I can no longer connect to SQL Server 2000 using ADO after installing XP SP2
.
I receive authentication error. I have even turned off all firewalls.
I also installed SQL Server Service Pack 4.
I also added the SQL Server data source(ODBC). I am using Windows
Authentication. When I test the ODBC data source it connects successfully.
I just can not access it via ADO.
The receive the error message when I try to open the connection in my progra
m.
Conn.Open
"SQL Server does not exist or access denied."
Can anyone tell me what else I need to do?
RonRon wrote:
> I can no longer connect to SQL Server 2000 using ADO after installing
> XP SP2. I receive authentication error. I have even turned off all
> firewalls.
> I also installed SQL Server Service Pack 4.
> I also added the SQL Server data source(ODBC). I am using Windows
> Authentication. When I test the ODBC data source it connects
> successfully.
> I just can not access it via ADO.
> The receive the error message when I try to open the connection in my
> program. Conn.Open
> "SQL Server does not exist or access denied."
> Can anyone tell me what else I need to do?
> Ron
Can you tell us what your server name is and what connection string you
are passing to the ADO connection object?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||FAQ: How Windows XP Service Pack 2 (SP2) Affects SQL Server and MSDE
http://www.microsoft.com/sql/techin...faq.asp

--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:E8DD2341-1928-4D7E-975A-A53294AA05E8@.microsoft.com...
>I can no longer connect to SQL Server 2000 using ADO after installing XP
>SP2.
> I receive authentication error. I have even turned off all firewalls.
> I also installed SQL Server Service Pack 4.
> I also added the SQL Server data source(ODBC). I am using Windows
> Authentication. When I test the ODBC data source it connects
> successfully.
> I just can not access it via ADO.
> The receive the error message when I try to open the connection in my
> program.
> Conn.Open
> "SQL Server does not exist or access denied."
> Can anyone tell me what else I need to do?
> Ron
>
>