Re: MSDE and VS.NET Quickstart Tutorials
From: Ron Allen (rallen_at__nospam_src-us.com)
Date: 08/04/04
- Next message: Peter van der Goes: "Re: Cant find installer"
- Previous message: Ashish Kanoongo: "How to add/edit job in MSDE?"
- In reply to: Luke Vogel: "Re: MSDE and VS.NET Quickstart Tutorials"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 4 Aug 2004 08:59:50 -0400
Luke,
When I installed the latest version of MSDE it only created the system
databases (master, model, msdb, and tempdb). It also asked for a strong sa
password. You can try logging in as user sa and supply the password you
asked it to create. You may have to give it an instance name as well if you
installed it with one. Also network connections are turned off by default
now so you will have to enable them using svrnetcn.exe which is located in
the 80\Tools\Binn directory of your installation.
Ron Allen
"Luke Vogel" <not@_real_address> wrote in message
news:eoOyXkfeEHA.3016@tk2msftngp13.phx.gbl...
> Ok, gave it a go,
>
> osql.exe returns:
> Error: No User selected. Try with -U or -E switches.
>
> So I try -U myusername(I have administrator privileges) ... asks for
> password ...
> responds with:
> SQL Server does not exist or access denied.
>
> So I try -E ... doesn't ask for a username this time ...
> responds with the same message:
> SQL Server does not exist or access denied.
>
> I've had a look at all users and groups on my laptop, and I can't find a
> specific SQL user or anything like that (there is an SQLDebugger account
> for use with VS.NET, but I don't know what password or whatever that it
> might be setup with)
>
> I'm no guru on this stuff ... any and all help would be appreciated.
> What am I doing wrong.
>
> Regards,
>
> Luke.
>
>
>
> "Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
> news:2n72l8Ftju82U1@uni-berlin.de...
> > hi Luke,
> > "Luke Vogel" <not@_real_address> ha scritto nel messaggio
> > news:ua5gR5HeEHA.2384@TK2MSFTNGP09.phx.gbl...
> > > Hi all,
> > >
> > > I believe that MSDE installs with 4 sample databases pubs grocery2go
> etc
> > > ...
> > >
> > > I can't seem to get the quickstart tutorials working properly
> > > (specifically the ones that access the "pubs" database).
> > >
> > > I suspect that the database files may have been corrupted or tables
> > > deleted or something ... I cant seem to get the databases to
> reinstall.
> > >
> > > Can someone point me in the direction of how to re-install the
> databases
> > > please?
> > > .. or would it be easier to uninstall the complete MSDE package
> delete
> > > the residual files and re-install?
> >
> > it is not required to reinstall MSDE... just delete that database...
> on
> > oSql.exe or whatever query tool you have execute
> > USE master
> > GO
> > DROP DATABASE pubs
> >
> > you then have to re-run the pubs install script..
> > --
> > Andrea Montanari (Microsoft MVP - SQL Server)
> > http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> > DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> > (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a
> visual
> > interface)
> > --------- remove DMO to reply
> >
>
>
- Next message: Peter van der Goes: "Re: Cant find installer"
- Previous message: Ashish Kanoongo: "How to add/edit job in MSDE?"
- In reply to: Luke Vogel: "Re: MSDE and VS.NET Quickstart Tutorials"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
