microsoft sql server express edition

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

microsoft sql server express edition

Author

Topic

saminny
Starting Member

2 Posts

Posted - 2009-09-20 : 15:05:28

Hi,
I downloaded the latest sql server express edition from http://www.microsoft.com/sqlserver/2008/en/us/default.aspx and it was properly installed.

However, there are no links installed to run the management studio or sql server. All I have in program files link is the configuration manager and "import and export data".

Can someone please tell me how do I run the database engine and start doing some real work.

thanks,

Sam

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-09-20 : 18:04:24

Which option did you download?

The option 'Runtime' (82MB) is just the database engine with no management tools other than SQLCMD (which is command line). To get management studio and the database engione you need to download an install 'Runtime with Management Tools', 'Runtime with Advanced Services' or both 'Runtime' and 'Management Tools'

Check the services tool (control panel -> administrative tools -> services) to see if the SQL service is running. There's never an option in the start menu to run the SQL Server database engine. It's installed as a windows service.

--
Gail Shaw
SQL Server MVP

saminny
Starting Member

2 Posts

Posted - 2009-09-20 : 20:04:07

Thanks. So whats the difference between 'database engine' and 'Management Studio Express'? I downloaded and installed option 2 which is why I don't have anything. If I install option 1 without the database engine, will that work for me? What does database engine give me? Can I run queries and do SQL stuff with just option 1 without the database engine.

thanks!
Sam

quote:
Originally posted by GilaMonster

Which option did you download?

The option 'Runtime' (82MB) is just the database engine with no management tools other than SQLCMD (which is command line). To get management studio and the database engione you need to download an install 'Runtime with Management Tools', 'Runtime with Advanced Services' or both 'Runtime' and 'Management Tools'

Check the services tool (control panel -> administrative tools -> services) to see if the SQL service is running. There's never an option in the start menu to run the SQL Server database engine. It's installed as a windows service.

--
Gail Shaw
SQL Server MVP

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-09-21 : 04:38:43

quote:
Originally posted by saminny

Thanks. So whats the difference between 'database engine' and 'Management Studio Express'?

The database engine is just that, the actual SQL server database engine. Managment studio is just the client interface

quote:
Can I run queries and do SQL stuff with just option 1 without the database engine.

No. The database engine is SQL server. You need the DB engine to hold the databases. The management studio express is just the client tools - management studio and couple other things. That's fine if there's already a DB engine somewhere that you want to connect to.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources