Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Connect SQL Server 2012 with Database Engine Expand / Collapse
Author
Message
Posted Friday, June 28, 2013 9:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 2, 2014 5:41 PM
Points: 23, 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.

Post #1468765
Posted Monday, July 1, 2013 1:51 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:18 AM
Points: 2,448, Visits: 2,988
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’! **
Post #1468966
Posted Monday, July 1, 2013 2:31 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 3:46 AM
Points: 709, Visits: 1,442
Have you taken a look at this link from BOL?

SQL Server 2012 Express LocalDB


Joie Andrew
"Since 1982"
Post #1468973
Posted Monday, July 1, 2013 7:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 2, 2014 5:41 PM
Points: 23, 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....
Post #1469271
Posted Tuesday, July 2, 2013 12:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:18 AM
Points: 2,448, Visits: 2,988
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 .
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’! **
Post #1469297
Posted Tuesday, July 2, 2013 1:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 2, 2014 5:41 PM
Points: 23, 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?
Post #1469318
Posted Tuesday, July 2, 2013 2:46 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 3:46 AM
Points: 709, Visits: 1,442
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"
Post #1469345
Posted Tuesday, July 2, 2013 6:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 2, 2014 5:41 PM
Points: 23, Visits: 109
I can't see any SQL Server services. How to/from where can I install the instance?
Post #1469804
Posted Wednesday, July 3, 2013 1:13 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 3:46 AM
Points: 709, Visits: 1,442
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"
Post #1469870
Posted Wednesday, July 3, 2013 1:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 2, 2014 5:41 PM
Points: 23, 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.......
Post #1469879
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse