| Author |
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 program.
Conn.Open
"SQL Server does not exist or access denied."
Can anyone tell me what else I need to do?
Ron
| |
| David Gugick 2005-06-29, 8:23 pm |
| Ron 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
| |
| Mike Epprecht \(SQL MVP\) 2005-06-30, 3:23 am |
|
FAQ: How Windows XP Service Pack 2 (SP2) Affects SQL Server and MSDE
http://www.microsoft.com/sql/techin...winxpsp2faq.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@microso
ft.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
>
>
>
|
|
|
|