Re: Cannot Install DB

Thats got it..with the OSQL -E it worked fine thru cmd.. Thanks for your help

"Jens Süßmeyer" wrote:

> Just a moment, i saw that you are using the QA ?!
> So perhaps you are not connected to the MSDE rathjer than to a SQL Server.
> If you issue the command
> sp_Attach_db the SQL Server / MSDE will always look on Local drives to get
> control over the datafile. So if you are connected to a remote server rather
> than to the MSDE it will tell you that the files are not present.
>
> If you really want to make sure that you are working on the MSDE, just do
> this on the command line:
>
> OSQL -E (if you are using Integrated Security, if not
> use -UUsername -PPassword)
>
> Then type in the Command i gave you in the last post, that should really
> help, if not there MUST be a difference in the location you specified.
>
> HTH, Jens SUessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
> "Matt" <Matt@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
> news:0206A4CE-541A-4CA8-B5A6-5213E982D1EC@xxxxxxxxxxxxxxxx
> > Thanks, Tried it but still the same error.
> >
> >
> >
> > "Jens Süßmeyer" wrote:
> >
> >> You don´t need these curly brackets. Just type in (as filename is
> >> expecting
> >> a nvarchar)
> >>
> >> EXEC sp_attach_db @dbname = 'SRPA',
> >> @filename1 = N'c:\SRPA\SRPA.MDF',
> >> @filename2 = N'c:\SPRA\SRPA.LDF'
> >>
> >> HTH, Jens Suessmeyer.
> >>
> >> ---
> >> http://www.sqlserver2005.de
> >> ---
> >>
> >> "Matt" <Matt@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
> >> news:C7340567-DD95-4534-A75E-0583F630E6E0@xxxxxxxxxxxxxxxx
> >> > Hi,
> >> >
> >> > I have installed the latest MSDE and am entering the following text in
> >> > the
> >> > query analyzer:
> >> >
> >> > EXEC sp_attach_db @dbname = 'SRPA',
> >> > @filename1 = '{c:\SRPA\SRPA.MDF}',
> >> > @filename2 = '{c:\SPRA\SRPA.LDF}';
> >> >
> >> > but i'm getting the following error:
> >> >
> >> > Error: Device activation error. The physical file name
> >> > 'c:\SRPA\SRPA.MDF'
> >> > may be incorrect.
> >> >
> >> > I have checked and double checked the name/location etc and it all
> >> > matches..
> >> >
> >> > any help would be greatly appreciated, Thanks
> >> >
> >> > Matt
> >> >
> >> >
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Changing SA password
    ... OP needs to review the install "command" line options for MSDE - SA ... After typing "osql -U sa" at the ...
    (microsoft.public.windowsxp.security_admin)
  • Changing SA password
    ... After typing "osql -U sa" at the ... command prompt the following message appears "'osql' is ... professional and trying to load MSDE 2000. ... open the command prompt window. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: How can I change the login name and password?
    ... My first post was the common expression based on BOL Syntax. ... Where do you fire the commadn to the SQL Server, from OSQL? ... > sp_password still comes up as an invalid command. ... >> HTH, Jens Suessmeyer. ...
    (microsoft.public.sqlserver.msde)
  • Re: Cannot Install DB
    ... So perhaps you are not connected to the MSDE rathjer than to a SQL Server. ... If you issue the command ... >> HTH, Jens Suessmeyer. ...
    (microsoft.public.sqlserver.msde)
  • Re: How can I change the login name and password?
    ... Sorry but I don't know what BOL means. ... command promt. ... > Where do you fire the commadn to the SQL Server, from OSQL? ... >>> HTH, Jens Suessmeyer. ...
    (microsoft.public.sqlserver.msde)