Is this the right forum for newbie sql server q's???

Question

Post reply

Is this the right forum for newbie sql server q's???

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

greg 69516 (8/13/2014)
I would've thought that manager would come with original package.

It does, SQL Server Express with Advanced Services 😉

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 2

If you just want Management Studio:

SQL Server Management Studio Express (SQLManagementStudio)

This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, full version of SQL Server 2014 Management Studio, etc. Use this if you already have the database and only need the management tools

http://msdn.microsoft.com/en-us/evalcenter/dn434042.aspx

The link will also contain the "with tools" and "advanced services" as mentioned in the previous post. You may not need Reporting Services or Full Text Search.

Steve

greg 69516 SSC Enthusiast Points: 101 More actions · Answer 3

OK, thanks much for that link. I don't recall

downloading from that page, although there were

a lot of pages that I looked at.

However, it did lead me to the same download page

as before where first I had to log in to MS and then

there was a list of downloads, one of them being the

server management studio. So it seems that I've already

downloaded that, so I didn't immediately do that again.

So, I guess I was thinking about uninstalling it all and

trying to start over? But before I do, is there some maybe

secret way to start the server management studio that I don't

know about???

I was looking on my w8.1 start/app page,

or an icon desktop, or something on the popup taskbar.

I also looked in the program file explorer and did a search.

Also, going back to my original plan, which is to have android device

trade a piece of info with a simple database on a web based

server, ...Is this SQL server programme what I want to use next?

Do I need something that powerful to start out with? I was just

looking for the most straightforward way to write a simple database

on a web based server. Am I trying to shoot ducks with a 50 cal

machine gun? Any better program recommendations for a beginner?

Thanks much!

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 4

After you login, just download the Management Studio.

SQL Server 2014 Management Studio Express 32 Bit or 64

If you already downloaded/installed

SQL Server 2014 Express with Tools 64 Bit or 32

or

SQL Server 2014 Express with Advanced Services 64 Bit or 32 bit

All you need to do is run the installer again and during the setup, only select the "Management Studio Complete", instead of the database engine.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 5

Have you gone to the start page on win8 and then start writing "SQL Server" or "Management Studio"? That way Windows will look for you.

You need to have at least SQL Server Configuration Manager. If you open it, you should see that the services are running (or not), that will indicate that the database engine was correctly installed.

Before reinstalling you might need to uninstall or you might end up with multiple db engines by mistake.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Adam.galfskiy Valued Member Points: 51 More actions · Answer 6

Sounds like you've run the first part of the installation.

I would recommend reviewing this post:

http://social.technet.microsoft.com/wiki/contents/articles/23878.installing-sql-server-2014-step-by-step-tutorial.aspx?PageIndex=2

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Luis Cazares (8/14/2014)
Have you gone to the start page on win8 and then start writing "SQL Server" or "Management Studio"? That way Windows will look for you.
You need to have at least SQL Server Configuration Manager. If you open it, you should see that the services are running (or not), that will indicate that the database engine was correctly installed.
Before reinstalling you might need to uninstall or you might end up with multiple db engines by mistake.

Use the search function on the Win 8.1 start page to search for SSMS. It should find SQK Server 2014 Management Studio with a nice big app icon; pin it to the start menu and move it to where you want it so that you don't have to search again.

Tom

greg 69516 SSC Enthusiast Points: 101 More actions · Answer 8

greg 69516

SSC Enthusiast

Points: 101

August 16, 2014 at 9:13 am

#1738633

greg 69516 SSC Enthusiast Points: 101 More actions · Answer 9

Thanks for idea. The only thing that

turned up in search for ssms were two .MSI

files, and said they were installation files.

Should I try to install again? I thought I

already did that but maybe it failed.

I took a bit of a detour and found out the

way to insert images via imgur. In the above

post is the configuration manager that someone

mentioned earlier. Does that show anything to

the learned eye???

Thanks all.