MSDE newbie

I Just installed MDSE2000A (ithink it already comes with SP3a), by doing
Setup.exe /qb+ INSTANCENAME=MOC DISABLENETWORKPROTOCOLS=1 SAPWD=moc
I downloaded the northwind database and tried to install it by doing
osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
Databases\northwind.mdf'"
the response was
[Shared Memory]Invalid connection.
[Shared Memory]ConnectionOpen (Invalid Instance()).
what have I done wrong?
You did not specify th instance you want to connect to, this can be done
with the switch -S
osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
Databases\northwind.mdf' -SServername\Instancename
Would be on the the local server ".\MOC"
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joo Costa" <JooCosta@.discussions.microsoft.com> schrieb im Newsbeitrag
news:520F0379-78B1-449C-9864-896E04C5C910@.microsoft.com...
>I Just installed MDSE2000A (ithink it already comes with SP3a), by doing
> Setup.exe /qb+ INSTANCENAME=MOC DISABLENETWORKPROTOCOLS=1 SAPWD=moc
> I downloaded the northwind database and tried to install it by doing
> osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
> Databases\northwind.mdf'"
> the response was
> [Shared Memory]Invalid connection.
> [Shared Memory]ConnectionOpen (Invalid Instance()).
> what have I done wrong?
|||thanks, now I have unather problem, I transcribed the line below:
osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
Databases\northwind.mdf'" -S.\MOC
the answer was:
Msg 5105, Level 16, State 4, Server RAINBOWARRIOR\MOC, Line 1
Device activation error. The physical file name 'c:\SQL Server 2000 Sample
Databases\northwind.mdf' may be incorrect.
"Jens Sü?meyer" wrote:

> You did not specify th instance you want to connect to, this can be done
> with the switch -S
> osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
> Databases\northwind.mdf' -SServername\Instancename
> Would be on the the local server ".\MOC"
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Jo?o Costa" <JooCosta@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:520F0379-78B1-449C-9864-896E04C5C910@.microsoft.com...
>
>
|||The problem is that there are spaces in the pathname, if you could get
around this you should use a simple path which doesnt contain any space
perhaps c:\sql. If you cant you have to doublequote the Quotes.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joo Costa" <JooCosta@.discussions.microsoft.com> schrieb im Newsbeitrag
news:6A7F0B79-0B83-46C3-A1D6-C48EB86E0C8B@.microsoft.com...[vbcol=seagreen]
> thanks, now I have unather problem, I transcribed the line below:
> osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
> Databases\northwind.mdf'" -S.\MOC
> the answer was:
> Msg 5105, Level 16, State 4, Server RAINBOWARRIOR\MOC, Line 1
> Device activation error. The physical file name 'c:\SQL Server 2000 Sample
> Databases\northwind.mdf' may be incorrect.
> "Jens Smeyer" wrote:
|||thanks!
"Jens Sü?meyer" wrote:

> The problem is that there are spaces in the pathname, if you could get
> around this you should use a simple path which doesn′t contain any space
> perhaps c:\sql. If you can′t you have to doublequote the Quotes.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Jo?o Costa" <JooCosta@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A7F0B79-0B83-46C3-A1D6-C48EB86E0C8B@.microsoft.com...
>
>