MSDE SP4 install problem

I attempted to install MSDE SP4 (file SQL2000.MSDE-KB884525-SP4-x86-ENU) on a WinXP Pro SP2 machine.

Command used:

setup SAPWD="ourpw" SECURITYMODE=SQL /L*v c:\MSDELog.log

Install log shows successful install.

MSDE appears to function properly, service starts automatically after reboot, etc.

I can open and work with DB's with a freebie 3rd party GUI called DbaMGR2K, through which I have added the necessary DB user for our locally running ASP application to use the db.

However, when I try to use the DB with our locally running ASP application - connecting with ADO from a dll we wrote, I get the following:

"[DNETLIB]{ConnectionOpen (Connect()).]SQL Server does not exist or access denied"

Any help appreciated.

day10

Hi,

make sure that you connect to the same database and you are using a valid login for connecting. Perhaps you have chosen another authentication mode within the ADO code ? That could explain either the one or the other error message you are getting.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I think we have solved the issue. We used the SQL Server Network Utility to enable TCP/IP (apparently not enabled by default) and now all appears well.

I wonder if there is a way to enable TCP/IP during the install process. Is there an install flag/option?

|||

>> Is there an install flag/option?

Most likely. The flag for this when installing SP3 was "DISABLENETWORKPROTOCOLS=0". I wouldn't think that they would have removed it for SP4.

sql

MSDE Sort Page

Hi,
I would like to install MSDE by selecting options from the
screen and not by typing commads at command prompt, just
the same way of installing SQL Server 2000.
I would also like to change the Sorting and collation
options under MSDE.
Please Help.
Thanks
Asim
hi Asim,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:79d501c48460$d47c2890$a401280a@.phx.gbl...
> Hi,
> I would like to install MSDE by selecting options from the
> screen and not by typing commads at command prompt, just
> the same way of installing SQL Server 2000.
> I would also like to change the Sorting and collation
> options under MSDE.
you have then to provide your own custom tool, which will then pass al
gathered info to the setup.exe via standard command line parameters or INI
settings
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,
I think your message did not come completely. I would
appreciate if you can send it once again.
Also please let me know how can I change by what code, the
sort or collation page setting after the MSDE has been
installed. My email is asim@.dataocean.com
Thanks

>--Original Message--
>hi Asim,
>"Asim" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:79d501c48460$d47c2890$a401280a@.phx.gbl...
the
>you have then to provide your own custom tool, which will
then pass al
>gathered info to the setup.exe via standard command line
parameters or INI
>settings
>--
>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
>.
>
|||hi Asim,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:7c8b01c48468$b1d359a0$a601280a@.phx.gbl...
> HI Andrea,
> I think your message did not come completely. I would
> appreciate if you can send it once again.
> Also please let me know how can I change by what code, the
> sort or collation page setting after the MSDE has been
> installed. My email is asim@.dataocean.com
my message was complete... LOL
I apologise if it was not clear
you have to implement a vb/vc/.net/delphi pre-installer, which collects all
user's input regarding settings like SAPWD, DISABLENETWORKPROTOCOLS,
INSTANCENAME, SECURITYMODE, TARGETDIR, DATADIR and COLLATION (for sort
order)...
then you have shell out to setup.exe passing all parameters (or setting them
in the referenced INI file)
as regard COLLATION, you can not change the system collation after the
instance has been installed...
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

MSDE setup failed

was installing MSDE for use with Web matrix
thot had done all correctly ie the setup.exe sapwd=xxxxx securitymode=sql from the command prompt
was told that setup has failed
where is the problemWas there any other information provided with the error message? If the message was "Setup Failed to configure the server" then this might help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql

Also, there should be a setup log created that might have more information.

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 OSQL command

Is there any books or website that will explain in depth about OSQL. Thanks.
Did you try the BOL ?
http://www.aspfaq.com/show.asp?id=2229
HTH, Jens Suessmeyer.
sql

MSDE Not installing

I am running Windows XP Pro. When trying to install MSDE, sql2ksp3, i go to the command line and enter:
setup SAPWD=somegreatpassword SECURITYMODE=SQL and off it goes, gathering information and starting to install.

After a short period of time where the status bar shows about 9 seconds left the status bar runs backwards down to zero and installation stops.

No error message, no crashes, just packs up its tent and goes away.

I have tried running setup from a batch file with the same results.

I have turned off my antivirus program as well as all other programs.

Need Input! - Thanks - T.C.nothing in the System error log?|||Still have the probl if you modify msde setup.ini to install?
e.g.
----------------------------
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="mysapassword"
----------------------------|||Thanks for the tries but...

Adjusting the ini gave me the same negative results.

System Event viewer just tracked that Installer was used.
Application Event viewer returned error message:
"Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."

and when i follow link to web site i am told Sorry but no help here.|||Hi, I am having the same problem. I have done a bit of research on the net and the MS knowledge base and come up with the following kb article...

http://support.microsoft.com/default.aspx?scid=kb;[LN];816499|||And seeHOW TO: Manually Remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Instance|||thank you one and all for try but alas to no avail. I have not a previous version of SQL so i am a bit stuck.|||You can try to open RPC services, and Server Services.
They are in control pad.|||I have found what it was, I also was having the problem. You have to start the service Server started, even if it is Manual, you will still need to start it.

In the instalation docs for MSDE SP3 under Install Log Verbose at the bottom to look for "Value 3", and withing 10 lines of that you find the item that failed. I found "InstallSQLAgentSecurity failed..." I then proceeded to do a search for that on Technet and low and behold there it was. in the very first sentance of "829386 - You Cannot Install MSDE 2000 if the Server Service Is Not Running" it says you need the Server service running.|||I had the same problem, with my Windows XP home. I worked on it for 4 hours, the problem was that you have to have a network set-up on your computer. so I entered into setting up a home network wizard, windows installed all the components and then I installed the MSDE. Worked like a charm. So the way to solve this is to start the network Wizard! and then install MSDE.

Thanks guys.sql

MSDE needs to be installed for BackupEXec

I have a windows 2003 ent server that we cannot install MSDE on.
If we run this from terminal services and a command line, we get nothing:
Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log
Not even a log file.
Does anyone have any suggestions?
Eric Sabo
NT Administrator
hi,
Sabo, Eric wrote:
> I have a windows 2003 ent server that we cannot install MSDE on.
> If we run this from terminal services and a command line, we get
> nothing: Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log
> Not even a log file.
> Does anyone have any suggestions?
I do not think MSDE setup is a viable solution via terminal session.. have
you tried locally connected to the server?
(FWIW, is BLANKSAPWD=1 mandatory? ... and you'll get an instance without
networkprotocols support..)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea is correct. The setup program for MSDE (and SQL Server for that
matter) needs to be done on the physical console of the machine it is being
installed on.
Jim
"Sabo, Eric" <sabo_e@.cup.edu> wrote in message
news:e$fzrbiBFHA.3976@.tk2msftngp13.phx.gbl...
>I have a windows 2003 ent server that we cannot install MSDE on.
> If we run this from terminal services and a command line, we get nothing:
> Setup.exe INSTANCENAME=BKUPEXEC BLANKSAPWD=1 /L*v C:\MSDE.log
> Not even a log file.
> Does anyone have any suggestions?
> --
> Eric Sabo
> NT Administrator
>
|||I tried it this morning and got the same results from the console of the
machine.
Is there a way to complete remove MSDE?
It will not install.
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:OrjflHvBFHA.3096@.TK2MSFTNGP14.phx.gbl...
> Andrea is correct. The setup program for MSDE (and SQL Server for that
> matter) needs to be done on the physical console of the machine it is
> being installed on.
> Jim
> "Sabo, Eric" <sabo_e@.cup.edu> wrote in message
> news:e$fzrbiBFHA.3976@.tk2msftngp13.phx.gbl...
>
|||hi Eric,
Sabo, Eric wrote:
> I tried it this morning and got the same results from the console of
> the machine.
> Is there a way to complete remove MSDE?
> It will not install.
please have a look at
http://support.microsoft.com/default...;EN-US;Q290991 ...
this will not clear the Windows Installer related entries in the Windows
registry, that requires MSIZap.exe from the Platform SDK as reported in
http://support.microsoft.com/default...b;en-us;320873
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE installed, now what?

I've run the install from the command prompt for MSDE. Is there a GUI somewhere that I can fire up? I don't see anything installed in my programs or any shortcuts anywhere, so I'm not sure where to go from here and how to tie my aspx pages into it. Thanks.Hi,

No GUI for MSDE natively except that you can use other third party 'control panel' to configure the MSDE engine. After installing the MSDE from command prompt , your next step is most likely to install the SP3 and then get started writing code against your database. :)

FYI:http://asp.net/webmatrix/guidedtour/Appendices/installMsde.aspx

Regards,|||Thank you!|||Check this 3rd party tool out for a great MSDE GUI interface:

http://www.valesoftware.com/

MSDE Installation stops in Command Prompt

Hi,
I am trying to install MSDE from a CD. At the beginning I cunpack all files at C:\sql2ksp3. Then in in Command prompt
I enter C:\sql2ksp3\MSDE>Setup SAPWD=Hello SecurityMode=SQL
The problem is that nothing happens after that. When I press enter another line appears C:\sql2ksp3\MSDE>
but that's about it.
The installation does not continue. Does anybody know how to "push" it a bit so it will continue?
Thanks
Try the post below for the correct file part. Hope this helps.
http://forums.asp.net/955765/ShowPost.aspx

MSDE install problem

I am trying to install on a fresh copy of XP Home SP1. When I type the cmd line command to start the installation, the progress bar moves to almost completion and then it rolls back to the left and dies. What's going on here??

Help!!

Thanks
Mike Kiewiczhard to say. does it leave behind an install.log? what about the system's event viewer? anything in there?|||I am having the same behavior.

Event viewer has 5 entries

1. Warning
No object list was found in the installation file. Adding an object list to the installation file will improve performance of the system when measuring performance counters.

2. Error
The performance counter name string value in the registry is incorrectly formatted. The last valid index value is DWORD 0 in the Record Data.

3. Error
The performance counter name string value in the registry is incorrectly formatted. The last valid index value is DWORD 0 in the Record Data.

4. Error
Installing the performance counter strings for MSSQL$BOBBY1 failed. The Error code is DWORD 0 of the Record Data.

5. Information
Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.|||I had this same problem. You have to have File and Print Sharing installed and running on the machine.

Kory|||File and print services are installed, however I can not view the properties

MSDE install problem

I have installed MSDE from the command prompt as instructed and get no error message - nor do I get the expected request to reboot. Since I know I must reboot to see MSDE launch, I did so, but it does not launch. It doesn't matter how many times I do this... Any ideas? I am attempting to do this on an XP machine with more than the requirements for doing so. Any help would be MOST APPRECIATED.

thanks
JSearcyIf you go to Start -> Settings -> Control Panel -> Administrative Tools -> Services do you see anything like MSSQLServer listed?

(it may be named slightly different if you installed a "named instance", in which case the name of the instance will be after MSSQLServer).

Cheers
Ken

MSDE Install fails. No service listed.

I installed MSDE with the following command line:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=luxing11
but when I start the system, no service and no server appears listed. How to correct this?
Gavin
Dear Andrea,
Thank you,I could find services in the control panel.
Isaac

>--Original Message--
>hi Isaac,
>"Isaac" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:18b6501c44b0f$67d85540$a001280a@.phx.gbl...
click
>but it shoul'd be there =;-)
>else, go to control panel and search for the Services
Management MMC snap-in
>applet
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>

MSDE install

Hello,
I installed MSDE 2000 sp3 on my windows 2000 computer. I
installed it within the command prompt as per the
instructions "setup INSTANCENAME="InstanceName"
SECURITYMODE=SQL SAPWD="Mypassword"
The setup seemed to run ok. The instancename is running in
the services and the SQLAgent is running.
However, when I go into the Enterprise manager and try to
register the server as (local) and enter my sa password
when it asks for it. I'm getting "SQL server does not exit
or access denied".
Thank you,
Randy
hi Randy,
Randy wrote:
> Hello,
> I installed MSDE 2000 sp3 on my windows 2000 computer. I
> installed it within the command prompt as per the
> instructions "setup INSTANCENAME="InstanceName"
> SECURITYMODE=SQL SAPWD="Mypassword"
> The setup seemed to run ok. The instancename is running in
> the services and the SQLAgent is running.
> However, when I go into the Enterprise manager and try to
> register the server as (local) and enter my sa password
> when it asks for it. I'm getting "SQL server does not exit
> or access denied".
> Thank you,
> Randy
as you installed a named instance, you can reach it uing it's full name,
composed by ComputerName\InstanceName, or Local\InstanceName
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply