• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • Last Modified:

SQL Server 2008 R2 Express

I just downloaded Sql server 2008 r2 express and upgraded from sql server 2005 express.

For some reason, I can't connect to the sqlexpress server name on my local machine (laptop).  Here is the error I get:

sqlexpress error
Thanks for any help you can provide.
0
Isaac
Asked:
Isaac
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
sqlxlCommented:
This happens when the SQL client cannot connect to the SQL server. The common reason I've seen are:

1. SQL is not started. This is quite common actually. ;)
2. Invalid SQL server name.
3. Invalid SQL instance name.
0
 
sqlxlCommented:
If you're connecting remotely, you would also want to:

1. Identify which port SQL is running on.
2. Open that port in the firewall(s) to permit traffic from the client IP.
3. Enable TCP/IP protocol in SQL.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now