Re: MSDE newbie

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: date from yesterday
    ... | | versions of date that uses the -v flag. ... | | adjust units, but without the -/+ preceding the unit it gives the ... Users in countries that didn't switch from the Julian ... Fully functional demos available by email request (specify OS). ...
    (comp.unix.sco.misc)
  • Re: ping problem
    ... Hi adonis, I should have asked you to being with, are you using server 2000 ... which lets you specify a source address. ... There is also a switch for ipv4 ... i want to ping a client, from a server with one of my NICs. ...
    (microsoft.public.windows.server.general)
  • Re: Using the /norestart switch
    ... > I am using SMS 2003 to deploy patches to Windows XP and Windows 2000 ... > Even I specify the /norestart switch, the clients are rebooting. ...
    (microsoft.public.sms.admin)
  • Re: HELP - WARNING: Privilege separation user "root" does not exist"
    ... > btw, I have also tried the following but it didn't ... >> to specify the root user, however I got the same error message. ... >> I tried creating an sshd user and not using the switch but got the same ...
    (comp.security.ssh)
  • Re: automating builds using msdev
    ... > to automate my project builds. ... > I see I can use the /OUT switch to specify a text file to receive the ... FindNextChangeNotification to avoid polling, or use one of the "tail" ...
    (microsoft.public.win32.programmer.kernel)
Loading