Cannot install SQL 2000 Reporting Services on W2K3 server

Hi ALL,
I want to install SQL 2000 Reporting Services Component on a Windows Server
2003 with SP1 box. While I ran the SQL 2000 setup.exe, it prompted the error
message 'System Check Results --> ASP.NET is not installed or is not
registered with your Web Server". However, I'd checked the Web service
extensions and 'Active Server Pages', 'ASP.NET v1.1.4322' and 'ASP.NET
v2.0.50727' had been allowed. Do anyone have the same problem? Can I install
the Reporting Services Database on the SQL 2000 cluster?
TIA.Hi, I have the same problem, 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? Have you got a solution yet?
DQ
"M C" wrote:
> Hi ALL,
> I want to install SQL 2000 Reporting Services Component on a Windows Server
> 2003 with SP1 box. While I ran the SQL 2000 setup.exe, it prompted the error
> message 'System Check Results --> ASP.NET is not installed or is not
> registered with your Web Server". However, I'd checked the Web service
> extensions and 'Active Server Pages', 'ASP.NET v1.1.4322' and 'ASP.NET
> v2.0.50727' had been allowed. Do anyone have the same problem? Can I install
> the Reporting Services Database on the SQL 2000 cluster?
> TIA.
>
>|||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, 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? Have you got a solution yet?
> DQ
>
> "M C" wrote:
> > Hi ALL,
> >
> > I want to install SQL 2000 Reporting Services Component on a Windows Server
> > 2003 with SP1 box. While I ran the SQL 2000 setup.exe, it prompted the error
> > message 'System Check Results --> ASP.NET is not installed or is not
> > registered with your Web Server". However, I'd checked the Web service
> > extensions and 'Active Server Pages', 'ASP.NET v1.1.4322' and 'ASP.NET
> > v2.0.50727' had been allowed. Do anyone have the same problem? Can I install
> > the Reporting Services Database on the SQL 2000 cluster?
> >
> > TIA.
> >
> >
> >

Cannot install SQL 2000

When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
programme installation left pending files please restart. I already restarted
five times but it still doesn't work. Anybody got a clue why it's happening?Perhaps this applies?
http://support.microsoft.com/kb/312995/en-us
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"lc_craze" <lccraze@.discussions.microsoft.com> wrote in message
news:A2A80F8D-70FF-4A18-A49A-EBC3EAE6B02D@.microsoft.com...
> When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
> programme installation left pending files please restart. I already restarted
> five times but it still doesn't work. Anybody got a clue why it's happening?|||Hi
I think there are still some registry entries remaining in the Registry of
the system. Delete the entries for SQL Server.
1) go to 'START -> RUN'
2) type 'regedit' and run it.
3) go to 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\' folder.
4) delet the folder 'Microsoft SQL Server' in it.
CAUTION: backup your registry before doing any changes to it else you'll end
up with all haywire.
After deleting that folder, reboot once and then try installing SQL again.
Hope this helps :-)
Regards
Amer M J
MCP
"lc_craze" wrote:
> When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
> programme installation left pending files please restart. I already restarted
> five times but it still doesn't work. Anybody got a clue why it's happening?

Cannot install SQL 2000

When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
programme installation left pending files please restart. I already restarted
five times but it still doesn't work. Anybody got a clue why it's happening?
Perhaps this applies?
http://support.microsoft.com/kb/312995/en-us
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"lc_craze" <lccraze@.discussions.microsoft.com> wrote in message
news:A2A80F8D-70FF-4A18-A49A-EBC3EAE6B02D@.microsoft.com...
> When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
> programme installation left pending files please restart. I already restarted
> five times but it still doesn't work. Anybody got a clue why it's happening?
|||Hi
I think there are still some registry entries remaining in the Registry of
the system. Delete the entries for SQL Server.
1) go to 'START -> RUN'
2) type 'regedit' and run it.
3) go to 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\' folder.
4) delet the folder 'Microsoft SQL Server' in it.
CAUTION: backup your registry before doing any changes to it else you'll end
up with all haywire.
After deleting that folder, reboot once and then try installing SQL again.
Hope this helps :-)
Regards
Amer M J
MCP
"lc_craze" wrote:

> When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
> programme installation left pending files please restart. I already restarted
> five times but it still doesn't work. Anybody got a clue why it's happening?

Cannot install SQL 2000

When I try to install SQL 2000 on my pc Windows XP sp 2 I get previous
programme installation left pending files please restart. I already restarte
d
five times but it still doesn't work. Anybody got a clue why it's happening?Perhaps this applies?
http://support.microsoft.com/kb/312995/en-us
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"lc_craze" <lccraze@.discussions.microsoft.com> wrote in message
news:A2A80F8D-70FF-4A18-A49A-EBC3EAE6B02D@.microsoft.com...[vbcol=seagreen]
> When I try to install SQL 2000 on my pc Windows XP sp 2 I get previous
> programme installation left pending files please restart. I already restar
ted
> five times but it still doesn't work. Anybody got a clue why it's happening?[/vbco
l]|||Hi
I think there are still some registry entries remaining in the Registry of
the system. Delete the entries for SQL Server.
1) go to 'START -> RUN'
2) type 'regedit' and run it.
3) go to 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft'
folder.
4) delet the folder 'Microsoft SQL Server' in it.
CAUTION: backup your registry before doing any changes to it else you'll end
up with all haywire.
After deleting that folder, reboot once and then try installing SQL again.
Hope this helps :-)
Regards
Amer M J
MCP
"lc_craze" wrote:
[vbcol=seagreen]
> When I try to install SQL 2000 on my pc Windows XP sp 2 I get previous
> programme installation left pending files please restart. I already restar
ted
> five times but it still doesn't work. Anybody got a clue why it's happening?[/vbco
l]

Cannot Install SP4 for SQL Server 2000

I am trying to install SP4 for SQL Server 2000.
When I click on the setup.bat, I get the message:
Setup Initialization Error
Access is denied
Source: 'C\SQL2kSP4\x86\setup\saqlsore.ini'
Target: 'C:\Document~1\dave\locals~1\temp\setupsql.ini'
I am installing the standard version of SQL Server on to Windows XP with
latest service packs.
According to the SP instructions, I set Local Security Policy | Local
Policies | Security Options to Silently Succeed for Devices: Unsigned
driver installation behavior.
I even gave "everyone" full control to C:\Documents and Settings\dave\Local
Settings\Temp
Still I get this error.
Does anyone have an ideas what I can do to avoid this error?
Hello Dave,
I understand that you encountered error message "Setup Initialization Error
Access is denied" when installing SQL 2000 SP4. Please let me know if it's
not correct.
Based on my experience, the problem is the setupsql.ini file already exist
in that default folder C:\Document~1\dave\locals~1\temp\. You may want to
remove the file from that folder and try to run setup again.
If above method do not work, please try to log on as a different user with
local admin rights to try to install SP4.
If the issue persists, you may want to remove the folder C:\SQL2kSP4\, and
extract the setup file from the compressed exe file again.
Please let's know if this resolve the issue. I look forward to your update.
Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||That worked.
Thanks for your help!
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:%23$hToamSHHA.3604@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dave,
> I understand that you encountered error message "Setup Initialization
> Error
> Access is denied" when installing SQL 2000 SP4. Please let me know if it's
> not correct.
> Based on my experience, the problem is the setupsql.ini file already exist
> in that default folder C:\Document~1\dave\locals~1\temp\. You may want to
> remove the file from that folder and try to run setup again.
> If above method do not work, please try to log on as a different user with
> local admin rights to try to install SP4.
> If the issue persists, you may want to remove the folder C:\SQL2kSP4\, and
> extract the setup file from the compressed exe file again.
> Please let's know if this resolve the issue. I look forward to your
> update.
> Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

Cannot Install SP4 for SQL Server 2000

I am trying to install SP4 for SQL Server 2000.
When I click on the setup.bat, I get the message:
Setup Initialization Error
Access is denied
Source: 'C\SQL2kSP4\x86\setup\saqlsore.ini'
Target: 'C:\Document~1\dave\locals~1\temp\setups
ql.ini'
I am installing the standard version of SQL Server on to Windows XP with
latest service packs.
According to the SP instructions, I set Local Security Policy | Local
Policies | Security Options to Silently Succeed for Devices: Unsigned
driver installation behavior.
I even gave "everyone" full control to C:\Documents and Settings\dave\Local
Settings\Temp
Still I get this error.
Does anyone have an ideas what I can do to avoid this error?Hello Dave,
I understand that you encountered error message "Setup Initialization Error
Access is denied" when installing SQL 2000 SP4. Please let me know if it's
not correct.
Based on my experience, the problem is the setupsql.ini file already exist
in that default folder C:\Document~1\dave\locals~1\temp\. You may want to
remove the file from that folder and try to run setup again.
If above method do not work, please try to log on as a different user with
local admin rights to try to install SP4.
If the issue persists, you may want to remove the folder C:\SQL2kSP4\, and
extract the setup file from the compressed exe file again.
Please let's know if this resolve the issue. I look forward to your update.
Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||That worked.
Thanks for your help!
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:%23$hToamSHHA.3604@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dave,
> I understand that you encountered error message "Setup Initialization
> Error
> Access is denied" when installing SQL 2000 SP4. Please let me know if it's
> not correct.
> Based on my experience, the problem is the setupsql.ini file already exist
> in that default folder C:\Document~1\dave\locals~1\temp\. You may want to
> remove the file from that folder and try to run setup again.
> If above method do not work, please try to log on as a different user with
> local admin rights to try to install SP4.
> If the issue persists, you may want to remove the folder C:\SQL2kSP4\, and
> extract the setup file from the compressed exe file again.
> Please let's know if this resolve the issue. I look forward to your
> update.
> Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

Cannot Install SP4 for SQL Server 2000

I am trying to install SP4 for SQL Server 2000.
When I click on the setup.bat, I get the message:
Setup Initialization Error
Access is denied
Source: 'C\SQL2kSP4\x86\setup\saqlsore.ini'
Target: 'C:\Document~1\dave\locals~1\temp\setupsql.ini'
I am installing the standard version of SQL Server on to Windows XP with
latest service packs.
According to the SP instructions, I set Local Security Policy | Local
Policies | Security Options to Silently Succeed for Devices: Unsigned
driver installation behavior.
I even gave "everyone" full control to C:\Documents and Settings\dave\Local
Settings\Temp
Still I get this error.
Does anyone have an ideas what I can do to avoid this error?Hello Dave,
I understand that you encountered error message "Setup Initialization Error
Access is denied" when installing SQL 2000 SP4. Please let me know if it's
not correct.
Based on my experience, the problem is the setupsql.ini file already exist
in that default folder C:\Document~1\dave\locals~1\temp\. You may want to
remove the file from that folder and try to run setup again.
If above method do not work, please try to log on as a different user with
local admin rights to try to install SP4.
If the issue persists, you may want to remove the folder C:\SQL2kSP4\, and
extract the setup file from the compressed exe file again.
Please let's know if this resolve the issue. I look forward to your update.
Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||That worked.
Thanks for your help!
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:%23$hToamSHHA.3604@.TK2MSFTNGHUB02.phx.gbl...
> Hello Dave,
> I understand that you encountered error message "Setup Initialization
> Error
> Access is denied" when installing SQL 2000 SP4. Please let me know if it's
> not correct.
> Based on my experience, the problem is the setupsql.ini file already exist
> in that default folder C:\Document~1\dave\locals~1\temp\. You may want to
> remove the file from that folder and try to run setup again.
> If above method do not work, please try to log on as a different user with
> local admin rights to try to install SP4.
> If the issue persists, you may want to remove the folder C:\SQL2kSP4\, and
> extract the setup file from the compressed exe file again.
> Please let's know if this resolve the issue. I look forward to your
> update.
> Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

Cannot install SP1 x86 - Windows XP Professional

Hi, I am trying to install SP1 on a Windows XP Professional - Version 2002 SP2.

but i got an Error, this is the error log :

(File : Redist9_Hotfix_KB913090.log )

-

05/18/2006 16:59:31.835 ================================================================================
05/18/2006 16:59:31.866 Hotfix package launched
05/18/2006 17:01:07.616 Attempting to install instance: SQL Server Native Client
05/18/2006 17:01:07.631 Attempting to install target: GDSA3367
05/18/2006 17:01:07.678 Attempting to install file: sqlncli.msi
05/18/2006 17:01:07.881 Attempting to install file: \\GDSA3367\c$\33b3e8d8202a1514eb8d3dbc\HotFixSqlncli\Files\sqlncli.msi
05/18/2006 17:01:07.928 Creating MSI install log file at: C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_sqlncli.msi.log
05/18/2006 17:01:07.959 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
05/18/2006 17:01:07.991 Failed to read registry key: Debug
05/18/2006 17:01:11.381 MSP returned 0: The action completed successfully.
05/18/2006 17:01:11.444 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
05/18/2006 17:01:11.475 Failed to read registry key: Debug
05/18/2006 17:01:11.491 Successfully installed file: \\GDSA3367\c$\33b3e8d8202a1514eb8d3dbc\HotFixSqlncli\Files\sqlncli.msi
05/18/2006 17:01:11.522 Successfully installed target: GDSA3367
05/18/2006 17:01:11.553 Successfully installed instance: SQL Server Native Client
05/18/2006 17:01:11.584
05/18/2006 17:01:11.600 Product Status Summary:
05/18/2006 17:01:11.631 Product: SQL Server Native Client
05/18/2006 17:01:11.662 SQL Server Native Client (RTM ) - Success
05/18/2006 17:01:11.694
05/18/2006 17:01:11.709 Product: Setup Support Files
05/18/2006 17:01:11.741 Setup Support Files (RTM ) - Not Applied
05/18/2006 17:01:11.756
05/18/2006 17:01:11.834 Product: Database Services
05/18/2006 17:01:11.928 Database Services (RTM 1399 ENU) - Not Applied
05/18/2006 17:01:11.975
05/18/2006 17:01:11.991 Product: Client Components
05/18/2006 17:01:12.022 Client Components (SP1 2047 ENU) - Not Applied
05/18/2006 17:01:12.053
05/18/2006 17:01:12.069 Product: MSXML 6.0 Parser
05/18/2006 17:01:12.116 MSXML 6.0 Parser (RTM ) - Not Applied
05/18/2006 17:01:12.147
05/18/2006 17:01:12.162 Product: SQLXML4
05/18/2006 17:01:12.194 SQLXML4 (RTM ) - Not Applied
05/18/2006 17:01:12.225
05/18/2006 17:01:12.272 Product: Backward Compatibility
05/18/2006 17:01:12.303 Backward Compatibility (RTM ) - Not Applied
05/18/2006 17:01:12.381
05/18/2006 17:01:12.412 Product: Microsoft SQL Server VSS Writer
05/18/2006 17:01:12.428 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
05/18/2006 17:01:12.459
-<EOF>

...and this is the Error Report sends this info:

EventType : sqlsesetup P1 : sql9 P2 : 9 P3 : x86 P4 : null
P5 : null P6 : kb913090
P7 : _depot_sqlvault_setupmain_setup_sqlse_sqlsedll_copyengine.cpp - 856
P8 : null

Files:
C:\WINDOWS\Hotfix\HotFix.log
C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090.log
C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090.log
C:\WINDOWS\Hotfix\OLAP9\Logs\OLAP9_Hotfix_KB913090.log
C:\WINDOWS\Hotfix\NS9\Logs\NS9_Hotfix_KB913090.log
C:\WINDOWS\Hotfix\RS9\Logs\RS9_Hotfix_KB913090.log
C:\WINDOWS\Hotfix\DTS9\Logs\DTS9_Hotfix_KB913090.log
C:\WINDOWS\Hotfix\SQLTools9\Logs\SQLTools9_Hotfix_KB913090.log
C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_sqlncli.msi.log
C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_SqlSupport.msp.log
C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log
C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.out

-

My Version of SQL is - Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) .

Thanks.

Cristian Bianchi

I don't see anything interesting there. Can you look in the log files here:

%Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files

|||

Paul:

In the folder " %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files" there in not files dated when i made the instalation of the SP1. But i found in the log C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log , the next line :

MSI (s) (FC:F0) [17:21:26:030]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log.

Thanks in advance.

Crsitan F. Bianchi

|||1603 is just "Fatal error during installation." The lines above that in the log should reveal something about the cause of the error.

Cannot install SP1 on SQL Server 2005 (64bit)

Hi,

I'm having problems installing SP1 on one of our servers.

If I try to install the x64 version of SP1 setup says it can not update my server and I should use x86 version. Trying to install the x86 version results in the message I should use x64 version....

Any ideas?

Regards, Jan

What version of SQL do you have on the machine? x64 or x86? And when are you getting the error?

Thanks,
Sam Lester (MSFT)

|||

Hi Sam,

version is Microsoft SQL Server Standard Edition (64-bit). I get this error after doubleclicking the service pack .exe file.

Regards,

Jan

|||

OK, just to confirm what is on the box, can you go to Add/Remove Programs, click on change, and then on Report. This will show everything that the discovery process finds associated with SQL Server. This may help us figure out why the detection is giving you the error.

Also, can you supply the package name that you're trying to run?

Thanks,
Sam

|||

Hi Sam,

here is the report:

---

SIAM

The following components are installed on this server

MSSQLSERVER

Analysis Services

[Version: 9.00.1399.06 Edition: Standard Edition (64-bit) Patch level: 9.00.1399.06 Language: English (United States)]

Database Engine

[Version: 9.00.1399.06 Edition: Standard Edition (64-bit) Patch level: 9.00.1399.06 Language: English (United States)]

Common components

Integration Services

[Version: 9.00.1399.06 Edition: Standard Edition (64-bit) Patch level: 9.00.1399.06 Language: English (United States)]

Notification Services

[Version: 9.00.1399.06 Edition: Standard Edition (64-bit) Patch level: 9.00.1399.06 Language: English (United States)]

Workstation Components

[Version: 9.00.1399.06 Edition: Standard Edition (64-bit) Patch level: 9.00.1399.06 Language: English (United States)]

---

Regards,

Jan

|||

Great, thanks for posting the info! And to confirm, are you running this SP1 package:

SQLServer2005SP1-KB913090-x64-ENU.exe

from

http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en

Thanks,
Sam

|||

Hi,

no I didn't run this package but SQLServer2005SP1-KB913090-x64-ENU.exe (most of our server are german version).

With the englisch version installation worked - thanks for the great support.

Anyway, the error message is a bit misleading...

Regards,

Jan

Cannot install SP1

Hi folks,
My Win2003 server won't let me install RS SP1.
It gets about two thirds of the way through the initial progress bar, then tells me this:
SQL Setup failed to connect to the database service for server configuration. Refer to the Server error logs and setup logs for more detailed error information.
I am logged into the server as the same user (a Domain Admin) that installed RS in the first place. I've even tried using the rssetupaccount and rssetuppassword parameters to make it install as the 'sqlservice' user on our domain (the one that runs the SQL Server service).
Our 'Domain Admins' group, as well as the 'sqlservice' user, has dbo rights to the ReportServer database. I've even tried adding 'BUILTIN\Administrators' to the user-list of the db and giving it dbo rights, then logging in as the local Administrator user on the server - still get the same error.
What else can I try?
Thanks in advance,
MattTry using a sql account when passing in the rssetupaccount and
rssetuppassword.
Do you have Terminal services for applications turned on? That may be
causing this issue as well. Even so, using a sql account during setup
should solve the issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt Hamilton" <Matt Hamilton@.discussions.microsoft.com> wrote in message
news:F34F7448-4D94-468C-A362-E809BE1B56EE@.microsoft.com...
> Hi folks,
> My Win2003 server won't let me install RS SP1.
> It gets about two thirds of the way through the initial progress bar, then
tells me this:
> SQL Setup failed to connect to the database service for server
configuration. Refer to the Server error logs and setup logs for more
detailed error information.
> I am logged into the server as the same user (a Domain Admin) that
installed RS in the first place. I've even tried using the rssetupaccount
and rssetuppassword parameters to make it install as the 'sqlservice' user
on our domain (the one that runs the SQL Server service).
> Our 'Domain Admins' group, as well as the 'sqlservice' user, has dbo
rights to the ReportServer database. I've even tried adding
'BUILTIN\Administrators' to the user-list of the db and giving it dbo
rights, then logging in as the local Administrator user on the server -
still get the same error.
> What else can I try?
> Thanks in advance,
> Matt|||"Daniel Reib [MSFT]" wrote:
> Try using a sql account when passing in the rssetupaccount and
> rssetuppassword.
> Do you have Terminal services for applications turned on? That may be
> causing this issue as well. Even so, using a sql account during setup
> should solve the issue.
The only TS thing we're using is the Remote Desktop functionality.
I tried running this:
e:\rssp1\sp1setup.exe rssetupaccount=sa rssetuppassword=<our sa password>
And it still threw the same error.
Interestingly, it also brings up a prompt to send an error report to MS when I click OK on the error dialog.
I've installed SP1 with no problems at all on one of our other servers (running Win2k rather than Win2003). Argh! Please help!
Matt|||The parameters are case sensitive. Did you use RSSETUPACCOUNT &
RSSETUPPASSWORD?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt Hamilton" <Matt Hamilton@.discussions.microsoft.com> wrote in message
news:13231C67-50A3-4A59-9D15-040E24183592@.microsoft.com...
> "Daniel Reib [MSFT]" wrote:
> > Try using a sql account when passing in the rssetupaccount and
> > rssetuppassword.
> >
> > Do you have Terminal services for applications turned on? That may be
> > causing this issue as well. Even so, using a sql account during setup
> > should solve the issue.
> The only TS thing we're using is the Remote Desktop functionality.
> I tried running this:
> e:\rssp1\sp1setup.exe rssetupaccount=sa rssetuppassword=<our sa password>
> And it still threw the same error.
> Interestingly, it also brings up a prompt to send an error report to MS
when I click OK on the error dialog.
> I've installed SP1 with no problems at all on one of our other servers
(running Win2k rather than Win2003). Argh! Please help!
> Matt|||No! I didn't!
I'll try that next. Thanks, Daniel.
Case-sensitive parameters, eh? That's a first.
"Daniel Reib [MSFT]" wrote:
> The parameters are case sensitive. Did you use RSSETUPACCOUNT &
> RSSETUPPASSWORD?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Matt Hamilton" <Matt Hamilton@.discussions.microsoft.com> wrote in message
> news:13231C67-50A3-4A59-9D15-040E24183592@.microsoft.com...
> > "Daniel Reib [MSFT]" wrote:
> >
> > > Try using a sql account when passing in the rssetupaccount and
> > > rssetuppassword.
> > >
> > > Do you have Terminal services for applications turned on? That may be
> > > causing this issue as well. Even so, using a sql account during setup
> > > should solve the issue.
> >
> > The only TS thing we're using is the Remote Desktop functionality.
> >
> > I tried running this:
> >
> > e:\rssp1\sp1setup.exe rssetupaccount=sa rssetuppassword=<our sa password>
> >
> > And it still threw the same error.
> >
> > Interestingly, it also brings up a prompt to send an error report to MS
> when I click OK on the error dialog.
> >
> > I've installed SP1 with no problems at all on one of our other servers
> (running Win2k rather than Win2003). Argh! Please help!
> >
> > Matt
>
>|||Actually not for Windows Installer. They use case to determine scope.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt Hamilton" <MattHamilton@.discussions.microsoft.com> wrote in message
news:AD74DFAD-9735-465F-B75C-214E982D07AB@.microsoft.com...
> No! I didn't!
> I'll try that next. Thanks, Daniel.
> Case-sensitive parameters, eh? That's a first.
> "Daniel Reib [MSFT]" wrote:
> > The parameters are case sensitive. Did you use RSSETUPACCOUNT &
> > RSSETUPPASSWORD?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Matt Hamilton" <Matt Hamilton@.discussions.microsoft.com> wrote in
message
> > news:13231C67-50A3-4A59-9D15-040E24183592@.microsoft.com...
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > Try using a sql account when passing in the rssetupaccount and
> > > > rssetuppassword.
> > > >
> > > > Do you have Terminal services for applications turned on? That may
be
> > > > causing this issue as well. Even so, using a sql account during
setup
> > > > should solve the issue.
> > >
> > > The only TS thing we're using is the Remote Desktop functionality.
> > >
> > > I tried running this:
> > >
> > > e:\rssp1\sp1setup.exe rssetupaccount=sa rssetuppassword=<our sa
password>
> > >
> > > And it still threw the same error.
> > >
> > > Interestingly, it also brings up a prompt to send an error report to
MS
> > when I click OK on the error dialog.
> > >
> > > I've installed SP1 with no problems at all on one of our other servers
> > (running Win2k rather than Win2003). Argh! Please help!
> > >
> > > Matt
> >
> >
> >|||In case anyone's interested:
One of our techies, when trying to resolve something else, uninstalled and reinstalled IIS on our server the other day, breaking RS.
So I uninstalled and reinstalled RS ... and then (thinking, "what the hell?") tried installing SP1 - and this time it worked.
We changed nothing, so I have no idea what was stopping us from installing SP1 in the first place.
So if you have similar problems, try uninstalling & reinstalling.
Cheers,
Matt|||In case anyone's interested:
One of our techies, when trying to resolve something else, uninstalled and reinstalled IIS on our server the other day, breaking RS.
So I uninstalled and reinstalled RS ... and then (thinking, "what the hell?") tried installing SP1 - and this time it worked.
We changed nothing, so I have no idea what was stopping us from installing SP1 in the first place.
So if you have similar problems, try uninstalling & reinstalling.
Cheers,
Matt|||In case anyone's interested:
One of our techies, when trying to resolve something else, uninstalled and reinstalled IIS on our server the other day, breaking RS.
So I uninstalled and reinstalled RS ... and then (thinking, "what the hell?") tried installing SP1 - and this time it worked.
We changed nothing, so I have no idea what was stopping us from installing SP1 in the first place.
So if you have similar problems, try uninstalling & reinstalling.
Cheers,
Matt

Cannot install Setup Support Files

Iâ'm unable to complete the first step of the install. For some reason the
Setup Support Files do not finish installing. When proceeding to the next
step I get a â'Microsoft SQL Server 2000 Reporting Services Setup was unable
to install on your computerâ'. â'Microsoft SQL Server 2000 Reporting Services
Setup encountered a problem and has rolled backâ'. I cannot get any further
than this. When I try the installer again it trys to install the Setup
Sopport Files again...
I am installing on Win2K Server SP4, recently rebuilt.
Below are the last few lines of the log file - it seems to be an issue with
finding the "InstalledInstances"? Any and all help much appreciated.
Cheers,
Nick
<EndFunc Name='UpdateComponents' Return='0' GetLastError='0'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
Failed to find property in cache: InstalledInstances
Failed to perform discovery on machine: SYD123456
HRESULT: 2147749904
<EndFunc Name='PerformDetections' Return='2' GetLastError='183'>
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
Bootstrap\LOG\RSStp_.cab"Hi Nick,
I ran the same problem but only on one machine among 2 servers and 3
developers. Did you ever find answer (reason) for this and did you find a way
how to fix it? I did try to uninstall and reinstall SQL server but it doesn't
help.
Regards,
Nisad.
"NickB" wrote:
> Iâ'm unable to complete the first step of the install. For some reason the
> Setup Support Files do not finish installing. When proceeding to the next
> step I get a â'Microsoft SQL Server 2000 Reporting Services Setup was unable
> to install on your computerâ'. â'Microsoft SQL Server 2000 Reporting Services
> Setup encountered a problem and has rolled backâ'. I cannot get any further
> than this. When I try the installer again it trys to install the Setup
> Sopport Files again...
> I am installing on Win2K Server SP4, recently rebuilt.
> Below are the last few lines of the log file - it seems to be an issue with
> finding the "InstalledInstances"? Any and all help much appreciated.
> Cheers,
> Nick
> <EndFunc Name='UpdateComponents' Return='0' GetLastError='0'>
> <Func Name='DwLaunchMsiExec'>
> <Func Name='PerformDetections'>
> 0
> Failed to find property in cache: InstalledInstances
> Failed to perform discovery on machine: SYD123456
> HRESULT: 2147749904
> <EndFunc Name='PerformDetections' Return='2' GetLastError='183'>
> <Func Name='FSetupLogging'>
> <Func Name='CreateSetupLogCabs'>
> Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
> Bootstrap\LOG\RSStp_.cab"
>|||Hi Nisad,
I did speak to MS support about it but between us we were unable to come up
with an answer within the timeframe my client required. Because we were
installing RS on a test box we decided to simply rebuild it in the hope that
would fix things. After that we had no problems doing the install.
Unfortunately we were none the wiser about what caused the issue.
Sorry...no real answer to the problem. Good luck.
Cheers,
Nick
"Nisad" wrote:
> Hi Nick,
> I ran the same problem but only on one machine among 2 servers and 3
> developers. Did you ever find answer (reason) for this and did you find a way
> how to fix it? I did try to uninstall and reinstall SQL server but it doesn't
> help.
> Regards,
> Nisad.
> "NickB" wrote:
> >
> > Iâ'm unable to complete the first step of the install. For some reason the
> > Setup Support Files do not finish installing. When proceeding to the next
> > step I get a â'Microsoft SQL Server 2000 Reporting Services Setup was unable
> > to install on your computerâ'. â'Microsoft SQL Server 2000 Reporting Services
> > Setup encountered a problem and has rolled backâ'. I cannot get any further
> > than this. When I try the installer again it trys to install the Setup
> > Sopport Files again...
> >
> > I am installing on Win2K Server SP4, recently rebuilt.
> >
> > Below are the last few lines of the log file - it seems to be an issue with
> > finding the "InstalledInstances"? Any and all help much appreciated.
> >
> > Cheers,
> > Nick
> >
> > <EndFunc Name='UpdateComponents' Return='0' GetLastError='0'>
> > <Func Name='DwLaunchMsiExec'>
> > <Func Name='PerformDetections'>
> > 0
> > Failed to find property in cache: InstalledInstances
> > Failed to perform discovery on machine: SYD123456
> > HRESULT: 2147749904
> > <EndFunc Name='PerformDetections' Return='2' GetLastError='183'>
> > <Func Name='FSetupLogging'>
> > <Func Name='CreateSetupLogCabs'>
> > Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
> > Bootstrap\LOG\RSStp_.cab"
> >

Cannot install server components

I have the beta version of RS running fine on Windows 2000 Server (SP4), IIS 5, and SQL Server 2000 Enterprise (SP3a). No issues at all.
However, when trying to install the RS release candidate, for some reason I am not presented with the server components option - I can only see the client tools option.
Can anyone assist?Did you receive any prereq warnings?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravinder" <Ravinder@.discussions.microsoft.com> wrote in message
news:0E870307-157B-4509-9003-B6CC934C4DDB@.microsoft.com...
> I have the beta version of RS running fine on Windows 2000 Server (SP4),
IIS 5, and SQL Server 2000 Enterprise (SP3a). No issues at all.
> However, when trying to install the RS release candidate, for some reason
I am not presented with the server components option - I can only see the
client tools option.
> Can anyone assist?|||I finally got the install working properly. As a last resort I re-installed Win2k SP4 and low and behold I am now able to install RS Server Components without any issues at all.
Microsoft might want to add this "known issue" to the install notes.
"Daniel Reib [MSFT]" wrote:
> Did you receive any prereq warnings?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ravinder" <Ravinder@.discussions.microsoft.com> wrote in message
> news:0E870307-157B-4509-9003-B6CC934C4DDB@.microsoft.com...
> > I have the beta version of RS running fine on Windows 2000 Server (SP4),
> IIS 5, and SQL Server 2000 Enterprise (SP3a). No issues at all.
> >
> > However, when trying to install the RS release candidate, for some reason
> I am not presented with the server components option - I can only see the
> client tools option.
> >
> > Can anyone assist?
>
>

Cannot install second SQL virtual server on four node cluster...

I am having some issues installing a second virtual server. The first VS
installed fine with no issues and has no issues operating. On the second VS
install, the install process makes it all the way through to the point where
it creates the cluster resources. But when it goes to bring the SQL Server
resource online it fails. It gives the following error in the log:
[sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35;
message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
I found a KB article that came close to this and it stated that if you are
having issues connecting to a SQL Cluster instance on Windows 2003 nodes it
is because SQL needs to be at SP3 for it to work. The only problem is I can't
get the intial install to work in order to apply the service pack. Any
ideas?
Isaac Story
Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default...b;en-us;815431
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Isaac Story" <IsaacStory@.discussions.microsoft.com> wrote in message
news:00C5C9F2-B09B-4211-B713-673844262E42@.microsoft.com...
>I am having some issues installing a second virtual server. The first VS
> installed fine with no issues and has no issues operating. On the second
> VS
> install, the install process makes it all the way through to the point
> where
> it creates the cluster resources. But when it goes to bring the SQL Server
> resource online it fails. It gives the following error in the log:
> [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35;
> message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (Connect()).
> I found a KB article that came close to this and it stated that if you are
> having issues connecting to a SQL Cluster instance on Windows 2003 nodes
> it
> is because SQL needs to be at SP3 for it to work. The only problem is I
> can't
> get the intial install to work in order to apply the service pack. Any
> ideas?
>
> Isaac Story
>

cannot install samples

hi to all,

i just installed sql server 2005 express edition. I also downloaded and run the "Northwind and pubs Sample Databases" and i have problem installing them

In the line of the guide that i have to run
sqlcmd -s .\SQLExpress -i instnwnd.sql

i get the following error:

HResult 0x2, Level 16, State 1
Named Pipes provider: could not open a connection to Sql Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occured while establishing a connection to the server. When connecting to the Sql Server 2005, this failuremay be caused by the fact that under the default setting Sql Server does not allow remote connections..
SqlCmd: Error: Microsoft Sql Native Client : Login timeout expired
I also cannot connect through C# express and take the same error. SqlServer and SqlBrowser are up and running...

Can anyone help me please ?

Thanks in advance

AnthonyHi.

Make sure TCP/IP access is enabled in Configuration Manager.|||I already have tcp/ip enabled...But except from that, i suppose that is not needed for local connections, isn't it ?

Still, not working...|||You need to use sqlcmd -S that's capital S. small s is a different parameter

Cannot install RS on a SQLserver 2005 SP1 installation

The situation is as follow:

Sqlserver 2005 installed, reporting services NOT installed

SP1 installed

Trying to add Reporting Services results in an eror messages about incompliant versions. Nothing happens

Is there anybody who has a clue?

No. You cannot add instance-awared components when SP1 is applied. But you can do as follows,

1. Install RS RTM

2. Apply SP1.

|||

Ok, thats why it did not work

What dou you mean with RS RTM?

And after the installation of RS RTM and SP1 this is a complete and normal Sql server 2005 installation with Reporting Services?

|||

SQL Server does not ship a slipstreamed version (1 install that brings you up to SP1 level), so as Jiongxiong mentioned, you'll need to install the RTM version of RS from your original media, then apply SP1 to the newly installed instance. Then your box will be at the normal SP1 level for all components.

Thanks,
Sam Lester (MSFT)

|||

So I am still stuck at the beginning.

on the server the installation refuse to install extra components.

I hope that there is a better solution than completely deinstall SQlserver2005 and do a complete reinstall since this is a production server and I want to avoid the risk from a deinstall

Cannot Install Reporting Services Components!

I have set up a Virtual Machine that runs Windows Server 2003 x64.
When I come to install SQL Server Express edition the Reporting
Services components don't even show up as options for installation.
Oh, I'm installing Express edition with advanced services by the way
and I have the 3.0 .NET services already in place. I don't have IIS
installed though, and I don't know if that is related (it's the only
warning I get during install). I can only see Client and Database
components in the install. I'm trying to create a virtualized
environment where I can do some testing and run the Adventure Works
DBs... that way I have a place to train using the Microsoft training
modules. Tht way, it will not affect any of the real databases we use.IIS has to be there. Reporting Services is an asp.net application. RS 2005
is a 2.0 framework application (so 3.0 framework is of no use to it).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ayman" <aymantg@.gmail.com> wrote in message
news:1180621469.669972.171680@.g4g2000hsf.googlegroups.com...
>I have set up a Virtual Machine that runs Windows Server 2003 x64.
> When I come to install SQL Server Express edition the Reporting
> Services components don't even show up as options for installation.
> Oh, I'm installing Express edition with advanced services by the way
> and I have the 3.0 .NET services already in place. I don't have IIS
> installed though, and I don't know if that is related (it's the only
> warning I get during install). I can only see Client and Database
> components in the install. I'm trying to create a virtualized
> environment where I can do some testing and run the Adventure Works
> DBs... that way I have a place to train using the Microsoft training
> modules. Tht way, it will not affect any of the real databases we use.
>|||On May 31, 10:34 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> IIS has to be there. Reporting Services is an asp.net application. RS 2005
> is a 2.0 framework application (so 3.0 framework is of no use to it).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ayman" <ayma...@.gmail.com> wrote in message
> news:1180621469.669972.171680@.g4g2000hsf.googlegroups.com...
> >I have set up a Virtual Machine that runs Windows Server 2003 x64.
> > When I come to install SQL Server Express edition the Reporting
> > Services components don't even show up as options for installation.
> > Oh, I'm installing Express edition with advanced services by the way
> > and I have the 3.0 .NET services already in place. I don't have IIS
> > installed though, and I don't know if that is related (it's the only
> > warning I get during install). I can only see Client and Database
> > components in the install. I'm trying to create a virtualized
> > environment where I can do some testing and run the Adventure Works
> > DBs... that way I have a place to train using the Microsoft training
> > modules. Tht way, it will not affect any of the real databases we use.
Ok, so I'll install IIS before running SQL Server installation.
Correction, I installed 2.0 .NET framework then I installed the SDK
(300mb) version on after that. Is that going to be ok? 3.0 is the
Vista one, my mistake. Is the initial reason why RS does not show up
in the installation because IIS is not there? It's just invisible.|||The issue with the 2.0 framework is whether the website is setup to be
running the framework. IIS has to be there for RS to install.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ayman" <aymantg@.gmail.com> wrote in message
news:1180627922.532307.151760@.q66g2000hsg.googlegroups.com...
> On May 31, 10:34 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> IIS has to be there. Reporting Services is an asp.net application. RS
>> 2005
>> is a 2.0 framework application (so 3.0 framework is of no use to it).
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ayman" <ayma...@.gmail.com> wrote in message
>> news:1180621469.669972.171680@.g4g2000hsf.googlegroups.com...
>> >I have set up a Virtual Machine that runs Windows Server 2003 x64.
>> > When I come to install SQL Server Express edition the Reporting
>> > Services components don't even show up as options for installation.
>> > Oh, I'm installing Express edition with advanced services by the way
>> > and I have the 3.0 .NET services already in place. I don't have IIS
>> > installed though, and I don't know if that is related (it's the only
>> > warning I get during install). I can only see Client and Database
>> > components in the install. I'm trying to create a virtualized
>> > environment where I can do some testing and run the Adventure Works
>> > DBs... that way I have a place to train using the Microsoft training
>> > modules. Tht way, it will not affect any of the real databases we use.
> Ok, so I'll install IIS before running SQL Server installation.
> Correction, I installed 2.0 .NET framework then I installed the SDK
> (300mb) version on after that. Is that going to be ok? 3.0 is the
> Vista one, my mistake. Is the initial reason why RS does not show up
> in the installation because IIS is not there? It's just invisible.
>|||On May 31, 4:58 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> The issue with the 2.0 framework is whether the website is setup to be
> running the framework. IIS has to be there for RS to install.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ayman" <ayma...@.gmail.com> wrote in message
> news:1180627922.532307.151760@.q66g2000hsg.googlegroups.com...
> > On May 31, 10:34 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> IIS has to be there. Reporting Services is an asp.net application. RS
> >> 2005
> >> is a 2.0 framework application (so 3.0 framework is of no use to it).
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> "Ayman" <ayma...@.gmail.com> wrote in message
> >>news:1180621469.669972.171680@.g4g2000hsf.googlegroups.com...
> >> >I have set up a Virtual Machine that runs Windows Server 2003 x64.
> >> > When I come to install SQL Server Express edition the Reporting
> >> > Services components don't even show up as options for installation.
> >> > Oh, I'm installing Express edition with advanced services by the way
> >> > and I have the 3.0 .NET services already in place. I don't have IIS
> >> > installed though, and I don't know if that is related (it's the only
> >> > warning I get during install). I can only see Client and Database
> >> > components in the install. I'm trying to create a virtualized
> >> > environment where I can do some testing and run the Adventure Works
> >> > DBs... that way I have a place to train using the Microsoft training
> >> > modules. Tht way, it will not affect any of the real databases we use.
> > Ok, so I'll install IIS before running SQL Server installation.
> > Correction, I installed 2.0 .NET framework then I installed the SDK
> > (300mb) version on after that. Is that going to be ok? 3.0 is the
> > Vista one, my mistake. Is the initial reason why RS does not show up
> > in the installation because IIS is not there? It's just invisible.
Ok I got it working. I had to setup up IIS and then make it so that
it will work in 32-bit mode. Afterwards it started working. I'm
thinking I could have just put the 180 day demo version on instead of
the express edition since it has more functionality. Oh well.

Cannot install report server DB

Hi All,
I have installed VS.Net 2003, SQL Server 2000 with SQL Server 2000 sp3,
enabled Internet Information services, Frontpage server extensions.
However the Report Server database does not appear on my local server.
Is there something I am missing?
Thanks
SanjeevSQL Reporting Services has it's own seperate install. You need to aquire it
and run it on your server and on the client you wish to use the report
designer from in order to begin.
Peace,
Dan
"Sanjeev" <sanjeev@.microsoft.com> wrote in message
news:ON6nskJfFHA.3436@.tk2msftngp13.phx.gbl...
> Hi All,
> I have installed VS.Net 2003, SQL Server 2000 with SQL Server 2000 sp3,
> enabled Internet Information services, Frontpage server extensions.
> However the Report Server database does not appear on my local server.
> Is there something I am missing?
> Thanks
> Sanjeev
>|||Thanks Dan. I will try this.
"Dan Christjohn" <dchristjohn(removethis)@.directapps.com> wrote in message
news:OvNw$yMfFHA.2444@.tk2msftngp13.phx.gbl...
> SQL Reporting Services has it's own seperate install. You need to aquire
> it and run it on your server and on the client you wish to use the report
> designer from in order to begin.
> Peace,
> Dan
> "Sanjeev" <sanjeev@.microsoft.com> wrote in message
> news:ON6nskJfFHA.3436@.tk2msftngp13.phx.gbl...
>> Hi All,
>> I have installed VS.Net 2003, SQL Server 2000 with SQL Server 2000 sp3,
>> enabled Internet Information services, Frontpage server extensions.
>> However the Report Server database does not appear on my local server.
>> Is there something I am missing?
>> Thanks
>> Sanjeev
>

Cannot install or uninstall

We have a 2003 server with SQL Server 2005.
Our instance in SRS was playing up basically so I uninstalled it.
When I now try to reinstall via the original CD it still thinks the product
is installed. If I try to uninstall it tells me no features have changed
and exits.
When I try to reinstall or uninstall via control panel and changing the
items installed and that gives me an error of "Could not find a package to
install on the installation media".
Any help would be appreciated.
ChubblyI have now completely removed the instance of SQL Server, run a registry
cleaner to remove any erroneous entries and then tried to reinstall SQL
Server. It still thinks however that Reporting Services are already there.
I continued with the installation which threw up numerous other errors,
installed the SQL 2005 patch from Microsoft update and then tried to change
the installed components of SQL Server. To no avail. I still receive
"Could not find a package to install on the installation media".
If I try to manually run the SqlRun_RS.msi file I get the following error:
"An instance with the same name is already installed on this computer. To
proceed with SQL Server Setup, provide a unique instance name."
I'm stumped and don't particularly want to have to rebuild the whole server.
Chubbly
"Chubbly Geezer" <chubbly_geezer@.newsgroup.nospam> wrote in message
news:eyJQY9wPHHA.4484@.TK2MSFTNGP02.phx.gbl...
> We have a 2003 server with SQL Server 2005.
> Our instance in SRS was playing up basically so I uninstalled it.
> When I now try to reinstall via the original CD it still thinks the
> product is installed. If I try to uninstall it tells me no features have
> changed and exits.
> When I try to reinstall or uninstall via control panel and changing the
> items installed and that gives me an error of "Could not find a package to
> install on the installation media".
> Any help would be appreciated.
> Chubbly
>
>

cannot install Northwind database in SQL Server Express

Hi,

I tried to install the Northwind database into SQl Server Express via the instnwnd.sql script using the command line:

osql -E -i instnwnd.sql

after a time out though I get this message:

"[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL
Server [2].
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote
connections."

I already granted access to the administrator account on my machine.

Anyone knows what I need to do more?

Thanks in advance

greetings from Belgium,

Anthony

Are you running osql on the same machine as SQL Server or on a remote machine? If you are executing this on a remote machine, you need to enable remote connections.

Thanks
Laurentiu

|||

Hi Laurentiu,

No, I'm running SQL Server on the same machine.

Thanks for your reply,

Anthony

|||

You should specify the SQL Express instance name:

sqlcmd -E -S.\sqlexpress -i instnwnd.sql

The same will work for osql, of course. Make sure you type the dot. If you're connecting remotely, replace the dot with the machine name.

Thanks
Laurentiu

Cannot install no matter what I do!

I've officially done everything. I've uninstalled everything I can think of. I've cleaned the registry until it sparkles. I've removed all directories having anything to do with VS or SQL. I've even run the uninstall tool multiple times and been told everything is OK. However, SQL Server Express STILL tells me there are "beta versions" of stuff on my machine. Do you have any suggestions, or should I just give up in disgust?!?!?!

Occasionally, this has proven to be quite a headache.

Here is the list of steps and things to check that I walk through. Be precise and dilligent to check/do every one. Don't assume that it is 'almost' the same as something else you have checked/done.

Hopefully, there will be something here that will help you.

Remove -Error message when you install SQL Server 2005: "Beta components detected"
http://support.microsoft.com/?kbid=919394

Remove -How do I remove previous versions of SQL Server 2005 / Whidbey?
http://www.aspfaq.com/sql2005/show.asp?id=15

Remove -How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/?kbid=290991

Remove -How to uninstall an instance of SQL Server 2005 manually
http://support.microsoft.com/?kbid=909967

Remove -How to Uninstall SQL Server 2005 Beta
http://go.microsoft.com/?linkid=1396133

Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953

Remove -How to use the Add or Remove Programs item in Control Panel to add
or remove components for stand-alone installations and clustered
installations of SQL Server 2005 (KB: 922670)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;922670

Remove -How to: Uninstall SQL Server Express
http://msdn2.microsoft.com/en-us/library/ms143505.aspx

Remove -The error is: Fatal error during installation"
http://support.microsoft.com/?kbid=919945

Remove -Uninstall Applications NOT in Install/Remove Programs List
http://blogs.msdn.com/astebner/archive/2005/10/30/487096.aspx

Remove –Windows Installer Clean-Up Tool
http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe

|||Thanks! I think I lied about that though; I kept digging and found the log file, which lead me to a poorly-uninstalled SQL program. I removed any reference to the program in the registry (that was no longer there anyway), and it worked!

Cannot install MSDE 2000 on XP SP2

I have attempted to install MSDE 2000 (Italian localized version) on
XP SP2 but the install fails with the message (translated from
Italian): "Impossible to configure the server. For further information
examine the log etc., etc."
Norton Av: disenabled. Not connected to network.
My install parameters were:
setup SAPWD="password" SECURITYMODE=SQL /L*v "C:\Temp\MSDELog.log"
I searched the log for "return value 3" (valore restituito 3, in
Italian), and have captured the 20 lines before the failure:
MSI (s) (EC:D0) [18:27:47:141]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI21.tmp, Entrypoint: InstallSQLAgentSecurity
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\Mike\IMPOST~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Mike\IMPOST~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity succeeded
MSI (s) (EC:38) [18:27:47:261]: Executing op:
ActionStart(Name=SkuIt.2D02443E_7002_4C0B_ABC9_EAB 2C064397B,,)
MSI (s) (EC:38) [18:27:47:261]: Executing op:
CustomActionSchedule(Action=SkuIt.2D02443E_7002_4C 0B_ABC9_EAB2C064397B,ActionType=1025,Source=Binary Data,Target=SkuIt,)
MSI (s) (EC:D8) [18:27:47:261]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI22.tmp, Entrypoint: SkuIt
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\Mike\IMPOST~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Mike\IMPOST~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SkuIt
MSI (s) (EC:38) [18:27:47:361]: Executing op:
ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
MSI (s) (EC:38) [18:27:47:361]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (EC:C0) [18:27:47:361]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI23.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\Mike\IMPOST~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Mike\IMPOST~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
Executing "C:\Programmi\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "Latin1_General_CI_AS""
MSI (c) (BC:B8) [18:29:54:003]: Font created. Charset: Req=0, Ret=0,
Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
Impossibile configurare il server. Per ulteriori informazioni,
esaminare il log degli errori del server e il log degli errori del
programma di installazione.
MSI (s) (EC!C4) [18:29:59:491]: Prodotto: Microsoft SQL Server Desktop
Engine -- Impossibile configurare il server. Per ulteriori
informazioni, esaminare il log degli errori del server e il log degli
errori del programma di installazione.
Fine operazione 18.29.59: InstallFinalize. Valore restituito 3.
Can anyone help me?
Mike Watson
hi Mike,
Mike Watson wrote:
> I have attempted to install MSDE 2000 (Italian localized version) on
> XP SP2 but the install fails with the message (translated from
> Italian): "Impossible to configure the server. For further information
> examine the log etc., etc."
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:<3b5fcgF6gi5u6U1@.individual.net>...
> hi Mike,
> Mike Watson wrote:
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
Ciao Andrea,
I checked out the the indicated paper. I have no previous installs.
Nonetheless, I physically removed the leftover install folders. I then
added an INSTANCENAME="..." to my ini file and repeated the
installation.
Exactly the same result. Can you give me further help?
Mike Watson
|||Ciao Mike,
Mike Watson wrote:
> I checked out the the indicated paper. I have no previous installs.
> Nonetheless, I physically removed the leftover install folders. I then
> added an INSTANCENAME="..." to my ini file and repeated the
> installation.
> Exactly the same result. Can you give me further help?
>
I actually installed MSDE on WinXP pro sp2 2 days ago on a virtual machine
just to test the very same result reported by another user but I was not
able to repro..
all Microsoft hints related to that kind of problem are indicated to be
solved by that Knowledge Base article... but I learned that sometime MSDE
fails to install on WinXP sp2 due to problems with the MDAC 2.8 WinXP sp2
stack, and currently there's no workaround for that.. but again, I was
(fortunately :D) not able to repro this kind of problems
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Cannot install MS SQL 2000 Developer Edition to my computer

When come to Create Instances screen and click next it prompt error message

although i had restart my computer.

A previous program Installation created pending file operations on the installation machine. You must restart the computer before running setup.

That message is normally because there is a 'runonce' flag set (and some files to be replaced).

However, if you have re-booted your computer (not just logged off and on), then the flag 'should' be cleared.

|||

yes i had restart even shutdown but still prompt the same errors.

Cannot install Microsoft SQL Server 2005 Express Edition x86

I recently (yesterday) installed a fresh copy of Windows XP with Service Pack 2 applied.

I proceeded with Visual Studio 2005 Express Editions installation straight away.

But I cannot install Microsoft SQL Server 2005 Express Edition x86.

I choose to install Microsoft SQL Server 2005 Express Edition x86 component along with every component of visual studio but it simply would not install.

In the end, after the installation of each complete is complete, I simply get an error message saying that Microsoft SQL Server 2005 Express Edition x86 failed to install.

What is the problem?

First take a look at the following file: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\summary.txt. This should point you to which component failed and the specific log file for the component. When you open the component log file search for "Value 3" (this is a Windows Installer code for the error section). Take a look at +/- 10 lines for the error.

If the summary.txt file doesn't provide any clues, take a look at: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\files\*_core(local).txt - open the most recent one if there are multiple. Go to the end of the file and you should find some clues as to why the installation failed.

|||

I looked. There were three errors and all of them said that installation cannot be done to a compressed drive

--

Error : SQL Server Setup cannot install files to the compressed or encrypted folder: C:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again.

--

I'll remove drive compression and try again.

Thanks for help!

|||

I am having the same problem - cannot install SQL Server Express, I looked in the file you mentioned to the other fellow and it says:

D43QNW81 : SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

but I HAVE removed all components except a thing called Enterprise Library June 2005, and thaat one will not un-install without dot net framework 1.1

is that it? do I have to go ALL the way back?

any help will be much appreciated, I installed the whole works in a Virutal machine and now I am trying to install it on my base machine (because the Virtual one is too slow)

|||

David,

You can take a look at the latest *_core(local).log file to see which old component it's detecting. The log files can be found here: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\files

If you email me directly at dtjones@.microsoft.com I can send you a clean up script. The script isn't supported but we've had good luck with it.

Cheers,
Dan

Cannot install June CTP on Windows 2003 DC !!!

I am trying to install Sql Server 2005 June CTP on a Windows Server
2003 SP1 primary domain controller with IIS/ASP installed.

I get this error (when Sql Server Database Services is being installed:
"SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to
local group SQLServer2005MSSQLServerADHelp­erUser".
And I am not alone!
See http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=18788

Any workaround or update to be able to install it on a domain controller, Microsoft?

Thanks!

Anybody?

Our environment requires installation of SQL 2005 on a server with Active Directory... so this is really a big issue.

Please, can somebody from MS look into this?|||We are a few days later now, and still, nowhere on the Internet I can find a solution.

Can somebody from Microsoft please respond?|||

Currently SQL Server 2005 will not install on a Domain Controller or on Windows Small Business Server. There is no known work around at this time other than installing on a machine that is not configured as a domain controller. This is a known issue and we're working on resolving it.

Dan

|||Yikes, this is a huge issue. I have this issue too on a single Win2K3 Server Standard with SP1, AD/DC. Active Directory and DC are required before setting up TFS.
|||I've been in contact with the TFS team on this issue. As long as you use the April CTP that shipped with TFS Beta 2 you're okay. You just can't use the June CTP.

Cannot install it at all

I was following the post that Jeff had where he could not re-install MSDE.
But I cannot install it at all. When I run the setup and specify the
TARGETDIR I can watch the setup install the folder and the files under it.
However; when it gets to the end it removes it completely. I do not have an
instance of the install in the registry. I cannot find it under add/remove
programs. I do not have a service running after the install. In fact, this
is why I started using the TARGETDIR switch. I thought I was going nuts.
Just as a test, I installed it on my work PC and it worked with no problems.
I have dual boot (win98 on c:\ and w2k on d:\). I am trying desperately to
load on w2k. Please help and thank you.
"Linda" wrote:

> I was following the post that Jeff had where he could not re-install MSDE.
> But I cannot install it at all. When I run the setup and specify the
> TARGETDIR I can watch the setup install the folder and the files under it.
> However; when it gets to the end it removes it completely. I do not have an
> instance of the install in the registry. I cannot find it under add/remove
> programs. I do not have a service running after the install. In fact, this
> is why I started using the TARGETDIR switch. I thought I was going nuts.
> Just as a test, I installed it on my work PC and it worked with no problems.
> I have dual boot (win98 on c:\ and w2k on d:\). I am trying desperately to
> load on w2k. Please help and thank you.
|||Correction: I do have MSSQLServerADHelper as a service which is pointing to
d:\program files\Microsoft SQL Server\80\tools\Binn\sqladhlp.exe ... which
does not exist. I disabled it from my hardware profile, and that did not
work.
"Linda" wrote:

> I was following the post that Jeff had where he could not re-install MSDE.
> But I cannot install it at all. When I run the setup and specify the
> TARGETDIR I can watch the setup install the folder and the files under it.
> However; when it gets to the end it removes it completely. I do not have an
> instance of the install in the registry. I cannot find it under add/remove
> programs. I do not have a service running after the install. In fact, this
> is why I started using the TARGETDIR switch. I thought I was going nuts.
> Just as a test, I installed it on my work PC and it worked with no problems.
> I have dual boot (win98 on c:\ and w2k on d:\). I am trying desperately to
> load on w2k. Please help and thank you.
|||hi Linda,
"Linda" <Linda@.discussions.microsoft.com> ha scritto nel messaggio
news:DB8FB3DF-E869-4387-AC3D-0DA53F19F62C@.microsoft.com
> I was following the post that Jeff had where he could not re-install
> MSDE. But I cannot install it at all. When I run the setup and
> specify the TARGETDIR I can watch the setup install the folder and
> the files under it. However; when it gets to the end it removes it
> completely. I do not have an instance of the install in the
> registry. I cannot find it under add/remove programs. I do not have
> a service running after the install. In fact, this is why I started
> using the TARGETDIR switch. I thought I was going nuts. Just as a
> test, I installed it on my work PC and it worked with no problems. I
> have dual boot (win98 on c:\ and w2k on d:\). I am trying
> desperately to load on w2k. Please help and thank you.
please add the
/L*v "d:\MsdeLog.txt"
parameter to your call to setup.exe, in order to produce a verbose log
(about 2mb) of the installation process
then search for
Return Value 3
result in order to see what the problem is
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I ran it with the log and found the Return Value 3 which was
InstallSQLAgentSecurity failed (HomePC,LocalSystem,87).
Action ended 20:54:18: InstallFinalize. Return value 3.
I looked up the error and found it immediately. I had to install File and
Print sharing. OMG Thank you so much. It is asking me to reboot now.
"Andrea Montanari" wrote:

> hi Linda,
> "Linda" <Linda@.discussions.microsoft.com> ha scritto nel messaggio
> news:DB8FB3DF-E869-4387-AC3D-0DA53F19F62C@.microsoft.com
> please add the
> /L*v "d:\MsdeLog.txt"
> parameter to your call to setup.exe, in order to produce a verbose log
> (about 2mb) of the installation process
> then search for
> Return Value 3
> result in order to see what the problem is
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

cannot install integration services

Hi!

During the installation of integration services (SQL 05 Developer RTM) I get the following error:

TITLE: Microsoft SQL Server 2005 Setup

Failed to install and configure assemblies C:\Programme\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: Failed to generate type library 'C:\Programme\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.tlb' for 'Microsoft.SqlServer.MSMQTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.

I had CTPs of SQL05 and VS05 installed before, but uninstalled them with the cleanup tool.

yeh, I had this issue and found a resolution... read my thread about the installation issue resolved (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=134853&SiteID=1)

the other workaround really is not to select to install integration services but to install it after everything else|||Thank you for your fast reply. I'm trying to install SQL05 Developer on Windows XP Pro SP2. I forgot to mention that in my first post. So I think your solution won't help me :(|||I see!
Well, try to install everything except integration services and then install integration services after everything

The thread I created STILL DOES apply to WS2003, due to installed components still breaking and during installation (I know you are running XP so you do not need to go through the thread!) :)|||

I already did that. I uninstalled Integration Services (during the first installation, I ignored the error message, but IS didn't work then), and tried to reinstall them. I always get the same error.

|||have you:

tried completly removing SQL Server 2005.
Then installing it WITHOUT the integration and reporting services? :-)|||- I uninstalled SQL server, including SQL Native Client and Everything I found that had "sql" in it's name.
- rebooted
- Installed just the SQL Server engine, Clients, Documentation
- rebooted
- Instaled everything except Integration Services
- rebooted
- Tried to install Integration Services, I still get the same error|||Hi Mathias,

I am in exactly the same situation as you. If I find anything I will post here.

Regards,

Chris|||Thank you. Good luck! :)|||Hi all,
I had the same problem. I think it was because of a incomplete uninstall of a previous Beta Version. Check if in there an old version of one of the "Microsoft.SqlServer.DtsXXX" Assemblies (take a look at the Last Modified Date in the Properties) in the Global Assembly Cache.
If there is one or more, delete them.
If you can't delete them because there are references, eliminate these first (can be done by deleting some registry-keys, but I don't know exactly which ones).
Then, after all old assemblies are removed, reinstall the Integration Services using the Setup. Should then work flawlessy.
Greetings,
Ingo
|||Have the same problem with Win2K Pro, SQL 2000 already installed and then SQL
2005 DevEd

After uninstalling SQL2005 a few times in order to get it to install with this error, which also breaks Enterprise Manager on SQL2000 in the process, I then end up reinstalling both. What a pain!

Eventually, after many hours buggering around, got SQL2000 and SQL2005 working but this 'install bug' or 'another MS featurett' (which is still not resolved from what I can see), is such a time waster, in what already is limited!

Does anyone know of an easy fix or patch, rather than have to re-install IS again and possibly cause other issues?
|||This is somewhat related to the problem I had. See my resolution with SSIS at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124884&SiteID=1. Reinstall OS and then install SQL 2005 RTM Dev Edtion.

I still want to configure a mixed environment with SQL2000 SP4 and SQL2005 RTM Dev Edition on Win XP Pro SP2. I have tried it and cannot use SSIS to configure connections.

If someone has a workaround, please post but I do not want to go thru the pain of reinstalling the OS and my dev tools again.|||Hi centexbi,
I have SQL2000 and SQL2005 working side-by-side on my XP SP2.
Don't know if this is a solution for you and if it works, but you might give it a try:
- Completely remove anything that has to do with .NET (all framework version, VisualStudio, etc.)
- Ensure that you no longer have the directories %SYSTEMROOT%\assembly und %SYSTEMROOT%\Microsoft.NET, delete them if necessary
- Reinstall SQL2000 including SP4
- Try to install SQL2005
Greets,
Ingo
|||Appreciate Ingo and Centexbi thoughts but reinstall of OS is simply not an option.

As a developer, one has a large number of apps, tools etc installed and if the system (as in my case), is very stable apart from SQL2005 install then I would rather ditch install of SQL as opposed to spending a number of days re-assembling the PC OS etc.

Reinstall of SQL2005 has not resolved this - even from the point of painstakenly removing registry entries etc and trying to install as virgin. Maybe MS should provide a proper installer which will remove the masses of junk registry entries SQL2005 leaves behind when you unistall. How about a 'SQL2005 clean reg / os' tool - bit like what Symantec do for their AV?

This is the real world and time is as scarce as money. 'We' all spend far too much time working in this 'black art' industry and shame MS do not do more to help us!

|||Hi ComputerSolutions
An OS-Reinstall is of course _never_ an option.
I can only support your idea of a cleanup-tool.
Greets,
Ingo

cannot install integration services

Hi!

During the installation of integration services (SQL 05 Developer RTM) I get the following error:

TITLE: Microsoft SQL Server 2005 Setup

Failed to install and configure assemblies C:\Programme\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: Failed to generate type library 'C:\Programme\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.tlb' for 'Microsoft.SqlServer.MSMQTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.

I had CTPs of SQL05 and VS05 installed before, but uninstalled them with the cleanup tool.

yeh, I had this issue and found a resolution... read my thread about the installation issue resolved (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=134853&SiteID=1)

the other workaround really is not to select to install integration services but to install it after everything else|||Thank you for your fast reply. I'm trying to install SQL05 Developer on Windows XP Pro SP2. I forgot to mention that in my first post. So I think your solution won't help me :(|||I see!
Well, try to install everything except integration services and then install integration services after everything

The thread I created STILL DOES apply to WS2003, due to installed components still breaking and during installation (I know you are running XP so you do not need to go through the thread!) :)|||

I already did that. I uninstalled Integration Services (during the first installation, I ignored the error message, but IS didn't work then), and tried to reinstall them. I always get the same error.

|||have you:

tried completly removing SQL Server 2005.
Then installing it WITHOUT the integration and reporting services? :-)|||- I uninstalled SQL server, including SQL Native Client and Everything I found that had "sql" in it's name.
- rebooted
- Installed just the SQL Server engine, Clients, Documentation
- rebooted
- Instaled everything except Integration Services
- rebooted
- Tried to install Integration Services, I still get the same error|||Hi Mathias,

I am in exactly the same situation as you. If I find anything I will post here.

Regards,

Chris|||Thank you. Good luck! :)|||Hi all,
I had the same problem. I think it was because of a incomplete uninstall of a previous Beta Version. Check if in there an old version of one of the "Microsoft.SqlServer.DtsXXX" Assemblies (take a look at the Last Modified Date in the Properties) in the Global Assembly Cache.
If there is one or more, delete them.
If you can't delete them because there are references, eliminate these first (can be done by deleting some registry-keys, but I don't know exactly which ones).
Then, after all old assemblies are removed, reinstall the Integration Services using the Setup. Should then work flawlessy.
Greetings,
Ingo|||Have the same problem with Win2K Pro, SQL 2000 already installed and then SQL
2005 DevEd

After uninstalling SQL2005 a few times in order to get it to install with this error, which also breaks Enterprise Manager on SQL2000 in the process, I then end up reinstalling both. What a pain!

Eventually, after many hours buggering around, got SQL2000 and SQL2005 working but this 'install bug' or 'another MS featurett' (which is still not resolved from what I can see), is such a time waster, in what already is limited!

Does anyone know of an easy fix or patch, rather than have to re-install IS again and possibly cause other issues?|||This is somewhat related to the problem I had. See my resolution with SSIS at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124884&SiteID=1. Reinstall OS and then install SQL 2005 RTM Dev Edtion.

I still want to configure a mixed environment with SQL2000 SP4 and SQL2005 RTM Dev Edition on Win XP Pro SP2. I have tried it and cannot use SSIS to configure connections.

If someone has a workaround, please post but I do not want to go thru the pain of reinstalling the OS and my dev tools again.|||Hi centexbi,
I have SQL2000 and SQL2005 working side-by-side on my XP SP2.
Don't know if this is a solution for you and if it works, but you might give it a try:
- Completely remove anything that has to do with .NET (all framework version, VisualStudio, etc.)
- Ensure that you no longer have the directories %SYSTEMROOT%\assembly und %SYSTEMROOT%\Microsoft.NET, delete them if necessary
- Reinstall SQL2000 including SP4
- Try to install SQL2005
Greets,
Ingo|||Appreciate Ingo and Centexbi thoughts but reinstall of OS is simply not an option.

As a developer, one has a large number of apps, tools etc installed and if the system (as in my case), is very stable apart from SQL2005 install then I would rather ditch install of SQL as opposed to spending a number of days re-assembling the PC OS etc.

Reinstall of SQL2005 has not resolved this - even from the point of painstakenly removing registry entries etc and trying to install as virgin. Maybe MS should provide a proper installer which will remove the masses of junk registry entries SQL2005 leaves behind when you unistall. How about a 'SQL2005 clean reg / os' tool - bit like what Symantec do for their AV?

This is the real world and time is as scarce as money. 'We' all spend far too much time working in this 'black art' industry and shame MS do not do more to help us!|||Hi ComputerSolutions
An OS-Reinstall is of course _never_ an option.
I can only support your idea of a cleanup-tool.
Greets,
Ingo