after installing XP SP2 SQL Server does not exist or access denied.

[sb]

Hi,

I just installed Windows XP SP2 on my previous installation of XP SP1.

Since it is intalled, my ado.net connection on my programs do not work
anymore; i receive this exception message:
"SQL Server does not exist or access denied."

I setted port TCP 1433 and 1434 on the firewall.cpl and it did not fix the
problem.

Is some tips for finding why it do not work anymore? do i have to
re-install sql server? it works well by itself, it is the connection from
my vb.net programs that not work anymore.

Thanks
Serge
se******@aei.ca

[Nick Malik]

what is your connection string?
--- N

"sb" <sy*****@hotmail.com> wrote in message news:41400541_2@aeinews....

Hi,

I just installed Windows XP SP2 on my previous installation of XP SP1.

Since it is intalled, my ado.net connection on my programs do not work
anymore; i receive this exception message:
"SQL Server does not exist or access denied."

I setted port TCP 1433 and 1434 on the firewall.cpl and it did not fix the
problem.

Is some tips for finding why it do not work anymore? do i have to
re-install sql server? it works well by itself, it is the connection from
my vb.net programs that not work anymore.

Thanks
Serge
se******@aei.ca

[Henk Verhoeven]

Hi sb

There is a know issue with SP2 and SQL Server. I assume you are connecting
to a local server (Localhost or You Machine\Instance).

Look at the following url, perhaps this may help you.
http://support.microsoft.com/default.aspx?kbid=842242

Henk
"sb" <sy*****@hotmail.com> wrote in message news:41400541_2@aeinews....

Hi,

I just installed Windows XP SP2 on my previous installation of XP SP1.

Since it is intalled, my ado.net connection on my programs do not work
anymore; i receive this exception message:
"SQL Server does not exist or access denied."

I setted port TCP 1433 and 1434 on the firewall.cpl and it did not fix the
problem.

Is some tips for finding why it do not work anymore? do i have to
re-install sql server? it works well by itself, it is the connection from
my vb.net programs that not work anymore.

Thanks
Serge
se******@aei.ca

[Ted Harper]

On Thu, 9 Sep 2004 03:19:50 -0400, "sb" <sy*****@hotmail.com> wrote:

Since it is intalled, my ado.net connection on my programs do not work
anymore; i receive this exception message:
"SQL Server does not exist or access denied."

Can you connect using Query Analyser using the EXACT same name for the
server you are using in your ADO.Net connect string?

With SQLServer 2000 (and the equivalent MSDE) we have had no problems
- and NOT needed any manual adjustments to the SP2 firewall settings -
by accessing the local (default) SQLServer instance as "." (and I
believe "(local)" - with the braces, without the quotes) - would work
too.

Here is an example from our default web.config, used on the developer
PCs with SQL2K Developer Edition and for stand-alone demonstration
installs with MSDE2000 (latest service pack and hotfix level in all
cases, and a simple default installation):

<add key="DBConnectString" value="data source=.;initial
catalog=IIPortal;integrated security=SSPI;persist security
info=False;Application Name=IIPortal" />
ted.h.
--
Ted Harper (Sydney, Australia)