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

no server name appears in sql server 2005

Hi

I have windows 7 installed on my machine. I have downloaded sql server 2005 express edition on my machine. When I open sql server instance I don't see the server name (which is local to my machine). When I use .\SQLExpress I am getting error as shown in the screen shot.

Can I get the free SSMS for windows 7.

error message when connecting using sqlexpress
0
KaranGupta
Asked:
KaranGupta
  • 2
1 Solution
 
deviprasadgCommented:
Download and install client tools (management tools) in the express edition for SQL Server 2008 or SQL Server 2012.

Links:
http://www.microsoft.com/en-us/download/details.aspx?id=23650
http://www.microsoft.com/en-us/download/details.aspx?id=29062


Download with tools versions.
0
 
KaranGuptaAuthor Commented:
Hi

I have VS 2010 and I want to install sql server 2012 express edition. Which one should I install first.
0
 
nishant joshiTechnology Development ConsultantCommented:
if you are having multiple instances in machine the you have to write like :


 ".\<InstanceName>"

.If you don't know Instance Name then go to sql server configuration manage and check its service.

Thanks,
Nishant
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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