CODEWITHSUNDEEP
sql-servervisual-studio-2010sql-server-2008
Jason94
Jason94

Reputation: 13610

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:

enter image description here

Now, I've checked a couple of things:

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

Upvotes: 1

Views: 13942

Answers (3)

Lalith
Lalith

Reputation: 1

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.

Upvotes: 0

Magnus Strand
Magnus Strand

Reputation: 167

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

Upvotes: 1

paulsm4
paulsm4

Reputation: 121599

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:

Upvotes: 3

Related Questions