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.
>
Showing posts with label steps. Show all posts
Showing posts with label steps. Show all posts
Friday, March 23, 2012
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
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
Friday, March 9, 2012
MSDE installation for .Text blogging
Hi All
A little help for MSDE please. I have tried and tried but
no luck ;-(
I followed the steps on the Installation page and
installed .Text and MSDE.
To install MSDE i used the instructions
Setup SAPWD=Test123 SecurityMode=SQL
My first question is
In the connection string, whats the username for the MSDE.
I tried looking for a default login but couldn't find one.
If i use my domain login, it doesn't work.
When i load the default page i get
"Sql Server does not exist or access denied"
I know Sql Server Exists and i can use the MSDE Query
tool. If i use NT Auth i can log in. Please advise for the
connection string.
<DbProvider type
= "Dottext.Framework.Data.SqlDataProvider,
Dottext.Framework"
connectionString = "Password=test1234;Persist
Security Info=True;User ID=admin;Initial
Catalog=blogDb;Data Source=localhost" />
Do i need to grant users for access. how do i do that.
I havent used databases in about 10 yers. a little rusty.
Raj
hi Raj,
"Raj" <raj.sinha@.gmail.com> ha scritto nel messaggio
news:996601c49747$c0098ca0$a601280a@.phx.gbl...
> Hi All
> A little help for MSDE please. I have tried and tried but
> no luck ;-(
> I followed the steps on the Installation page and
> installed .Text and MSDE.
> To install MSDE i used the instructions
> Setup SAPWD=Test123 SecurityMode=SQL
> My first question is
> In the connection string, whats the username for the MSDE.
> I tried looking for a default login but couldn't find one.
> If i use my domain login, it doesn't work.
> When i load the default page i get
> "Sql Server does not exist or access denied"
> I know Sql Server Exists and i can use the MSDE Query
> tool. If i use NT Auth i can log in. Please advise for the
> connection string.
> <DbProvider type
> = "Dottext.Framework.Data.SqlDataProvider,
> Dottext.Framework"
> connectionString = "Password=test1234;Persist
> Security Info=True;User ID=admin;Initial
> Catalog=blogDb;Data Source=localhost" />
> Do i need to grant users for access. how do i do that.
> I havent used databases in about 10 yers. a little rusty.
> Raj
>
for potential causes of access denied, please have a look at
http://support.microsoft.com/default...06&Product=sql
please verify MSDE accepts SQL Server connections too, and that the
credentials you are passing have been granted logins rights...
the "admin" SQL Server user must of course exists in SQL Server logins
collection, and so all other logins, both WindowsNT and SQL Server...
you can do that via oSql.exe, the command prompt management tool provided
with MSDE, more info at
http://support.microsoft.com/default...EN-US;q325003, but for
your convenience, you can have a look at further management tools, both free
and/or commercials, at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
A little help for MSDE please. I have tried and tried but
no luck ;-(
I followed the steps on the Installation page and
installed .Text and MSDE.
To install MSDE i used the instructions
Setup SAPWD=Test123 SecurityMode=SQL
My first question is
In the connection string, whats the username for the MSDE.
I tried looking for a default login but couldn't find one.
If i use my domain login, it doesn't work.
When i load the default page i get
"Sql Server does not exist or access denied"
I know Sql Server Exists and i can use the MSDE Query
tool. If i use NT Auth i can log in. Please advise for the
connection string.
<DbProvider type
= "Dottext.Framework.Data.SqlDataProvider,
Dottext.Framework"
connectionString = "Password=test1234;Persist
Security Info=True;User ID=admin;Initial
Catalog=blogDb;Data Source=localhost" />
Do i need to grant users for access. how do i do that.
I havent used databases in about 10 yers. a little rusty.
Raj
hi Raj,
"Raj" <raj.sinha@.gmail.com> ha scritto nel messaggio
news:996601c49747$c0098ca0$a601280a@.phx.gbl...
> Hi All
> A little help for MSDE please. I have tried and tried but
> no luck ;-(
> I followed the steps on the Installation page and
> installed .Text and MSDE.
> To install MSDE i used the instructions
> Setup SAPWD=Test123 SecurityMode=SQL
> My first question is
> In the connection string, whats the username for the MSDE.
> I tried looking for a default login but couldn't find one.
> If i use my domain login, it doesn't work.
> When i load the default page i get
> "Sql Server does not exist or access denied"
> I know Sql Server Exists and i can use the MSDE Query
> tool. If i use NT Auth i can log in. Please advise for the
> connection string.
> <DbProvider type
> = "Dottext.Framework.Data.SqlDataProvider,
> Dottext.Framework"
> connectionString = "Password=test1234;Persist
> Security Info=True;User ID=admin;Initial
> Catalog=blogDb;Data Source=localhost" />
> Do i need to grant users for access. how do i do that.
> I havent used databases in about 10 yers. a little rusty.
> Raj
>
for potential causes of access denied, please have a look at
http://support.microsoft.com/default...06&Product=sql
please verify MSDE accepts SQL Server connections too, and that the
credentials you are passing have been granted logins rights...
the "admin" SQL Server user must of course exists in SQL Server logins
collection, and so all other logins, both WindowsNT and SQL Server...
you can do that via oSql.exe, the command prompt management tool provided
with MSDE, more info at
http://support.microsoft.com/default...EN-US;q325003, but for
your convenience, you can have a look at further management tools, both free
and/or commercials, at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Wednesday, March 7, 2012
msde INSTALLATION
Hi
I am trying to install the MSDE.
I followed the steps on this page http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
on running the setup I get a message showing that the following instance is not valid and it doesn't install the MSDE.
Could somebody help me.
AkshatOK. what's your computer's name?
what command line are you specifying, exactly?|||Thanx for the message.
Computer Name=Akshat
Setup SAPWD=hello SecurityMode=SQL
These are mentioned on the webpage for installation so I just followed them.
http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
Akshat
Subscribe to:
Posts (Atom)