Cannot reference Microsoft.SqlServer.Dts.DtsClient?

Reinstalled SqlServer 2005 and SP2. Reinstalled VS2005 and SP1. I add a reference to Microsoft.SqlServer.Dts.DtsClient. It automatically adds a line to web.config

<add assembly="Microsoft.SqlServer.Dts.DtsClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>

I still cannot do

using Microsoft.SqlServer.Dts.DtsClient;

I can do

using Microsoft.SqlServer.Server;

I am thinking a config file or something is missing/corrupt somewhere to prevent me from being able to correctly reference this dll. Can anyone help please?

NoRemorse,

If you're trying to configure the Reporting Service you may find the following helpful: http://msdn2.microsoft.com/en-us/library/ms345250.aspx.

HTH,

Patrik

|||I just want to be able to run an SSIS package from code. I need to have that assembly in order to get at the DTS objects. I did what that article suggested anyway but it still doesn't work. Oddly, if I create a new Windows Form project I can reference the assembly fine, so the DLL seems to be regeistered ok. But in a Web project I cannot reference it.|||I uninstalled VS team system and now it works fine. Some incompatibility there

Cannot Install SQL2005 developer on Windows XP with Office 2007 pr

Have a new computer with Windows XP SP2 and all updates and Office 2007
professional.
When I try and install SQL2005 developer get an error 1706: Setup cannot
find the required file c:/program files/Microsoft Office11/1033/setup.chm
Any assistance is appreciated.
GavinHi Gavin,
This is actually a known bug and Microsoft is aware of it. Until a fix
is released you need to workaround it by uninstalling Microsoft Office
2003 Web Components from the Add/Remove Software control panel and then
re-run the SQL Server setup.
Hope this helps!
Jonathan
gavin wrote:
> Have a new computer with Windows XP SP2 and all updates and Office 2007
> professional.
> When I try and install SQL2005 developer get an error 1706: Setup cannot
> find the required file c:/program files/Microsoft Office11/1033/setup.chm
> Any assistance is appreciated.
> Gavin|||On Aug 2, 10:17 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Gavin,
> This is actually a known bug and Microsoft is aware of it. Until a fix
> is released you need to workaround it by uninstalling Microsoft Office
> 2003 Web Components from the Add/Remove Software control panel and then
> re-run the SQL Server setup.
> Hope this helps!
> Jonathan
>
> gavin wrote:
> > Have a new computer with Windows XP SP2 and all updates and Office 2007
> > professional.
> > When I try and install SQL2005 developer get an error 1706: Setup cannot
> > find the required file c:/program files/Microsoft Office11/1033/setup.chm
> > Any assistance is appreciated.
> > Gavin- Hide quoted text -
> - Show quoted text -
Interesting. I was curious to what it was looking in the Office11
folder, as I believe Office 2007 falls withing the Office12 arena. I
have the same setup (no Office Web Components) and had no issues
installing the SQL 2005 developer edition.

Cannot Install SQL2005 developer on Windows XP with Office 2007 pr

Have a new computer with Windows XP SP2 and all updates and Office 2007
professional.
When I try and install SQL2005 developer get an error 1706: Setup cannot
find the required file c:/program files/Microsoft Office11/1033/setup.chm
Any assistance is appreciated.
Gavin
On Aug 2, 10:17 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Gavin,
> This is actually a known bug and Microsoft is aware of it. Until a fix
> is released you need to workaround it by uninstalling Microsoft Office
> 2003 Web Components from the Add/Remove Software control panel and then
> re-run the SQL Server setup.
> Hope this helps!
> Jonathan
>
> gavin wrote:
>
> - Show quoted text -
Interesting. I was curious to what it was looking in the Office11
folder, as I believe Office 2007 falls withing the Office12 arena. I
have the same setup (no Office Web Components) and had no issues
installing the SQL 2005 developer edition.

Cannot Install SQL2005 developer on Windows XP with Office 2007 pr

Have a new computer with Windows XP SP2 and all updates and Office 2007
professional.
When I try and install SQL2005 developer get an error 1706: Setup cannot
find the required file c:/program files/Microsoft Office11/1033/setup.chm
Any assistance is appreciated.
GavinOn Aug 2, 10:17 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Gavin,
> This is actually a known bug and Microsoft is aware of it. Until a fix
> is released you need to workaround it by uninstalling Microsoft Office
> 2003 Web Components from the Add/Remove Software control panel and then
> re-run the SQL Server setup.
> Hope this helps!
> Jonathan
>
> gavin wrote:
>
> - Show quoted text -
Interesting. I was curious to what it was looking in the Office11
folder, as I believe Office 2007 falls withing the Office12 arena. I
have the same setup (no Office Web Components) and had no issues
installing the SQL 2005 developer edition.

Cannot install SQL Srv 2005 Service Pack 2 (KB 921896) / uninstall SQL Srv 2005

I tried to uninstall SQL Server 2005 and it was failed.

I tried to install SP2 for SQL Server 2005, and it was failed too!

Here are the log file SUMMARY.TXT (is it enough?).

Can anyone tell me what the problem is?

Time: 05/17/2007 16:51:41.483
KB Number: KB921896
Machine: XXXXXX
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : D:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 1332
Error Description : *** Shared String ID 1332 Not Found ***
-

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1332

From the log, it looks like you have two instances of SQL 2005 on your machine, one instance of Standard Edition (instance name of MSSQLSERVER) and one instance of Express (instance name of SQLEXPRESS). The SP2 installer will only apply to your Standard edition and not to the Express edition. Try to run the SP2 installer and only select the Standard edition components. To upgrade your Express edition, use this package:

http://www.microsoft.com/downloads/details.aspx?familyid=31711d5d-725c-4afa-9d65-e4465cdff1e7&displaylang=en

Thanks,
Sam Lester (MSFT)

Cannot install SQL Server 2005 Standard WinXP Pro SP2

Hello,

I have SQL Server 2000 Developer Edition already installed. Before starting
the SQL Server 2005 Standard setup, I exited the SQL server agent running in
my system tray.

I am logged on as Administrator and no other desktop apps are running. SQL
Server 2005 Setup reports several "Setup failed." error messages after the
install. I am choosing (for now) ONLY the workstation tools and books online
check mark. The installation presents a screen that says that these products
were successfully installed ("Setup finished"):
- MSXML6
- OWC11
- SQL Server Backward-Compatibility Files
However, these items have a red x next to them:
- SQL Server Books Online
- SQL Server Support Files
- SQLXML4
- SQL Native Client
- Workstation Components, Books Online, ...

My Setup log file terminates with a few messages--one of which contains the
words "Configuration failed." (This is the ONLY mention of the word "fail" in
the Setup log--see the excerpt below.)

Any ideas? I'm stuck without SQL Server 2005 running so this is a
productivity killer for me.

More info: Here is what I have done, to no avail:

1) Installed the OWC11 components using a direct download from Microsoft.
That install worked. But when it runs again from the SQL Server 2005 DVD, it
fails.
2) Logged on not as a user with Admin rights, but as ADMINISTRATOR. Same
results--the SQL Server 2005 Standard setup failed.
3) Installed SQL Server 2005 Express successfully. Afterwards, tried again
to install SQL Server 2005 Standard, and that setup failed.
4) Cleared registry values for SQL Server 2005 under HKLM.../Software as
described in KB article. Also deleted the installation folder ...90. Tried
again to install SQL Server 2005 Standard, and that setup failed.
5) Tried the 180-day trial of SQL Server 2005 Enterprise--to no avail. Same
results.

Found error logs but they did not help me pinpoint the root cause for the
failed installation.

Thank you,
-- Jonathan

SQLSetup0004_zzzzz_SQLNCLI_1.log Excerpt:
============================+
MSI (s) (60:90) [12:01:14:390]: Note: 1: 1729
MSI (s) (60:90) [12:01:14:406]: Product: Microsoft SQL Server Native Client
-- Configuration failed.

MSI (s) (60:90) [12:01:14:406]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (60:90) [12:01:14:406]: MainEngineThread is returning 1603
MSI (s) (60:68) [12:01:14:406]: Destroying RemoteAPI object.
MSI (s) (60:9C) [12:01:14:406]: Custom Action Manager thread ending.
=== Logging stopped: 2/8/2007 12:01:14 ===
MSI (c) (8C:4C) [12:01:14:406]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (8C:4C) [12:01:14:406]: MainEngineThread is returning 1603
=== Verbose logging stopped: 2/8/2007 12:01:14 ===

As a first check have you disabled Anti-virus and Anti-firewall before installing?|||

Yes, anti-virus software is OFF and my XP Firewall is OFF.

I re-ran SQL Server 2005 Standard Setup, and here is some more information.

Setup Support files install properly.
Installation Wizard begins.
Status of ALL requirements is "Success".
Windows Installer launches.
I click Next on Serial Number screen after completing the form.
In Components to Install, I select only "Workstation components, Books Online and development tools"
A screen acknowledges that only Client Components will be installed.
I click Install.
A status dialog appears. Setup clearly begins to install files. Then it shows, one-by-one:

1. SQL Setup Support Files FAILED.
2. SQL Native Client FAILED.
3. OWC11 Setup finished.
4. Then I see "Removing backup files"
5. Then Sql Server Books Online failed, along with other failed statuses.

Any ideas?

|||

OK--If anyone cannot help on Microsoft TechNet, can anyone point me in the right direction on how to solve this issue?

1) Are there other web sites that might offer help?

2) Will Microsoft charge an incident fee for this issue since it appears to be a problem with Setup?

3) Does anyone have any suggestions?

This machine has Visual Studio 2003, Visual Studio 6, Macromedia 8, Adobe Photoshop CS2, IE7, and several other high-end products, such as InstallShield 12 Premium. All of those installed and are running without incident.

I can't imagine why SQL Server 2005 setup can't detect what's wrong and provide a successful installation.

Thank you.

|||Install sqlncli.msi before installing mssql2005.|||

Hello:

I ran the sqlncli.msi and received an error that I had a higher version already installed on my machine. I then used Add/Remove programs to remove the SQL Native Client--and then I re-ran sqlncli.msi successfully.

I then re-ran SQL Server 2005 Standard setup and received all the same installation errors already reported.

What now?

|||

I'm contacting Microsoft Support. I thank you for those who tried to help but it is a bit ridiculous to have a support group that can't even troubleshoot getting the product installed!

I will report the root cause here (if Microsoft is able to figure it out).

Thank you,

Jon500

Cannot install SQL Server 2005 Standard WinXP Pro SP2

Hello,

I have SQL Server 2000 Developer Edition already installed. Before starting
the SQL Server 2005 Standard setup, I exited the SQL server agent running in
my system tray.

I am logged on as Administrator and no other desktop apps are running. SQL
Server 2005 Setup reports several "Setup failed." error messages after the
install. I am choosing (for now) ONLY the workstation tools and books online
check mark. The installation presents a screen that says that these products
were successfully installed ("Setup finished"):
- MSXML6
- OWC11
- SQL Server Backward-Compatibility Files
However, these items have a red x next to them:
- SQL Server Books Online
- SQL Server Support Files
- SQLXML4
- SQL Native Client
- Workstation Components, Books Online, ...

My Setup log file terminates with a few messages--one of which contains the
words "Configuration failed." (This is the ONLY mention of the word "fail" in
the Setup log--see the excerpt below.)

Any ideas? I'm stuck without SQL Server 2005 running so this is a
productivity killer for me.

More info: Here is what I have done, to no avail:

1) Installed the OWC11 components using a direct download from Microsoft.
That install worked. But when it runs again from the SQL Server 2005 DVD, it
fails.
2) Logged on not as a user with Admin rights, but as ADMINISTRATOR. Same
results--the SQL Server 2005 Standard setup failed.
3) Installed SQL Server 2005 Express successfully. Afterwards, tried again
to install SQL Server 2005 Standard, and that setup failed.
4) Cleared registry values for SQL Server 2005 under HKLM.../Software as
described in KB article. Also deleted the installation folder ...90. Tried
again to install SQL Server 2005 Standard, and that setup failed.
5) Tried the 180-day trial of SQL Server 2005 Enterprise--to no avail. Same
results.

Found error logs but they did not help me pinpoint the root cause for the
failed installation.

Thank you,
-- Jonathan

SQLSetup0004_zzzzz_SQLNCLI_1.log Excerpt:
============================+
MSI (s) (60:90) [12:01:14:390]: Note: 1: 1729
MSI (s) (60:90) [12:01:14:406]: Product: Microsoft SQL Server Native Client
-- Configuration failed.

MSI (s) (60:90) [12:01:14:406]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (60:90) [12:01:14:406]: MainEngineThread is returning 1603
MSI (s) (60:68) [12:01:14:406]: Destroying RemoteAPI object.
MSI (s) (60:9C) [12:01:14:406]: Custom Action Manager thread ending.
=== Logging stopped: 2/8/2007 12:01:14 ===
MSI (c) (8C:4C) [12:01:14:406]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (8C:4C) [12:01:14:406]: MainEngineThread is returning 1603
=== Verbose logging stopped: 2/8/2007 12:01:14 ===

As a first check have you disabled Anti-virus and Anti-firewall before installing?|||

Yes, anti-virus software is OFF and my XP Firewall is OFF.

I re-ran SQL Server 2005 Standard Setup, and here is some more information.

Setup Support files install properly.
Installation Wizard begins.
Status of ALL requirements is "Success".
Windows Installer launches.
I click Next on Serial Number screen after completing the form.
In Components to Install, I select only "Workstation components, Books Online and development tools"
A screen acknowledges that only Client Components will be installed.
I click Install.
A status dialog appears. Setup clearly begins to install files. Then it shows, one-by-one:

1. SQL Setup Support Files FAILED.
2. SQL Native Client FAILED.
3. OWC11 Setup finished.
4. Then I see "Removing backup files"
5. Then Sql Server Books Online failed, along with other failed statuses.

Any ideas?

|||

OK--If anyone cannot help on Microsoft TechNet, can anyone point me in the right direction on how to solve this issue?

1) Are there other web sites that might offer help?

2) Will Microsoft charge an incident fee for this issue since it appears to be a problem with Setup?

3) Does anyone have any suggestions?

This machine has Visual Studio 2003, Visual Studio 6, Macromedia 8, Adobe Photoshop CS2, IE7, and several other high-end products, such as InstallShield 12 Premium. All of those installed and are running without incident.

I can't imagine why SQL Server 2005 setup can't detect what's wrong and provide a successful installation.

Thank you.

|||Install sqlncli.msi before installing mssql2005.|||

Hello:

I ran the sqlncli.msi and received an error that I had a higher version already installed on my machine. I then used Add/Remove programs to remove the SQL Native Client--and then I re-ran sqlncli.msi successfully.

I then re-ran SQL Server 2005 Standard setup and received all the same installation errors already reported.

What now?

|||

I'm contacting Microsoft Support. I thank you for those who tried to help but it is a bit ridiculous to have a support group that can't even troubleshoot getting the product installed!

I will report the root cause here (if Microsoft is able to figure it out).

Thank you,

Jon500

cannot install SQL Server 2005 Express Edition with Advanced Services SP2

I get the following error message each time I try to install SQL Server 2005 Express Edition with Advanced Services SP2:

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

This problem is described in:
http://support.microsoft.com/kb/920201
and each of the IIS 7 components specified in this article have been installed.

When I continue with:
http://support.microsoft.com/kb/934162,
the script 'adsutil.vbs' cannot be executed because it does not exist anywhere on my drive.

My question is, what is the 'adsutil.vbs' script and how do I get a hold of it? Are these contortions really necessary to get SQL server working or has MS provided a patch for this nasty problem?

My system:

VISTA Home Premium, x64

Intel Quad CPU, 2.4GHz

4Gig RAM

500Gig hard disk

Thanks,

Ian

I've removed MS Office, VS2005 + documentation and everthing related to SQL. I then re-installed the 64 bit version of the .NET framework 2.0 and followed this up by SQL Server 2005 Express Edition with Advanced Services SP2. The same problems occur as reported below.

I've been at this for 5 days. Can anyone give me an idea of where to begin debugging this problem or should I simply give up and report it as a bug to Microsoft. I would appreciate any comments or suggestions.

Thanks,

Ian

Reported warnings:

- IIS Feature Requirement (Warning)

Messages

IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

ASP.Net Version Registration Requirement (Warning)

Messages

ASP.Net Version Registration Requirement

64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

|||

1. I've now enabled all IIS features.

2. For the SSEAS setup, I make no selections and simply keep the default feature selection (i.e. data base services). At the `Existing components` window, the option `SQL Server Database services 9.2.30042.00` is disabled and clicking on `next` displays a message that "None of the selected features can be installed or upgraded. Setup cannot proceed...".

Any ideas as to what this causing the bug and how to get past it?

Ian

|||I reformatted the hard driver, reinstalled Vista Premium, SQL Server Express and all is well now.|||Make shure you didnt mask reportng services resources on instalation, because, IIS is a pre-requisit to install it.

cannot install SQL Server 2005 Express Edition with Advanced Services SP2

I get the following error message each time I try to install SQL Server 2005 Express Edition with Advanced Services SP2:

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

This problem is described in:
http://support.microsoft.com/kb/920201
and each of the IIS 7 components specified in this article have been installed.

When I continue with:
http://support.microsoft.com/kb/934162,
the script 'adsutil.vbs' cannot be executed because it does not exist anywhere on my drive.

My question is, what is the 'adsutil.vbs' script and how do I get a hold of it? Are these contortions really necessary to get SQL server working or has MS provided a patch for this nasty problem?

My system:

VISTA Home Premium, x64

Intel Quad CPU, 2.4GHz

4Gig RAM

500Gig hard disk

Thanks,

Ian

I've removed MS Office, VS2005 + documentation and everthing related to SQL. I then re-installed the 64 bit version of the .NET framework 2.0 and followed this up by SQL Server 2005 Express Edition with Advanced Services SP2. The same problems occur as reported below.

I've been at this for 5 days. Can anyone give me an idea of where to begin debugging this problem or should I simply give up and report it as a bug to Microsoft. I would appreciate any comments or suggestions.

Thanks,

Ian

Reported warnings:

- IIS Feature Requirement (Warning)

Messages

IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

ASP.Net Version Registration Requirement (Warning)

Messages

ASP.Net Version Registration Requirement

64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

|||

1. I've now enabled all IIS features.

2. For the SSEAS setup, I make no selections and simply keep the default feature selection (i.e. data base services). At the `Existing components` window, the option `SQL Server Database services 9.2.30042.00` is disabled and clicking on `next` displays a message that "None of the selected features can be installed or upgraded. Setup cannot proceed...".

Any ideas as to what this causing the bug and how to get past it?

Ian

|||I reformatted the hard driver, reinstalled Vista Premium, SQL Server Express and all is well now.|||Make shure you didnt mask reportng services resources on instalation, because, IIS is a pre-requisit to install it.

cannot install SQL Server 2005 Express Edition with Advanced Services SP2

I get the following error message each time I try to install SQL Server 2005 Express Edition with Advanced Services SP2:

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

This problem is described in:
http://support.microsoft.com/kb/920201
and each of the IIS 7 components specified in this article have been installed.

When I continue with:
http://support.microsoft.com/kb/934162,
the script 'adsutil.vbs' cannot be executed because it does not exist anywhere on my drive.

My question is, what is the 'adsutil.vbs' script and how do I get a hold of it? Are these contortions really necessary to get SQL server working or has MS provided a patch for this nasty problem?

My system:

VISTA Home Premium, x64

Intel Quad CPU, 2.4GHz

4Gig RAM

500Gig hard disk

Thanks,

Ian

I've removed MS Office, VS2005 + documentation and everthing related to SQL. I then re-installed the 64 bit version of the .NET framework 2.0 and followed this up by SQL Server 2005 Express Edition with Advanced Services SP2. The same problems occur as reported below.

I've been at this for 5 days. Can anyone give me an idea of where to begin debugging this problem or should I simply give up and report it as a bug to Microsoft. I would appreciate any comments or suggestions.

Thanks,

Ian

Reported warnings:

- IIS Feature Requirement (Warning)

Messages

IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

ASP.Net Version Registration Requirement (Warning)

Messages

ASP.Net Version Registration Requirement

64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

|||

1. I've now enabled all IIS features.

2. For the SSEAS setup, I make no selections and simply keep the default feature selection (i.e. data base services). At the `Existing components` window, the option `SQL Server Database services 9.2.30042.00` is disabled and clicking on `next` displays a message that "None of the selected features can be installed or upgraded. Setup cannot proceed...".

Any ideas as to what this causing the bug and how to get past it?

Ian

|||I reformatted the hard driver, reinstalled Vista Premium, SQL Server Express and all is well now.|||Make shure you didnt mask reportng services resources on instalation, because, IIS is a pre-requisit to install it.

Cannot install Sql 2005 SP2, Error: Your Account information Could not be verified

Hi all,

I am running a named instance of SQL Server 2005 Enterprise Edition, side by side with named instance of SQL Server 2000 in Windows Server 2003. When I start the installation. I am unable to proceed from authentication stage.

The error description for Database Services and Reporting Services under both sa and windows authentication mode is: Encryption not supported on client Sqlcmd error: Microsoft SQL Native client: Client Unable to establish connection

In Service Manager, all SQL Server 2005 services are running with Logon as Administrator, and I am also able to connect to SSAS, SSRS, SSIS via Management studio both via Windows authentication and sa account information.

Would you please inform if I have to change any security settings before SP2 installation here.

How to add myself a Sql Server Administrator. The link in Surface Area Configuration to Add new Administrator doesn't work.

Hi,

I tried repairing the Sql Server Native Client via Add/ Remove Programs. After successfully repairing, SP2 installation went fine.

Thanks

Subhash Subramanyam

|||

Hi,

I 'm having the same trouble. I've just tired to repair instalation of SQL NativeClient, but the resupl is still the same.

In part of instalation in verifing of accounts , there is status "Login failed".

I'm not able to solve this issue. Please , encounter somebody this trouble?

|||

Hi Barlo,

Are you using a local account (Windows authentication), If so then make sure you have NT Administrator privileges while installing. In my case I run all the services under local account. If you are doing the same, verify the type of account installed. Run Services.msc -> For all the Sql 2005 Services running -> properties -> log on with local account. Make sure that you are able to connect to all the services.

Still if you face error during authentication mode, Please look at the error instructions on the third column in the table on authentication modes for list of services, after it prompts the error. e.g: Table might show that Reporting Services and Database cannot connect, since native client failed..

Cannot install Sql 2005 SP2, Error: Your Account information Could not be verified

Hi all,

I am running a named instance of SQL Server 2005 Enterprise Edition, side by side with named instance of SQL Server 2000 in Windows Server 2003. When I start the installation. I am unable to proceed from authentication stage.

The error description for Database Services and Reporting Services under both sa and windows authentication mode is: Encryption not supported on client Sqlcmd error: Microsoft SQL Native client: Client Unable to establish connection

In Service Manager, all SQL Server 2005 services are running with Logon as Administrator, and I am also able to connect to SSAS, SSRS, SSIS via Management studio both via Windows authentication and sa account information.

Would you please inform if I have to change any security settings before SP2 installation here.

How to add myself a Sql Server Administrator. The link in Surface Area Configuration to Add new Administrator doesn't work.

Hi,

I tried repairing the Sql Server Native Client via Add/ Remove Programs. After successfully repairing, SP2 installation went fine.

Thanks

Subhash Subramanyam

|||

Hi,

I 'm having the same trouble. I've just tired to repair instalation of SQL NativeClient, but the resupl is still the same.

In part of instalation in verifing of accounts , there is status "Login failed".

I'm not able to solve this issue. Please , encounter somebody this trouble?

|||

Hi Barlo,

Are you using a local account (Windows authentication), If so then make sure you have NT Administrator privileges while installing. In my case I run all the services under local account. If you are doing the same, verify the type of account installed. Run Services.msc -> For all the Sql 2005 Services running -> properties -> log on with local account. Make sure that you are able to connect to all the services.

Still if you face error during authentication mode, Please look at the error instructions on the third column in the table on authentication modes for list of services, after it prompts the error. e.g: Table might show that Reporting Services and Database cannot connect, since native client failed..

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 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 Get CSV or XML to Render

Hello,

I've just installed SQL Server 2005 Express, and RS (all with SP2). I can run reports fine for HTML, PDF, and Excel, but whenever I specify a format with "CSV" or "XML", I get the following error:

An attempt has been made to use a rendering extension that is not registered for this report serverAn attempt has been made to use a rendering extension that is not registered for this report server

I'd really like these report formats to work. I haven't modified any system configuration files.

Has anyone else seen this error?

Thanks,

Michael

Sorry, Michael.

CSV, XML, and TIFF don't work in Express.

From TechNet: http://technet.microsoft.com/en-us/library/ms365166(SQL.90).aspx

You'll have to upgrade to another version to use those extension.

-Jessica

|||

Jessica,

What's strange is that I ran XML and CSV reports right after getting the report server installed (with SQL Express), and then they just stopped working the next day when I shut down and then re-started my machine. VERY strange indeed. That lends some argument that it is possible. There were a few points in that link you sent me (thanks for the link, BTW), that were wrong. For example, I can reference my local report server with http://localhost/Reports, whereas the page says that I need to reference my report server with http://localhost/Reports$sqlexpress. That was not correct, or is not correct with SP2. So I am wondering if they changed the allowed formats too. Thanks for the info.

Michael

cannot generate SSPI context on Win XP machine

I am running sql server 2005 developper edition on a Windows XP Sp2 machine
that is part of a domain.
I am getting the cannot generate SSPI context error when I am trying to
connect via integrated security. I can connect using username and password.
I looked at the docs but found that the setspn utility is only for servers
(w2k w2003 etc). How do I fix this problem on a Windows XP machine.
Thanks for any help
Bob
Trying to connect from what client to what server using
integrated security? Is this a local connection - just
connecting to the SQL Server on your machine?
Are the services running under a domain account or a built
in account?
-Sue
On Thu, 3 May 2007 12:39:59 -0400, "Robert Dufour"
<bdufour@.sgiims.com> wrote:

>I am running sql server 2005 developper edition on a Windows XP Sp2 machine
>that is part of a domain.
>I am getting the cannot generate SSPI context error when I am trying to
>connect via integrated security. I can connect using username and password.
>I looked at the docs but found that the setspn utility is only for servers
>(w2k w2003 etc). How do I fix this problem on a Windows XP machine.
>Thanks for any help
>Bob
>

cannot generate SSPI context on Win XP machine

I am running sql server 2005 developper edition on a Windows XP Sp2 machine
that is part of a domain.
I am getting the cannot generate SSPI context error when I am trying to
connect via integrated security. I can connect using username and password.
I looked at the docs but found that the setspn utility is only for servers
(w2k w2003 etc). How do I fix this problem on a Windows XP machine.
Thanks for any help
BobTrying to connect from what client to what server using
integrated security? Is this a local connection - just
connecting to the SQL Server on your machine?
Are the services running under a domain account or a built
in account?
-Sue
On Thu, 3 May 2007 12:39:59 -0400, "Robert Dufour"
<bdufour@.sgiims.com> wrote:

>I am running sql server 2005 developper edition on a Windows XP Sp2 machine
>that is part of a domain.
>I am getting the cannot generate SSPI context error when I am trying to
>connect via integrated security. I can connect using username and password.
>I looked at the docs but found that the setspn utility is only for servers
>(w2k w2003 etc). How do I fix this problem on a Windows XP machine.
>Thanks for any help
>Bob
>