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

If there is no error in the SQL Server error log when the login fails then
that would indicate that the connection is not getting to SQL Server. This
would indicate that you're trying to fix the wrong problem because
reinstalling SQL is not going to affect a network issue which is preventing
you from getting to SQL Server.

--
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" <karlag92@xxxxxxxxxxx> wrote in message
news:1162170577.987035.214360@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Sorry, I forgot to note that there is nothing unusual in the error log.
When I compare it to another machine's log, it looks identical to all
extents and purposes.

Karl

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

<karla...@xxxxxxxxxxx> wrote in
messagenews: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: Upsizing wizard access Sql Server express
    ... Sylvain Lafontaine, ing. ... Troubleshooting connection problem: ... database into sql server express 2005 by using the upsizing wizardi go ... SQL Server Error: 2 ...
    (microsoft.public.access.adp.sqlserver)
  • Connection failed SQL State 01000 SQL error 52
    ... Connection failed ... SQL Server Error: 52 ... I have tried SQL Server authentication, ...
    (microsoft.public.project)
  • Re: Upsizing wizard access Sql Server express
    ... Troubleshooting connection problem: ... database into sql server express 2005 by using the upsizing wizardi go ... SQL Server Error: 2 ... I downloaded SSMA but my work environment does not allow for the ...
    (microsoft.public.access.adp.sqlserver)
  • ODBC Connection.
    ... There is a problem with my ODBC connection. ... a connection time out occurs and the error ... SQL Server Error: 0 ...
    (microsoft.public.sqlserver.odbc)
  • ODBC Connect Prob in 2005
    ... Connection Failed: ... SQLState: '08001' ... SQL Server Error: 1326 ... SQL Server Error: 0 ...
    (microsoft.public.sqlserver.odbc)