Solved

no server name appears in sql server 2005

Posted on 2013-02-03
4
222 Views
Last Modified: 2013-02-21
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
Comment
Question by:KaranGupta
  • 2
4 Comments
 
LVL 10

Expert Comment

by:deviprasadg
ID: 38849946
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
 

Author Comment

by:KaranGupta
ID: 38849964
Hi

I have VS 2010 and I want to install sql server 2012 express edition. Which one should I install first.
0
 
LVL 10

Accepted Solution

by:
deviprasadg earned 500 total points
ID: 38849974
0
 
LVL 14

Expert Comment

by:nishant joshi
ID: 38850085
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Query Missing Money orders... 6 73
Complex SQL 10 34
Sql query 34 22
SQL Update Query - What's wrong with this. 18 14
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now