Re: Unable to connect to SQLExpress Remotely - no matter what

If the connection makes it to SQL Server then there should be an error in
the SQL Server error log. If not, it's likely that either the firewall
isn't allowing connections to SQL Server or there's a login failure which
should show up in the Windows Security event log.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

<karlag92@xxxxxxxxxxx> wrote in message
news:1162169471.249853.164170@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Roger,

The error text is as follows:

An error has occurred 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: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Enabling the browser, tcp/ip, etc. is all covered in the KB article
that I gave a link to.

This only happens on my laptop. I JUST installed yet another machine
and connected remotely the first try.

I think that something went wrong with sql express that even an
uninstall and reinstall does not correct.

Again, thanks in advance for any help anyone can provide.

Karl


Roger Wolter[MSFT] wrote:
Do you have SQLBrowser enabled and running? what's the error you get
when
connecting and are there errors put into the SQL Server error log file
when
you try to connect?

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

<karlag92@xxxxxxxxxxx> wrote in message
news:1161989112.797814.70790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi all,

I've been fighting to get sql server express on my machine to be
accessible remotely. I've tried many times and quadruple checked all
of the instructions in KB article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

I have even performed a full uninstall and reinstall, then applied KB
914277 (once again).

I've turned off all firewalls and virus scan.

I've compared to other machines that work.

We've installed to other machines and followed KB 914277 and they've
worked.

Nothing helps. My Sql server express instance remains unavailable from
other machines.

Any ideas? I've spent a whole day on this and I'm frustrated as can
be! I need this machine to work as moving to another machine for my
work is not practical.

Thanks!

Karl




.

Relevant Pages

  • Re: What is the best way to connect to a server not on the network?
    ... That 192 IP address is most likely not a remote one. ... but doesn't object to migrating the data to SQL server. ... I tried using ADO within Access to create a connection string to the remote ...
    (microsoft.public.access.modulesdaovba)
  • Re: Performance reduction of SQL 2005 server when connected from V
    ... Rick Byham (MSFT), SQL Server Books Online ... against the slow SQL 2005 remote server succesfully (through the SSMSE ... will tell you what process ID is your current connection. ...
    (microsoft.public.sqlserver.connect)
  • 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)
  • Re: Performance reduction of SQL 2005 server when connected from V
    ... One of my computers says 9.0.9091.2 but that computer has a future build of SQL Server on it, ... will tell you what process ID is your current connection. ... How can I check out if the SQL Server Native Client version is the same ... > found no reduction in the speed of the SQL 2005 server remote> connection. ...
    (microsoft.public.sqlserver.connect)
  • Re: Performance reduction of SQL 2005 server when connected from V
    ... SQL Server on it, ... will tell you what process ID is your current connection. ... How can I check out if the SQL Server Native Client version is the same ... found no reduction in the speed of the SQL 2005 server remote ...
    (microsoft.public.sqlserver.connect)