Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

sql server --- > Server Name

Posted on 2011-02-21
17
791 Views
Last Modified: 2012-05-11
I downloaded sql server 2008 express on my windows 7 laptop. I went into manamgement studio and now need to create a new SQL Server so that I can import my databases. Could somebody tell me where to go to do this?
0
Comment
Question by:vbnetcoder
  • 10
  • 4
  • 3
17 Comments
 
LVL 6

Expert Comment

by:AkAlan
ID: 34946484
Not a lot of info to go on. Do you need to create a new blank database on the server?
0
 

Author Comment

by:vbnetcoder
ID: 34946513
I downloaded management studio and the "connect to server" box on the form with the connect button that you would normally use to connect to SQL server databases is blank.

I want to know what to do about this so i can start creating databases
0
 
LVL 6

Expert Comment

by:AkAlan
ID: 34946608
You say you downloaded SQL Server but did you actually install it? If you did then go into your control panel and look at your Services. SQL Server needs to be started, either MAnually or Automatically, depending on how you configure it.
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 32

Expert Comment

by:ewangoya
ID: 34946629

Snow you need to create a new database, right click on the Databases then select New database

You will get a dialog, type in the name of the database you wish to create and click OK

The database will now be listed under Databases

You will then have to create tables
Right click on Tables, New table and define your fields
NEW-DB.PNG
0
 

Author Comment

by:vbnetcoder
ID: 34946695
I am not even that far ... I am on the connect to server screen.  The Server name box is empty ... I am assuming I have to create one (as server) but don't know what to do.
0
 
LVL 32

Expert Comment

by:ewangoya
ID: 34946717

If you installed it then server instance is already created

The server name should be listed in the drop down combobox by default its the computername unless you installed a named instance

Are you sure you installed the sql server database engine or just the management tools
0
 

Author Comment

by:vbnetcoder
ID: 34946745
I thought i installed both
0
 

Author Comment

by:vbnetcoder
ID: 34946768
I downloaded this:

prior to download management studio
0
 

Author Comment

by:vbnetcoder
ID: 34946774
0
 

Author Comment

by:vbnetcoder
ID: 34947271
AkAlan:

What is the exact name of the service that needs to be started?
0
 
LVL 6

Expert Comment

by:AkAlan
ID: 34947369
It's simply called SQL Server.
If you go into Administrative tools and Services, you will see it there. That is if you installed SQL Server correctly.

0
 

Author Comment

by:vbnetcoder
ID: 34947398
i see sql server stuff but not one that simple is called sql server
0
 
LVL 6

Accepted Solution

by:
AkAlan earned 500 total points
ID: 34947415
Post a screen shot.
How about looking at Control Panel Programs and Features (or whatever it's called on your operating system) ? You should see SQL Sever installed there if you installed it correctly
0
 
LVL 32

Expert Comment

by:ewangoya
ID: 34947754

You installed an older version, the current one can be found here
http://www.microsoft.com/express/Database/

To see the service
From your start menu, All programs, go to Microsoft SQL Server 2008->Configuration Tools->SQL Server Configuration Manager

This will show you all the sql services
ConfigManager.png
0
 

Author Comment

by:vbnetcoder
ID: 34950586
AkAlan:

I reinstalled everything and checked the services and i see SQL Server (sql express) which is running. I still have the same problem when I open up SQL Server Management Studio....
0
 

Author Comment

by:vbnetcoder
ID: 34950608
NEver mind I got it working
0
 

Author Closing Comment

by:vbnetcoder
ID: 34950612
ty
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql Server group by 10 43
SQL Improvement  ( Speed) 14 33
Amazon RDS migrate to SQL Server 3 24
SQL - Curser to do an insert based on a select 2 10
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

840 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