Develop Database on Local machine? MSDE

Hi all
I am experiencing a problem comming to grip[s with MSDE and what it does.
I need to develop an SQL Server Database but i only have a Windos XP OS
and not a server type system.
From what i understand i should be able to use msde as the engine and
utilsie the tools that i can install with SQL SERVER eg enterprise manager.
To my way odf thinking that would enable me to develop a database with
out the need for a server OS.
If this is correct i am having trouble installing MSDE 2000 and using it
with enterprise manager. can some please put me on the right path.
I have used the MSDE with SQL Server but the service seems to stop and i
cant get it restarted, so i am beliveing i just dont have it setup
properly.
Please any docs or sites and advice sent my way will be greatly appreciated.
What is the best environment to develop with one PC?
Thanks in advance
Greg
hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:OQClCBnVEHA.2408@.tk2msftngp13.phx.gbl...
> Hi all
> I am experiencing a problem comming to grip[s with MSDE and what it does.
> I need to develop an SQL Server Database but i only have a Windos XP OS
> and not a server type system.
> From what i understand i should be able to use msde as the engine and
> utilsie the tools that i can install with SQL SERVER eg enterprise
manager.
> To my way odf thinking that would enable me to develop a database with
> out the need for a server OS.
> If this is correct i am having trouble installing MSDE 2000 and using it
> with enterprise manager. can some please put me on the right path.
> I have used the MSDE with SQL Server but the service seems to stop and i
> cant get it restarted, so i am beliveing i just dont have it setup
> properly.
> Please any docs or sites and advice sent my way will be greatly
appreciated.
> What is the best environment to develop with one PC?
WinXP is fine, and you cna install on it bot MSDE and/or SQL Server Desktop
Edition or SQL Server Developer edition, now priced at $49.00 =;-D.
the latest solution, the Dev edition, shoul'd be the best one to go, both
for pricing and for tools... you have all the tools you (usually) need to
develop, test and tune your application(s), and then you cna bundle MSDE
with tem, as MSDE was really not intended for develping phase, even if it
can...
as regard your MSDE instance, it's not clear to me your inconvenient... does
it starts and then stops? or does it not start at all?
please check, in the services control panel applet, the account running SQL
Server and SQL Server Agent services...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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
|||Hi andrea
Thanks for your advice, the MSDE instance does start, but for a reason i
cannot find it stops and i cant seem to get it to restart, My only way
to get going again was to uninstall msde and reinstall. I have my
database saved
I have tried the 2000a version of MSDE but get very confused as a
service manager does not appear. so i have no idea on how to get things
going. The doco is more towards deploying than stting up on a local machine.
Can i ask if the developer version is in the Visual studio .net package?
as i might get this (still a student).
Or maybe your view on an ideal developer environment for SQL Server
(Oracle is so much easier) i intend doing the front end with VB
your help is greatly appreciated
regards
greg
Andrea Montanari wrote:
> hi Greg,
> "oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
> news:OQClCBnVEHA.2408@.tk2msftngp13.phx.gbl...
>
> manager.
>
> appreciated.
>
> WinXP is fine, and you cna install on it bot MSDE and/or SQL Server Desktop
> Edition or SQL Server Developer edition, now priced at $49.00 =;-D.
> the latest solution, the Dev edition, shoul'd be the best one to go, both
> for pricing and for tools... you have all the tools you (usually) need to
> develop, test and tune your application(s), and then you cna bundle MSDE
> with tem, as MSDE was really not intended for develping phase, even if it
> can...
> as regard your MSDE instance, it's not clear to me your inconvenient... does
> it starts and then stops? or does it not start at all?
> please check, in the services control panel applet, the account running SQL
> Server and SQL Server Agent services...
|||hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:%23OdPlByVEHA.1164@.tk2msftngp13.phx.gbl...
> I have tried the 2000a version of MSDE but get very confused as a
> service manager does not appear. so i have no idea on how to get things
> going. The doco is more towards deploying than stting up on a local
machine.
if you set up MSDE without enabling network protocols, the installed
instance can not be shown in service manager combobox as reported in
http://support.microsoft.com/default...b;EN-US;814132

> Can i ask if the developer version is in the Visual studio .net package?
> as i might get this (still a student).
the Dev edition of SQL Server comes only in VS.Net enterprise package... the
other VS.Net editions only provides MSDE...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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
|||Andrea Montanari wrote:
> hi Greg,
> "oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
> news:%23OdPlByVEHA.1164@.tk2msftngp13.phx.gbl...
>
> machine.
> if you set up MSDE without enabling network protocols, the installed
> instance can not be shown in service manager combobox as reported in
> http://support.microsoft.com/default...b;EN-US;814132
>
>
> the Dev edition of SQL Server comes only in VS.Net enterprise package... the
> other VS.Net editions only provides MSDE...
Hi andrea
Thanks for your reply, after a long night last night i worked it all
out, i had to actually go to the services window and physically start
service manager, somehow it was set to manual.
Now i have another issue, when i create a database i get a suspect next
to the DB and and an error 5105 "database already exists".
i have searched long and hard on this issue and it seems to be one of
those things that a number of problems could be causing it. do you have
any sugestions.
regards
Greg
|||hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:eszInS$VEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Now i have another issue, when i create a database i get a suspect next
> to the DB and and an error 5105 "database already exists".
> i have searched long and hard on this issue and it seems to be one of
> those things that a number of problems could be causing it. do you have
> any sugestions.
please have a look at Hugo answer in http://tinyurl.com/3ecnj ... it might
help
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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