Hi !
How to avoid a SQL Native Client Instalation (a corrupted package ? from MSDN Disc !?) during MS SQL 2005 Server Standard instalation on MS Windows Vista Ultimate RC1 ?!?
Generally after this error all instalation failed !
Thanks in advance.
Hi,
I am getting the following error:
0:Watson 1:1304 2treamSupportFiles 3treamBinaryToDisk
4:5 5:tyukonsqlsetupdarwinsqlcastubstreamca.cpp 6:238
7qlcastub.dll 8qlrun.msi
While installing "SqlRunTools.msi" on a Microsoft SQL Server 2005 Developer's Edition Disc 2 on Windows Vista Ultimate.
I am trying to install the Sql Server 2005 Client Tools, Enterprise Manager, Query Analyzer, on Windows Vista Ultimate.
Any ideas as to what is causing this error and how to fix it?
Thanks,
Mark
I am trying to install SQL Server Express - (the non ADV version) and get the following error.
"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'".
I have 64 bit Vista Ultimate running on an HP dv9000.
I am using the download from the bottom of the download page for SSX where it says 64 bit version.
Prior to this I got the. "64-bit ASP.net is registered. Required 32-bit ASP.NET to install Microsoft Reporting services 2005(32-bit)." messagd during the pre-install scan. From what I gather in the posts, the reporting issue is different from my installation package problem.
I have been trying to prove a point to friends about how far you can go with SSX but am having no luck installing it. This whole process took 1 hour in XP but I've been stymied for 2 days.
I would appreciate being pointed at the right downloads for what seems to be a simple install.
Whenever I try to install SQL Server 2005 Express Edition on my Vista Ultimate x64 platform I get error 29506. All I could find on the web was that this is probably due to an access control problem. I have tried installing it as the local administrator, as a member of domain admins, and as the domain administrator. All get the same error. My domain is a Small Business Server domain. This may be part of the problem, but I can't imagine how.
When trying to force access to the domain administrator, I also seem to get an access problem.
Any suggestions?
I am tring to install SQL standard edition on a laptop with vista ultermate, I have ISS 7 instaled and active (test by http:\localhost)
but when SQL install does is system check it reports that ISS is not install or not enabled, hence the rest of the installation fails
also get a error 1706
Can someone help please
Hi all,
I'm trying to install just the client components of SQL 2005 on my clean Vista Ultimate machine and am not having a great deal of luck. From what I can see in this forum I'm not the only one. I apologise if this post is going over old ground but none of the other threads quite deal with my query so here goes.
I'm installing from a SQL 2005 Dev DVD. Compatibility checks are being passed fine but once the actual installation starts I get an OWC 11 failure followed by workstation components etc failure. None of the workstation tools are installed. I have tried installing OWC 11 but because I am using Office 2007 it won't let me do it. I can't understand why OWC should cause a failure of the workstation tools installation.
The intention is to use the Vista box as a development client with VS 2005 to work on a Windows 2003 server hosting SQL 2005 Enterprise.
I would really apreciate a steer on this one as I am close to abandoning Vista and going back to XP Pro which would be a real shame.
Many thanks
Nick Bowling
Does anyone know if this is a SQL Native Client bug? I've read a previous thread (posted back on Jan. 18th, 2007) about this error, but there are no replies. I am getting this error when I issue the sp_setapprole command using sqlexecdirect() ODBC api call. Is there any way to work around this? Or is there a fix to the SQL Native Client? The error 15002 message text states "The procedure sys.sp_setapprole cannot be executed within a transaction". This is on a new connection so there should be no transactions active at the time. Thanks in advance for any info anyone can provide on this.
View 5 Replies View Related
Hey All,
I have a notbook with vista ultimate and i am trying to install sql server 2005 (developers edition ) on it. The setup fails during the installation giving the message thaht the database service didnot start succesfully. I ahve tried a number of solutions for the issue but all in vain. The user i am using to install the server is an admin user.Plus i am very sure taht there are no h/w dependencies taht are causing the problem.
Can some one please help me . I have been banging my head withteh issue for the past 4-5 days and some some will be reallyy appreciated
========================A section of the SQL.Log file==============================
<EndFunc Name='Do_sqlServiceSDDL' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlServiceSDDL : Thu Aug 23 16:25:37 2007
MSI (s) (8C:14) [16:25:37:484]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:37:486]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof)
MSI (s) (8C:70) [16:25:37:491]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7517.tmp, Entrypoint: Do_sqlMofcomp
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:37 2007
<Func Name='InstallMOF'>
MOF data compiled from C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof
<EndFunc Name='InstallMOF' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:39 2007
MSI (s) (8C:14) [16:25:39:605]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:39:607]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL Server90SharedResources1033sqlmgmprovider.mfl)
MSI (s) (8C:2C) [16:25:39:612]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7D61.tmp, Entrypoint: Do_sqlMofcomp
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:39 2007
<Func Name='InstallMOF'>
MOF data compiled from C:Program FilesMicrosoft SQL Server90SharedResources1033sqlmgmprovider.mfl
<EndFunc Name='InstallMOF' Return='0' GetLastError='14007'>
PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:40 2007
MSI (s) (8C:14) [16:25:40:091]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='14007'>
MSI (s) (8C:14) [16:25:40:093]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof)
MSI (s) (8C:CC) [16:25:40:098]: Invoking remote custom action. DLL: C:WindowsInstallerMSI7F46.tmp, Entrypoint: Do_sqlMofcomp
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:40 2007
<Func Name='InstallMOF'>
MOF data compiled from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof
<EndFunc Name='InstallMOF' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:42 2007
MSI (s) (8C:14) [16:25:42:371]: Executing op: ActionStart(Name=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:42:373]: Executing op: CustomActionSchedule(Action=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_sqlMofcomp,CustomActionData=010Installing WMI registration50000\.
ootMicrosoftSqlServerServerEventsMSSQLSERVERC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnsqlwep-uni.mof)
MSI (s) (8C:14) [16:25:42:374]: Executing op: ActionStart(Name=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
MSI (s) (8C:14) [16:25:42:375]: Executing op: CustomActionSchedule(Action=Do_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlMofcomp,CustomActionData=110Installing WMI registration100000C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnetwcls.mof)
MSI (s) (8C:2C) [16:25:42:380]: Invoking remote custom action. DLL: C:WindowsInstallerMSI882D.tmp, Entrypoint: Do_sqlMofcomp
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Thu Aug 23 16:25:42 2007
<Func Name='InstallMOF'>
MOF data compiled from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnetwcls.mof
<EndFunc Name='InstallMOF' Return='0' GetLastError='14007'>
PerfTime Stop: Do_sqlMofcomp : Thu Aug 23 16:25:47 2007
MSI (s) (8C:14) [16:25:47:173]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='14007'>
MSI (s) (8C:14) [16:25:47:230]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerServerEvents(A;CI;CCDCLCSWRPWPRCWD;;;BA))
MSI (s) (8C:A4) [16:25:47:236]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9B21.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerServerEvents
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)
<Func Name='SecureWMINamespace'>
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007
MSI (s) (8C:14) [16:25:47:286]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:47:288]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerServerEventsMSSQLSERVER(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CCDCRC;;;[SQLServer2005SQLAgentUser$ADNAN-PC$MSSQLSERVER]))
MSI (s) (8C:4C) [16:25:47:292]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9B61.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerServerEventsMSSQLSERVER
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CCDCRC;;;S-1-5-21-3043782012-3745310101-388358720-1076)
<Func Name='SecureWMINamespace'>
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007
MSI (s) (8C:14) [16:25:47:348]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:47:349]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerComputerManagement(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD))
MSI (s) (8C:40) [16:25:47:354]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9BA0.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Thu Aug 23 16:25:47 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerComputerManagement
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)
<Func Name='SecureWMINamespace'>
No need to protect the namespace security
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Thu Aug 23 16:25:47 2007
MSI (s) (8C:14) [16:25:47:387]: Executing op: ActionStart(Name=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:47:389]: Executing op: CustomActionSchedule(Action=CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=AddCertificate,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn)
MSI (s) (8C:54) [16:25:47:394]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9BD0.tmp, Entrypoint: AddCertificate
FTECa.DLL: INFO: FTE: AddCertificate(), Entering...
FTECa.DLL: INFO: FTE: AddCertificate: CustomActionData: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn
MSI (s) (8C:14) [16:25:47:452]: Executing op: ActionStart(Name=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: AddCertificate: Succeeded. Added Certificate from C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll
MSI (s) (8C:14) [16:25:47:453]: Executing op: CustomActionSchedule(Action=CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=InstallPerfCounters,CustomActionData=C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn
MSI (s) (8C:14) [16:25:47:458]: Invoking remote custom action. DLL: C:WindowsInstallerMSI9C0F.tmp, Entrypoint: InstallPerfCounters
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Entering...
FTECa.DLL: INFO: InstallPerfCounters: CustomActionData: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn:
FTECa.DLL: INFO: InstallPerfCounters: Instance name obtained:
FTECa.DLL: INFO: InstallPerfCounters: Instance home path: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn
FTECa.DLL: INFO: Setting acls on C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll
FTECa.DLL: INFO: successfully allowed access to PerfLoggingUsers and PerfMonitoringUser on C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnmsfte.dll
FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnfdcntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnifdcntrs.ini, msftesqlFD -> msftesqlFD, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnftecntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniftcntrs.ini, msftesql -> msftesql, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Patching C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnidxcntrs.ini -> C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniindctrs.ini, msftesqlidx -> msftesqlidx, MSFTESQL -> MSFTESQL
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnifdcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniftcntrs.ini have been installed.
FTECa.DLL: INFO: InstallPerfCounters: Perf counters from x "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinniindctrs.ini have been installed.
MSI (s) (8C:14) [16:25:51:273]: Executing op: ActionStart(Name=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,,)
FTECa.DLL: INFO: FTE: InstallPerfCounters(), Exiting...
MSI (s) (8C:14) [16:25:51:274]: Executing op: CustomActionSchedule(Action=CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C,ActionType=1089,Source=BinaryData,Target=SetLaunchPermissions,CustomActionData={68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYSYSTEM)
MSI (s) (8C:78) [16:25:51:279]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAAFE.tmp, Entrypoint: SetLaunchPermissions
MSI (s) (8C:14) [16:25:51:327]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
MSI (s) (8C:14) [16:25:51:329]: Executing op: ProgressTotal(Total=2,Type=1,ByteEquivalent=1300000)
MSI (s) (8C:14) [16:25:51:329]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:330]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.ldf00)
MSI (s) (8C:14) [16:25:51:332]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:333]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.ldf00)
MSI (s) (8C:C4) [16:25:51:338]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB2E.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
MSI (s) (8C:14) [16:25:51:370]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:51:371]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.mdf00)
MSI (s) (8C:14) [16:25:51:373]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:375]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatamssqlsystemresource.mdf00)
MSI (s) (8C:28) [16:25:51:380]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB5E.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
MSI (s) (8C:14) [16:25:51:426]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:51:427]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.ldf00)
MSI (s) (8C:14) [16:25:51:429]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:430]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.ldfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.ldf00)
MSI (s) (8C:04) [16:25:51:435]: Invoking remote custom action. DLL: C:WindowsInstallerMSIAB9D.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
MSI (s) (8C:14) [16:25:51:477]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:51:478]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.mdf00)
MSI (s) (8C:14) [16:25:51:480]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (8C:14) [16:25:51:502]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl1.mdfC:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDatadistmdl.mdf00)
MSI (s) (8C:C0) [16:25:51:508]: Invoking remote custom action. DLL: C:WindowsInstallerMSIABDD.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Thu Aug 23 16:25:51 2007
MSI (s) (8C:14) [16:25:51:526]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (8C:14) [16:25:51:527]: Executing op: CustomActionSchedule(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server30329600lpc:ADNAN-PC)
MSI (s) (8C:14) [16:25:51:528]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])
MSI (s) (8C:14) [16:25:51:532]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (8C:C8) [16:25:51:537]: Invoking remote custom action. DLL: C:WindowsInstallerMSIABFD.tmp, Entrypoint: Do_sqlScript
<Func Name='LaunchFunction'>
Function=Do_sqlScript
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Aug 23 16:25:51 2007
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Aug 23 16:25:51 2007
Service failed unexpectedly (1067)
Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: sqls:ervice:tart
Source Line Number: 301
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQLSERVER
Error Code: 1067
MSI (s) (8C!B0) [16:28:16:318]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
.
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Aug 23 16:28:16 2007
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Aug 23 16:28:16 2007
Service failed unexpectedly (1067)
Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: sqls:ervice:tart
Source Line Number: 301
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQLSERVER
Do_sqlScript
SqlScriptHlpr
Start service MSSQLSERVER
Error Code: 1067
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5520 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 4116 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 2800 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5220 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 532 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5320 could not be cancelled. Error: 1168
MSI (s) (8C:60) [16:28:22:407]: I/O on thread 5836 could not be cancelled. Error: 1168
MSI (s) (8C!B0) [16:28:22:408]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
.
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
.
Hello Everyone,
A've installed Visual Studio 2005, SQL Server 2005 and all the SP's necessary. My Problem is I do not have the possability to install a SQL Server Instance of any kind, therefore it is not possible to start any of the SQL Server 2005 Configuration Tools.
I Get the Warnings during the Installation process:
Edition Change Check
SQl Server Edition Operating System Campatibility
Any help at all is very much appreciated, thanks a lot.
Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
View 78 Replies View RelatedHi,
I have SQL2000 installed as the default instance, and now I'm trying to install SQL 2005 standard edition as a named instance.
I receive this error :
SQL Server could not connect to database service for server configuration.. [SQL Native client] Encryption not supported on the client. However I'm able to install client tools
The setup works fine on other box with the same config : SQL 2000/Windows XP, is there any work around for this issue ?
In my SQL 2000 client network utilty "Force proctocol encryption " is desabled and did not find the setting for SQL 2005 !
Thank you
Ok guys, I am trying to install Sql server 2005 on Vista but I am still stuck with this warning message in the System Configuration Check during Sql server 2K5 installation :
SQL Server Edition Operating System Compatibility (Warning)
Messages
* SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
Now, I know I need to install SP2 but how the hell I am going to install SP2 if Sql server 2005 doesn't install any of the components including Sql server Database services, Analysus services, Reporting integration services( only the workstation component is available for installation)?
Any work around for this issue?
P.S.: I didn't install VS.NET 2005 yet, can this solve the problem?
I am running on Vista Ultimate and Installing Sql Server 2k5 enterprise edition
Thanks.
Just to be clear, I would like to know if a problem I face is due to an error on my part or a limitation on Microsoft's. In my experience (several hours-long installations, removals, reinstallations, using the skuupgrade=1 parameter from the command line, ad nauseum) I have concluded that the best one can do installing SQL Server 2005 Developer Edition from the Visual Studio 2005 Professional Edition package is to get the Express Edition, (actually styled MSSMLBIZ). In particular, what I'm hoping to be able to do is program to a test database that I have from my client, which I was able to do on my XP Professional machine. But on my new Vista Ultimate 64 bit machine (which will only let me install the x64 version of SQL Server 2005), I get an instance that is characterized as SQL Server Express and generates the following error message when I try to attach to the same MDF file to which I was able to attach under my prior, XP-Pro based configuration:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'ZAPHOD42MSSMLBIZ'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft SQL Server, Error: 1827)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=1827&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
===================================================================================
The following is the Help obtained when clicking on the button on the error msg and the references in the error msg:
===================================================================================
Details
ID: Attach database Server
Source: Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText
We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.
--------------------------------------------------------------------------------
Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.
Currently there are no Microsoft Knowledge Base articles available for this specific error or event message. For information about other support options you can use to find answers online, see http://support.microsoft.com/default.aspx.
==================
Details
ID: 1827
Source: MSSQLServer
We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.
Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.
==========End of reproduction of error messages and help text ====================================
The Developer Edition, of course, is supposed to enable us to program to all levels of the database, and I would hate to think it is really crippled in this way, but after uninstalling everything, reinstalling multiple times (devoting several days to the process), it sure beats me how I can overcome this problem short of going back to my old machine. Any definitive answers on this apparent limitation, or useful procedural advice on installation quirks, would be appreciated (and, yes, I've spent a lot of time going through the installation/setup forum -- if the answer is there I can't find it).
Is sql 2005 Developer's EditionVista Ultimate OS an officially supported combination? Or not yet?
TIA,
Barkingdog
While installing SQL Server 2005 Express Edition SP2 or SQL Server 2005 Express Edition with Advanced Services SP2
on Vista Ultimate, I get the error "The feature(s) selected are not valid for this edition of SQL server". Then the installation stops and exist. The only feature selected is Database Services, data files and shared tools.
HELP!
Ive been told that you cant install SQL Server 2000/2005 on anything but a server OS (such as Windows Server 2003). How are people installing this into vista then as Longhorn is far from being released?
When i try and install it into Ultimate, i only get the option to install client tools... which makes sense as the machine isnt a server. Surely people can install SQL Server 2005 in Vista though?
All of the features are green ticked except the OS which has a compatabilty warning (which i expected).
I feel im missing something really simple here....
Cheers
Rob Macnair
I am getting the error message below when installing sql server 2005 dev edition on windows vista ultimate. I just bought a new hp notebook and installed visual studio 2005 pro and office 2007. Works very well. Then I'm trying to install sql server 2005 dev edition and get the error below. Please help
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'SAVIOURSQLServer2005MSSQLUser$SAVIOUR$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40CnfgSQL%4080%40x3c29
Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error:
- SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility
Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
Please help.
Currently I am just trying to completely remove all Vista Ultimate's knowledge of installed instances of SQLServer 2005 Developer edition.
I cannot do this for some reason. This all began when I tried to install SQLServer 2005 and it installed but I could not connect to it. Now I have two installed instances that I cannot access, after removing all SQL programs from the Programs and Features icon in the control panel.
I tried running "WIndows Installer CleanUp Utility" as I read in a thread on this forum. This did not help. After going thru and removing all SQLServer programs using the "programs and features" icon in control panel... The installation process shows two installed instances of SQLServer 2005.
1) How can I completely erase all Vista Ultimate's knowledge of any SQLServer 2005 install and start over?
I have downloaded SQLServer 2005 SP 2, and run it, but clearly what I should do, and what Microsoft has asked me to do are not working...
2) What should I be doing to install SQLServer 2005 Developer Edition successfully?
I have been a strong supporter of Microsoft, but this is getting me very frustrated.
Please help,
- Chaz
I'm trying to perform a fresh new install of SQL Express 2005 Advanced SP (CTP) on Vista Ultimate RTM but running into an installation issue preventing me from installing the Reporting Services option. When the SQL Express Advanced installation does it's system configuration check, it gives me this warning ...
- 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.
I do have IIS7 installed and running on my system with all options except for FTP. Why isn't the SQL Express install recognizing IIS7? Is there a workaround? I'd really like to get Reporting Services installed. But SQL Express isn't giving me that option during install because of this IIS issue. Thanks in advance!
I have been trying to install BCM 07 and Accounting Pro 07 for a couple days now with the same SQL Server Express eroor. I've also attempted to install SQL Express sp2 alone to no avail either. Here is the log file from my last BCM install attempt. Any advise would be GREAT! I have already tried changing my PC name to CHARLIE which did not resolve it either. Thanks for the help! Charlie
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Professional (Build 6000)
Time : Thu Jul 26 21:21:43 2007
Machine : CHARLIE
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : CHARLIE
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : CHARLIE
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : CHARLIE
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : CHARLIE
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : CHARLIE
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Shared Memory Provider: Timeout error {258}. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Thu Jul 26 21:23:43 2007
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SCC.log
c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
Hi,
I have the following scenario in my lab:
1. Windows Vista Ultimate with an fresh SQL 2005 Express SP2;
2. Developer machine with Windows XP and SQL Manag. Studio.
Problem:
Windows Vista isn't allowing a SQL connection from XP >> Vista.
I've tried:
1. Configured surface area (the same configurations works on XP);
2. Configured all services and windows firewall base on online docs from MS.
After 6 hours arround i didn't find any solution. Any ideas?
Hi Everyone,
I was playing around with SQL2k5 Express, but decided to download Enterprise using my MSDN subscription. I installed it, but none of the services are running. I don't understand why?
I've checked the requirments and I notice that Vista x64 is not on the list for compatible OS's.
I do get this when trying to install:
- SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility
Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
Also, during the install, Componoents to Install: All the services are greyed out... is that because they can't be installed or because they're going to be installed by default?
Anyone else have it running on Vista Ultimate x64? Am I doing something wrong or does it just not install on this version of Vista?
Cheers,
Mike Avelar
I am having trouble installing disc number 2 on sql standard 2005( I installed disc one) I get the message my workstation components are already installed etc.It will not allow me to go any further It seem like everything installed Here is my summary.... I unistalled vs 2 express 2005---I never used it......
Here is my list on my vista ultimate computer sql server business intelligence, sql server management studio, analysis services installed configuration tools documentation pefmorance tools Did I need to install disc 2 instead of disc 1?
one I am using vista Please help ? I tried opening business intelligence studio it says it has compability issues
Here is my log:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Professional (Build 6000)
Time : Tue Apr 29 14:13:59 2008
Machine : BILLPREC690
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_1.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_2.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_2.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_3.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_3.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_3.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_4.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_4.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_4.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_5.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_3.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_5.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_5.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLSupport_6.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLNCLI_4.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU
Product Version : 8.0.50727.42
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_PPESku_1.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_OWC11_6.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BOL_1.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_BackwardsCompat_6.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Integration Services
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_DTS.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLXML4_1.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQL.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_SQLXML4_2.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Analysis Services
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_AS.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Notification Services
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_NS.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Reporting Services
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_RS.log
--------------------------------------------------------------------------------
Machine : BILLPREC690
Product : Microsoft SQL Server 2005 Tools
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_BILLPREC690_Tools.log
--------------------------------------------------------------------------------
when i was installing ss2005 i got two warnings:
- SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility
I-IS Feature Requirement (Warning)
Messages
IIS Feature Requirement
then in the next step ,there was only one option i could choose(workstation components,books online and develop tools), all the services were grey and not selected ,here 's the log file
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Professional (Build 6000)
Time : Wed Dec 06 13:01:54 2006
TJM-PC : The current system does not meet the minimum hardware requirements for this SQL Server release. For system requirements, see Hardware and Software Requirements, in the readme file or in SQL Server Books Online.
TJM-PC : 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.
Machine : TJM-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU
Product Version : 8.0.50727.42
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_PPESku_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_OWC11_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BOL_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_SQLXML4_1.log
--------------------------------------------------------------------------------
Machine : TJM-PC
Product : Microsoft SQL Server 2005 Tools
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_TJM-PC_Tools.log
--------------------------------------------------------------------------------
could any one tell my how could i intall the sql server database services and other services?
thanks
We receive the error below when attempting to access our newly installed reporting service under Windows Vista. We can't seem to fix to this error. While we can view reports deployed to my report server at http://ServerName/ReportServer, we cannot access the Report Manager that comes with SSRS via http://ServerName/Reports. When we do we get the error below.
According to the error it cannot find the 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll. The missing dll is located in our C:$WINDOWS.~QDATAWindowsMicrosoft.NETFrameworkv2.0.50727System.EnterpriseServices.dll. We do not have a GAC_32 directory in our Assembly directory and we cannot manually add any thing to the Assembly folder.
Does anyone have any idea how to resolve this error?
Any assistance is greatly appreciated.
Server Error in '/Reports' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS0006: Metadata file 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll' could not be found
Source Error:
[No relevant source lines]
Source File: Line: 0
Show Detailed Compiler Output:
c:windowssystem32inetsrv> "C:WindowsMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl350805c34 0086ba6_164dc701ReportingServicesNativeClient.DLL" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl357073932 092ba95_164dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl34957153c 0086ba6_164dc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WindowsassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Web.RegularExpressions2.0.0.0__b03f5f7f11d50a3aSystem.Web.RegularExpressions.dll" /R:"C:WindowsassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl36a74e136 0086ba6_164dc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.Windows.Forms2.0.0.0__b77a5c561934e089System.Windows.Forms.dll" /R:"C:WindowsassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl39a6712b7 092ba95_164dc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WindowsassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl34c4caac7 0359ca7_164dc701ReportingServicesWebUserInterface.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.DirectoryServices2.0.0.0__b03f5f7f11d50a3aSystem.DirectoryServices.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl326b107a1 0e258c3_b4d0c501ReportingServicesCDOInterop.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WindowsassemblyGAC_MSILSystem.ServiceProcess2.0.0.0__b03f5f7f11d50a3aSystem.ServiceProcess.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Design2.0.0.0__b03f5f7f11d50a3aSystem.Design.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WindowsassemblyGAC_MSILSystem.DirectoryServices.Protocols2.0.0.0__b03f5f7f11d50a3aSystem.DirectoryServices.Protocols.dll" /R:"C:WindowsassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /out:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699 "C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.0.cs" "C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.1.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.312
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
error CS0006: Metadata file 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll' could not be found
Version Information: Microsoft .NET Framework Version:2.0.50727.312; ASP.NET Version:2.0.50727.833
Hi
I have just take my system back to the factory defaults after some unsuccessful attempts to install 64 bit and 32 bit sql server on my notebook. I am looking to use either 32 or 64 bit (I have disks for both) and I would like to get a step by step guide that will help me through the process.
I tried an install of the 64 bit version, applied SP2, and it went smoothly but the report services browser didn't work. I tried to change some IIS settings but I didnt document what I changed so i was unable to undo the changes that i made when these didnt work.
I tried several combinations of things but then decided that a clean install on a clean system was the best option.
I need the SQL engine , reporting services, analysis services - and possibly integration services - i am not sure if i need notification services (dont know what it does anyway!)
I also have vs2005 - should i install that first or after sql server 2005 SP2?
Thanks
Doug
Hi,
I have a problem when i want to debug an ssis component under visual studio 2005.
I'm using sql 2005 with service pack 2 and i have already install patch for visual studio under vista.
When i put a breakpoint for exemple in the method "public override void PreExecute()" or in the other method. "public override void ProcessInput(int inputID, PipelineBuffer buffer)" and i execute the pgm.
however when i begin debugging,it's always skip breakpoint
However when i put a break point in the Validate method "public override DTSValidationStatus Validate()" it function.
When execute the the package it works fine.
I use this debug parametres :
Start external program :
C:Program FilesMicrosoft SQL Server90DTSBinnDTExec.exe
Command line arguments
/FILE "D:ProjectsIntegration Services Project1Integration Services Project1TestXmlParserPipe.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI
I execute visual studio 2005 as Administrator
Please, can some one help me!
I'm new in this forum and I 'm Italian, so my English won't be perfect!
If i want to connect to my SQL Server database in prompt i type:
"osql -U sa" and then i type the password.
So, I get an error that says:
"[Sql Native Client] Provider Via: Impossible to find the specified module.
[Sql Native Client] Access timeout expired
[Sql Native Client] An error occured during the attempt to estabilish a connection to the server. During the connection to SQL Server this error may be caused by pre-defined settings that don't ......"
How i can solve this problem?
Who can help me?
Thank you!!
Maxx
I'm new in this forum and I 'm Italian, so my English won't be perfect!
If i want to connect to my SQL Server database in prompt i type:
"osql -U sa" and then i type the password.
So, I get an error that says:
"[Sql Native Client] Provider Via: Impossible to find the specified module.
[Sql Native Client] Access timeout expired
[Sql Native Client] An error occured during the attempt to estabilish a connection to the server. During the connection to SQL Server this error may be caused by pre-defined settings that don't ......"
How i can solve this problem?
Who can help me?
Thank you!!
Maxx
Do I need to install SQL Server 2005 Native client drivers on the servers that contain applications that make connections to the new SS2005 db server? My understanding is that this driver is backward compatible with SS 2000... Can I have both installed on the same server, and then create and ODBC driver for either?
Thank-Dave
The following (VB.Net) code causes exceptions at seemingly random times.
Any suggestions?
Not sure if the problem is in .Net's ODBC support or in Sql Native Client.
If MARS is off, usually after less than 100 loops:
Code Snippet
System.Data.Odbc.OdbcException was unhandled
ErrorCode=-2146232009
Message="ERROR [HY000] [Microsoft][SQL Native Client]Connection is busy with results for another command"
Source="SQLNCLI.DLL"
Turning MARS is on bypasses that error, so it will sometimes survive a thousand or so runs before hitting:
Code Snippet
System.Data.Odbc.OdbcException was unhandled
ErrorCode=-2146232009
Message="ERROR [23000] [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'Number', table 'tempdb.dbo.#TempTable___..(shortened to fit).. _________000000002F3F'; column does not allow nulls. INSERT fails.
Source="SQLNCLI.DLL"
Code here:
(Console Application, empty database,
Visual Studio 2005, .Net 2.0, Windows XP,SQL Server 2005 or SQL Express 2005, Local or Remote)
Code Snippet
Module Module1
Sub Main()
'Dim connection As New SqlClient.SqlConnection("database=TestDB;server=.sqlexpress;Integrated Security=SSPI;") 'Doesn't crash
'Dim connection As New OleDb.OleDbConnection("Provider=SQLNCLI;database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Doesn't crash
'Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Crashes
Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;MARS_Connection=yes") 'Crashes
VBMath.Randomize()
Dim run_count As Integer = 1
connection.Open()
Console.WriteLine("Connected!!")
While True
'connection.Open()
Dim testcmd As New Odbc.OdbcCommand("CREATE TABLE [#TempTable] (Number int PRIMARY KEY)", connection)
testcmd.ExecuteNonQuery()
testcmd.Dispose()
testcmd = Nothing
Dim dtTemp As New DataTable
Dim daTemp As New Odbc.OdbcDataAdapter("SELECT * FROM [#TempTable]", connection)
daTemp.MissingSchemaAction = MissingSchemaAction.AddWithKey
daTemp.Fill(dtTemp)
Dim cbTemp As New Odbc.OdbcCommandBuilder(daTemp)
Dim viewTemp As New DataView(dtTemp, Nothing, "Number", DataViewRowState.CurrentRows)
Dim i As Integer
For i = 1 To 1000
Dim test_number As Integer = CInt(Rnd() * 2000)
If viewTemp.Find(test_number) = -1 Then 'Keep it unique
Dim new_temp_row As DataRowView = viewTemp.AddNew()
new_temp_row("Number") = test_number
new_temp_row.EndEdit()
End If
Next
daTemp.Update(dtTemp)
'daTemp.Dispose()
'daTemp = Nothing
'cbTemp.Dispose()
'cbTemp = Nothing
'dtTemp.Dispose()
'dtTemp = Nothing
'viewTemp.Dispose()
'viewTemp = Nothing
Dim testcmd2 As New Odbc.OdbcCommand("DROP TABLE [#TempTable]", connection)
testcmd2.ExecuteNonQuery()
testcmd2.Dispose()
testcmd2 = Nothing
'connection.Close()
'GC.Collect()
'Console.Write(".")
run_count += 1
End While
End Sub
End Module
Usually the ".Update" triggers the exception, but sometimes the other sql commands do it.
Have tried various experiments with disposing of objects immediately when finished, but no effect.
Opening and closing the connection each loop seems to delay the errors, but it still happens eventually.
Hi Gurus,
I have a Windows Server 2003 with SQL Server 2000, and I tryng to upgrading this version to SQL Server 2005 but when I start the setup file a received a big log error:
Microsoft SQL Server 2005 Setup beginning at Mon Nov 26 11:47:08 2007
Process ID : 2332
E:Tempsqlcd1setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/10/26 11:47:8
Complete: LoadResourcesAction at: 2007/10/26 11:47:8, returned true
Running: ParseBootstrapOptionsAction at: 2007/10/26 11:47:8
Loaded DLL:E:Tempsqlcd1xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/10/26 11:47:8, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: -1073741766
Windows Error Text: Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50
3221225530
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2332"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/10/26 11:47:8
Complete: ValidateWinNTAction at: 2007/10/26 11:47:8, returned true
Running: ValidateMinOSAction at: 2007/10/26 11:47:8
Complete: ValidateMinOSAction at: 2007/10/26 11:47:8, returned true
Running: PerformSCCAction at: 2007/10/26 11:47:8
Complete: PerformSCCAction at: 2007/10/26 11:47:8, returned true
Running: ActivateLoggingAction at: 2007/10/26 11:47:8
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00DCCFC8Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2332"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2