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

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: Cannot connect a remote sql server
    ... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to connect to SQLExpress Remotely - no matter what
    ... Still no luck after as full of a reinstall as I could manage. ... Nothing to the error log. ... Another note is that I'm connecting using SQL Server Authentication. ...
    (microsoft.public.sqlserver.connect)
  • Use Single Sign on to connect to sql server
    ... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
    (microsoft.public.sharepoint.portalserver.development)
  • InlineTDS
    ... I decided to try InlineTDS... ... I could also pull it open in Tora by connecting to ... localhost and then back out to the remote SQL Server. ...
    (comp.lang.php)
Loading