Installing MSDE2000 sp3 - help

Hiya folks,
I'm a newbie at this, so forgive the ignorance that I may display!
I have installed a software package on my system that installs MSDE through
merge modules contained in its MSI. I have several workstations that
connect. Unfortunately, with SP2 coming down the pipe for windows xp, i
have to do lots of fancy stuff to make sure they still connect (it uses
named pipes tcp/ip). The solution according to microsoft is to install SP3
for sql...i've downloaded the MSDE version of the upgrade, and attempted to
install for several hours with no luck.
First, it said i required a strong password, which i supplised in the
setup.ini:
[options]
sapassword="mypassword"
Things started to load, and then the installer quit. Confused, I started it
again. Now the installer is giving me '
the instance name specified is invalid'
Ok, so i go back to the setup.ini and add a line
[options]
sapassword="mypassword"
instancename="liveddm"
and STILL, i get the invalid instance name error message. No matter what I
seem to try, it is telling me i have an invalid instance name; if i use
enterprise manager, i can clearly see my instance and browse the attached
database. I've also tried instancename="computername\liveddm" with no luck.
Any help would be greatly appreciated.
Thanks!
Sheldon
sheldon@.REMOVETHISthedoctorcompany.com
Sheldon Purkiss wrote:
> Hiya folks,
> I'm a newbie at this, so forgive the ignorance that I may display!
> I have installed a software package on my system that installs MSDE through
> merge modules contained in its MSI. I have several workstations that
> connect. Unfortunately, with SP2 coming down the pipe for windows xp, i
> have to do lots of fancy stuff to make sure they still connect (it uses
> named pipes tcp/ip). The solution according to microsoft is to install SP3
> for sql...i've downloaded the MSDE version of the upgrade, and attempted to
> install for several hours with no luck.
> First, it said i required a strong password, which i supplised in the
> setup.ini:
> [options]
> sapassword="mypassword"
> Things started to load, and then the installer quit. Confused, I started it
> again. Now the installer is giving me '
> the instance name specified is invalid'
> Ok, so i go back to the setup.ini and add a line
> [options]
> sapassword="mypassword"
> instancename="liveddm"
> and STILL, i get the invalid instance name error message. No matter what I
> seem to try, it is telling me i have an invalid instance name; if i use
> enterprise manager, i can clearly see my instance and browse the attached
> database. I've also tried instancename="computername\liveddm" with no luck.
> Any help would be greatly appreciated.
> Thanks!
> Sheldon
> sheldon@.REMOVETHISthedoctorcompany.com
>
>
>
Hi Sheldon
Unfortunately, I believe that if your software vendor has installed MSDE
using merge modules from within their own MSI they will need to supply
you with the patch package themselves.
See http://www.microsoft.com/sql/downloads/2000/sp3.asp
Tony

Installing MSDE SP3 to Win98 causes an error.

Ok I have an MSI file that installs an instance of the MSDE. I recently updated my install to used the SP3 MSMs of the MSDE. I have the installation working correctly on XP. However it fails rather quickly on install to Win98. I will paste the log file of the failure below.

To create the installation I used the VisualStudio installer. Afte the installtion I use ORCA and edit the MSI with the following values in the property table.

ProductLanguage = 1033
SqlBlankPwd = 1
SqlSecurityMode = SQL

No special actions are being used by my installer. Yet according to MS the reason for my error is that I am using a special action with a non-c++ dll (KB Article (http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306627)) . I am guessing that this is something that MS is doing. Has anyone else gotten a successful install of SP3 onto Win98? Any info would be helpful.

Mike Villaronga
mike_villaronga@.yahoo.com

LogFile:

Internal Error 2737. StreamSupportFiles.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B, C:\WINDOWS\TEMP\MSI60B6.TMP, StreamSupportFiles
=== Logging stopped: 2/3/03 10:06:17 ===I have not gotten SP3 to install on win98. I have tried to do it manually as well as from an install shield application. I get an error message that there is a dll missing. It doesn't specify which dll or give any kind of clue.

[SIZE=1]Originally posted by mvillaronga
Ok I have an MSI file that installs an instance of the MSDE. I recently updated my install to used the SP3 MSMs of the MSDE. I have the installation working correctly on XP. However it fails rather quickly on install to Win98. I will paste the log file of the failure below.

I am guessing that this is something that MS is doing. Has anyone else gotten a successful install of SP3 onto Win98? Any info would be helpful.

Installing MS sql server 2000 on win 2003 server

How do I do this when my instalation cd is an old veriosn with no SPs? Win
2003 requires MS SQL 2000 SP3 sp what do I do?

Regards
Anders> When you get the prompt saying that it must be SP3 you can continue to the
> end of the installation as per normal. You should then install SP3
> immediately before you do anything else. SP3a can be download from the
> microsoft web site.

Actually not. It says:

Ms SQL Server 2000 Enterprise Ediditon server componenet is not supportet on
this operating system. Only client componentes will be avaible for
instalation.

I juts read that before SQL server 2000 could run i would need SP3. But I
get no chance of installing it. Is it because its enteprise edition?

ANders|||> When you get the prompt saying that it must be SP3 you can continue to the
> end of the installation as per normal. You should then install SP3
> immediately before you do anything else. SP3a can be download from the
> microsoft web site.

Ahhhh. Stupid stupid me. So embarrassed. Id used my locally cdrom drive as
mountet network drive. Somehow i have manished to click on autorun menu at
my local computer! Thougt the popup window was on the server. (Using VNC)

Anyay thx. I'll just crawl back in my hole.

Anders

Installing MDAC 2.5 on W2k sp3

I have tried installing MDAC 2.5 on a w2k sp3 machine and it fails with the following error:

Microsoft Data Access components 2.5 is already installed on the version of windows you are running. Setup cannot update the system. For more information .....

BUT, Mdac 2.5 is not installed on the machine and VB applications using it do not work.

Any ideas?

ThankQ1 Any ideas?

A1 Yes.

1 Check your MDAC component status with the compatibility checking tool. See:

http://www.microsoft.com/data/download.htm#CCinfo

http://download.microsoft.com/download/dasdk/CC/2.7/WIN98MeXP/EN-US/cc.exe

2 See MDAC Installation Notes at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/data_mdacinstall.asp|||Thanks DBA,

This has let me discover that the latest PCs with W2k have sp3 installed by default which includes MDAC 2.6. It is therefore not possible to install MDAC 2.5 - it physically stops you.

It just means I have to change the references to the ADO 2.5 objects to 2.6...|||You are most welcome.

Hopefully 2.6 is otherwise fully compatible with your applications. Newer (and sometimes corrupt or third party) dll issues are not an uncommon source of spurious "already installed" and similar MDAC errors.sql

installing hotfix SQL2000-KB810185-8.00.0780-ENU

I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?
1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:

> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

installing hotfix SQL2000-KB810185-8.00.0780-ENU

I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC
.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:

> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>sql

installing hotfix SQL2000-KB810185-8.00.0780-ENU

I am attempting to install this hotfix on a second instance of SQL Server
2000 running sp3 on a window 2003 server. I successfully installed the
hotfix on the first instance with no problems following the same sequence of
events against the first instance.
I am unable to install as it tells me one of the files is write locked. I
have shutdown both instances (SQL server and SQL agent) as well as the MSDTC.
I have shutdown the Window 2003 server and attempted to run the install. I
was successfully able to install the hotfixes on 2 instances on another
server running the same products.
The file in question is dbmslpcn.dll.
Any suggestions ?1. Try renaming the DLL - does this work?
2. Run TLIST (included in windows resource kit) to see what app is holding
a lock to this DLL
syntax: TLIST -m <DLL>/<.exe Name>
3. shutdown all unecessary services and set to manual mode, then reboot.
See KB for a list of services to NOT shut down:
INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
ID: 219264
Do not shut off any services necessary for disk or network access.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx|||I ran the tasklist command, found my application that was using the file and
stopped that service. thanks very much for the info
"Fany Vargas [MSFT]" wrote:
> 1. Try renaming the DLL - does this work?
> 2. Run TLIST (included in windows resource kit) to see what app is holding
> a lock to this DLL
> syntax: TLIST -m <DLL>/<.exe Name>
> 3. shutdown all unecessary services and set to manual mode, then reboot.
> See KB for a list of services to NOT shut down:
> INF: Order of Installation for SQL Server 7.0 Clustering Setup WGID:249
> ID: 219264
> Do not shut off any services necessary for disk or network access.
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>

Installation SQL-Cluster failed

Hi,
we are trying to install "SQL-Server Version 8.00.780 SP3" on a Win2003
2-node Cluster. The Installation breaks, and in the sqlstp.log we find the
Message "remsetup.exe not find". In the Knowledge Base we find problems with
Terminal Service (no TS installed) and with special character in connection
names (the names are public and private). We have log in as a domain admin
and the sql engine and the agent are started with a domain admin.
1.copyexe=cnvsvc1.exe
08:28:41 Setup is performing required operations on cluster nodes. This may
take a few minutes...
08:28:41 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
08:30:14 Process Exit Code: (2) The system cannot find the file specified.
08:30:14 Begin Action : GetRemsetupRetCode
08:30:14 Installation return status on OBELIX : 2
08:30:14 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 05/14/04 08:28:41 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x74] created for execution.
CThread::Process [0x74]
CThreadPool::RunUntilCompleteHlpr start thread [0x74],index=0
Script file copied to '\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss' successfully.
Installing remote service (OBELIX)...
Running '\\ASTERIX\Z$\x86\setup\setupsql.exe k=ClSec k=Rm k=Cl -SMS -s -f
"\\ASTERIX\Z$\x86\setup\setup.ins" -f1
\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss -f2 "\\OBELIX\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (OBELIX) ...
CRemoteProcess::RunUntilComplete [0x74] exit code: 2
Remote process exit code was '2' (OBELIX).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x74]
Thread [0x74] exit code: [0x2]
CThreadPool::RunUntilComplete returned 2
CThreadPool::RunUntilComplete execution level=1, need execution: 0
One or more errors occurred while running the remote/unattended setups.
Disconnecting from remote machine (OBELIX)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 05/14/04 08:30:14 ####
08:30:14 End Action : Run setup on cluster nodes
08:30:14 One or more errors occurred while running remote setup on the
clustered machines.
08:30:28 Setup failed to perform required operations on the cluster nodes.
08:30:28 Begin Action : ClusterErrorCleanup
08:30:28 End Action : ClusterErrorCleanup
08:30:28 End Action : ClusterSetupHelper
Thank you for help.
Sound to me like your MS cluster isn't installed correctly.
Have you carried out the tests suggested in the Cluster checklist?
If you are happy with the installation try copying the remsetup.ini file from the user dir as mentioned in KB301520.
|||Try these steps to see if you can resolve the problem:
1) Check and see if the machine is configured to disallow 8.3 name creation
by
checking the following registry key:
HKLM\SYSTEM\CURRENTCONTROLSET\CONTROL\FileSystem\N tfsDisable8dot3NameCreatio
n
A value of 1 means this is disabled and hence change it back to 0. This
requires a
reboot for it to take effect
OR
2) Change the TEMP and TMP User Environment Variables to a path that does
not have
spaces in them. For example: c:\temp. Use the SET command to verify the new
TEMP
location is in effect. This does not require a reboot
Rand
This posting is provided "as is" with no warranties and confers no rights.

Installation on Windows XP SP2

I try to install SQL Server 2000 SP3 on my Windows XP server.

During the installation, the setup process inform me database services can't be install on my machine.
I can only install client tools.

It seems to success, but when I try to connect register a new database in the Enterprise Manager tool, connection to my server databases always fail with error:
"waiting time expire"

If I try to connect to the same database with the Querty Analyzer it works.

How can I solve this problem ? His there a patch ?SQL Server 2000 is designed to run on a server OS so it won't install on XP. You can install msde and run small databases just fine.|||sql server standard and sql server enterprise editions are designed to install on server OS's. However, SQL Server Developer edition runs just fine on my windows xp with sp2 laptop.

the developer edition is exactly like SQL Std and Ent in tools looks and function. it is just limited in its client support. somewhere around 8 clients i believe.

on a side note, i worked on a really slow sql server once and found out that they had installed the dev edition on a production server......
pop the cd in
choose upgrade
restart
finished in 2 minutes. that'll be $100.00 please

Installation of MS SQL SP3 failed

Hello,
We have a problem installing SP3 on some machines. We get
the following error:
"There is not enough space on drive C:\ to extract this
package. Please free up 109.41 MB and click Retry."
We found a Microsoft Knowledge Base Article - No. 301913
on this problem, but it gives a workaround that is not
helpfull for us:
"To work around this problem, add or delete files on your
computer so that the free disk space is not a multiple of
4-gigabytes."
Is there another solution/workaround for this problem?
The link for the articale is:
http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/Q3
01/9/13.ASP&NoWebContent=1
Thanks,
ShiriSP3a fixes problems with the installation of SP3. Suggest going straight to
SP3a
--
HTH
Ryan Waight, MCDBA, MCSE
<Shiri.Tzuk@.verint.com> wrote in message
news:093201c3a7a0$bd103db0$a501280a@.phx.gbl...
> Hello,
> We have a problem installing SP3 on some machines. We get
> the following error:
> "There is not enough space on drive C:\ to extract this
> package. Please free up 109.41 MB and click Retry."
> We found a Microsoft Knowledge Base Article - No. 301913
> on this problem, but it gives a workaround that is not
> helpfull for us:
> "To work around this problem, add or delete files on your
> computer so that the free disk space is not a multiple of
> 4-gigabytes."
> Is there another solution/workaround for this problem?
> The link for the articale is:
> http://support.microsoft.com/default.aspx?
> scid=http://support.microsoft.com:80/support/kb/articles/Q3
> 01/9/13.ASP&NoWebContent=1
> Thanks,
> Shiri
>|||Shiri - why can you not manually use some space up?
> We have a problem installing SP3 on some machines. We get
> the following error:
> "There is not enough space on drive C:\ to extract this
> package. Please free up 109.41 MB and click Retry."
> We found a Microsoft Knowledge Base Article - No. 301913
> on this problem, but it gives a workaround that is not
> helpfull for us:
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

Installation error an error occured during move data process: -145...?

hi all..

please any one help me in installing sql sp4 in my w2k server machine having sp4 and all the other updates.i tried installing sql sp3 and newly downloaded sql sp4 but shows an error at 97 % of installation that "an error occured during move data process: -145"

its really urgent ....please

thanxz in advance

Have you repeated the process?|||

thanxz bass for the reply..i installed sql server analysis service and installed the service packs..its now ok...Solved errors..thnk god

but i want to know more about the error..i googled it...nothing meaningful...

Installation Error

I have a SBS Premium with SQL Server 2000 SP3, I try to install Reporting
Services Std, and send a error "One does not find the point of entry of the
procedure abort in the DLL msvcr71.dll". Anybody can help me plz...
Thanks in advance,
GrgCan I Install Reporting on SBS Premium 2003?