I found the information of installing DTS service without installing SQL server on the disc:
INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)
------------------
The following files must be registered using the regsvr32.exe utility:
dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll
Example: regsvr32 80\Tools\Binn\dtsffile.dll
The sqlunirl.dll file should reside in the system folder (i.e., \winnt\system32 or \windows\system).
when I attempted to register the dlls, the message
:"loadLibrary("...\dtsffile.dll")failed - The speified module could not be
found.
is there anything I have to do before I can get the dll registered?
Thanks in advance.problem solved, please consult here:
http://www.sqldts.com/default.aspx?6,105,225,0,1
Showing posts with label installing. Show all posts
Showing posts with label installing. Show all posts
Thursday, March 29, 2012
Friday, March 23, 2012
Failed to deploy reports after installing Reporting Services SP1
Hi,
Before installing Reporting Services SP1, I can deploy and view reports.
Everything works fine. However, after I installed Reporting Services SP1, I
can not deploy all my reports to Report Servers. On the other hand, I can
preview the reports through Visual Studio .NET and it looks very normal.
Can anybody give me some suggestions?
Thanks a lot.
DavidHi,
The problem was fixed after re-installing enterprise version Reporting
Services and SP1.
"David" wrote:
> Hi,
> Before installing Reporting Services SP1, I can deploy and view reports.
> Everything works fine. However, after I installed Reporting Services SP1, I
> can not deploy all my reports to Report Servers. On the other hand, I can
> preview the reports through Visual Studio .NET and it looks very normal.
> Can anybody give me some suggestions?
> Thanks a lot.
> David
Before installing Reporting Services SP1, I can deploy and view reports.
Everything works fine. However, after I installed Reporting Services SP1, I
can not deploy all my reports to Report Servers. On the other hand, I can
preview the reports through Visual Studio .NET and it looks very normal.
Can anybody give me some suggestions?
Thanks a lot.
DavidHi,
The problem was fixed after re-installing enterprise version Reporting
Services and SP1.
"David" wrote:
> Hi,
> Before installing Reporting Services SP1, I can deploy and view reports.
> Everything works fine. However, after I installed Reporting Services SP1, I
> can not deploy all my reports to Report Servers. On the other hand, I can
> preview the reports through Visual Studio .NET and it looks very normal.
> Can anybody give me some suggestions?
> Thanks a lot.
> David
Monday, March 19, 2012
Failed Node Need to rebuild
I am having an issue with the primary node of our SQL 2005 x64 Cluster
(Windows2003EnterpriseEditionx64). After installing SP1 I am getting the
below error when the service tries to start.
So obviously I messed up something during the upgrade. So decided to write
this node off and try and reinstall SQL. Unfortunately it will not
uninstall because it can not see the quorum drive even though it really is
there. Obviously I can not move the group because the service is failed.
How can I for uninstall SQL to try and rebuild the node? Has anyone seen
this issue before? I would rather not rebuild the OS if possible. It is
only SQL that is failing the rest of the box it working great.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 11/22/2006
Time: 8:33:48 AM
User: N/A
Computer: SQL001A
Description:
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
Hi Tim,
I ran into a similar issue when working on SQL 20056 clusters in my lab. I
did find a link that was very useful when trying to uninstall a node manually.
Take a look at this one and let me know if it helps;
http://msdn2.microsoft.com/en-US/library/ms180973.aspx
Regards,
Sporter
"Tim Murray" wrote:
> I am having an issue with the primary node of our SQL 2005 x64 Cluster
> (Windows2003EnterpriseEditionx64). After installing SP1 I am getting the
> below error when the service tries to start.
> So obviously I messed up something during the upgrade. So decided to write
> this node off and try and reinstall SQL. Unfortunately it will not
> uninstall because it can not see the quorum drive even though it really is
> there. Obviously I can not move the group because the service is failed.
> How can I for uninstall SQL to try and rebuild the node? Has anyone seen
> this issue before? I would rather not rebuild the OS if possible. It is
> only SQL that is failing the rest of the box it working great.
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7024
> Date: 11/22/2006
> Time: 8:33:48 AM
> User: N/A
> Computer: SQL001A
> Description:
> The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 17058 (0x42A2).
>
>
(Windows2003EnterpriseEditionx64). After installing SP1 I am getting the
below error when the service tries to start.
So obviously I messed up something during the upgrade. So decided to write
this node off and try and reinstall SQL. Unfortunately it will not
uninstall because it can not see the quorum drive even though it really is
there. Obviously I can not move the group because the service is failed.
How can I for uninstall SQL to try and rebuild the node? Has anyone seen
this issue before? I would rather not rebuild the OS if possible. It is
only SQL that is failing the rest of the box it working great.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 11/22/2006
Time: 8:33:48 AM
User: N/A
Computer: SQL001A
Description:
The SQL Server (MSSQLSERVER) service terminated with service-specific error
17058 (0x42A2).
Hi Tim,
I ran into a similar issue when working on SQL 20056 clusters in my lab. I
did find a link that was very useful when trying to uninstall a node manually.
Take a look at this one and let me know if it helps;
http://msdn2.microsoft.com/en-US/library/ms180973.aspx
Regards,
Sporter
"Tim Murray" wrote:
> I am having an issue with the primary node of our SQL 2005 x64 Cluster
> (Windows2003EnterpriseEditionx64). After installing SP1 I am getting the
> below error when the service tries to start.
> So obviously I messed up something during the upgrade. So decided to write
> this node off and try and reinstall SQL. Unfortunately it will not
> uninstall because it can not see the quorum drive even though it really is
> there. Obviously I can not move the group because the service is failed.
> How can I for uninstall SQL to try and rebuild the node? Has anyone seen
> this issue before? I would rather not rebuild the OS if possible. It is
> only SQL that is failing the rest of the box it working great.
> Event Type: Error
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7024
> Date: 11/22/2006
> Time: 8:33:48 AM
> User: N/A
> Computer: SQL001A
> Description:
> The SQL Server (MSSQLSERVER) service terminated with service-specific error
> 17058 (0x42A2).
>
>
Failed MSDE installation - Feedback on posting by Jason Howell
Hi Jason, Hi all,
I have been having an error installing MSDE and discovered a thread in this
newsgroup, which appears to handle the same error.
Specifically, the post http://tinyurl.com/2vtzv by Jason Howell seemed
relevant.
Interestingly, setting BLANKSAPWD=1 did get the installation to complete,
but I was still not able to start the service. This did not really help me.
Now I believe that I have more information , which may be interesting to
others.
The problem appears to be related to the facts that,
- I have the SQL Server 2000 Enterprise Edition client tools installed on my
machine
- I have already installed and deinstalled an MSDE instance with the same
instance name (CS3DB).
I have managed to install a second instance of MSDE using a different
instance name (CS3DBTEST) and this works perfectly.
The problem is clearly related to the instance name CS3DB.
However, although I had unistalled the CS3DB instance, various entries were
left in the registry. These were:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
InstalledInstances=CS3DB CS3DBTEST
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set
InstanceComponentSet.1={E09B48B5-E141-427A-AB0C-D3605127224A}
InstanceComponentSet.2={689404D2-1C94-44B3-9203-BEC5594FDA7A}
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\CS3DB
...
which all indicate to me that the CS3DB instance had not been removed
properly, and that in some manner or other, there were still two versions
installed. However, the CS3DB instance no longer appeared in the Add/Remove
programs dialog in the control panel.
My suspision is, that is you have the SQL Server 2000 client tools installed
before you install MSDE, then you cannot cleanly remove the first instance
of MSDE.
I have now modified the registry, by:
removing CS3DB from
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\InstalledInstances
deleting
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set
InstanceComponentSet.1={E09B48B5-E141-427A-AB0C-D3605127224A}
deleting the related key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Uninstall\{E09B
48B5-E141-427A-AB0C-D3605127224A}
and deleting the key and subkeys
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\CS3DB
This seems to have down the trick.
I have now reinstalled the MSDE instance CS3DB and it seems to be working.
So again, my guess is that uninstalling MSDE in the presence of the SQL
client tools does not work properly.
Hope this helps somebody and any feedback would be appreciated.
Phil
Hi,
I have now repeated this, as follows:
- uninstall instance CS3DB
- try to reinstall - it fails
- remove registry entries as described before
- try to reinstall - it works.
Phil
|||"Phil Jollans" <nospam@.messring.de> wrote in message
news:2kg1ioF1qnrpU1@.uni-berlin.de...
> Hi,
> I have now repeated this, as follows:
> - uninstall instance CS3DB
> - try to reinstall - it fails
> - remove registry entries as described before
> - try to reinstall - it works.
> Phil
>
This may not be big news to others, but it's a valuable piece of information
to me, as we use MSDE in our labs and classrooms, and many of our students
use it at home in conjunction with Visual Studio .NET. (Next time I have a
student who is having MSDE trouble, I now have one more question/possible
solution to use).
Thanks very much for sharing! It's what makes these groups so valuable.
Peter [MVP Visual Developer]
Jack of all trades, master of none.
I have been having an error installing MSDE and discovered a thread in this
newsgroup, which appears to handle the same error.
Specifically, the post http://tinyurl.com/2vtzv by Jason Howell seemed
relevant.
Interestingly, setting BLANKSAPWD=1 did get the installation to complete,
but I was still not able to start the service. This did not really help me.
Now I believe that I have more information , which may be interesting to
others.
The problem appears to be related to the facts that,
- I have the SQL Server 2000 Enterprise Edition client tools installed on my
machine
- I have already installed and deinstalled an MSDE instance with the same
instance name (CS3DB).
I have managed to install a second instance of MSDE using a different
instance name (CS3DBTEST) and this works perfectly.
The problem is clearly related to the instance name CS3DB.
However, although I had unistalled the CS3DB instance, various entries were
left in the registry. These were:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
InstalledInstances=CS3DB CS3DBTEST
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set
InstanceComponentSet.1={E09B48B5-E141-427A-AB0C-D3605127224A}
InstanceComponentSet.2={689404D2-1C94-44B3-9203-BEC5594FDA7A}
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\CS3DB
...
which all indicate to me that the CS3DB instance had not been removed
properly, and that in some manner or other, there were still two versions
installed. However, the CS3DB instance no longer appeared in the Add/Remove
programs dialog in the control panel.
My suspision is, that is you have the SQL Server 2000 client tools installed
before you install MSDE, then you cannot cleanly remove the first instance
of MSDE.
I have now modified the registry, by:
removing CS3DB from
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\InstalledInstances
deleting
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set
InstanceComponentSet.1={E09B48B5-E141-427A-AB0C-D3605127224A}
deleting the related key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Uninstall\{E09B
48B5-E141-427A-AB0C-D3605127224A}
and deleting the key and subkeys
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\CS3DB
This seems to have down the trick.
I have now reinstalled the MSDE instance CS3DB and it seems to be working.
So again, my guess is that uninstalling MSDE in the presence of the SQL
client tools does not work properly.
Hope this helps somebody and any feedback would be appreciated.
Phil
Hi,
I have now repeated this, as follows:
- uninstall instance CS3DB
- try to reinstall - it fails
- remove registry entries as described before
- try to reinstall - it works.
Phil
|||"Phil Jollans" <nospam@.messring.de> wrote in message
news:2kg1ioF1qnrpU1@.uni-berlin.de...
> Hi,
> I have now repeated this, as follows:
> - uninstall instance CS3DB
> - try to reinstall - it fails
> - remove registry entries as described before
> - try to reinstall - it works.
> Phil
>
This may not be big news to others, but it's a valuable piece of information
to me, as we use MSDE in our labs and classrooms, and many of our students
use it at home in conjunction with Visual Studio .NET. (Next time I have a
student who is having MSDE trouble, I now have one more question/possible
solution to use).
Thanks very much for sharing! It's what makes these groups so valuable.
Peter [MVP Visual Developer]
Jack of all trades, master of none.
Failed install of SQL Server 2005 Developer Edition on Win XP Pro
I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation."
This is the bottom of the SQLSetup0001_<machine name>_SQL.log
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:33:07 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
MSI (s) (40!00) [14:40:59:034]: Product: Microsoft SQL Server 2005 -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:40:59 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
I'm at a complete loss, but I am sure the error is something about the configuration with this computer. I have fond a couple of posts on other web sites where people have similar errors, but no feedback on the error or even ideas on what to look at.
ANY recommendations would be helpful!!
Thank you,
Jay A. Moritz
I had the same error. Turns out my WMI repository is corrupted.
Run the following in a batch file to rebuild the repository and fix the problem:
net stop winmgmt
c:
cd %systemroot%\system32\wbem
rd /S /Q repository
regsvr32 /s %systemroot%\system32\scecli.dll
regsvr32 /s %systemroot%\system32\userenv.dll
mofcomp cimwin32.mof
mofcomp cimwin32.mfl
mofcomp rsop.mof
mofcomp rsop.mfl
for /f %%s in ('dir /b /s *.dll') do regsvr32 /s %%s
for /f %%s in ('dir /b *.mof') do mofcomp %%s
for /f %%s in ('dir /b *.mfl') do mofcomp %%s
echo DONE reboot
pause
Hello, I'm having hte same issue...
How do I run in a batch?....Does this mean something is wrong with my XP....If I installed a new version of XP, would this fix the problem?
|||This is most likely caused by a corruption in WMI in your Windows Server. Try reinstalling WMI. There's information on how to do this at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp
Thanks,
Samuel Lester (MSFT)
Strange, that page looks to be down now. Here is a WMI diagnosis tool you can also try:
http://www.microsoft.com/downloads/details.aspx?familyid=d7ba3cd6-18d1-4d05-b11e-4c64192ae97d&displaylang=en
Thanks,
Sam Lester (MSFT)
I received the same error.
Thanks !!! this was useful for me !
Emil
|||
Would like to thank you. This solution worked for me.
Thanks
|||The WMI Diagnostic utility provided only unhelpful information. The batch file provided above fixed the WMI problem and allowed the SQL Server 2005 installation to complete under Vista.
To run the text as a batch file, just copy and paste it into notepad, save it somewhere with a .bat extension, and then run it from a command (DOS) window
Failed install of SQL Server 2005 Developer Edition on Win XP Pro
I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation."
This is the bottom of the SQLSetup0001_<machine name>_SQL.log
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:33:07 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
MSI (s) (40!00) [14:40:59:034]: Product: Microsoft SQL Server 2005 -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:40:59 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
I'm at a complete loss, but I am sure the error is something about the configuration with this computer. I have fond a couple of posts on other web sites where people have similar errors, but no feedback on the error or even ideas on what to look at.
ANY recommendations would be helpful!!
Thank you,
Jay A. Moritz
I had the same error. Turns out my WMI repository is corrupted.
Run the following in a batch file to rebuild the repository and fix the problem:
net stop winmgmt
c:
cd %systemroot%\system32\wbem
rd /S /Q repository
regsvr32 /s %systemroot%\system32\scecli.dll
regsvr32 /s %systemroot%\system32\userenv.dll
mofcomp cimwin32.mof
mofcomp cimwin32.mfl
mofcomp rsop.mof
mofcomp rsop.mfl
for /f %%s in ('dir /b /s *.dll') do regsvr32 /s %%s
for /f %%s in ('dir /b *.mof') do mofcomp %%s
for /f %%s in ('dir /b *.mfl') do mofcomp %%s
echo DONE reboot
pause
Hello, I'm having hte same issue...
How do I run in a batch?....Does this mean something is wrong with my XP....If I installed a new version of XP, would this fix the problem?
|||This is most likely caused by a corruption in WMI in your Windows Server. Try reinstalling WMI. There's information on how to do this at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp
Thanks,
Samuel Lester (MSFT)
Strange, that page looks to be down now. Here is a WMI diagnosis tool you can also try:
http://www.microsoft.com/downloads/details.aspx?familyid=d7ba3cd6-18d1-4d05-b11e-4c64192ae97d&displaylang=en
Thanks,
Sam Lester (MSFT)
I received the same error.
Thanks !!! this was useful for me !
Emil
|||Would like to thank you. This solution worked for me.
Thanks
|||The WMI Diagnostic utility provided only unhelpful information. The batch file provided above fixed the WMI problem and allowed the SQL Server 2005 installation to complete under Vista.
To run the text as a batch file, just copy and paste it into notepad, save it somewhere with a .bat extension, and then run it from a command (DOS) window
Failed install of SQL Server 2005 Developer Edition on Win XP Pro
I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation."
This is the bottom of the SQLSetup0001_<machine name>_SQL.log
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:33:07 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
MSI (s) (40!00) [14:40:59:034]: Product: Microsoft SQL Server 2005 -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:40:59 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
I'm at a complete loss, but I am sure the error is something about the configuration with this computer. I have fond a couple of posts on other web sites where people have similar errors, but no feedback on the error or even ideas on what to look at.
ANY recommendations would be helpful!!
Thank you,
Jay A. Moritz
I had the same error. Turns out my WMI repository is corrupted.
Run the following in a batch file to rebuild the repository and fix the problem:
net stop winmgmt
c:
cd %systemroot%\system32\wbem
rd /S /Q repository
regsvr32 /s %systemroot%\system32\scecli.dll
regsvr32 /s %systemroot%\system32\userenv.dll
mofcomp cimwin32.mof
mofcomp cimwin32.mfl
mofcomp rsop.mof
mofcomp rsop.mfl
for /f %%s in ('dir /b /s *.dll') do regsvr32 /s %%s
for /f %%s in ('dir /b *.mof') do mofcomp %%s
for /f %%s in ('dir /b *.mfl') do mofcomp %%s
echo DONE reboot
pause
Hello, I'm having hte same issue...
How do I run in a batch?....Does this mean something is wrong with my XP....If I installed a new version of XP, would this fix the problem?
|||This is most likely caused by a corruption in WMI in your Windows Server. Try reinstalling WMI. There's information on how to do this at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp
Thanks,
Samuel Lester (MSFT)
Strange, that page looks to be down now. Here is a WMI diagnosis tool you can also try:
http://www.microsoft.com/downloads/details.aspx?familyid=d7ba3cd6-18d1-4d05-b11e-4c64192ae97d&displaylang=en
Thanks,
Sam Lester (MSFT)
I received the same error.
Thanks !!! this was useful for me !
Emil
|||Would like to thank you. This solution worked for me.
Thanks
|||The WMI Diagnostic utility provided only unhelpful information. The batch file provided above fixed the WMI problem and allowed the SQL Server 2005 installation to complete under Vista.
To run the text as a batch file, just copy and paste it into notepad, save it somewhere with a .bat extension, and then run it from a command (DOS) window
Failed install of SQL Server 2005 Developer Edition on Win XP Pro
I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation."
This is the bottom of the SQLSetup0001_<machine name>_SQL.log
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:33:07 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
MSI (s) (40!00) [14:40:59:034]: Product: Microsoft SQL Server 2005 -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:40:59 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
I'm at a complete loss, but I am sure the error is something about the configuration with this computer. I have fond a couple of posts on other web sites where people have similar errors, but no feedback on the error or even ideas on what to look at.
ANY recommendations would be helpful!!
Thank you,
Jay A. Moritz
I had the same error. Turns out my WMI repository is corrupted.
Run the following in a batch file to rebuild the repository and fix the problem:
net stop winmgmt
c:
cd %systemroot%\system32\wbem
rd /S /Q repository
regsvr32 /s %systemroot%\system32\scecli.dll
regsvr32 /s %systemroot%\system32\userenv.dll
mofcomp cimwin32.mof
mofcomp cimwin32.mfl
mofcomp rsop.mof
mofcomp rsop.mfl
for /f %%s in ('dir /b /s *.dll') do regsvr32 /s %%s
for /f %%s in ('dir /b *.mof') do mofcomp %%s
for /f %%s in ('dir /b *.mfl') do mofcomp %%s
echo DONE reboot
pause
Hello, I'm having hte same issue...
How do I run in a batch?....Does this mean something is wrong with my XP....If I installed a new version of XP, would this fix the problem?
|||This is most likely caused by a corruption in WMI in your Windows Server. Try reinstalling WMI. There's information on how to do this at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp
Thanks,
Samuel Lester (MSFT)
Strange, that page looks to be down now. Here is a WMI diagnosis tool you can also try:
http://www.microsoft.com/downloads/details.aspx?familyid=d7ba3cd6-18d1-4d05-b11e-4c64192ae97d&displaylang=en
Thanks,
Sam Lester (MSFT)
I received the same error.
Thanks !!! this was useful for me !
Emil
|||
Would like to thank you. This solution worked for me.
Thanks
|||The WMI Diagnostic utility provided only unhelpful information. The batch file provided above fixed the WMI problem and allowed the SQL Server 2005 installation to complete under Vista.
To run the text as a batch file, just copy and paste it into notepad, save it somewhere with a .bat extension, and then run it from a command (DOS) window
Failed install of SQL Server 2005 Developer Edition on Win XP Pro
I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation."
This is the bottom of the SQLSetup0001_<machine name>_SQL.log
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:33:07 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
MSI (s) (40!00) [14:40:59:034]: Product: Microsoft SQL Server 2005 -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:40:59 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
I'm at a complete loss, but I am sure the error is something about the configuration with this computer. I have fond a couple of posts on other web sites where people have similar errors, but no feedback on the error or even ideas on what to look at.
ANY recommendations would be helpful!!
Thank you,
Jay A. Moritz
I had the same error. Turns out my WMI repository is corrupted.
Run the following in a batch file to rebuild the repository and fix the problem:
net stop winmgmt
c:
cd %systemroot%\system32\wbem
rd /S /Q repository
regsvr32 /s %systemroot%\system32\scecli.dll
regsvr32 /s %systemroot%\system32\userenv.dll
mofcomp cimwin32.mof
mofcomp cimwin32.mfl
mofcomp rsop.mof
mofcomp rsop.mfl
for /f %%s in ('dir /b /s *.dll') do regsvr32 /s %%s
for /f %%s in ('dir /b *.mof') do mofcomp %%s
for /f %%s in ('dir /b *.mfl') do mofcomp %%s
echo DONE reboot
pause
Hello, I'm having hte same issue...
How do I run in a batch?....Does this mean something is wrong with my XP....If I installed a new version of XP, would this fix the problem?
|||This is most likely caused by a corruption in WMI in your Windows Server. Try reinstalling WMI. There's information on how to do this at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp
Thanks,
Samuel Lester (MSFT)
Strange, that page looks to be down now. Here is a WMI diagnosis tool you can also try:
http://www.microsoft.com/downloads/details.aspx?familyid=d7ba3cd6-18d1-4d05-b11e-4c64192ae97d&displaylang=en
Thanks,
Sam Lester (MSFT)
I received the same error.
Thanks !!! this was useful for me !
Emil
|||
Would like to thank you. This solution worked for me.
Thanks
|||The WMI Diagnostic utility provided only unhelpful information. The batch file provided above fixed the WMI problem and allowed the SQL Server 2005 installation to complete under Vista.
To run the text as a batch file, just copy and paste it into notepad, save it somewhere with a .bat extension, and then run it from a command (DOS) window
Failed install of SQL Server 2005 Developer Edition on Win XP Pro
I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation."
This is the bottom of the SQLSetup0001_<machine name>_SQL.log
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:33:07 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
MSI (s) (40!00) [14:40:59:034]: Product: Microsoft SQL Server 2005 -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:40:59 2006
<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text:Source File Name: sqlca\sqlmofca.cpp
Compiler Timestamp: Tue Aug9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
I'm at a complete loss, but I am sure the error is something about the configuration with this computer. I have fond a couple of posts on other web sites where people have similar errors, but no feedback on the error or even ideas on what to look at.
ANY recommendations would be helpful!!
Thank you,
Jay A. Moritz
I had the same error. Turns out my WMI repository is corrupted.
Run the following in a batch file to rebuild the repository and fix the problem:
net stop winmgmt
c:
cd %systemroot%\system32\wbem
rd /S /Q repository
regsvr32 /s %systemroot%\system32\scecli.dll
regsvr32 /s %systemroot%\system32\userenv.dll
mofcomp cimwin32.mof
mofcomp cimwin32.mfl
mofcomp rsop.mof
mofcomp rsop.mfl
for /f %%s in ('dir /b /s *.dll') do regsvr32 /s %%s
for /f %%s in ('dir /b *.mof') do mofcomp %%s
for /f %%s in ('dir /b *.mfl') do mofcomp %%s
echo DONE reboot
pause
Hello, I'm having hte same issue...
How do I run in a batch?....Does this mean something is wrong with my XP....If I installed a new version of XP, would this fix the problem?
|||This is most likely caused by a corruption in WMI in your Windows Server. Try reinstalling WMI. There's information on how to do this at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp
Thanks,
Samuel Lester (MSFT)
Strange, that page looks to be down now. Here is a WMI diagnosis tool you can also try:
http://www.microsoft.com/downloads/details.aspx?familyid=d7ba3cd6-18d1-4d05-b11e-4c64192ae97d&displaylang=en
Thanks,
Sam Lester (MSFT)
I received the same error.
Thanks !!! this was useful for me !
Emil
|||Would like to thank you. This solution worked for me.
Thanks
|||The WMI Diagnostic utility provided only unhelpful information. The batch file provided above fixed the WMI problem and allowed the SQL Server 2005 installation to complete under Vista.
To run the text as a batch file, just copy and paste it into notepad, save it somewhere with a .bat extension, and then run it from a command (DOS) window
Friday, March 9, 2012
fail to installation of MDAC on SQL Server install
this log message occour when installation of microsoft
SqlServer 2k:
11:25:20 Setup is installing Microsoft Data Access
Components (MDAC) ...
11:25:20 E:\SQL Server 2000\x86
\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
11:27:23 ExitCode: -1
11:27:37 Installation of the Microsoft Data Access
Components package failed. (-1)
11:27:37 ConnectivityLocked returned: 0
what can i do to repair this problem?
If you update MDAC to the most recent version manually, SQL Server can skip
that step. MDAC 2.8 can be retrieved from:
http://msdn.microsoft.com/data/downl...#MDACDownloads
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Renato Cabelino" <renatocabelino@.yahoo.com> wrote in message
news:1bdf201c42165$2d0803d0$a301280a@.phx.gbl...
> this log message occour when installation of microsoft
> SqlServer 2k:
> 11:25:20 Setup is installing Microsoft Data Access
> Components (MDAC) ...
> 11:25:20 E:\SQL Server 2000\x86
> \Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
> 11:27:23 ExitCode: -1
> 11:27:37 Installation of the Microsoft Data Access
> Components package failed. (-1)
> 11:27:37 ConnectivityLocked returned: 0
> what can i do to repair this problem?
SqlServer 2k:
11:25:20 Setup is installing Microsoft Data Access
Components (MDAC) ...
11:25:20 E:\SQL Server 2000\x86
\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
11:27:23 ExitCode: -1
11:27:37 Installation of the Microsoft Data Access
Components package failed. (-1)
11:27:37 ConnectivityLocked returned: 0
what can i do to repair this problem?
If you update MDAC to the most recent version manually, SQL Server can skip
that step. MDAC 2.8 can be retrieved from:
http://msdn.microsoft.com/data/downl...#MDACDownloads
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Renato Cabelino" <renatocabelino@.yahoo.com> wrote in message
news:1bdf201c42165$2d0803d0$a301280a@.phx.gbl...
> this log message occour when installation of microsoft
> SqlServer 2k:
> 11:25:20 Setup is installing Microsoft Data Access
> Components (MDAC) ...
> 11:25:20 E:\SQL Server 2000\x86
> \Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
> 11:27:23 ExitCode: -1
> 11:27:37 Installation of the Microsoft Data Access
> Components package failed. (-1)
> 11:27:37 ConnectivityLocked returned: 0
> what can i do to repair this problem?
fail to installation of MDAC on SQL Server install
this log message occour when installation of microsoft
SqlServer 2k:
11:25:20 Setup is installing Microsoft Data Access
Components (MDAC) ...
11:25:20 E:\SQL Server 2000\x86
\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
11:27:23 ExitCode: -1
11:27:37 Installation of the Microsoft Data Access
Components package failed. (-1)
11:27:37 ConnectivityLocked returned: 0
what can i do to repair this problem?If you update MDAC to the most recent version manually, SQL Server can skip
that step. MDAC 2.8 can be retrieved from:
http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Renato Cabelino" <renatocabelino@.yahoo.com> wrote in message
news:1bdf201c42165$2d0803d0$a301280a@.phx.gbl...
> this log message occour when installation of microsoft
> SqlServer 2k:
> 11:25:20 Setup is installing Microsoft Data Access
> Components (MDAC) ...
> 11:25:20 E:\SQL Server 2000\x86
> \Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
> 11:27:23 ExitCode: -1
> 11:27:37 Installation of the Microsoft Data Access
> Components package failed. (-1)
> 11:27:37 ConnectivityLocked returned: 0
> what can i do to repair this problem?
SqlServer 2k:
11:25:20 Setup is installing Microsoft Data Access
Components (MDAC) ...
11:25:20 E:\SQL Server 2000\x86
\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
11:27:23 ExitCode: -1
11:27:37 Installation of the Microsoft Data Access
Components package failed. (-1)
11:27:37 ConnectivityLocked returned: 0
what can i do to repair this problem?If you update MDAC to the most recent version manually, SQL Server can skip
that step. MDAC 2.8 can be retrieved from:
http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Renato Cabelino" <renatocabelino@.yahoo.com> wrote in message
news:1bdf201c42165$2d0803d0$a301280a@.phx.gbl...
> this log message occour when installation of microsoft
> SqlServer 2k:
> 11:25:20 Setup is installing Microsoft Data Access
> Components (MDAC) ...
> 11:25:20 E:\SQL Server 2000\x86
> \Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
> 11:27:23 ExitCode: -1
> 11:27:37 Installation of the Microsoft Data Access
> Components package failed. (-1)
> 11:27:37 ConnectivityLocked returned: 0
> what can i do to repair this problem?
fail to installation of MDAC on SQL Server install
this log message occour when installation of microsoft
SqlServer 2k:
11:25:20 Setup is installing Microsoft Data Access
Components (MDAC) ...
11:25:20 E:\SQL Server 2000\x86
\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
11:27:23 ExitCode: -1
11:27:37 Installation of the Microsoft Data Access
Components package failed. (-1)
11:27:37 ConnectivityLocked returned: 0
what can i do to repair this problem?If you update MDAC to the most recent version manually, SQL Server can skip
that step. MDAC 2.8 can be retrieved from:
http://msdn.microsoft.com/data/down...x#MDACDownloads
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Renato Cabelino" <renatocabelino@.yahoo.com> wrote in message
news:1bdf201c42165$2d0803d0$a301280a@.phx
.gbl...
> this log message occour when installation of microsoft
> SqlServer 2k:
> 11:25:20 Setup is installing Microsoft Data Access
> Components (MDAC) ...
> 11:25:20 E:\SQL Server 2000\x86
> \Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
> 11:27:23 ExitCode: -1
> 11:27:37 Installation of the Microsoft Data Access
> Components package failed. (-1)
> 11:27:37 ConnectivityLocked returned: 0
> what can i do to repair this problem?
SqlServer 2k:
11:25:20 Setup is installing Microsoft Data Access
Components (MDAC) ...
11:25:20 E:\SQL Server 2000\x86
\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
11:27:23 ExitCode: -1
11:27:37 Installation of the Microsoft Data Access
Components package failed. (-1)
11:27:37 ConnectivityLocked returned: 0
what can i do to repair this problem?If you update MDAC to the most recent version manually, SQL Server can skip
that step. MDAC 2.8 can be retrieved from:
http://msdn.microsoft.com/data/down...x#MDACDownloads
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Renato Cabelino" <renatocabelino@.yahoo.com> wrote in message
news:1bdf201c42165$2d0803d0$a301280a@.phx
.gbl...
> this log message occour when installation of microsoft
> SqlServer 2k:
> 11:25:20 Setup is installing Microsoft Data Access
> Components (MDAC) ...
> 11:25:20 E:\SQL Server 2000\x86
> \Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
> 11:27:23 ExitCode: -1
> 11:27:37 Installation of the Microsoft Data Access
> Components package failed. (-1)
> 11:27:37 ConnectivityLocked returned: 0
> what can i do to repair this problem?
Fail to install RS 2k on windows 2k3 with IIS configuration error
***Environment:
Windows 2003 Standard, IIS 6.0, SQL Server 2000
***Error:
When installing, warning message appears as:
"IIS is either not installed or not configurated for a server component
installation"
After the installation is finished by ignoreing the preceding warning, no
virtual dir is crated for RS to run.
***My idea:
After reading the setup document, I find out that:
"If you are using IIS 6.x, Setup uses the default application pool. If the
default Web site or application pool is not available, Setup will continue,
but your installation will not work once Setup is finished." That might be
the major cause of the problem...
***My problem:
Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
6.0. The only thing is that RS can not recognize it...
Is there anybody could give some advice? Thanks in advance!!!i found this once when i hadnt got aspnet reg'd for iis
i went to
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
i then went into start > programs > sql server 2005 > reporting
services configuration
and you can get it to have another go at creating the websites (an
option on the left). this worked for me.
db
--
http://www.osix.net
the open source institute
home of the geek programming challenges
CrazyCalculator wrote:
> ***Environment:
> Windows 2003 Standard, IIS 6.0, SQL Server 2000
> ***Error:
> When installing, warning message appears as:
> "IIS is either not installed or not configurated for a server component
> installation"
> After the installation is finished by ignoreing the preceding warning, no
> virtual dir is crated for RS to run.
> ***My idea:
> After reading the setup document, I find out that:
> "If you are using IIS 6.x, Setup uses the default application pool. If the
> default Web site or application pool is not available, Setup will continue,
> but your installation will not work once Setup is finished." That might be
> the major cause of the problem...
> ***My problem:
> Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
> 6.0. The only thing is that RS can not recognize it...
> Is there anybody could give some advice? Thanks in advance!!!|||Thank bb for your suggestion :)
However, I am install Reporting services 2000 on SQL Server 2000 and my
ASP.NET 1.1 seems to be perfectly registed...|||then sorry friend, cant really help as ive not tried with 2000
tell your techies to get update with the latest stuff!
good luck
db
CrazyCalculator wrote:
> Thank bb for your suggestion :)
> However, I am install Reporting services 2000 on SQL Server 2000 and my
> ASP.NET 1.1 seems to be perfectly registed...|||At last, with the inspiration of the goddess in my dream, I solve the evil
problem...
(1) Cause
SQL Server 2000 Need the "Default Web Site" as one of its installation
prerequisite. When I say "Default Web Site", I mean the Site with the
identifier 1. You can view the indentifier once you click "Web Sites" in your
IIS Manager.
(2) Why I fail
Really simple, I deleted the "Default Web Site" long time ago. The install
program can not find one Web Site with identifier 1, so it fails.
(3) How to do
Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
Kit Tools, with Metabase Explorer", Download it from
http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
(4) And there is a document to help you
"http://www.gafvert.info/notes/IISDefaultWebsite.htm"
Hope you lucky.|||Hi, I have the same problem, it is just that I have a nr 1 and when I tried
to change I got the erroe that I didn´t have IIS installed, prior to this I
"only" have the error that I dont have asp.net installed or configured,
despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
I have tried to switch between both, but the result is the same error, any
ideas?
DQ
"CrazyCalculator" wrote:
> At last, with the inspiration of the goddess in my dream, I solve the evil
> problem...
> (1) Cause
> SQL Server 2000 Need the "Default Web Site" as one of its installation
> prerequisite. When I say "Default Web Site", I mean the Site with the
> identifier 1. You can view the indentifier once you click "Web Sites" in your
> IIS Manager.
> (2) Why I fail
> Really simple, I deleted the "Default Web Site" long time ago. The install
> program can not find one Web Site with identifier 1, so it fails.
> (3) How to do
> Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> Kit Tools, with Metabase Explorer", Download it from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> (4) And there is a document to help you
> "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
>
> Hope you lucky.|||SOLUTION that helped me!!
FIX: Error "ASP.NET v1.1 not Installed" while installing Sql Server 2000
Reporting Services
I finally had the chance to rebuild my dev machine with the RTM version of
Sql Server 200 Reporting Services [SQL2kRS] and ran into an unusual error.
During the "Check Prerequisites" stage of installation, it said that I didnt
have ASP.NET v1.1 installed on my PC. Considering that I do web-development
with VS.NET 2003 on this PC I was a bit perplexed why it said that.
After much digging and exploring, I finally discovered the problem. A
recent install of the new XP version of the Longhorn Command Shell had
installed the .NET Framework v2.0.31113.33 and set it as the Root Version of
the framework for ASP.NET.
So, the fix is pretty trivial, just update the RootVer registry value to
correctly (or temporarily) show v1.1.4322.573.
[\\HKLM\SOFTWARE\Microsoft\ASP.NET\RootVer] = "1.1.4322.573"
Strangely enough, this didnt seem to be affecting my ASP.NET applications.
*shrug*
None of this was documented in the verbose Help files that shipped with
SQL2kRS. This got me thinking about the nature of help files. Far too
often, I see FAQ's and "Common Issues" under the Troubleshooting section of
help files, yet rarely do I have those "common" problems.
I would much prefer a generic section on, "How to troubleshoot", "Where to
look for error clues", and provide deep lists of "Why an application or
installation might fail".
In this case, I actually did find a good reference in the Help entitled "Log
Files Used During Installation". This section explained how to locate the
log files created during installation, and this is how I eventually solved
the problem.
For reference, in SQL2kRS there are 3 main places to look for log files;
C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log\RSStp_.cab
(inside the CAB)
AND
%temp%\rsstp<integer>.log
(<integer> = number to make filename unique. e.g. rsstp2.log)
AND
%temp%\RSMSI<integer>.log
The latter 2 log files are the same ones that get copied into the CAB file
listed above, but its still useful knowledge in case something fails before
they get added to the CAB.
"DQ" wrote:
> Hi, I have the same problem, it is just that I have a nr 1 and when I tried
> to change I got the erroe that I didn´t have IIS installed, prior to this I
> "only" have the error that I dont have asp.net installed or configured,
> despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
> I have tried to switch between both, but the result is the same error, any
> ideas?
> DQ
> "CrazyCalculator" wrote:
> > At last, with the inspiration of the goddess in my dream, I solve the evil
> > problem...
> >
> > (1) Cause
> > SQL Server 2000 Need the "Default Web Site" as one of its installation
> > prerequisite. When I say "Default Web Site", I mean the Site with the
> > identifier 1. You can view the indentifier once you click "Web Sites" in your
> > IIS Manager.
> >
> > (2) Why I fail
> > Really simple, I deleted the "Default Web Site" long time ago. The install
> > program can not find one Web Site with identifier 1, so it fails.
> >
> > (3) How to do
> > Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> > Kit Tools, with Metabase Explorer", Download it from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> >
> > (4) And there is a document to help you
> > "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
> >
> >
> > Hope you lucky.
Windows 2003 Standard, IIS 6.0, SQL Server 2000
***Error:
When installing, warning message appears as:
"IIS is either not installed or not configurated for a server component
installation"
After the installation is finished by ignoreing the preceding warning, no
virtual dir is crated for RS to run.
***My idea:
After reading the setup document, I find out that:
"If you are using IIS 6.x, Setup uses the default application pool. If the
default Web site or application pool is not available, Setup will continue,
but your installation will not work once Setup is finished." That might be
the major cause of the problem...
***My problem:
Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
6.0. The only thing is that RS can not recognize it...
Is there anybody could give some advice? Thanks in advance!!!i found this once when i hadnt got aspnet reg'd for iis
i went to
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
i then went into start > programs > sql server 2005 > reporting
services configuration
and you can get it to have another go at creating the websites (an
option on the left). this worked for me.
db
--
http://www.osix.net
the open source institute
home of the geek programming challenges
CrazyCalculator wrote:
> ***Environment:
> Windows 2003 Standard, IIS 6.0, SQL Server 2000
> ***Error:
> When installing, warning message appears as:
> "IIS is either not installed or not configurated for a server component
> installation"
> After the installation is finished by ignoreing the preceding warning, no
> virtual dir is crated for RS to run.
> ***My idea:
> After reading the setup document, I find out that:
> "If you are using IIS 6.x, Setup uses the default application pool. If the
> default Web site or application pool is not available, Setup will continue,
> but your installation will not work once Setup is finished." That might be
> the major cause of the problem...
> ***My problem:
> Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
> 6.0. The only thing is that RS can not recognize it...
> Is there anybody could give some advice? Thanks in advance!!!|||Thank bb for your suggestion :)
However, I am install Reporting services 2000 on SQL Server 2000 and my
ASP.NET 1.1 seems to be perfectly registed...|||then sorry friend, cant really help as ive not tried with 2000
tell your techies to get update with the latest stuff!
good luck
db
CrazyCalculator wrote:
> Thank bb for your suggestion :)
> However, I am install Reporting services 2000 on SQL Server 2000 and my
> ASP.NET 1.1 seems to be perfectly registed...|||At last, with the inspiration of the goddess in my dream, I solve the evil
problem...
(1) Cause
SQL Server 2000 Need the "Default Web Site" as one of its installation
prerequisite. When I say "Default Web Site", I mean the Site with the
identifier 1. You can view the indentifier once you click "Web Sites" in your
IIS Manager.
(2) Why I fail
Really simple, I deleted the "Default Web Site" long time ago. The install
program can not find one Web Site with identifier 1, so it fails.
(3) How to do
Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
Kit Tools, with Metabase Explorer", Download it from
http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
(4) And there is a document to help you
"http://www.gafvert.info/notes/IISDefaultWebsite.htm"
Hope you lucky.|||Hi, I have the same problem, it is just that I have a nr 1 and when I tried
to change I got the erroe that I didn´t have IIS installed, prior to this I
"only" have the error that I dont have asp.net installed or configured,
despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
I have tried to switch between both, but the result is the same error, any
ideas?
DQ
"CrazyCalculator" wrote:
> At last, with the inspiration of the goddess in my dream, I solve the evil
> problem...
> (1) Cause
> SQL Server 2000 Need the "Default Web Site" as one of its installation
> prerequisite. When I say "Default Web Site", I mean the Site with the
> identifier 1. You can view the indentifier once you click "Web Sites" in your
> IIS Manager.
> (2) Why I fail
> Really simple, I deleted the "Default Web Site" long time ago. The install
> program can not find one Web Site with identifier 1, so it fails.
> (3) How to do
> Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> Kit Tools, with Metabase Explorer", Download it from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> (4) And there is a document to help you
> "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
>
> Hope you lucky.|||SOLUTION that helped me!!
FIX: Error "ASP.NET v1.1 not Installed" while installing Sql Server 2000
Reporting Services
I finally had the chance to rebuild my dev machine with the RTM version of
Sql Server 200 Reporting Services [SQL2kRS] and ran into an unusual error.
During the "Check Prerequisites" stage of installation, it said that I didnt
have ASP.NET v1.1 installed on my PC. Considering that I do web-development
with VS.NET 2003 on this PC I was a bit perplexed why it said that.
After much digging and exploring, I finally discovered the problem. A
recent install of the new XP version of the Longhorn Command Shell had
installed the .NET Framework v2.0.31113.33 and set it as the Root Version of
the framework for ASP.NET.
So, the fix is pretty trivial, just update the RootVer registry value to
correctly (or temporarily) show v1.1.4322.573.
[\\HKLM\SOFTWARE\Microsoft\ASP.NET\RootVer] = "1.1.4322.573"
Strangely enough, this didnt seem to be affecting my ASP.NET applications.
*shrug*
None of this was documented in the verbose Help files that shipped with
SQL2kRS. This got me thinking about the nature of help files. Far too
often, I see FAQ's and "Common Issues" under the Troubleshooting section of
help files, yet rarely do I have those "common" problems.
I would much prefer a generic section on, "How to troubleshoot", "Where to
look for error clues", and provide deep lists of "Why an application or
installation might fail".
In this case, I actually did find a good reference in the Help entitled "Log
Files Used During Installation". This section explained how to locate the
log files created during installation, and this is how I eventually solved
the problem.
For reference, in SQL2kRS there are 3 main places to look for log files;
C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log\RSStp_.cab
(inside the CAB)
AND
%temp%\rsstp<integer>.log
(<integer> = number to make filename unique. e.g. rsstp2.log)
AND
%temp%\RSMSI<integer>.log
The latter 2 log files are the same ones that get copied into the CAB file
listed above, but its still useful knowledge in case something fails before
they get added to the CAB.
"DQ" wrote:
> Hi, I have the same problem, it is just that I have a nr 1 and when I tried
> to change I got the erroe that I didn´t have IIS installed, prior to this I
> "only" have the error that I dont have asp.net installed or configured,
> despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
> I have tried to switch between both, but the result is the same error, any
> ideas?
> DQ
> "CrazyCalculator" wrote:
> > At last, with the inspiration of the goddess in my dream, I solve the evil
> > problem...
> >
> > (1) Cause
> > SQL Server 2000 Need the "Default Web Site" as one of its installation
> > prerequisite. When I say "Default Web Site", I mean the Site with the
> > identifier 1. You can view the indentifier once you click "Web Sites" in your
> > IIS Manager.
> >
> > (2) Why I fail
> > Really simple, I deleted the "Default Web Site" long time ago. The install
> > program can not find one Web Site with identifier 1, so it fails.
> >
> > (3) How to do
> > Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> > Kit Tools, with Metabase Explorer", Download it from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> >
> > (4) And there is a document to help you
> > "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
> >
> >
> > Hope you lucky.
Subscribe to:
Posts (Atom)