SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Connect SQL Server 2012 with Database Engine


Connect SQL Server 2012 with Database Engine

Author
Message
smart_analyst
smart_analyst
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 109
Hi all,

Installed SSMS 2012 Express addition with localDB. I don't know how to connect with Database engine and start using Sql Server?
I also want to download Sample Database TSQL2012 for 70-461 practice?
One more question do I have to give all the three Microsoft exams at the same time to become MCSA?

Thank you.
HanShi
HanShi
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4512 Visits: 3672
Have you downloaded and installed the Database Tools?
From the microsoft website:
•Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express)
•This package contains everything needed to install and configure SQL Server as a database server. Choose either LocalDB or Express depending on your needs above.
•SQL Server Management Studio Express (Tools only)
•This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, etc. Use this if you already have the database and only need the management tools. This package includes LocalDB.


As for the MCSA certification: you are free in the sequence of the exams and the time between the exams. Microsoft will keep track of the exams you have passed and reward you the MCSA when you passed all three exams.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Joie Andrew
Joie Andrew
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2417 Visits: 2032
Have you taken a look at this link from BOL?

SQL Server 2012 Express LocalDB

Joie Andrew
"Since 1982"
smart_analyst
smart_analyst
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 109
I have already installed SQL Server 2012 with shared features like Management tools - Basic, SQL Client Connectivity - SDK and Local DB.
I need step by step guidance how to do what? Plz....
HanShi
HanShi
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4512 Visits: 3672
I haven't SQL2012 at my hands right now, so the mentioned steps could be a bit different. So if you can't find it at once, just look a bit around in the possibilities.

Start the "SQL Server Management" tool.
Select "SQL Express" as the engine to connect to and enter the name of the SQL instance.

If you are completely new to SQL I suggest you get a more experienced person at your side, to get you started. You can also take a look at the "Microsoft Virtual Labs". These are online virtual machines where Microsoft has a step-by-step guide to get some things done. Else start by reading a lot :-P.
You need to understand the things you do, before you do actually it.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
smart_analyst
smart_analyst
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 109
I have installed SSMS 2012 on win 7. Inside both, SQL server services and SQL server Network config it says - "They are no items to show in this view."

May be with this information could help someone understand my problem? Am I missing anything during/after installation?
Joie Andrew
Joie Andrew
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2417 Visits: 2032
It sounds like you have just installed SQL Server Management Studio, not the database engine. If you open up Services in your control panel do you see any SQL Server services? If not you do not have an instance of SQL installed, just the workstation components.

Joie Andrew
"Since 1982"
smart_analyst
smart_analyst
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 109
I can't see any SQL Server services. How to/from where can I install the instance?
Joie Andrew
Joie Andrew
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2417 Visits: 2032
What media did you install SQL originally from? Was it a disk? A single executable? It is hard to tell you where to install it from without knowing what media you have first. For example full SQL Server (Standard/Enterprise/etc.) normally comes on a disk with several files, but I believe SQL Server Express comes wrapped in an executable.

What installation media do you have available? If it is a single file list the exact filename.

Joie Andrew
"Since 1982"
smart_analyst
smart_analyst
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 109
ok I found the issue and fixed it. I didn't download the sqlexpress at all before now donwloaded and connected successfully to the database engine. Thank you all for your help.......:-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search