Connection woos ...

Connection woos ...

• Alvin Kuiper

  What version of VS are you using
  
  

• Baldwintm

  Pinging the server name and ip address both work fine from all computers!
  

• Andrew Chapman

  
  Did you check your configuration as documented in the link I posted
  
  

• pars382985

  Dumb question ...

  Which username is the follow command line referring to

  The computer administrator, the database owner or the user id in the connection string

  osql -S SERVERNAME\SQLEXPRESS -U <username>
  

  
  

• AlexReg

  Yes!
  

• Wellnow

  
  See if the following helps:

  http://www.datamasker.com/SSE2005_NetworkCfg.htm

  
  
  

• Michael Vanhoutte

  My new and my old applications used to work remotely without problems.
  Both could connect using the server name or ip address.

  Now neither one works now, meaning they can't connect.
  Message is that the server doesn't exist.

  I can only connect using the server name now, NOT the ip address.

  
  

• aahkam

  I restart it!

  To re-iterate ...

  All I have noticed is that in the Surface Area Configurator the Local Connections only radio button it selected.

  So I try selecting the Remote radio button and Apply and Ok and then exit the Surface Area Configurator program and then come back in again and the Local Only is selected.

  Is this normal behavior Is Remote connections allowed or not How verify

  Is there a utility to force remote connections to be on

  Is there a setting in the registry I can check

  
  

• DaveSmith

  
  Have you run the SQL Server Configuration Manager and under SQL Server 2005 Network Configuration verified that the TCP/IP protocol is enabled

  
  
  

• the fariborz

  
  Run a command prompt and ping the server name. Then use the returned IP address and try to ping it:

  ping -a <ip address>

  If you can ping successfully make sure that the server name matches the IP address.

  Let us know what the results are.

  
  
  

• AlexBB

  
  I think it just has to be a valid SQL Server user. The example is for testing connectivity to the database.
  
  

• Pure Krome

  VS 2003

  
  

• Marcin Kruszynski

  If you are wanting to change SQL Express to support remote connections, you will need to restart the service once you've made the change in the Surface Area Configuration tool.

  BTW, if you are having problems connecting to SQL Express, I recommend looking over the following blog posting http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

  HTH,
  Jimmy

  
  
  

• Dottj

  
  See if any of the following helps, particularly item #3:

  Cannot connect to remote SQL 2005 Express Server

  
  
  
• Connection woos ...