MSDE reinstall.

I had MSDE installed on my machine, but I had problems making it work. I installed the Visual Studio 2005Beta2, and it apparently installed MSDE 2005. I deinstalled MSDE 2000, then tried to make MSDE 2005 work. After lots of hair pulling I finally found the instance name, reset the authenitcation method, and reset the SA password. Then I found out all my sql tools don't work with it. No enterprise manager or query analyzer. So off MSCE 2005 came from my machine. I reinstalled MSCE 2000, but I cannot login. I am not sure if I don't have the proper instance name, or password for the sa account. I have not really found any good into on setting up the msce 2000 software. I think it found the old username/password info because whtn I started it, it did not ask me for any of that information.
How can I reload/set the admin password? I would like to get it going so I can start playing with visual studio 2005. I sure hope it knows how to play with MSDE 2000 properly.

Jr.CoderCleaning up really old threads; I assume you got this resolved one way or another long since?

MSDE reinstall.

I had MSDE installed on my machine, but I had problems making it work. I installed the Visual Studio 2005Beta2, and it apparently installed MSDE 2005. I deinstalled MSDE 2000, then tried to make MSDE 2005 work. After lots of hair pulling I finally found the instance name, reset the authenitcation method, and reset the SA password. Then I found out all my sql tools don't work with it. No enterprise manager or query analyzer. So off MSCE 2005 came from my machine. I reinstalled MSCE 2000, but I cannot login. I am not sure if I don't have the proper instance name, or password for the sa account. I have not really found any good into on setting up the msce 2000 software. I think it found the old username/password info because whtn I started it, it did not ask me for any of that information.
How can I reload/set the admin password? I would like to get it going so I can start playing with visual studio 2005. I sure hope it knows how to play with MSDE 2000 properly.

Jr.CoderCleaning up really old threads; I assume you got this resolved one way or another long since?

MSDE Reinstall

Have reinstalled MSDE using Command Prompt Installation and received Errors.
Then I proceeded with a Batch.file installation and that seemed to work for the most part.

This is what I used for the Batch.file

setup.exe SAPWD=somename INSTANCENAME=somename SECURITYMODE=SQL

The Problem I ran into is - I can't seem to get the (SQL SERVER SERVICE MANAGER) to connect. I've entered the server name & instancename but so far no luck.

Ive checked - Control Panel/Administive Tools/Services - to make sure that it was installed & Yes it is there. So I Proceeded to start it up. Next I tried to Connect Via SERVER MANGER with no luck.
Then I did a c:\>osql -E check with the Command Line Prompt which returned the following message:

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.

Tried again with c:\>osql -E -S
returned the same message.

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.

Not sure what to do at this point any help/advice. Thx/TIA

(MSDE Version: sql2kdesksp3)
OS = XP ProUpdate:

Finally Managed to Connect to (SERVICE MANAGER) So now I have Connection with my server. I had to Specify ServerName\Instancename - and finally managed to connect.

But I can't seem to make a Database Connection In webMatrix. I entered The (USERName & Password Name) with no luck, even tried different combinations but still no luck!! USERNAME:Someusername**** (and) PASSWORD:SomePassword****

Is there a way I can create a New USERNAME & PASSWORD, with the command Line Prompt?
Anyone know how to do this? THX /TIS

Tristen|||view post 446484|||Thank you for Link/replying Bill,

Problem corrected. Reinstalled MSDE & Made a New SQL Authentication Password.|||Did "setup /upgradesp" help you?

msde question

Can you tell me how to reinstall MSDE? my MSDE is installed from Office CD.
instructions step by steps. thank you.thank you all.
"Matt" <spam@.spam.com> wrote in message
news:O5SZ8PFqDHA.964@.TK2MSFTNGP10.phx.gbl...
> Can you tell me how to reinstall MSDE? my MSDE is installed from Office
CD.
> instructions step by steps. thank you.
>|||thank you all.
"Matt" <spam@.spam.com> wrote in message
news:O5SZ8PFqDHA.964@.TK2MSFTNGP10.phx.gbl...
> Can you tell me how to reinstall MSDE? my MSDE is installed from Office
CD.
> instructions step by steps. thank you.
>

msde question

Can you tell me how to reinstall MSDE? my MSDE is installed from Office CD.
instructions step by steps. thank you.This may help :- http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
--
HTH
Ryan Waight, MCDBA, MCSE
"Matt" <spam@.spam.com> wrote in message
news:%23YzyCQFqDHA.964@.TK2MSFTNGP10.phx.gbl...
> Can you tell me how to reinstall MSDE? my MSDE is installed from Office
CD.
> instructions step by steps. thank you.
>
>|||Ryan Waight wrote:
> This may help :-
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
I dont quite see how that link helps him?
Nethertheless Matt your best bet is to do the following (you will then
have the most recent updated version (sp3a)
1. Download
Sql2kdesksp3.exe. From
> http://www.microsoft.com/sql/downloads/2000/sp3.asp
2. Run executable and extract to a directory
3. If you still have a previous copy installed, (backup if you want to
keep data) and uninstall
4. Within the msde folder you will see a sp3readme.htm file, open it
and refer to this part of it and follow the installation instructions.
file:///sp3readme.htm#_3467465_installing_a_new_instance_of_msd_cuy1
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||Hi Matt,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with your issue.
First of all, I would like to thank Mark for his assistance on your issue. I believe the detailed
steps make you clear and easy to apply a reinstallation. I'd like to add more information here
to further simplify the installation.
As we known, we can customize many of the default installation parameters for Setup.exe and
then redistribute it for automated installation using shell scripts and other installation programs.
I recommend you configure the setup.ini file after you run executable and extract it to a
directory. You can edit the setup.ini in the extracted directory by adding the following settings,
and then run the setup.exe to perform an automated installation.
When you install a default instance, the recommended default settings are:
#Note: You can change the "sa_password" as you like
--
[Options]
TARGETDIR="C:\Program Files\Microsoft SQL Server\Mssql\Binn\"
DATADIR="C:\Program Files\Microsoft SQL Server\Mssql\Data\"
SECURITYMODE=SQL
SAPWD="sa_password"
--
When you install a named instance, the recommended default settings are:
--
[Options]
TARGETDIR="C:\Program Files\Microsoft SQL Server\Mssql$MyInstance\Binn\"
DATADIR="C:\Program Files\Microsoft SQL Server\Mssql$MyInstance\Data\"
INSTANCENAME="MyInstance"
SECURITYMODE = SQL
SAPWD="sa_password"
--
Matt, does that answer your question? Please feel free to let me know if this help solves your
problem. If there is anything more I can still assist you with, please feel free to post it in the
group.
Best regards,
Billy Yao
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql

MSDE instance restore question

how do I reinstall the MSDE instance after I restored my server?
The issue that I am having is that I can not restore the database because I
can not start the MSSQL$LDMSDATA service. So at this point I need to
reinstall the MSDE
instance.
Unless someone has a better idea.
Thanks in advance
Hi,
See the below link to manually remove MSDE.
http://support.microsoft.com/default...b;en-us;290991
After that you can do a fresh install and restore the databases.
Thanks
Hari
SQL Server MVP
"Greg" <gregkh@.hotmail.com> wrote in message
news:075D3330-8F53-41D5-9544-D45C8954B055@.microsoft.com...
> how do I reinstall the MSDE instance after I restored my server?
> The issue that I am having is that I can not restore the database because
> I
> can not start the MSSQL$LDMSDATA service. So at this point I need to
> reinstall the MSDE
> instance.
> Unless someone has a better idea.
> Thanks in advance

MSDE instance restore question

how do I reinstall the MSDE instance after I restored my server?
The issue that I am having is that I can not restore the database because I
can not start the MSSQL$LDMSDATA service. So at this point I need to
reinstall the MSDE
instance.
Unless someone has a better idea.
Thanks in advanceHi,
See the below link to manually remove MSDE.
http://support.microsoft.com/defaul...kb;en-us;290991
After that you can do a fresh install and restore the databases.
Thanks
Hari
SQL Server MVP
"Greg" <gregkh@.hotmail.com> wrote in message
news:075D3330-8F53-41D5-9544-D45C8954B055@.microsoft.com...
> how do I reinstall the MSDE instance after I restored my server?
> The issue that I am having is that I can not restore the database because
> I
> can not start the MSSQL$LDMSDATA service. So at this point I need to
> reinstall the MSDE
> instance.
> Unless someone has a better idea.
> Thanks in advance

MSDE instance restore question

how do I reinstall the MSDE instance after I restored my server?
The issue that I am having is that I can not restore the database because I
can not start the MSSQL$LDMSDATA service. So at this point I need to
reinstall the MSDE
instance.
Unless someone has a better idea.
Thanks in advanceHi,
See the below link to manually remove MSDE.
http://support.microsoft.com/default.aspx?scid=kb;en-us;290991
After that you can do a fresh install and restore the databases.
Thanks
Hari
SQL Server MVP
"Greg" <gregkh@.hotmail.com> wrote in message
news:075D3330-8F53-41D5-9544-D45C8954B055@.microsoft.com...
> how do I reinstall the MSDE instance after I restored my server?
> The issue that I am having is that I can not restore the database because
> I
> can not start the MSSQL$LDMSDATA service. So at this point I need to
> reinstall the MSDE
> instance.
> Unless someone has a better idea.
> Thanks in advance

MSDE fail after upgrade from WIN98 to WINXP HOME

Anyone can help?
I installed MSDE in WIN98 and then upgrade to WINXP home, after that, MSDE failure and i can't reinstall MSDE again, already call microsoft support and try something but no help at all.
John
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Not to be rude, but your first mistake was attempting to upgrade Win9x to
XP.
MSDE installed under Win9x is a completely different animal than an
installation on the NT style operating systems. With Win9x there are no
service applications so MSDE runs as a standard application when the system
starts up. When you upgrade your OS to XP there is no magical conversion of
the MSDE installation to it running as a service. Your best bet is to backup
your databases and then manually uninstall MSDE. Microsoft has an article on
how to do this at:
http://support.microsoft.com/default...b;en-us;290991
After uninstalling MSDE re-install it and restore your databases.
Jim
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OzBSSNkjEHA.1404@.TK2MSFTNGP09.phx.gbl...
> Anyone can help?
> I installed MSDE in WIN98 and then upgrade to WINXP home, after that, MSDE
failure and i can't reinstall MSDE again, already call microsoft support and
try something but no help at all.
> John
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||Hi Jim,
Thanks for your advice, i will try it !!
John

>--=AD=EC=A9l=B6l=A5=F3--
>Not to be rude, but your first mistake was attempting to=20
upgrade Win9x to
>XP.
>MSDE installed under Win9x is a completely different=20
animal than an
>installation on the NT style operating systems. With=20
Win9x there are no
>service applications so MSDE runs as a standard=20
application when the system
>starts up. When you upgrade your OS to XP there is no=20
magical conversion of
>the MSDE installation to it running as a service. Your=20
best bet is to backup
>your databases and then manually uninstall MSDE.=20
Microsoft has an article on
>how to do this at:
>http://support.microsoft.com/default.aspx?scid=3Dkb;en-
us;290991
>After uninstalling MSDE re-install it and restore your=20
databases.
>Jim
>"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in=20
message[vbcol=seagreen]
>news:OzBSSNkjEHA.1404@.TK2MSFTNGP09.phx.gbl...
home, after that, MSDE
>failure and i can't reinstall MSDE again, already call=20
microsoft support and[vbcol=seagreen]
>try something but no help at all.
newsgroup engine
>supports Post Alerts, Ratings, and Searching.
>
>.
>