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 event log. Nothing to the error log. Firewall turned off. IP
and Named pipes enabled. Remote access enabled.

Any other ideas??? I'm not even sure how to troubleshoot any further .
.. . .

Thanks!!!!!


karlag92 wrote:
Just to make sure it wasn't getting in the way, I turned my firewall
off completely early in the troubleshooting of this problem.

Another note is that I'm connecting using SQL Server Authentication.

I'm in the middle of another reinstall. This time I removed the
Microsoft SQL Server directory and any registry entries that were
related to it.

On Oct 29, 7:31 pm, "Roger Wolter[MSFT]"
<rwol...@xxxxxxxxxxxxxxxxxxxx> wrote:
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 athttp://www.microsoft.com/info/cpyright.htm

<karla...@xxxxxxxxxxx> wrote in messagenews: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

<karla...@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- Hide quoted text -- Show quoted text -

.

Relevant Pages

  • Re: Unable to connect to SQLExpress Remotely - no matter what
    ... Still no luck after as complete of a reinstall as I can do. ... Another note is that I'm connecting using SQL Server Authentication. ... fact that under the default settings SQL Server does not allow remote ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to connect to SQLExpress Remotely - no matter what
    ... 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 ... I have even performed a full uninstall and reinstall, ...
    (microsoft.public.sqlserver.connect)
  • 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: Error Log file location causing Failover failure?
    ... We have a SQL Server on a 2 node cluster. ... Like SQL was looking for the error log file on the C:\ drive ...
    (microsoft.public.sqlserver.clustering)
  • 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)
Loading