SQL Express Remote Connections


Im having a problem connecting to my SQL Express box from a different subnet. At first i thought maybe it was a network restriction but i've been able to cross subnets with other boxes so i know thats not the problem.

the other odd thing about this box is it has multiple IPs on the same adapter.
TCP/IP is enabled (because i can get there from the local subnet) and if i go to the properties of the connection and go to IP Addresses they are all active but only the primary host ip is enabled.

the error i get on the remote systems is as follows

TITLE: Connect to Server
------------------------------

Cannot connect to server\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?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476


Any suggestions as to what this might be? or a way to diagnose this?

Thanks
Justin


.

Relevant Pages

  • Re: Cannot connect a remote sql server
    ... Try disabling the firewall on the client. ... I would also make sure the SQL Browser service is running and that the login credentials you're using have rights to the default database. ... I've also written a long chapter on connecting that has helped a lot of people establish and maintain connections. ... I don't know if this matter but the server I'm trying to connect to is SQL Server 2000. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Changing IP address for 2 Nodes, Cluster IP and SQL IP
    ... If you change the subnet mask for the cluster, it thinks it is a new network ... that the SQL IP resource subnet matches the physical IP subnet. ... How to change the network IP addresses of SQL Server failover cluster ...
    (microsoft.public.sqlserver.clustering)
  • RE: Website Administration has errors
    ... The application is configured to use SQL Server ... permission issue when the webadmin site page try connecting to the target ... since the web admin site will use the ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Performance really poor if calling data from sql clients
    ... This does not sound like a SQL Server issue but something to do with how the ... Andrew J. Kelly SQL MVP ... of the connection (same connecting string) needs again a while and then I ...
    (microsoft.public.sqlserver.clients)
  • Domain user cannot connect with integrated security
    ... We noticed a SQL process on our development SQL server (SQL 2k, ... I asked the user to use integrated security and not the local account - ... The domain user who is connecting is a member of a local group on the ...
    (microsoft.public.sqlserver.security)