June 28, 2013 at 9:52 pm
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.
July 1, 2013 at 1:51 am
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.
July 1, 2013 at 2:31 am
July 1, 2013 at 7:31 pm
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....
July 2, 2013 at 12:01 am
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.
July 2, 2013 at 1:01 am
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?
July 2, 2013 at 2:46 am
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"
July 2, 2013 at 6:17 pm
I can't see any SQL Server services. How to/from where can I install the instance?
July 3, 2013 at 1:13 am
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"
July 3, 2013 at 1:34 am
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.......:-)
July 3, 2013 at 1:45 am
Glad you got it up and working!
Joie Andrew
"Since 1982"
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply