Home All Groups Group Topic Archive Search About

Tools fail unless all SQL2005 installed on c: drive

Author
29 Jan 2007 10:12 PM
Jmc
We have done about a dozen installs of SQL2005 in labs and in production and
found that the tools work only if every component is installed on C:.  On
several production servers, we need to have the database on a large drive
other than C:, but when the "data" portion is installed on d:, the tools like
Surface Area Configuration fail.

The following popup occurs in the latter case: "Specified argument was out
of the range of valid values.  Parameter name:(System.Windows.Forms)

The Security log has the following failure audit:
Object Open:
    Object Server:    SC Manager
    Object Type:    SERVICE OBJECT
    Object Name:    ReportServer
    Handle ID:    -
    Operation ID:    {0,19352350}
    Process ID:    608
    Image File Name:    C:\WINDOWS\system32\services.exe
    Primary User Name:    MG1-SCDW$
    Primary Domain:    SERVICE
    Primary Logon ID:    (0x0,0x3E7)
    Client User Name:    NETWORK SERVICE
    Client Domain:    NT AUTHORITY
    Client Logon ID:    (0x0,0x3E4)
    Accesses:    Query service configuration information
            Query status of service
            Query information from service

    Privileges:    -
    Restricted Sid Count:    0
    Access Mask:    0x85

Identical errors appear for these objects: MSSQLServerOLAPService, MSSQLSERVER

--
Jmc

Author
29 Jan 2007 11:16 PM
Erland Sommarskog
Jmc (J**@discussions.microsoft.com) writes:
> We have done about a dozen installs of SQL2005 in labs and in production
> and found that the tools work only if every component is installed on
> C:.  On several production servers, we need to have the database on a
> large drive other than C:, but when the "data" portion is installed on
> d:, the tools like Surface Area Configuration fail.
>
> The following popup occurs in the latter case: "Specified argument was out
> of the range of valid values.  Parameter name:(System.Windows.Forms)

Have you filed a bug for this on http://connect.microsoft.com? If not,
you should do it. It sounds as if it is reproducible.

There is a way to force the entire install of the root disk: you can
change the setting for ProgramFilesDir and maybe also CommonFilesDir
in the registy. I don't know if this is supported though. You will
still take a tool on the system disk for all the Installer files.
Particularly the service packs put a lot of stuff there.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button