I can't connect to my SQL Server database

I have a 2nd computer that I've installed Microsoft SQL Server 2008 Express on. I got it up and running with SQL Server Management Studio and created some tables and stuff.

But I want to be able to connect to it from my other PC, the one I usually work on in my home. But when I try to make a connection I get this error:

Now, I've checked a couple of things:

  • doing a \\SERVER in explorer from my computer works. So im guessing DNS is ok.
  • I've tried to turn the firewall on the server off, connect and back on again with no luck.
  • both SQL Server (SQLEXPRESS) and SQL Server Browser services are running (SQL Server Agent is not).
  • TCP on port 1433 is turned on.

Server name: SERVER is a result in the dropdown there.

Answers


1) It sounds like the instance you're trying to reach is SQL Express. In which case the instance will be called myserver\sqlexpress ("SQLEXPRESS" literal; case doesn't matter). "myserver" won't work with a "named instance"; "myserver\sqlexpress" might do the trick.

2) You MUST enable TCP/IP with the SQL Configuration tool (installed when you installed MSSQL and SSMS).

3) You should turn off the firewall (brute force - don't do it if you don't have to) or enable MSSQL in the firewall (MSSQL is not enabled by default)

'Hope that helps - please post back what you find.

PS:

Useful link:


Do you want to connect with Named Pipes or TCP/IP sockets? Please show a screen dump of the Advanced tab in the dialog. Maybe you can change to TCP/IP sockets if that is how you want to connect? SQL server needs to be configured to allow Named Pipes or TCP/IP sockets.

How to: Enable or Disable a Server Network Protocol

Choosing SQL Server's Network Protocol


Just use the Server Name in Add Connection Dialog in the following format. ComputerName/SQLEXPRESS

for example: MYPCNAME/SQLEXPRESS where MYPCNAME is computer name & SQLEXPRESS is MS SQL Server instance running on the computer.


Need Your Help

how to fire an event on textbox value change from pop window in MVC ASP.net

javascript jquery asp.net-mvc model-view-controller

I m returning one value from pop up window now i want is the text box value changes from pop up window it should change its background color to red, otherwise no change will be reflect.

adding and saving new items to the collection

windows-phone-7

Assume we have an Customer object with collection of Payments.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.