error handling flow: installation

Showing posts with label installation. Show all posts

Thursday, March 29, 2012

Error Installing Workstation Components SQL 2005 Enterprise

Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:

EventType: sql90setup

P1: installtoolsaction

P2: 0xc0000006

P3: 0x78158a35

P4: 0xc0000006

P5: setup_sqlactionenginelistener.cpp@.198

P6: setup.exe@.2005.90.1399.0

P7: none

This happens after the second disk of the installation is about halfway through installing and then it throws an error stating that "The wrong volume is in the drive. Please insert volume SQLSRVRS into drive D. Cancel, Try Again, Continue" I replace the disc with the first disc and if I pick "Continue" it will display the error above. If I pick "Try again" the installation finishes, but there are components missing from Visual Studio.

Here is the log file:

=== Verbose logging started: 3/16/2006 14:03:49 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (58:00) [14:03:49:483]: Resetting cached policy values
MSI (c) (58:00) [14:03:49:483]: Machine policy value 'Debug' is 0
MSI (c) (58:00) [14:03:49:483]: ******* RunEngine:
******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Setup\SqlRun_Tools.msi
******* Action:
******* CommandLine: **********
MSI (c) (58:00) [14:03:49:483]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (58:00) [14:03:49:483]: Grabbed execution mutex.
MSI (c) (58:00) [14:03:49:483]: Cloaking enabled.
MSI (c) (58:00) [14:03:49:483]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (58:00) [14:03:49:483]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (D4:80) [14:03:49:499]: Grabbed execution mutex.
MSI (s) (D4:BC) [14:03:49:499]: Resetting cached policy values
MSI (s) (D4:BC) [14:03:49:499]: Machine policy value 'Debug' is 0
MSI (s) (D4:BC) [14:03:49:499]: ******* RunEngine:
******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Setup\SqlRun_Tools.msi
******* Action:
******* CommandLine: **********
MSI (s) (D4:BC) [14:03:49:499]: Note: 1: 2203 2: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Setup\SqlRun_Tools.msi 3: -2147287037
MSI (s) (D4:BC) [14:03:49:499]: MainEngineThread is returning 3
MSI (c) (58:00) [14:03:49:499]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (58:00) [14:03:49:499]: MainEngineThread is returning 3
=== Verbose logging stopped: 3/16/2006 14:03:49 ===

Thank you very much,

Did you get this solved? I don't think this is a known issue. Possibly it's a bad disk. If you're still blocked by this please either file a bug or post a link to your complete setup logs.

Thanks,

Paul

|||If you want to install only client components, start setup from disc 2. That should fix the problem. I saw this error message commented somewhere, it is even worse when you use unattended setup from CD1 for client components only.|||

I think there is a problem with the disc because I was able to install the Workstation Components from the Developer disc that came with VS .NET 2005 on the same machines. I guess we will need to send them back for new discs.

Thanks!

|||We also ran into this problem with our Visual Studio 2005 CDs. The statement that you can run the set-up from the second CD only doesn't resolve the problem either. I will have to contact Microsoft regarding this problem though. I haven't been able to prevent this from occurring as of yet.|||

I also got this error. This is how I was able to complete the installation.

I just restarted installation using disk 1 and selected only workstation components to install. It asked for disk 2 and the it completed the installation. At the end of the installation again I got that error popped up but it's ok the SQL Server installation is fine and complete.

cool - Ashok Ojha

|||I also got this problem and solved installing the Client Components from the second cd

Error Installing Workstation Components SQL 2005 Enterprise

Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:

EventType: sql90setup

P1: installtoolsaction

P2: 0xc0000006

P3: 0x78158a35

P4: 0xc0000006

P5: setup_sqlactionenginelistener.cpp@.198

P6: setup.exe@.2005.90.1399.0

P7: none

Here is the log file:

Thank you very much,

Did you get this solved? I don't think this is a known issue. Possibly it's a bad disk. If you're still blocked by this please either file a bug or post a link to your complete setup logs.

Thanks,

Paul

Thanks!

I also got this error. This is how I was able to complete the installation.

cool - Ashok Ojha

|||I also got this problem and solved installing the Client Components from the second cd

Error Installing Workstation Components SQL 2005 Enterprise

Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:

EventType: sql90setup

P1: installtoolsaction

P2: 0xc0000006

P3: 0x78158a35

P4: 0xc0000006

P5: setup_sqlactionenginelistener.cpp@.198

P6: setup.exe@.2005.90.1399.0

P7: none

Here is the log file:

Thank you very much,

Did you get this solved? I don't think this is a known issue. Possibly it's a bad disk. If you're still blocked by this please either file a bug or post a link to your complete setup logs.

Thanks,

Paul

Thanks!

I also got this error. This is how I was able to complete the installation.

cool - Ashok Ojha

|||I also got this problem and solved installing the Client Components from the second cd

Error Installing Workstation Components SQL 2005 Enterprise

Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:

EventType: sql90setup

P1: installtoolsaction

P2: 0xc0000006

P3: 0x78158a35

P4: 0xc0000006

P5: setup_sqlactionenginelistener.cpp@.198

P6: setup.exe@.2005.90.1399.0

P7: none

Here is the log file:

Thank you very much,

Did you get this solved? I don't think this is a known issue. Possibly it's a bad disk. If you're still blocked by this please either file a bug or post a link to your complete setup logs.

Thanks,

Paul

Thanks!

I also got this error. This is how I was able to complete the installation.

cool - Ashok Ojha

|||I also got this problem and solved installing the Client Components from the second cdsql

Tuesday, March 27, 2012

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Hi,

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

Help would be appreciated... thanks.

Regards,

Ravindranath Kini

Other than Sql server 2005 enterprise edition you can install everything with Windows 2000 SP..........can you provide the details available in Summary.txt file available in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG.

Refer the system requirements http://technet.microsoft.com/en-us/library/ms143506.aspx

|||

SQLServer2005SP2-KB921896-x86-ENU.exe is service pack only. Did you installed SQL Server 2005 on your computer? Moreover, this service pack doesn't support SQL Server 2005 Express Edition (Microsoft SQL Server 2005 Service Pack 2 http://www.microsoft.com/downloads/details.aspx?FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en). For SQL Server 2005 Express Edition SP2, please download from http://msdn2.microsoft.com/en-us/express/bb410792.aspx.

|||

Deepak,

The details of Summary.txt are available here.

Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Uninstall : Successful , Reboot required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0004_BNGWIP-D-99927_SQLSupport_1.log
--
Product : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Uninstall : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0004_BNGWIP-D-99927_MSXML6_1.log
--
Setup succeeded with the installation, inspect the log file completely for status on all the components.

Time : Tue Aug 21 12:08:04 2007

The setup is installing only MSXML6. It is not installing the SQL Server 2005.

Warren,

I am trying to install SP2 directly witout installing the SQL server 2005 base version. Will it not work?

Thanks for the replies,

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Hi,

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

Help would be appreciated... thanks.

Regards,

Ravindranath Kini

Refer the system requirements http://technet.microsoft.com/en-us/library/ms143506.aspx

|||

Deepak,

The details of Summary.txt are available here.

Time : Tue Aug 21 12:08:04 2007

The setup is installing only MSXML6. It is not installing the SQL Server 2005.

Warren,

I am trying to install SP2 directly witout installing the SQL server 2005 base version. Will it not work?

Thanks for the replies,

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Hi,

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

Help would be appreciated... thanks.

Regards,

Ravindranath Kini

Refer the system requirements http://technet.microsoft.com/en-us/library/ms143506.aspx

|||

Deepak,

The details of Summary.txt are available here.

Time : Tue Aug 21 12:08:04 2007

The setup is installing only MSXML6. It is not installing the SQL Server 2005.

Warren,

I am trying to install SP2 directly witout installing the SQL server 2005 base version. Will it not work?

Thanks for the replies,

Error installing SQL Server 2005 Express

I hope someone can help me with this issue. Thanks very much.

At the end of installation I get the summary screen showing that:

SQL Setup Support Files - Setup failed...

SQL Native Files - Setup failed...

SQL Server Database Services - Setup failed...

I am enclosing some of the log file SQLSetup0002_*_Core(Local).log where the errors start:

Action "InstallSqlAction" will return false due to the following preconditions:
Condition "Action: InstallSqlAction.11 has finished and failed." returned true.
Condition "Action: InstallSqlAction.12 has finished and failed." returned true.
Installation of package: "sql" failed due to a precondition.
Step "InstallSqlAction" was not able to run.
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run. Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result.
Skipped: InstallToolsAction
Skipped: Action "InstallToolsAction" was not run. Information reported during analysis:
No install request found for package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run. Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2006/2/25 10:2:22
-

Thanks very much.

I'm moving this to the Setup form for more expert help.

Mike

|||

try to look at my post.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=318735&SiteID=1&mode=1

Error installing SQL 2005 Reporting Services September CTP

When installing the September SQL 2005 CTP, the installation of
Reporting Services fails with the message: "The setup has encountered
an unexpected error while Setting reporting service and share point
exclusion path. The error is: Fatal error during installation."
Here's the section from the log:
---
<Func Name='LaunchFunction'>
Function=Do_RSSetSharePointExclusionPath
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_RSSetSharePointExclusionPath
PerfTime Start: Do_RSSetSharePointExclusionPath : Thu Oct 06 12:48:54
2005
<Func Name='Do_RSSetSharePointExclusionPath'>
Error Code: 0x80077374 (29556)
Windows Error Text: Source File Name: sqlca\sqliisca.cpp
Compiler Timestamp: Tue Aug 30 21:43:12 2005
Function Name: Do_RSSetSharePointExclusionPath
Source Line Number: 840
Error Code: 29556
MSI (s) (88!68) [12:57:42:934]: Product: Microsoft SQL Server 2005
Reporting Services CTP -- Error 29528. The setup has encountered an
unexpected error while Setting reporting service and share point
exclusion path. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while
Setting reporting service and share point exclusion path. The error is:
Fatal error during installation.
--
Sharepoint (not sure if that's what is referred to by "share point" up
above) is installed and working on the box in question. Any thoughts?
KenWell, I appear to have worked around it by uninstalling SharePoint
(both the "portal" and the "services" flavors). I reran setup, and it
worked that time. Luckily I didn't need SP on this box (yeah, yeah,
and it's still beta . . . )
Ken|||On 6 Oct 2005 13:11:22 -0700, smithkl42@.hotmail.com wrote:
>When installing the September SQL 2005 CTP, the installation of
>Reporting Services fails with the message: "The setup has encountered
>an unexpected error while Setting reporting service and share point
>exclusion path. The error is: Fatal error during installation."
>Here's the section from the log:
>---
><Func Name='LaunchFunction'>
>Function=Do_RSSetSharePointExclusionPath
><Func Name='GetCAContext'>
><EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
>Doing Action: Do_RSSetSharePointExclusionPath
>PerfTime Start: Do_RSSetSharePointExclusionPath : Thu Oct 06 12:48:54
>2005
><Func Name='Do_RSSetSharePointExclusionPath'>
> Error Code: 0x80077374 (29556)
>Windows Error Text: Source File Name: sqlca\sqliisca.cpp
>Compiler Timestamp: Tue Aug 30 21:43:12 2005
> Function Name: Do_RSSetSharePointExclusionPath
>Source Line Number: 840
>
>Error Code: 29556
>MSI (s) (88!68) [12:57:42:934]: Product: Microsoft SQL Server 2005
>Reporting Services CTP -- Error 29528. The setup has encountered an
>unexpected error while Setting reporting service and share point
>exclusion path. The error is: Fatal error during installation.
>
>Error 29528. The setup has encountered an unexpected error while
>Setting reporting service and share point exclusion path. The error is:
>Fatal error during installation.
>--
>Sharepoint (not sure if that's what is referred to by "share point" up
>above) is installed and working on the box in question. Any thoughts?
>Ken
Ken,
I tried a few times to get Reporting Services 2005 and Windows
SharePoint Services 2 working on the same box and failed with earlier
builds.
The specific problem you are seeing, I guess, is that say
http://localhost/reports and http://localhost/reportserver need to be
excluded paths (if I remember the terminology correctly in WSS2) on a
SharePoint server.
You need to find the Managed Paths screen to create the excluded
paths.
That's the first step, I think.
Andrew Watt
MVP - InfoPath

Monday, March 26, 2012

error installing sp2

We have a reporting server with SP1.
We tried to install SP2 while we were logged in with the domain admin account.
The installation program says 'please wait while windows configures
microsoft sql server 2000 reporting services enterprise edition' then we get
the error
'Failure modifying security permissions on file c:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\RSTempFiles for user ...
Anyone any idea ?Franky,
Are you using a user account for the ReportServer windows services? In that
case, change the startup option for the service to use a LocalSystem account,
stop the service and then try to install the SP2. When the SP2 installation
program ends, go back to the service properties and change back the account.
Finnally restart your server.
Regards
"Franky" wrote:
> We have a reporting server with SP1.
> We tried to install SP2 while we were logged in with the domain admin account.
> The installation program says 'please wait while windows configures
> microsoft sql server 2000 reporting services enterprise edition' then we get
> the error
> 'Failure modifying security permissions on file c:\Program Files\Microsoft
> SQL Server\MSSQL\Reporting Services\RSTempFiles for user ...
> Anyone any idea ?

Error Installing Reporting Services

I attempt to run the Reporting Services installation and
get and on the screen right after the license agreement, I
get a message that says just "Error!" and I cannot
continue. Is there a log file somewhere I can look at -
nothing was installed so no directory exists on the hard
disk. I am running Windows 2000, .NET 1.1 framework, and
SQL Server 2000 Development with latest service pack.Here is the contents of a file I found in the temp
directory that appears to have an error at the bottom:
Microsoft SQL Server 2000 Reporting Services Setup
beginning at Mon Sep 13 09:50:33 2004
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='WindowsInstallerComp::Init'>
.
.
.
QuietMode=false
Unattended=false
WorkDir=H:
}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:
292}
<Func Name='SqlSetupFilesComp::Install'>
SqlSetupFilesComp WNetGetUniversalName() returned : (1201)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:
449}
SCU_SetupMgr::svc() caught exception: SqlSetupFilesComp
WNetGetUniversalName() returned : (1201)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:
449}. SetupMgr: state=ERROR, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=H:
QuietMode=false
Unattended=false
WorkDir=H:
}}
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:
428}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting
for setup mgr
<EndFunc Name='UpdateComponents' Return='1602'
GetLastError='1400'>

Error Installing MSDE2000 Relase A

Hi there, This is the new installation of MSDE2000 Release A locally on the
Windows XP SP1 professional (Laptop). Never got it through the installation.
I have checked all the conditions in the Readme file, and they were met.
This is the log file:
2005-10-27 12:01:17.09 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2005-10-27 12:01:17.09 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-10-27 12:01:17.09 server All rights reserved.
2005-10-27 12:01:17.09 server Server Process ID is 2412.
2005-10-27 12:01:17.09 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2005-10-27 12:01:17.10 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2005-10-27 12:01:17.12 server SQL Server configured for thread mode
processing.
2005-10-27 12:01:17.12 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-10-27 12:01:17.12 spid3 Warning ******************
2005-10-27 12:01:17.12 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2005-10-27 12:01:17.13 spid3 Starting up database 'master'.
2005-10-27 12:01:17.35 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-10-27 12:01:17.35 spid5 Starting up database 'model'.
2005-10-27 12:01:17.37 server SQL server listening on 162.130.191.154:
1433.
2005-10-27 12:01:17.37 server SQL server listening on 127.0.0.1: 1433.
2005-10-27 12:01:17.37 spid3 Server name is 'HDQRKPC404445'.
2005-10-27 12:01:17.37 spid3 Skipping startup of clean database id 5
2005-10-27 12:01:17.37 spid3 Skipping startup of clean database id 6
2005-10-27 12:01:17.37 spid3 Starting up database 'msdb'.
2005-10-27 12:01:17.40 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2005-10-27 12:01:17.40 server SQL Server is ready for client connections
2005-10-27 12:01:17.50 spid5 Clearing tempdb database.
2005-10-27 12:01:18.12 spid5 Starting up database 'tempdb'.
2005-10-27 12:01:18.24 spid3 Recovery complete.
2005-10-27 12:01:18.24 spid3 SQL global counter collection task is
created.
2005-10-27 12:01:18.30 spid3 Warning: override, autoexec procedures
skipped.
2005-10-27 12:01:27.40 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
This is the cnfgsvr.out:
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=HDQRKPC404445;UID=sa;PWD=;database= master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=HDQRKPC404445;UID=sa;PWD=;database= master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=HDQRKPC404445;UID=sa;PWD=;database= master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
SQL Server configuration failed.
_____________
Please advice. Thanks
hi,
TomN wrote:
> Hi there, This is the new installation of MSDE2000 Release A locally
> on the Windows XP SP1 professional (Laptop). Never got it through
> the installation. I have checked all the conditions in the Readme
> file, and they were met. This is the log file:

> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> SQL Server configuration failed.
try fixing (or reinstalling) your MDAC stack...
http://msdn.microsoft.com/data/mdac/default.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Wednesday, March 21, 2012

Error in sql server 2005 developer edition.

Previously I have posted for the step of installation

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=312644&SiteID=1

I have just installed sql server 2005 developer edition.

After installation is completed when I open sql server management studio I am gwetting Following error.What can I do.

The error is

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Unable to cast object of type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization' to type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization'.
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization.LoadFromDisk()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization.get_Instance()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization.GetCountByCategory(String category)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs e)
at Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs e)
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
AppIDPackage
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
Microsoft.SqlServer.SqlTools.VSIntegration
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
-
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
-
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
Microsoft.SqlServer.SqlTDiagM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
-
Microsoft.DataWarehouse.SQM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
-
Microsoft.SqlServer.Instapi
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
-
ObjectExplorer
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
-
ConnectionDlg
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
-
SqlWorkbench.Interfaces
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
-
Microsoft.SqlServer.CustomControls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
-
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
-
SqlMgmt
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
-
Microsoft.SqlServer.Express.ConnectionDlg
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionDlg.DLL
-
Microsoft.SqlServer.RegSvrEnum
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
-
EnvDTE
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
-
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
-
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
-
Microsoft.SqlServer.ConnectionInfo
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

What Can I do

Hey Kamran,

I'm moving this thread to the Tools General forum so that the experts there can help you.

Thanks,

-Jeffrey

|||

I've seen this when Management Studio loads preferences from the express version and vice-versa. Do you have Management Studio Express installed on the same machine by any chance?

|||

I had the same problem until I removed Management Studio Express... thanks!

|||Yes That Were The Also the Problem.

Error in sql management express installation

Hi,

I had earlier installation of microsoft sql server 2005 in my machine. Recently I installed the visual studio 2005 beta which comes with sql express and after going through many hoops(as it kept complaining about the previous installation of beta components) i was able to install it correctly. I was also able to also use visaul studio 2005 server explorer to connect to the SQLEXPRESS and create table etc... Now I wanted to install sql server management express so I downloaded SQLEXPR_ADV from te microsoft's website. During the installation it complained about the older version of SQL server management sutdio installed and hence could not install the sql server management express. By looking at different forums I found following steps to deinstall earlier version but still runs into this issue. I will really appreciate somebody's help....

STPES I FOLLOWED TO REMOVE EARLIER VERSION OF SQL SERVER 2005 MANAGEMENT STUDIO

Click Start, and then click Control Panel.
Double-click Add or Remove Programs.
In the list of installed programs, click Microsoft SQL Server 2005, and then click Change.
On the Component Selection page, select Workstation components, and then click Next.
Click Next.
On the Change or Remove Instance page, click Change Installed Components.
Expand Client Components, click Management Tools, and then select Entire Feature will be Unavailable. Or just select the entire client components
Click Next.
Click Install.

2) I also tried to use the complete uninstall of visual studio ( By using the tolls

vs_unists_betas.exe) and after that also window uninstall clean up (msiccu2)

and then reinstalling visual studio 2005 beta which would install sql express...But

nothing seems to be able to uninstall the previous version of SQL SERVER 2005

Management studio from my computer and hence I am not able to uninstall the

sql server management express.

hi,

try having a look at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=907736&SiteID=1 as well

regards

sql

Error in SQL 2005 cluster installation

I am trying to install SQL 2005 in a 2-node Windows 2003 cluster. I have tried both upgrade and fresh installation, but got same error. The error stops the installation while checking system configuration after installing prerequisites. Any idea ? The log file entry is as follows:

*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastore\clusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
-
Failed to detect VS info due to datastore exception.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
-
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

Hi,

Did you resolve this? I have run into the same error and am unsure how to proceed.

Any advice would be warmly received.

Regards,

Rob.

Error in SQL 2005 cluster installation

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

Do you have admin shares disabled on the cluster nodes? If they're disabled, it can cause all kinds of problems with clustered SQL installation.|||

Hello we have faced the same problem. Using your problem desciption helped us find the drive letter which is not configured correctly.

In our case the drive letter was used by a previous de installed SQL Server configuration. The de install was not completed as it should. To solve the problem, we removed the MSSQL.x (x is a number between 1 and 100) containing sub keys with a value point to the drive missing. You can find these MSSQL.x keys in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

Kind regards

Marcel

sql

Error in SQL 2005 cluster installation

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

Do you have admin shares disabled on the cluster nodes? If they're disabled, it can cause all kinds of problems with clustered SQL installation.|||

Hello we have faced the same problem. Using your problem desciption helped us find the drive letter which is not configured correctly.

In our case the drive letter was used by a previous de installed SQL Server configuration. The de install was not completed as it should. To solve the problem, we removed the MSSQL.x (x is a number between 1 and 100) containing sub keys with a value point to the drive missing. You can find these MSSQL.x keys inHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

Kind regards

Marcel

Error in SQL 2005 cluster installation

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

Do you have admin shares disabled on the cluster nodes? If they're disabled, it can cause all kinds of problems with clustered SQL installation.|||

Hello we have faced the same problem. Using your problem desciption helped us find the drive letter which is not configured correctly.

Kind regards

Marcel

Sunday, March 11, 2012

Error in MSDE setup

When I install MSDE, I am getting an error and the installation stops. In
the log file that is created it looks like this:
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
"SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
Action ended 10:31:21: InstallFinalize. Return value 3.
When I look in the server log, it gives me the same message. "Refer to the
server error logs and setup error logs for more information." Big help!
My setup.ini file looks like this:
[Options]
INSTANCENAME = "CDC"
SAPWD = "CDC2003"
I checked the Windows event log and found this:
The MSSQL$CDC service failed to start due to the following error:
MSSQL$CDC is not a valid Win32 application.
I think this is the problem, but have no idea what is going on or how to fix
this.
Any ideas?
Thanks
LanceTurns out there is a problems with some MS products that if there is a file
on the root of C drive called "Program" then it fails when it trys to start
the service.
Lance
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:uiWTb.7265$IF1.3090@.fed1read01...
> When I install MSDE, I am getting an error and the installation stops. In
> the log file that is created it looks like this:
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
> "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> Action ended 10:31:21: InstallFinalize. Return value 3.
> When I look in the server log, it gives me the same message. "Refer to the
> server error logs and setup error logs for more information." Big help!
> My setup.ini file looks like this:
> [Options]
> INSTANCENAME = "CDC"
> SAPWD = "CDC2003"
> I checked the Windows event log and found this:
> The MSSQL$CDC service failed to start due to the following error:
> MSSQL$CDC is not a valid Win32 application.
> I think this is the problem, but have no idea what is going on or how to
fix
> this.
> Any ideas?
> Thanks
> Lance
>

Error in MSDE setup

quote:

> When I install MSDE, I am getting an error and the installation stops. In
> the log file that is created it looks like this:
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
> "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> Action ended 10:31:21: InstallFinalize. Return value 3.
> When I look in the server log, it gives me the same message. "Refer to the
> server error logs and setup error logs for more information." Big help!
> My setup.ini file looks like this:
> [Options]
> INSTANCENAME = "CDC"
> SAPWD = "CDC2003"
> I checked the Windows event log and found this:
> The MSSQL$CDC service failed to start due to the following error:
> MSSQL$CDC is not a valid Win32 application.
> I think this is the problem, but have no idea what is going on or how to

fix

quote:

> this.
> Any ideas?
> Thanks
> Lance
>

Thursday, March 29, 2012

Error Installing Workstation Components SQL 2005 Enterprise

Error Installing Workstation Components SQL 2005 Enterprise

Error Installing Workstation Components SQL 2005 Enterprise

Error Installing Workstation Components SQL 2005 Enterprise

Tuesday, March 27, 2012

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Error installing SQL Server 2005 Express

Error installing SQL 2005 Reporting Services September CTP

Monday, March 26, 2012

error installing sp2

Error Installing Reporting Services

Error Installing MSDE2000 Relase A

Wednesday, March 21, 2012

Error in sql server 2005 developer edition.

Error in sql management express installation

Error in SQL 2005 cluster installation

Error in SQL 2005 cluster installation

Error in SQL 2005 cluster installation

Error in SQL 2005 cluster installation

Sunday, March 11, 2012

Error in MSDE setup

Error in MSDE setup

error handling flow

Blog Archive

About Me