new on installing SQL server 2005

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

SQL Server 2005 Forums

SQL Server Administration (2005)

new on installing SQL server 2005

Author

Topic

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2007-11-05 : 15:13:48

Hi,

I've installed SQL server 2005 (enterprise edition) and started SQL Server Management Studio; and I don't have any servers nor databases.

What shall/can I do in order to get (at least) a sample database (eg. Adventureworks) getting started.

Thank you for anykind of help.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 15:18:26

Just connect to the server that you installed. Did you install the default instance or a named instance?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2007-11-05 : 15:20:46

Hi,

didn't installed either because i didn't get any prompt which to install. I'm using analysis Services Deployment wizard (running *.abdatabase file) but it seems the wizard can't find the localhost :(

-> i'm lost :(

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 15:26:27

Then you didn't install the database engine, so you have no server or database to connect to. You'll need to install the engine.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2007-11-05 : 15:34:15

khm...thank you; how do I install database engine? :)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 15:37:34

Well it's on your Enterprise Edition CD.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2007-11-05 : 16:32:04

khm...it seems it's already installed but I just can't access localhost or any instance where i can deploy/install adventureworks :(

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 16:37:54

You don't specify localhost for SQL Server. Specify your hostname or hostname\instancename. To see what your hostname is set to run hostname from a cmd window.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-05 : 21:42:46

Or look at sql server configuration manager for instance name.

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2007-11-06 : 15:45:13

rmiao: i've opened sql server configuration manager and found none instance!

Tkizer: i've found hostname. where do I specify hostname or instancename?

thank you very much

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-06 : 22:06:48

Looks like you installed sql2k5 client only. Did you see sql2k5 service in services applet?

jcumberland
Starting Member

8 Posts

Posted - 2007-11-06 : 22:47:11

What OS are you trying to put this on; I don't think enterprise edition will install on a non-server OS, but it will allow you to install the client tools.

Jason Cumberland
:wq

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources