Friday, February 10, 2012

Can not remote connect

I am presented with...
TITLE: Connect to Server
--
Cannot connect to LARRYTESTBOX\SQLEXPRESS.
ADDITIONAL INFORMATION:
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)
For help, click:
http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
BUTTONS:
OK
--
I installed SQLExpress on a Windows 2000 Pro machine. It is configured Mix
Mode. I have it's browser running. It is visible from my computer under
Network Servers. I attempt to log on as sa.
Strangely, I did exactly the same last week for a client. The only
difference was that the machine was XP Pro SP-2. Should that make a
difference? I have DotNet 3.0 installed. What else shoudl I check?
TIACheck the firewall settings and my blog for a checklist on getting
connected.
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Larry Killen" <lkillen@.charter.net> wrote in message
news:tii9i.626$3j6.282@.newsfe03.lga...
>I am presented with...
> TITLE: Connect to Server
> --
> Cannot connect to LARRYTESTBOX\SQLEXPRESS.
> --
> ADDITIONAL INFORMATION:
> 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)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I installed SQLExpress on a Windows 2000 Pro machine. It is configured
> Mix Mode. I have it's browser running. It is visible from my computer
> under Network Servers. I attempt to log on as sa.
> Strangely, I did exactly the same last week for a client. The only
> difference was that the machine was XP Pro SP-2. Should that make a
> difference? I have DotNet 3.0 installed. What else shoudl I check?
> TIA
>

No comments:

Post a Comment