SQL Server 2005 - newbie question

3 May 2007 8:41 PM

spacemarine

hello,

ive just installed my dev copy of SQL Server 2005. evidently it doesnt
install the sample AdventureWorks db by default. unfortunately,
installing it is proving to be somewhat troublesome.

i have gone thru the Ad/Remove wizard and i now have the data files in
this folder:

Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP
\

.....now i need to attach it or whatnot. in that folder there is an
attach script, "instawdb.sql". attempts to execute this bring up,
naturally enough, a connect prompt.

however, there would appear to be no dbs for me to connect to -- not
even a "local". how do i install/enable/configure a local server
instance? one that will then allow me to connect to it and run the
attach script..

thanks,
sm

3 May 2007 10:32 PM

Kalen Delaney

Do you mean there are no SQL Server instances to connect to? A db is an
entity within a SQL Server instance. You log in to the instance and usually
that is what is specified in the connection box.

What do you do in the connection box? Are you getting an error when you try
to connect? If so, what does it say?

If you think you have successfully installed your SQL Server 2005, perhaps
the service hasn't been started. You can use SQL Server Configuration
Manager to start the SQL Server service.

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com

<spacemar***@mailinator.com> wrote in message

Show quoteHide quote

news:1178224891.262428.93010@n59g2000hsh.googlegroups.com...
> hello,
>
> ive just installed my dev copy of SQL Server 2005. evidently it doesnt
> install the sample AdventureWorks db by default. unfortunately,
> installing it is proving to be somewhat troublesome.
>
> i have gone thru the Ad/Remove wizard and i now have the data files in
> this folder:
>
> Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP
> \
>
> ....now i need to attach it or whatnot. in that folder there is an
> attach script, "instawdb.sql". attempts to execute this bring up,
> naturally enough, a connect prompt.
>
> however, there would appear to be no dbs for me to connect to -- not
> even a "local". how do i install/enable/configure a local server
> instance? one that will then allow me to connect to it and run the
> attach script..
>
>
> thanks,
> sm
>

4 May 2007 3:16 PM

spacemarine

On May 3, 5:32 pm, "Kalen Delaney" <replies@public_newsgroups.com>
wrote:
> Do you mean there are no SQL Server instances to connect to? A db is an

yes, sorry for the ambiguity in my post, but i need to install/enable/
configure a local server instance. for whatever reason, merely
installing studio did not perform this action -- i have no instances
to connect to, no local.

using SQL Server Configuration Manager, i click on "SQL Server 2005
Services", and i have no items under it -- apparently no services to
start.

it almost looks like only client tools were installed, but not actual
SQL Server. is there a dev release that does this? our copy came on cd
from our msdn flipbook.

thanks
sm

4 May 2007 5:50 PM

Kalen Delaney

It sure sounds like only the client tools were installed. I have no idea
what edition comes with the 'msdn flipbook', but it might be one that is
incompatible with your OS, so only the tools are able to be installed.

Is there any info on the CD about what edition of SQL Server is on the CD,
or is there an MSDN disk number?
What OS are you using?

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com

<spacemar***@mailinator.com> wrote in message

Show quoteHide quote

news:1178291759.014902.216970@l77g2000hsb.googlegroups.com...
> On May 3, 5:32 pm, "Kalen Delaney" <replies@public_newsgroups.com>
> wrote:
>> Do you mean there are no SQL Server instances to connect to? A db is an
>
> yes, sorry for the ambiguity in my post, but i need to install/enable/
> configure a local server instance. for whatever reason, merely
> installing studio did not perform this action -- i have no instances
> to connect to, no local.
>
> using SQL Server Configuration Manager, i click on "SQL Server 2005
> Services", and i have no items under it -- apparently no services to
> start.
>
> it almost looks like only client tools were installed, but not actual
> SQL Server. is there a dev release that does this? our copy came on cd
> from our msdn flipbook.
>
>
> thanks
> sm
>

4 May 2007 7:07 PM

spacemarine

On May 4, 12:50 pm, "Kalen Delaney" <replies@public_newsgroups.com>
wrote:
> It sure sounds like only the client tools were installed. I have no idea
> what edition comes with the 'msdn flipbook', but it might be one that is
> incompatible with your OS, so only the tools are able to be installed.
>
> Is there any info on the CD about what edition of SQL Server is on the CD,
> or is there an MSDN disk number?

yep, only the client tools were installed. i guess somehow i missed
one of the initial checkboxes. problem solved!

thanks
sm