Monday, March 12, 2012
Problem of MSDE 2000 Release A Installation
I'm new user for MSDE 2000 Release A.
Recently i have downloading MSDE2000A.exe and extract the MSDE 2000 Release
A installation files under folder name MSDERelA.
I have read thrg the document but still failed to install a new instance of
Desktop Engine for win XP .
Command Prompt:
C:\MSDERelA\Setup>SAPWD="xxxxx"
'SAPWD' is not recognized as an internal or external command,
operable program or batch file.
I think i'm missed interpreting the installation way.
Can anybody explain wht's the meaning of the below statement? Where can i
find
Windows Authentication Mode?
......To install a default instance configured to use Windows Authentication
Mode, execute: ..........
Appreciating any command suggestion for the above.
Thanks.
Regards
Chris
Try:
setup /sapwd xxxx
or put
[Options]
sapwd=xxxx
in setup.ini
SQL Server has multiple layers of security. The first one determines who can
talk to SQL Server (regardless of any attached databases). Windows
Authentication, the new default, lets anyone with a Windows login talk to
SQL Server. The old method, called SQL Server Authentication, requires a
user name and password instead. There exists Mixed Mode Authentication,
which will allow both, for instance in case you want to allow some user over
the network to access some parts of a database, you first have to allow him
to talk to SQL Server. Windows Authentication is the recommended mode,
unless you have a reason to allow login by name and password.
I'm rather new to all this, so some things I've told you might be wrong.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:93E4793E-ACAA-4AE1-B0DE-B0C341B76111@.microsoft.com...
> Hi,
> I'm new user for MSDE 2000 Release A.
> Recently i have downloading MSDE2000A.exe and extract the MSDE 2000
> Release
> A installation files under folder name MSDERelA.
> I have read thrg the document but still failed to install a new instance
> of
> Desktop Engine for win XP .
> Command Prompt:
> C:\MSDERelA\Setup>SAPWD="xxxxx"
> 'SAPWD' is not recognized as an internal or external command,
> operable program or batch file.
> I think i'm missed interpreting the installation way.
> Can anybody explain wht's the meaning of the below statement? Where can i
> find
> Windows Authentication Mode?
> .....To install a default instance configured to use Windows
> Authentication
> Mode, execute: ..........
> Appreciating any command suggestion for the above.
> Thanks.
> Regards
> Chris
>
>
>
>
>
|||Thanks for the explaination. I have tried again with the command-
C:\MSDERelA\Setup>Setup/ SAPWD xxxxx
C:\MSDERelA\Setup>
System Prompt msg "pls go to control panel to install &configure your sys
component". Any idea what does it mean?
Below are the files in folder MSDERelA:
-- folder Msi, folder Setup (sql window installer pcks/patches),
autorun.txt, license.txt, ReadmeMSDE2000A.htm, setup.exe, setup.rll &
sqlresld.dll
Did i wrote a command to a wrong file?
Anybody can help to suggest a new command?
Thanks
Chris
"Paul Pedersen" wrote:
> Try:
> setup /sapwd xxxx
> or put
> [Options]
> sapwd=xxxx
> in setup.ini
>
> SQL Server has multiple layers of security. The first one determines who can
> talk to SQL Server (regardless of any attached databases). Windows
> Authentication, the new default, lets anyone with a Windows login talk to
> SQL Server. The old method, called SQL Server Authentication, requires a
> user name and password instead. There exists Mixed Mode Authentication,
> which will allow both, for instance in case you want to allow some user over
> the network to access some parts of a database, you first have to allow him
> to talk to SQL Server. Windows Authentication is the recommended mode,
> unless you have a reason to allow login by name and password.
> I'm rather new to all this, so some things I've told you might be wrong.
>
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:93E4793E-ACAA-4AE1-B0DE-B0C341B76111@.microsoft.com...
>
>
|||hi,
Paul Pedersen wrote:
> Try:
> setup /sapwd xxxx
>
just a typo...
SAPWD=xxxx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I got that message too. I was running setup from a network drive. When I ran
it from a local drive, it worked.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4DE8D5D0-9AC8-4837-8AA6-88DF10BBB921@.microsoft.com...[vbcol=seagreen]
> Thanks for the explaination. I have tried again with the command-
> C:\MSDERelA\Setup>Setup/ SAPWD xxxxx
> C:\MSDERelA\Setup>
> System Prompt msg "pls go to control panel to install &configure your sys
> component". Any idea what does it mean?
> Below are the files in folder MSDERelA:
> -- folder Msi, folder Setup (sql window installer pcks/patches),
> autorun.txt, license.txt, ReadmeMSDE2000A.htm, setup.exe, setup.rll &
> sqlresld.dll
> Did i wrote a command to a wrong file?
> Anybody can help to suggest a new command?
> Thanks
> Chris
> "Paul Pedersen" wrote:
|||Hi,
I ran it from a local drive. Unfortunately, the same msg still being
encounter.
C:\MSDERelA\Setup>Setup SAPWD=" xxxxx"[vbcol=seagreen]
Any hint will be sincerly appreciated..
Regards
Chris
"Paul Pedersen" wrote:
> I got that message too. I was running setup from a network drive. When I ran
> it from a local drive, it worked.
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:4DE8D5D0-9AC8-4837-8AA6-88DF10BBB921@.microsoft.com...
>
>
|||I have no other experience with that error message, but I when I ran an
internet search on the error message phrase, I got several hits. None of
them helped my situation, but maybe they will help yours.
In my case, I think it was something about Setup not finding network drives
or something like that. Does it work if you run setup with no parameters?
When I tried it, I used only
setup.exe /settings settings.ini
and kept all the switches in the ini file.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:DED2A104-30C5-4461-9EB6-9FD44B4DDC5B@.microsoft.com...[vbcol=seagreen]
> Hi,
> I ran it from a local drive. Unfortunately, the same msg still being
> encounter.
> C:\MSDERelA\Setup>Setup SAPWD=" xxxxx"
> Any hint will be sincerly appreciated..
> Regards
> Chris
>
>
> "Paul Pedersen" wrote:
|||hi,
Paul Pedersen wrote:
> In my case, I think it was something about Setup not finding network
> drives or something like that. Does it work if you run setup with no
> parameters? When I tried it, I used only
>
are File and Printer sharing set in your network configuration?
is the Server service running in your control panel->admin tools->services ?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Mine is working OK now, thank you. It's Chris who is still having a problem.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3hoakvFi25ieU1@.individual.net...
> hi,
> Paul Pedersen wrote:
> are File and Printer sharing set in your network configuration?
> is the Server service running in your control panel->admin tools->services
> ?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi,
Appreciating your guys help on my case. I tried, althg still failed to
install it. For the case, I’ll thinking to purchase a pc of Visual.net.
have a nice day's.
Regards
Chris
=======
Regards
Chris
"Paul Pedersen" wrote:
> Mine is working OK now, thank you. It's Chris who is still having a problem.
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3hoakvFi25ieU1@.individual.net...
>
>
Friday, March 9, 2012
Problem Launching Report Builder
Hi,
I am having a problem launching Report Builder on one of my users pcs.
When he clicks on the icon the following error message appears:
dfsv.exe has encountered a problem and needs to close
When I log in as myself to his PC Report Builder launches with no problems.
Any advice?
Cheers
Hi,
Re-creating the user's profile worked in this case,
Thx
Wednesday, March 7, 2012
problem intstalling SQLEXPR.EXE
everytime i try installing SQLEXPR.EXE.. it will give mi a problem saying SQL server 2005 setup has detect incompatible components from beta verisons of VS, .net framework, or SQL server 2005.
i did uninstall all beta version.. n try again.. but still e same problem..
how can it be solve and whats e probem?
Take a look at the setup logs to get a more specific idea which component is causing the problem. There a number of components that got installed when you installed the Beta, you need to get rid of all of them.
Setup logs are located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOGS.
There are several threads on solving this error in the SQL Setup forum, so you should search that forum for the details.
Regards,
Mike Wachal
SQL Express team
-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1
Problem installing SQL Server 2005 SP2
updates attempted to install it, so I downloaded the exe from the ms
site. However this freezes too while running the "Authentication
Verification". This also happens if I just click the Test button.
I tried both Windows Authentication and SQL authentication and same
happens on both.
Any ideas what could cause this problem?
Thanks,
zoro.
I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
III ). It didn't really locked up though,
but it took good 10 minutes... could it be resource related in your case
too?
r
"Zoro" <ilzoro@.gmail.com> wrote in message
news:1175276243.694408.227930@.l77g2000hsb.googlegr oups.com...
> The problem seems to be with the authentication. It froze when Windows
> updates attempted to install it, so I downloaded the exe from the ms
> site. However this freezes too while running the "Authentication
> Verification". This also happens if I just click the Test button.
> I tried both Windows Authentication and SQL authentication and same
> happens on both.
> Any ideas what could cause this problem?
> Thanks,
> zoro.
>
|||On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
wrote:[vbcol=seagreen]
> I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> III ). It didn't really locked up though,
> but it took good 10 minutes... could it be resource related in your case
> too?
> r
> "Zoro" <ilz...@.gmail.com> wrote in message
> news:1175276243.694408.227930@.l77g2000hsb.googlegr oups.com...
No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
I also let it run for about an hour before I used the Task Manager to
kill it.
zoro.
|||Hi
"Zoro" wrote:
> On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
> wrote:
> No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
> I also let it run for about an hour before I used the Task Manager to
> kill it.
> zoro.
>
You may have connectivity problems to the AD? What do the upgrade logs say?
John
Problem installing SQL Server 2005 SP2
updates attempted to install it, so I downloaded the exe from the ms
site. However this freezes too while running the "Authentication
Verification". This also happens if I just click the Test button.
I tried both Windows Authentication and SQL authentication and same
happens on both.
Any ideas what could cause this problem?
Thanks,
zoro.I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
III ). It didn't really locked up though,
but it took good 10 minutes... could it be resource related in your case
too?
r
"Zoro" <ilzoro@.gmail.com> wrote in message
news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> The problem seems to be with the authentication. It froze when Windows
> updates attempted to install it, so I downloaded the exe from the ms
> site. However this freezes too while running the "Authentication
> Verification". This also happens if I just click the Test button.
> I tried both Windows Authentication and SQL authentication and same
> happens on both.
> Any ideas what could cause this problem?
> Thanks,
> zoro.
>|||On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
wrote:
> I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> III ). It didn't really locked up though,
> but it took good 10 minutes... could it be resource related in your case
> too?
> r
> "Zoro" <ilz...@.gmail.com> wrote in message
> news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> > The problem seems to be with the authentication. It froze when Windows
> > updates attempted to install it, so I downloaded the exe from the ms
> > site. However this freezes too while running the "Authentication
> > Verification". This also happens if I just click the Test button.
> > I tried both Windows Authentication and SQL authentication and same
> > happens on both.
> > Any ideas what could cause this problem?
> > Thanks,
> > zoro.
No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
I also let it run for about an hour before I used the Task Manager to
kill it.
zoro.|||Hi
"Zoro" wrote:
> On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
> wrote:
> > I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> > III ). It didn't really locked up though,
> > but it took good 10 minutes... could it be resource related in your case
> > too?
> > r
> >
> > "Zoro" <ilz...@.gmail.com> wrote in message
> >
> > news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> >
> > > The problem seems to be with the authentication. It froze when Windows
> > > updates attempted to install it, so I downloaded the exe from the ms
> > > site. However this freezes too while running the "Authentication
> > > Verification". This also happens if I just click the Test button.
> > > I tried both Windows Authentication and SQL authentication and same
> > > happens on both.
> > > Any ideas what could cause this problem?
> > > Thanks,
> > > zoro.
> No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
> I also let it run for about an hour before I used the Task Manager to
> kill it.
> zoro.
>
You may have connectivity problems to the AD? What do the upgrade logs say?
John
Problem installing SQL Server 2005 SP2
updates attempted to install it, so I downloaded the exe from the ms
site. However this freezes too while running the "Authentication
Verification". This also happens if I just click the Test button.
I tried both Windows Authentication and SQL authentication and same
happens on both.
Any ideas what could cause this problem?
Thanks,
zoro.I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
III ). It didn't really locked up though,
but it took good 10 minutes... could it be resource related in your case
too?
r
"Zoro" <ilzoro@.gmail.com> wrote in message
news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
> The problem seems to be with the authentication. It froze when Windows
> updates attempted to install it, so I downloaded the exe from the ms
> site. However this freezes too while running the "Authentication
> Verification". This also happens if I just click the Test button.
> I tried both Windows Authentication and SQL authentication and same
> happens on both.
> Any ideas what could cause this problem?
> Thanks,
> zoro.
>|||On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
wrote:[vbcol=seagreen]
> I've seen it during upgrade of a piece of ... PC ( 4GB HD, 128MB RAM, P
> III ). It didn't really locked up though,
> but it took good 10 minutes... could it be resource related in your case
> too?
> r
> "Zoro" <ilz...@.gmail.com> wrote in message
> news:1175276243.694408.227930@.l77g2000hsb.googlegroups.com...
>
No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
I also let it run for about an hour before I used the Task Manager to
kill it.
zoro.|||Hi
"Zoro" wrote:
> On 30 Mar, 21:26, "Rafael Lenartowicz" <rafa...@.rcl-consulting.com>
> wrote:
> No - this pc is a P4 3 GHz, 1GB memory and about 6 GB free disk space.
> I also let it run for about an hour before I used the Task Manager to
> kill it.
> zoro.
>
You may have connectivity problems to the AD? What do the upgrade logs say?
John