Re: MSDE newbie

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@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
> news:520F0379-78B1-449C-9864-896E04C5C910@xxxxxxxxxxxxxxxx
> >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?
>
>
>
.

Relevant Pages

  • RE: Cant Attach Database
    ... would be if you are running a query to just create a database not specifying ... The process works when I do it on a standalone server, ... The physical file name ... physical file name 'F:\SQLLog\vibes_log.ldf' may be incorrect. ...
    (microsoft.public.sqlserver.clustering)
  • Re: XMLA and Windows 2K
    ... Did you use Anonymous authentication? ... then perhaps the username and ... password that you have configured for the anonymous user is incorrect. ... > I'm getting an Internal Server Error when trying to ...
    (microsoft.public.data.xmlanalysis)
  • Re: Interactive data application
    ... have to look at with the server, but that's pretty much all I know. ... multible choice and true/false quizs. ... continue if the answer is incorrect. ... information can be edited before uploading to server. ...
    (microsoft.public.frontpage.programming)
  • Re: FTP: disable save password checkbox?
    ... terms of saving the incorrect password, ... >> I'm running in to some snags with my IIS5 FTP. ... >> call me up saying there is a problem with the server. ... >Doesn't it ask them for a username and password if it is ...
    (microsoft.public.inetserver.iis.security)
  • Re: Daylight Savings Time bug? Experts requested
    ... If it is just "displaying" the correct ... reading incorrectly, it is reading an incorrect time caused by the server. ...
    (microsoft.public.windows.server.general)