RE: Can't access Sql Server Express 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

ps - I have a copy of the Virtual Machine with this problem if MS needs this
to reproduce the bug. But all I did to get it was:
1) Install Win XP
2) Install Sql Server Express
3) Run our .NET app that enumerates databases.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm




"David Thielen" wrote:

Found it. The ADO.NET enumeration of servers returns GASTON but not
GASTON\SQLEXPRESS. (This system only has Express installed on it). Once I
changed the name to GASTON\SQLEXPRESS it worked.

I've seen this bug a couple of times before so I guess we need to find a
work-around.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm




"David Thielen" wrote:

Hi;

I installed Sql Server 2005 Express and am trying to open a connection using
ADO.NET. I enabled TCP/IP and Named Pipes and then rebooted. The message is:

Cannot access the database.
Error: An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not allow
remote connections. (provider: Named Pipes Provider,
error: 40- Could not open a connection to SQL Server)

Any ideas?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm


.

Relevant Pages

  • Re: SP1 does not work
    ... Perhaps you hit some other bug then the one referred to in SP1? ... > This mail is regarding a trouble I'm facing with SQL Server 2000. ... but at times I get a fatal SQL Server Exception when I ... > every time I go to the database with a new connection. ...
    (microsoft.public.sqlserver.programming)
  • Re: SP1 does not work
    ... Perhaps you hit some other bug then the one referred to in SP1? ... > This mail is regarding a trouble I'm facing with SQL Server 2000. ... but at times I get a fatal SQL Server Exception when I ... > every time I go to the database with a new connection. ...
    (microsoft.public.sqlserver.setup)
  • Re: Login failed for user (null)
    ... Could you elaborate on "I tried with TCP/IP and messed up something, ... If you remove TCP/IP from the SQL Server library utility (following the ... > I tried with TCP/IP and messed up something, had to install SQL server all ... > associated with a trusted SQL Server connection" error. ...
    (microsoft.public.sqlserver.clients)
  • Re: MSAccess can run SP on some workstations but not others - why?
    ... workstations, but the error message on the other workstations says: ... SQL Server: versioned stored procedures. ... In Access in the Connection ... a bug in Access, and my guess is that the troublesome workstations have ...
    (microsoft.public.sqlserver.security)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)