Community discussion forum

Can't connect to SQL Server Management Studio Express

• • Reply

  6 months ago

  by ABDULAZIZ ALGHAMDI

  ABDULAZIZ ALGHAMDI

  , Saudi Arabia

  Joined 11 months ago

  Hi,

   I am trying to connect to SQL Server 2005. When I open SQL Server 2005, it prompts me to connect to the server.  Then, I am asked to type in the server name.  My first question, is the server name your computer?  If so, how do you determine you computer name?  Second, I tried putting in the IP address and received this error:

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

  Cannot connect to 69.120.134.39.

  ------------------------------
  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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

  What am I doing wrong?

   

   

  Report abuse
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  6 months ago

  by comsc

  comsc

  , Thailand

  Joined 11 months ago

  What application are you opening? Hmm, it is often that when you open the sql server management studio, the server name is already typed in.

  Server name is the computer name of the unit where the sql server 2005 is installed. (AFAIK, ü)

  How to determine your computer name? Right-click > Properties > Computer Name, in line Full computer name:

  Are you sure you can connect to 69.120.134.39? Try to ping it first. [Start > run > cmd > type in "ping 69.120.134.39"] Will it return "reply from..."?

  Just trying to help here, not sure if I can, ü 

  Report abuse
• • Reply

  6 months ago

  by ABDULAZIZ ALGHAMDI

  ABDULAZIZ ALGHAMDI

  , Saudi Arabia

  Joined 11 months ago

  Thanks.  I pinged it first and it did return the IP address.  So, my IP address does work. I also tried typing computername\SQLEXPRESS; it still threw an error.  I'm really not sure at this point what is wrong.

   

   

  Report abuse
• • Reply

  6 months ago

  by comsc

  comsc

  , Thailand

  Joined 11 months ago

  What application are you using? 

  Do you have username and password in your connection string? Can you show it here?

  ü

  Report abuse
• • Reply

  6 months ago

  by ABDULAZIZ ALGHAMDI

  ABDULAZIZ ALGHAMDI

  , Saudi Arabia

  Joined 11 months ago

  What do you mean what application am I using?  Right now, I am just trying to connect to the database by opening up SQL Server Management Studio Express.  I haven't written any code yet.

  Report abuse
• • Reply

  6 months ago

  by comsc

  comsc

  , Thailand

  Joined 11 months ago

  aahhh....

  To make sure that your network can see the unit you are accessing, try to browse the server you desired instead of typing it.

  Desperate move is to reinstall your sql 2005, wehehe..

  Report abuse
• • Reply

  6 months ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 1 year ago

  2 other things I would check are:

  1. Is the SQLServer Express service started? If you go to Control Panel > Administrative Tools > Services, you should see a SQLServer (SQLEXPRESS) service which should be started.
  

  2 Normally, you would only need to refer to the below if connecting to SQL Server from a remote machine. However, it might be worth you following the first part of this and turning on TCP/IP remote connections through the Surface Area Configuration tool.
  

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
  

  HTH,

  Tim 

  Report abuse
• • Reply

  5 months ago

  by sayema_ahasan

  A.B.M. Ahasan Ullah

  Chittagong, Bangladesh

  Joined 8 months ago

  Hi guys,

  Don't worry about to you

   worry about Server Management Services.......

  Can you spot server performance issues before they affect your business?The Protect service from mindSHIFT reports on the health of your servers and network 24x7x365, ensuring performance and availability.

  Protect provides 24/7 monitoring and alert notification, as well as remote troubleshooting and case resolution

  for Exchange and Windows servers.

   Mariya,
  (http://www.mindshift.com/server-management.aspx)

  Report abuse