Monday, March 26, 2012
Installing and Configuring SSRS on Vista
default instance of SQL Server 2005 SP2 down on the machine. I got all of
the IIS components installed on Vista in order to get an installation of
SSRS to go through. There was no installation option for configuration.
After installing, I applied SP2. Then I opened up IIS Manager and set the
app pool to Classic ASP.NET. When I launch RS Configuration, I select my
default instance, click connect, it it promptly blows up with the following
error:
YES, the SQL Server instance is started. If I click continue, it constantly
throws WMI errors. I managed to get to the database configuration and
create the reportserver and reportservertemp databases. Doing anything to
the virtual directories causes RS Configuration to simply abort and shut
down. I obviously can't get to either the reports or reportserver website,
because the config tool crashes and won't setup the virtual directories in
the config. (If I look in IIS admin, neither of the sites has a virtual
directory configured and the connection string is set to SQLEXPRESS and NOT
the default instance that I have on the machine.) This is getting
ridiculous. Does anyone have a manual config checklist which does NOT
require this Config tool, because the RS Config simply does NOT work.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
occurred and no additional error information is available. -->
System.Runtime.InteropServices.COMException (0x8000000A)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName,
ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
-- End of inner exception stack trace --
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
itemName)
at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
at System.Windows.Forms.Form.set_Active(Boolean value)
at System.Windows.Forms.Form.WmActivate(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.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
---
RSConfigTool
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
---
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
---
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
---
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
---
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
---
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
---
System.ServiceProcess
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.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:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
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.
--
Mike - mhotek@.mssqlserver.com
President FilAm Software Technology, Inc
Vice-President MHS Enterprises, Inc
MCITP - SQL Server DBA, MCT
http://www.mssqlserver.com
http://www.mhse.netI hacked my way around and manually added the virtual directory within IIS
Admin for the Reports website. I then hacked and manually input the
<ReportServerVirtualDirectory> within the RSWebApplication.config file. It
at least finds the website now when I go to http://<machine>/reports.
However, it fails on the connection attempt with the VERY unhelpful error
message of:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
So, since I know that it is all compatible, I'm assuming that I missed
something when I manually created the connection string in IIS Admin. Does
anyone have a sample connection string from a working SSRS configuration?
--
Mike - mhotek@.mssqlserver.com
President FilAm Software Technology, Inc
Vice-President MHS Enterprises, Inc
MCITP - SQL Server DBA, MCT
http://www.mssqlserver.com
http://www.mhse.net
"Michael Hotek" <mike.hotek@.mhse.net> wrote in message
news:2D164AE8-B582-4478-8D92-96C284E996DA@.microsoft.com...
> This config stuff is getting a little bit ridiculous. I already had a
> default instance of SQL Server 2005 SP2 down on the machine. I got all of
> the IIS components installed on Vista in order to get an installation of
> SSRS to go through. There was no installation option for configuration.
> After installing, I applied SP2. Then I opened up IIS Manager and set the
> app pool to Classic ASP.NET. When I launch RS Configuration, I select my
> default instance, click connect, it it promptly blows up with the
> following error:
> YES, the SQL Server instance is started. If I click continue, it
> constantly throws WMI errors. I managed to get to the database
> configuration and create the reportserver and reportservertemp databases.
> Doing anything to the virtual directories causes RS Configuration to
> simply abort and shut down. I obviously can't get to either the reports
> or reportserver website, because the config tool crashes and won't setup
> the virtual directories in the config. (If I look in IIS admin, neither
> of the sites has a virtual directory configured and the connection string
> is set to SQLEXPRESS and NOT the default instance that I have on the
> machine.) This is getting ridiculous. Does anyone have a manual config
> checklist which does NOT require this Config tool, because the RS Config
> simply does NOT work.
> See the end of this message for details on invoking
> just-in-time (JIT) debugging instead of this dialog box.
> ************** Exception Text **************
> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
> occurred and no additional error information is available. -->
> System.Runtime.InteropServices.COMException (0x8000000A)
> at
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at System.Management.ManagementObject.InvokeMethod(String methodName,
> ManagementBaseObject inParameters, InvokeMethodOptions options)
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> -- End of inner exception stack trace --
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
> itemName)
> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
> at System.Windows.Forms.Form.set_Active(Boolean value)
> at System.Windows.Forms.Form.WmActivate(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.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> ---
> RSConfigTool
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.3042.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
> ---
> System.Windows.Forms
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> ---
> System
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> ---
> System.Drawing
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> ---
> System.Xml
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
> ---
> System.Management
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
> ---
> System.ServiceProcess
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.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:
> <configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>
> 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.
> --
> Mike - mhotek@.mssqlserver.com
> President FilAm Software Technology, Inc
> Vice-President MHS Enterprises, Inc
> MCITP - SQL Server DBA, MCT
> http://www.mssqlserver.com
> http://www.mhse.net|||Turn off user account control (UAC) in Vista.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Michael Hotek" <mike.hotek@.mhse.net> wrote in message
news:91E85C23-8B52-49A4-B1A4-2F0F5CF7B362@.microsoft.com...
>I hacked my way around and manually added the virtual directory within IIS
>Admin for the Reports website. I then hacked and manually input the
><ReportServerVirtualDirectory> within the RSWebApplication.config file. It
>at least finds the website now when I go to http://<machine>/reports.
>However, it fails on the connection attempt with the VERY unhelpful error
>message of:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
> So, since I know that it is all compatible, I'm assuming that I missed
> something when I manually created the connection string in IIS Admin.
> Does anyone have a sample connection string from a working SSRS
> configuration?
> --
> Mike - mhotek@.mssqlserver.com
> President FilAm Software Technology, Inc
> Vice-President MHS Enterprises, Inc
> MCITP - SQL Server DBA, MCT
> http://www.mssqlserver.com
> http://www.mhse.net
> "Michael Hotek" <mike.hotek@.mhse.net> wrote in message
> news:2D164AE8-B582-4478-8D92-96C284E996DA@.microsoft.com...
>> This config stuff is getting a little bit ridiculous. I already had a
>> default instance of SQL Server 2005 SP2 down on the machine. I got all
>> of the IIS components installed on Vista in order to get an installation
>> of SSRS to go through. There was no installation option for
>> configuration. After installing, I applied SP2. Then I opened up IIS
>> Manager and set the app pool to Classic ASP.NET. When I launch RS
>> Configuration, I select my default instance, click connect, it it
>> promptly blows up with the following error:
>> YES, the SQL Server instance is started. If I click continue, it
>> constantly throws WMI errors. I managed to get to the database
>> configuration and create the reportserver and reportservertemp databases.
>> Doing anything to the virtual directories causes RS Configuration to
>> simply abort and shut down. I obviously can't get to either the reports
>> or reportserver website, because the config tool crashes and won't setup
>> the virtual directories in the config. (If I look in IIS admin, neither
>> of the sites has a virtual directory configured and the connection string
>> is set to SQLEXPRESS and NOT the default instance that I have on the
>> machine.) This is getting ridiculous. Does anyone have a manual config
>> checklist which does NOT require this Config tool, because the RS Config
>> simply does NOT work.
>> See the end of this message for details on invoking
>> just-in-time (JIT) debugging instead of this dialog box.
>> ************** Exception Text **************
>> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
>> occurred and no additional error information is available. -->
>> System.Runtime.InteropServices.COMException (0x8000000A)
>> at
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
>> errorCode, IntPtr errorInfo)
>> at System.Management.ManagementObject.InvokeMethod(String methodName,
>> ManagementBaseObject inParameters, InvokeMethodOptions options)
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> -- End of inner exception stack trace --
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
>> itemName)
>> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
>> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
>> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
>> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
>> at System.Windows.Forms.Form.set_Active(Boolean value)
>> at System.Windows.Forms.Form.WmActivate(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.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
>> ---
>> RSConfigTool
>> Assembly Version: 9.0.242.0
>> Win32 Version: 9.00.3042.00
>> CodeBase:
>> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
>> ---
>> System.Windows.Forms
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
>> ---
>> System
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
>> ---
>> System.Drawing
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
>> ---
>> System.Xml
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
>> ---
>> System.Management
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
>> ---
>> System.ServiceProcess
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.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:
>> <configuration>
>> <system.windows.forms jitDebugging="true" />
>> </configuration>
>> 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.
>> --
>> Mike - mhotek@.mssqlserver.com
>> President FilAm Software Technology, Inc
>> Vice-President MHS Enterprises, Inc
>> MCITP - SQL Server DBA, MCT
>> http://www.mssqlserver.com
>> http://www.mhse.net
>
Monday, March 12, 2012
Installation problem: Unable to start service (3) - Error Code: 0x80070003
Hello,
I have Vista x64 and I had been fighting SQL Server for a few days and yesterday I decided for reinstallation. Unfortunately now I am not able to instal the server back!
Each time I got the following error (it refers to SQL Server service):
Code Snippet
<Func Name='LaunchFunction'>
Function=Do_sqlShutDownRANUInstance
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlShutDownRANUInstance
PerfTime Start: Do_sqlShutDownRANUInstance : Tue Sep 04 23:32:16 2007
<Func Name='Do_sqlShutDownRANUInstance'>
Service SQLEXPRESS with parameters '' is being started at Tue Sep 04 23:32:16 2007
Unable to start service (3)
Error Code: 0x80070003 (3)
Windows Error Text: System nie mo?e odnale?? okre?lonej ?cie?ki.
Source File Name: sqlsetuplib\service.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls::Service::Start
Source Line Number: 316
- Context --
Setting status of unmanaged components and removing unmanaged resources
Error Code: 3
MSI (s) (F4:E4) [23:32:24:490]: I/O on thread 3716 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:493]: I/O on thread 788 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:493]: I/O on thread 2948 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:493]: I/O on thread 4392 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:493]: I/O on thread 5048 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:495]: I/O on thread 4464 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:495]: I/O on thread 4992 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:495]: I/O on thread 4768 could not be cancelled. Error: 1168
MSI (s) (F4:E4) [23:32:24:497]: I/O on thread 3004 could not be cancelled. Error: 1168
MSI (s) (F4!4C) [23:32:24:497]: 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 (3) System nie mo?e odnale?? okre?lonej ?cie?ki.
.
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 (3) System nie mo?e odnale?? okre?lonej ?cie?ki.
.
<Failure Type='Fatal' Error='3'>
<EndFunc Name='LaunchFunction' Return='3' GetLastError='203'>
MSI (s) (F4:80) [23:32:24:507]: User policy value 'DisableRollback' is 0
MSI (s) (F4:80) [23:32:24:507]: Machine policy value 'DisableRollback' is 0
Action ended 23:32:24: InstallFinalize. Return value 3.
MSI (s) (F4:80) [23:32:24:512]: Executing op: Header(Signature=1397708873,Version=400,Timestamp=925154312,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (F4:80) [23:32:24:512]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (F4:80) [23:32:24:513]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)
MSI (s) (F4:80) [23:32:24:514]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (F4:80) [23:32:24:516]: Executing op: ActionStart(Name=Do_sqlShutDownRANUInstance.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Running action to shutdown instance(Run As Normal User),)
MSI (s) (F4:80) [23:32:24:517]: Executing op: ProductInfo(ProductKey={C3F5DBA5-ABFC-443E-AA60-928223AADF53},ProductName=Microsoft SQL Server 2005,PackageName=sqlrun_sql.msi,Language=1033,Version=151129058,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={08AD0897-0300-4F7D-A3CC-A0CCEDD42E0D},,,InstanceType=1,LUASetting=0,RemoteURTInstalls=0,ProductDeploymentFlags=3)
MSI (s) (F4:80) [23:32:24:518]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,)
MSI (s) (F4:80) [23:32:24:519]: Executing op: RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs,,BinaryType=0,)
MSI (s) (F4:80) [23:32:24:520]: Executing op: RegOpenKey(Root=-2147483646,Key=SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs,,BinaryType=0,)
MSI (s) (F4:80) [23:32:24:520]: Executing op: ComponentUnregister(ComponentId={68C6D258-77E0-11D5-8528-00C04F68155C},ProductKey={C3F5DBA5-ABFC-443E-AA60-928223AADF53},BinaryType=0,)
MSI (s) (F4:80) [23:32:24:520]: Executing op: ComponentUnregister(ComponentId={68C6D257-77E0-11D5-8528-00C04F68155C},ProductKey={C3F5DBA5-ABFC-443E-AA60-928223AADF53},BinaryType=0,)
What can I do solve the problem?
I would run through a manual uninstall procedure:
http://support.microsoft.com/kb/909967
and then try and re-install it.
Friday, March 9, 2012
Installation on Vista
Hi, I have a serious issue installing sql server express (advanced edition) on Windows Vista Home Premium. I'm doing the install with elevated priviledges but setup of the sql server always fails at the same point with the following error:
{Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'
I've tried many different combinations, including advanced installation options selecting sql server instance to run as local system or local server but nothing came out of that. I always select add current user to the sql server administrators group.
Any help on this issue is appreciated. Below follows the setup summary log:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Mon Feb 26 22:02:41 2007
Machine : JUPITER
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLSupport_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLNCLI_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SqlWriter_1.log
--
Machine : JUPITER
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][SQL Server]Login failed for user 'sa'. 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 : JUPITER
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_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}{SQL Server}Login failed for user 'sa'. 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 Server\90\Setup Bootstrap\LOG\Summary.txt.
Time : Mon Feb 26 22:30:02 2007
Also had trouble with installation as well.
It's weird how they don't tell you to setup the app correctly.
There are two ways I believe to set up the app as an administrator.
The easiest for me was to goto "All Programs" in the start bar and right-click on the SQL Management application and they click "Run as Administrator"
Maybe it might launch correctly. It did for me.
Or I remember with Win XP days that you could boot and hit one of the function keys (I think F2) that would normally take you to Safe Mode but gives you the option to log onto as a system administrator as well.
Maybe that may work for Vista as well. Once you log in as system administrator you can open SQL Management and add your user windows account as a sysadmin through the app to give you correct permissions.
Hope any of that was readable and somewhat understandable.
|||
Hi, Amie.
Thank you for the tip, but the trouble is that this error occurs during the installation fase of the sql engine, so installation fails and it rolls back, which essentially means that the sql instance fails to run, so there is no server to manage. :-(
|||Hi Zzermont,
Are you installing a new instance of SQL or upgrading an existing installation? If you are upgrading an existing installation I would guess that you are trying to select SQL Authentication during the upgrade process, which is not supported. If this is a new installation, I'm not sure what's going on. I've installed SQL Express successfully on Vista a number of times.
Either way, I'm pushing this message over to the Setup forum for more directed help.
Mike
|||Hi, Mike.
It is a new installation on vista. The only thing to note is that I have Visual Studio 2005 SP1 installed (with sql server deselected at installation time).
Alek
Installation on Vista
Hi, I have a serious issue installing sql server express (advanced edition) on Windows Vista Home Premium. I'm doing the install with elevated priviledges but setup of the sql server always fails at the same point with the following error:
{Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'
I've tried many different combinations, including advanced installation options selecting sql server instance to run as local system or local server but nothing came out of that. I always select add current user to the sql server administrators group.
Any help on this issue is appreciated. Below follows the setup summary log:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Mon Feb 26 22:02:41 2007
Machine : JUPITER
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLSupport_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SQLNCLI_1.log
--
Machine : JUPITER
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_SqlWriter_1.log
--
Machine : JUPITER
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][SQL Server]Login failed for user 'sa'. 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 : JUPITER
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0007_JUPITER_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}{SQL Server}Login failed for user 'sa'. 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 Server\90\Setup Bootstrap\LOG\Summary.txt.
Time : Mon Feb 26 22:30:02 2007
Also had trouble with installation as well.
It's weird how they don't tell you to setup the app correctly.
There are two ways I believe to set up the app as an administrator.
The easiest for me was to goto "All Programs" in the start bar and right-click on the SQL Management application and they click "Run as Administrator"
Maybe it might launch correctly. It did for me.
Or I remember with Win XP days that you could boot and hit one of the function keys (I think F2) that would normally take you to Safe Mode but gives you the option to log onto as a system administrator as well.
Maybe that may work for Vista as well. Once you log in as system administrator you can open SQL Management and add your user windows account as a sysadmin through the app to give you correct permissions.
Hope any of that was readable and somewhat understandable.|||
Hi, Amie.
Thank you for the tip, but the trouble is that this error occurs during the installation fase of the sql engine, so installation fails and it rolls back, which essentially means that the sql instance fails to run, so there is no server to manage. :-(
|||Hi Zzermont,
Are you installing a new instance of SQL or upgrading an existing installation? If you are upgrading an existing installation I would guess that you are trying to select SQL Authentication during the upgrade process, which is not supported. If this is a new installation, I'm not sure what's going on. I've installed SQL Express successfully on Vista a number of times.
Either way, I'm pushing this message over to the Setup forum for more directed help.
Mike
|||Hi, Mike.
It is a new installation on vista. The only thing to note is that I have Visual Studio 2005 SP1 installed (with sql server deselected at installation time).
Alek
Installation of SQL Server 2005 + RS on a vista 64 bits
Hello,
I'm trying to install a version of SQL server 2005 with reporting services on a vista 64 bits.
I've a licence for SQL server 2005 standard edition in French, my vista is in French, and I'm using visual studio standard edition in English to develop. I would like to develop reports using SQL server to include these reports in my applications developped with Visual Studio.
Wich version of SQL server should I install ? I've tryed to install SQL server express 2005 with advanced feature SP2 (english version) and then later the standard edition (French version) (each time uninstalling all SQL server components between tries), but I got problems with reporting services each time.
I got first a warming saying than reporting services is 32 bits and IIS is 64 bits, I so allowed IIS to run 32 bits ASP .Net, but after that, I now get a problem of .Net registration in IIS as warming message on the line concerning Reporting services during the install of SQL Server, and it doesn't even offer to install RS on the next window.
I reinstalled the DotnetFX64 to be sure, but still get the same message. If I look in the IIS the application pools are looking me to be normal, with the ASPNET 32 bit code allowed.
Are you installing 32-bit SQL Server 2005 Standard on 64-bit Vista? Can you install 64-bit SQL Server 2005?
Vista is a client operating system and it does support all SQL Server 2005 editions except Enterprise edition. So SQL Server 2005 Standard Edition and SQL Server 2005 Express should be supported on Vista.
By default, IIS is not turned on Vista. When you turn on IIS on Vista, please make sure you als select "IIS Backward Compatibility". Otherwise, RS cannot be installed successfully.
|||I tried to install first SQL express with advanced services, then the 64 bits version SQL server standar edition, but it looks like it still was trying to install the reporting services in 32 bits mode.
I've well installed the IIS backward compatibility, indeed.
I just made a new try, and here are the warming I'm getting now, and I can't select reporting services in the list (sorry, the warmings are in French) :
- Critère d'enregistrement de version ASP.Net (Avertissement)
Messages
Critère d'enregistrement de version ASP.Net
échec de la recherche de l'enregistrement de version ASP.Net
avec Microsoft Internet Information Services (IIS).
- Catalogue COM Plus requis (Avertissement)
Messages
Catalogue COM Plus requis
En cas d'chec, le programme d'installation de SQL Server restaure l'installation
mais ne peut pas supprimer tous les fichiers .manifest. Pour contourner ce problème,
renommez les fichiers, puis excutez à nouveau le programme d'installation.
Pour plus d'informations, voir Procdure : contourner les checs de contr?le COM+
du programme d'installation de SQL Server.
|||
I've again tried to install the standard edition in French.
Reporting services were still not installing, still complaining about the registration of ASP.net in IIS. I then tried to apply the SP2, and it didn't install at all, complaining than some part of SQL server (like the management studio) where in 32 bits. In the end, all points of the SP2 updates failed. Visual Studio 2005 was then starting to act up (problems to access some log file when I was starting or leaving Visual Studio).
Then I've uninstalled all sql server again. Visual Studio was then completely messy (problems with the components in the tool box, problems with refactor for visual basic, Ideablde Dev Force, Kripton Toolkit, ...) So I also uninstalled Visual Studio 2005 and all these related components.
After that, I used the Windows installer cleaner utility to clean my system (http://support.microsoft.com/default.aspx/kb/290301/en-us).
How can I now mannage to reinstall my products, in wich order and in wich version, to be able in the end to develop my applications and reports, knowing than I've licence for Vista Professional edition, in French; and installed it in 64 bits, I've licence for SQL server 2005 standard edition, in French too and licence for Visual Studio 2005 Standard edition, in English ?
|||Am I really the first one trying to develop on a Vista 64 bits using Visual Studio 2005 and SQL server 2005 ?|||I'm having exactly the same problems as you (except in English!)
When I try to install Reporting Services on my Vista x64 machine, the following happens:
* In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
* On the following section, Reporting Services is greyed out so cannot be installed.
All of the blogs and posts on this matter suggest going into "Turn Windows Features on / off" and enabling various IIS7 features. However, even though I have ticked every possible IIS7 feature the problem remained.
I have also installed SP2, but again this didn't help when I returned to the original installation.
What is the solution?
|||
I have exactly the same problem installing SQL Server 2005 Express SP1 or SP2 on a Vista Ultimate 64 bits with all IIS7 features enabled: RS cannot install because I have registered the 64 bits version of ASP.NET.
I also use VS 2005 which I have it installed on my system.
Bye.
|||Well, at least, I know now than I am not the only one having the problem, and so than it is probably not related to a mistake I could have done ...|||I'm another frustrated developer trying to figure out the magic combination of steps required to install both Visual Studio 2005 Professional and SQL Server 2005 Standard on my Windows Vista Ultimate 64 machine.
Would love to hear a solution. I've also posted on the following thread earlier:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1780190&SiteID=1
|||Im not a programmer/developer or anything but i have been trying to install SQL Server 2005 onto my laptop (Vista Ultimate 64) pretty much all day.
Could it have something to do with the fact that because we are using a 64bit operating system, we cannot install the 32bit version of .NET?
Im sure after installing Vista 64 i tried to update .NET 2 using the 32bit version and was told i needed the 64bit version.
SQL Server 2005 Express Setup is 32bit, so its looking for software we cannot install right?
Then again i may be totally wrong ..... i dunno, i just dont want to have to format my laptop to reinstall XP or Vista 32
Finally! I know WHY I cannot get the enterprise version of SQL to download on Vista. Thank you!
I have been trying desperately for the past 2 days because of an onlne class that I am taking. I will try the Standard edition of SQL. Please keep your fingers crossed for me...
Thanks again, I have been SO frustrated!
E.
I do not expect any kind of an answer to the following question, but I have to ask it...
Why would MS release an operating system that does not support all of their current applications?!!!
Installation of SQL Server 2005 + RS on a vista 64 bits
Hello,
I'm trying to install a version of SQL server 2005 with reporting services on a vista 64 bits.
I've a licence for SQL server 2005 standard edition in French, my vista is in French, and I'm using visual studio standard edition in English to develop. I would like to develop reports using SQL server to include these reports in my applications developped with Visual Studio.
Wich version of SQL server should I install ? I've tryed to install SQL server express 2005 with advanced feature SP2 (english version) and then later the standard edition (French version) (each time uninstalling all SQL server components between tries), but I got problems with reporting services each time.
I got first a warming saying than reporting services is 32 bits and IIS is 64 bits, I so allowed IIS to run 32 bits ASP .Net, but after that, I now get a problem of .Net registration in IIS as warming message on the line concerning Reporting services during the install of SQL Server, and it doesn't even offer to install RS on the next window.
I reinstalled the DotnetFX64 to be sure, but still get the same message. If I look in the IIS the application pools are looking me to be normal, with the ASPNET 32 bit code allowed.
Are you installing 32-bit SQL Server 2005 Standard on 64-bit Vista? Can you install 64-bit SQL Server 2005?
Vista is a client operating system and it does support all SQL Server 2005 editions except Enterprise edition. So SQL Server 2005 Standard Edition and SQL Server 2005 Express should be supported on Vista.
By default, IIS is not turned on Vista. When you turn on IIS on Vista, please make sure you als select "IIS Backward Compatibility". Otherwise, RS cannot be installed successfully.
|||I tried to install first SQL express with advanced services, then the 64 bits version SQL server standar edition, but it looks like it still was trying to install the reporting services in 32 bits mode.
I've well installed the IIS backward compatibility, indeed.
I just made a new try, and here are the warming I'm getting now, and I can't select reporting services in the list (sorry, the warmings are in French) :
- Critère d'enregistrement de version ASP.Net (Avertissement)
Messages
Critère d'enregistrement de version ASP.Net
échec de la recherche de l'enregistrement de version ASP.Net
avec Microsoft Internet Information Services (IIS).
- Catalogue COM Plus requis (Avertissement)
Messages
Catalogue COM Plus requis
En cas d'chec, le programme d'installation de SQL Server restaure l'installation
mais ne peut pas supprimer tous les fichiers .manifest. Pour contourner ce problème,
renommez les fichiers, puis excutez à nouveau le programme d'installation.
Pour plus d'informations, voir Procdure : contourner les checs de contr?le COM+
du programme d'installation de SQL Server.
|||
I've again tried to install the standard edition in French.
Reporting services were still not installing, still complaining about the registration of ASP.net in IIS. I then tried to apply the SP2, and it didn't install at all, complaining than some part of SQL server (like the management studio) where in 32 bits. In the end, all points of the SP2 updates failed. Visual Studio 2005 was then starting to act up (problems to access some log file when I was starting or leaving Visual Studio).
Then I've uninstalled all sql server again. Visual Studio was then completely messy (problems with the components in the tool box, problems with refactor for visual basic, Ideablde Dev Force, Kripton Toolkit, ...) So I also uninstalled Visual Studio 2005 and all these related components.
After that, I used the Windows installer cleaner utility to clean my system (http://support.microsoft.com/default.aspx/kb/290301/en-us).
How can I now mannage to reinstall my products, in wich order and in wich version, to be able in the end to develop my applications and reports, knowing than I've licence for Vista Professional edition, in French; and installed it in 64 bits, I've licence for SQL server 2005 standard edition, in French too and licence for Visual Studio 2005 Standard edition, in English ?
|||Am I really the first one trying to develop on a Vista 64 bits using Visual Studio 2005 and SQL server 2005 ?|||I'm having exactly the same problems as you (except in English!)
When I try to install Reporting Services on my Vista x64 machine, the following happens:
* In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
* On the following section, Reporting Services is greyed out so cannot be installed.
All of the blogs and posts on this matter suggest going into "Turn
Windows Features on / off" and enabling various IIS7 features. However,
even though I have ticked every possible IIS7 feature the problem
remained.
I have also installed SP2, but again this didn't help when I returned to the original installation.
What is the solution?|||
I have exactly the same problem installing SQL Server 2005 Express SP1 or SP2 on a Vista Ultimate 64 bits with all IIS7 features enabled: RS cannot install because I have registered the 64 bits version of ASP.NET.
I also use VS 2005 which I have it installed on my system.
Bye.
|||Well, at least, I know now than I am not the only one having the problem, and so than it is probably not related to a mistake I could have done ...|||I'm another frustrated developer trying to figure out the magic combination of steps required to install both Visual Studio 2005 Professional and SQL Server 2005 Standard on my Windows Vista Ultimate 64 machine.
Would love to hear a solution. I've also posted on the following thread earlier:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1780190&SiteID=1
|||
Im not a programmer/developer or anything but i have been trying to install SQL Server 2005 onto my laptop (Vista Ultimate 64) pretty much all day.
Could it have something to do with the fact that because we are using a 64bit operating system, we cannot install the 32bit version of .NET?
Im sure after installing Vista 64 i tried to update .NET 2 using the 32bit version and was told i needed the 64bit version.
SQL Server 2005 Express Setup is 32bit, so its looking for software we cannot install right?
Then again i may be totally wrong ..... i dunno, i just dont want to have to format my laptop to reinstall XP or Vista 32
Installation of SQL Server 2005 + RS on a vista 64 bits
Hello,
I'm trying to install a version of SQL server 2005 with reporting services on a vista 64 bits.
I've a licence for SQL server 2005 standard edition in French, my vista is in French, and I'm using visual studio standard edition in English to develop. I would like to develop reports using SQL server to include these reports in my applications developped with Visual Studio.
Wich version of SQL server should I install ? I've tryed to install SQL server express 2005 with advanced feature SP2 (english version) and then later the standard edition (French version) (each time uninstalling all SQL server components between tries), but I got problems with reporting services each time.
I got first a warming saying than reporting services is 32 bits and IIS is 64 bits, I so allowed IIS to run 32 bits ASP .Net, but after that, I now get a problem of .Net registration in IIS as warming message on the line concerning Reporting services during the install of SQL Server, and it doesn't even offer to install RS on the next window.
I reinstalled the DotnetFX64 to be sure, but still get the same message. If I look in the IIS the application pools are looking me to be normal, with the ASPNET 32 bit code allowed.
Are you installing 32-bit SQL Server 2005 Standard on 64-bit Vista? Can you install 64-bit SQL Server 2005?
Vista is a client operating system and it does support all SQL Server 2005 editions except Enterprise edition. So SQL Server 2005 Standard Edition and SQL Server 2005 Express should be supported on Vista.
By default, IIS is not turned on Vista. When you turn on IIS on Vista, please make sure you als select "IIS Backward Compatibility". Otherwise, RS cannot be installed successfully.
|||I tried to install first SQL express with advanced services, then the 64 bits version SQL server standar edition, but it looks like it still was trying to install the reporting services in 32 bits mode.
I've well installed the IIS backward compatibility, indeed.
I just made a new try, and here are the warming I'm getting now, and I can't select reporting services in the list (sorry, the warmings are in French) :
- Critère d'enregistrement de version ASP.Net (Avertissement)
Messages
Critère d'enregistrement de version ASP.Net
échec de la recherche de l'enregistrement de version ASP.Net
avec Microsoft Internet Information Services (IIS).
- Catalogue COM Plus requis (Avertissement)
Messages
Catalogue COM Plus requis
En cas d'chec, le programme d'installation de SQL Server restaure l'installation
mais ne peut pas supprimer tous les fichiers .manifest. Pour contourner ce problème,
renommez les fichiers, puis excutez à nouveau le programme d'installation.
Pour plus d'informations, voir Procdure : contourner les checs de contr?le COM+
du programme d'installation de SQL Server.
|||
I've again tried to install the standard edition in French.
Reporting services were still not installing, still complaining about the registration of ASP.net in IIS. I then tried to apply the SP2, and it didn't install at all, complaining than some part of SQL server (like the management studio) where in 32 bits. In the end, all points of the SP2 updates failed. Visual Studio 2005 was then starting to act up (problems to access some log file when I was starting or leaving Visual Studio).
Then I've uninstalled all sql server again. Visual Studio was then completely messy (problems with the components in the tool box, problems with refactor for visual basic, Ideablde Dev Force, Kripton Toolkit, ...) So I also uninstalled Visual Studio 2005 and all these related components.
After that, I used the Windows installer cleaner utility to clean my system (http://support.microsoft.com/default.aspx/kb/290301/en-us).
How can I now mannage to reinstall my products, in wich order and in wich version, to be able in the end to develop my applications and reports, knowing than I've licence for Vista Professional edition, in French; and installed it in 64 bits, I've licence for SQL server 2005 standard edition, in French too and licence for Visual Studio 2005 Standard edition, in English ?
|||Am I really the first one trying to develop on a Vista 64 bits using Visual Studio 2005 and SQL server 2005 ?|||I'm having exactly the same problems as you (except in English!)
When I try to install Reporting Services on my Vista x64 machine, the following happens:
* In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
* On the following section, Reporting Services is greyed out so cannot be installed.
All of the blogs and posts on this matter suggest going into "Turn
Windows Features on / off" and enabling various IIS7 features. However,
even though I have ticked every possible IIS7 feature the problem
remained.
I have also installed SP2, but again this didn't help when I returned to the original installation.
What is the solution?|||
I have exactly the same problem installing SQL Server 2005 Express SP1 or SP2 on a Vista Ultimate 64 bits with all IIS7 features enabled: RS cannot install because I have registered the 64 bits version of ASP.NET.
I also use VS 2005 which I have it installed on my system.
Bye.
|||Well, at least, I know now than I am not the only one having the problem, and so than it is probably not related to a mistake I could have done ...|||I'm another frustrated developer trying to figure out the magic combination of steps required to install both Visual Studio 2005 Professional and SQL Server 2005 Standard on my Windows Vista Ultimate 64 machine.
Would love to hear a solution. I've also posted on the following thread earlier:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1780190&SiteID=1
|||
Im not a programmer/developer or anything but i have been trying to install SQL Server 2005 onto my laptop (Vista Ultimate 64) pretty much all day.
Could it have something to do with the fact that because we are using a 64bit operating system, we cannot install the 32bit version of .NET?
Im sure after installing Vista 64 i tried to update .NET 2 using the 32bit version and was told i needed the 64bit version.
SQL Server 2005 Express Setup is 32bit, so its looking for software we cannot install right?
Then again i may be totally wrong ..... i dunno, i just dont want to have to format my laptop to reinstall XP or Vista 32
Installation of SQL Server 2005 + RS fails on a vista 64 bits
Hello,
I'm trying to install a version of SQL server 2005 with reporting services on a vista 64 bits.
I've a licence for SQL server 2005 standard edition in French, my vista is in French, and I'm using visual studio standard edition in English to develop. I would like to develop reports using SQL server to include these reports in my applications developped with Visual Studio.
Wich version of SQL server should I install ? I've tryed to install SQL server express 2005 with advanced feature SP2 (english version) and then later the standard edition (French version) (each time uninstalling all SQL server components between tries), but I got problems with reporting services each time.
I got first a warming saying than reporting services is 32 bits and IIS is 64 bits, I so allowed IIS to run 32 bits ASP .Net, but after that, I now get a problem of .Net registration in IIS as warming message on the line concerning Reporting services during the install of SQL Server, and it doesn't even offer to install RS on the next window.
I reinstalled the DotnetFX64 to be sure, but still get the same message. If I look in the IIS the application pools are looking me to be normal, with the ASPNET 32 bit code allowed.
Are you installing 32-bit SQL Server 2005 Standard on 64-bit Vista? Can you install 64-bit SQL Server 2005?
Vista is a client operating system and it does support all SQL Server 2005 editions except Enterprise edition. So SQL Server 2005 Standard Edition and SQL Server 2005 Express should be supported on Vista.
By default, IIS is not turned on Vista. When you turn on IIS on Vista, please make sure you als select "IIS Backward Compatibility". Otherwise, RS cannot be installed successfully.
|||I tried to install first SQL express with advanced services, then the 64 bits version SQL server standar edition, but it looks like it still was trying to install the reporting services in 32 bits mode.
I've well installed the IIS backward compatibility, indeed.
I just made a new try, and here are the warming I'm getting now, and I can't select reporting services in the list (sorry, the warmings are in French) :
- Critère d'enregistrement de version ASP.Net (Avertissement)
Messages
Critère d'enregistrement de version ASP.Net
échec de la recherche de l'enregistrement de version ASP.Net
avec Microsoft Internet Information Services (IIS).
- Catalogue COM Plus requis (Avertissement)
Messages
Catalogue COM Plus requis
En cas d'chec, le programme d'installation de SQL Server restaure l'installation
mais ne peut pas supprimer tous les fichiers .manifest. Pour contourner ce problème,
renommez les fichiers, puis excutez à nouveau le programme d'installation.
Pour plus d'informations, voir Procdure : contourner les checs de contr?le COM+
du programme d'installation de SQL Server.
|||
I've again tried to install the standard edition in French.
Reporting services were still not installing, still complaining about the registration of ASP.net in IIS. I then tried to apply the SP2, and it didn't install at all, complaining than some part of SQL server (like the management studio) where in 32 bits. In the end, all points of the SP2 updates failed. Visual Studio 2005 was then starting to act up (problems to access some log file when I was starting or leaving Visual Studio).
Then I've uninstalled all sql server again. Visual Studio was then completely messy (problems with the components in the tool box, problems with refactor for visual basic, Ideablde Dev Force, Kripton Toolkit, ...) So I also uninstalled Visual Studio 2005 and all these related components.
After that, I used the Windows installer cleaner utility to clean my system (http://support.microsoft.com/default.aspx/kb/290301/en-us).
How can I now mannage to reinstall my products, in wich order and in wich version, to be able in the end to develop my applications and reports, knowing than I've licence for Vista Professional edition, in French; and installed it in 64 bits, I've licence for SQL server 2005 standard edition, in French too and licence for Visual Studio 2005 Standard edition, in English ?
|||Am I really the first one trying to develop on a Vista 64 bits using Visual Studio 2005 and SQL server 2005 ?|||I'm having exactly the same problems as you (except in English!)
When I try to install Reporting Services on my Vista x64 machine, the following happens:
* In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
* On the following section, Reporting Services is greyed out so cannot be installed.
All of the blogs and posts on this matter suggest going into "Turn Windows Features on / off" and enabling various IIS7 features. However, even though I have ticked every possible IIS7 feature the problem remained.
I have also installed SP2, but again this didn't help when I returned to the original installation.
What is the solution?
|||
I have exactly the same problem installing SQL Server 2005 Express SP1 or SP2 on a Vista Ultimate 64 bits with all IIS7 features enabled: RS cannot install because I have registered the 64 bits version of ASP.NET.
I also use VS 2005 which I have it installed on my system.
Bye.
|||Well, at least, I know now than I am not the only one having the problem, and so than it is probably not related to a mistake I could have done ...|||I'm another frustrated developer trying to figure out the magic combination of steps required to install both Visual Studio 2005 Professional and SQL Server 2005 Standard on my Windows Vista Ultimate 64 machine.
Would love to hear a solution. I've also posted on the following thread earlier:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1780190&SiteID=1
|||
Im not a programmer/developer or anything but i have been trying to install SQL Server 2005 onto my laptop (Vista Ultimate 64) pretty much all day.
Could it have something to do with the fact that because we are using a 64bit operating system, we cannot install the 32bit version of .NET?
Im sure after installing Vista 64 i tried to update .NET 2 using the 32bit version and was told i needed the 64bit version.
SQL Server 2005 Express Setup is 32bit, so its looking for software we cannot install right?
Then again i may be totally wrong ..... i dunno, i just dont want to have to format my laptop to reinstall XP or Vista 32
Finally! I know WHY I cannot get the enterprise version of SQL to download on Vista. Thank you!
I have been trying desperately for the past 2 days because of an onlne class that I am taking. I will try the Standard edition of SQL. Please keep your fingers crossed for me...
Thanks again, I have been SO frustrated!
E.
I do not expect any kind of an answer to the following question, but I have to ask it...
Why would MS release an operating system that does not support all of their current applications?!!!
Installation of SQL Server 2005 + RS fails on a vista 64 bits
Hello,
I'm trying to install a version of SQL server 2005 with reporting services on a vista 64 bits.
I've a licence for SQL server 2005 standard edition in French, my vista is in French, and I'm using visual studio standard edition in English to develop. I would like to develop reports using SQL server to include these reports in my applications developped with Visual Studio.
Wich version of SQL server should I install ? I've tryed to install SQL server express 2005 with advanced feature SP2 (english version) and then later the standard edition (French version) (each time uninstalling all SQL server components between tries), but I got problems with reporting services each time.
I got first a warming saying than reporting services is 32 bits and IIS is 64 bits, I so allowed IIS to run 32 bits ASP .Net, but after that, I now get a problem of .Net registration in IIS as warming message on the line concerning Reporting services during the install of SQL Server, and it doesn't even offer to install RS on the next window.
I reinstalled the DotnetFX64 to be sure, but still get the same message. If I look in the IIS the application pools are looking me to be normal, with the ASPNET 32 bit code allowed.
Are you installing 32-bit SQL Server 2005 Standard on 64-bit Vista? Can you install 64-bit SQL Server 2005?
Vista is a client operating system and it does support all SQL Server 2005 editions except Enterprise edition. So SQL Server 2005 Standard Edition and SQL Server 2005 Express should be supported on Vista.
By default, IIS is not turned on Vista. When you turn on IIS on Vista, please make sure you als select "IIS Backward Compatibility". Otherwise, RS cannot be installed successfully.
|||I tried to install first SQL express with advanced services, then the 64 bits version SQL server standar edition, but it looks like it still was trying to install the reporting services in 32 bits mode.
I've well installed the IIS backward compatibility, indeed.
I just made a new try, and here are the warming I'm getting now, and I can't select reporting services in the list (sorry, the warmings are in French) :
- Critère d'enregistrement de version ASP.Net (Avertissement)
Messages
Critère d'enregistrement de version ASP.Net
échec de la recherche de l'enregistrement de version ASP.Net
avec Microsoft Internet Information Services (IIS).
- Catalogue COM Plus requis (Avertissement)
Messages
Catalogue COM Plus requis
En cas d'chec, le programme d'installation de SQL Server restaure l'installation
mais ne peut pas supprimer tous les fichiers .manifest. Pour contourner ce problème,
renommez les fichiers, puis excutez à nouveau le programme d'installation.
Pour plus d'informations, voir Procdure : contourner les checs de contr?le COM+
du programme d'installation de SQL Server.
|||
I've again tried to install the standard edition in French.
Reporting services were still not installing, still complaining about the registration of ASP.net in IIS. I then tried to apply the SP2, and it didn't install at all, complaining than some part of SQL server (like the management studio) where in 32 bits. In the end, all points of the SP2 updates failed. Visual Studio 2005 was then starting to act up (problems to access some log file when I was starting or leaving Visual Studio).
Then I've uninstalled all sql server again. Visual Studio was then completely messy (problems with the components in the tool box, problems with refactor for visual basic, Ideablde Dev Force, Kripton Toolkit, ...) So I also uninstalled Visual Studio 2005 and all these related components.
After that, I used the Windows installer cleaner utility to clean my system (http://support.microsoft.com/default.aspx/kb/290301/en-us).
How can I now mannage to reinstall my products, in wich order and in wich version, to be able in the end to develop my applications and reports, knowing than I've licence for Vista Professional edition, in French; and installed it in 64 bits, I've licence for SQL server 2005 standard edition, in French too and licence for Visual Studio 2005 Standard edition, in English ?
|||Am I really the first one trying to develop on a Vista 64 bits using Visual Studio 2005 and SQL server 2005 ?|||I'm having exactly the same problems as you (except in English!)
When I try to install Reporting Services on my Vista x64 machine, the following happens:
* In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
* On the following section, Reporting Services is greyed out so cannot be installed.
All of the blogs and posts on this matter suggest going into "Turn Windows Features on / off" and enabling various IIS7 features. However, even though I have ticked every possible IIS7 feature the problem remained.
I have also installed SP2, but again this didn't help when I returned to the original installation.
What is the solution?
|||
I have exactly the same problem installing SQL Server 2005 Express SP1 or SP2 on a Vista Ultimate 64 bits with all IIS7 features enabled: RS cannot install because I have registered the 64 bits version of ASP.NET.
I also use VS 2005 which I have it installed on my system.
Bye.
|||Well, at least, I know now than I am not the only one having the problem, and so than it is probably not related to a mistake I could have done ...|||I'm another frustrated developer trying to figure out the magic combination of steps required to install both Visual Studio 2005 Professional and SQL Server 2005 Standard on my Windows Vista Ultimate 64 machine.
Would love to hear a solution. I've also posted on the following thread earlier:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1780190&SiteID=1
|||Im not a programmer/developer or anything but i have been trying to install SQL Server 2005 onto my laptop (Vista Ultimate 64) pretty much all day.
Could it have something to do with the fact that because we are using a 64bit operating system, we cannot install the 32bit version of .NET?
Im sure after installing Vista 64 i tried to update .NET 2 using the 32bit version and was told i needed the 64bit version.
SQL Server 2005 Express Setup is 32bit, so its looking for software we cannot install right?
Then again i may be totally wrong ..... i dunno, i just dont want to have to format my laptop to reinstall XP or Vista 32
Finally! I know WHY I cannot get the enterprise version of SQL to download on Vista. Thank you!
I have been trying desperately for the past 2 days because of an onlne class that I am taking. I will try the Standard edition of SQL. Please keep your fingers crossed for me...
Thanks again, I have been SO frustrated!
E.
I do not expect any kind of an answer to the following question, but I have to ask it...
Why would MS release an operating system that does not support all of their current applications?!!!
Installation of SQL Server 2005 + RS fails on a vista 64 bits
Hello,
I'm trying to install a version of SQL server 2005 with reporting services on a vista 64 bits.
I've a licence for SQL server 2005 standard edition in French, my vista is in French, and I'm using visual studio standard edition in English to develop. I would like to develop reports using SQL server to include these reports in my applications developped with Visual Studio.
Wich version of SQL server should I install ? I've tryed to install SQL server express 2005 with advanced feature SP2 (english version) and then later the standard edition (French version) (each time uninstalling all SQL server components between tries), but I got problems with reporting services each time.
I got first a warming saying than reporting services is 32 bits and IIS is 64 bits, I so allowed IIS to run 32 bits ASP .Net, but after that, I now get a problem of .Net registration in IIS as warming message on the line concerning Reporting services during the install of SQL Server, and it doesn't even offer to install RS on the next window.
I reinstalled the DotnetFX64 to be sure, but still get the same message. If I look in the IIS the application pools are looking me to be normal, with the ASPNET 32 bit code allowed.
Are you installing 32-bit SQL Server 2005 Standard on 64-bit Vista? Can you install 64-bit SQL Server 2005?
Vista is a client operating system and it does support all SQL Server 2005 editions except Enterprise edition. So SQL Server 2005 Standard Edition and SQL Server 2005 Express should be supported on Vista.
By default, IIS is not turned on Vista. When you turn on IIS on Vista, please make sure you als select "IIS Backward Compatibility". Otherwise, RS cannot be installed successfully.
|||I tried to install first SQL express with advanced services, then the 64 bits version SQL server standar edition, but it looks like it still was trying to install the reporting services in 32 bits mode.
I've well installed the IIS backward compatibility, indeed.
I just made a new try, and here are the warming I'm getting now, and I can't select reporting services in the list (sorry, the warmings are in French) :
- Critère d'enregistrement de version ASP.Net (Avertissement)
Messages
Critère d'enregistrement de version ASP.Net
échec de la recherche de l'enregistrement de version ASP.Net
avec Microsoft Internet Information Services (IIS).
- Catalogue COM Plus requis (Avertissement)
Messages
Catalogue COM Plus requis
En cas d'chec, le programme d'installation de SQL Server restaure l'installation
mais ne peut pas supprimer tous les fichiers .manifest. Pour contourner ce problème,
renommez les fichiers, puis excutez à nouveau le programme d'installation.
Pour plus d'informations, voir Procdure : contourner les checs de contr?le COM+
du programme d'installation de SQL Server.
|||
I've again tried to install the standard edition in French.
Reporting services were still not installing, still complaining about the registration of ASP.net in IIS. I then tried to apply the SP2, and it didn't install at all, complaining than some part of SQL server (like the management studio) where in 32 bits. In the end, all points of the SP2 updates failed. Visual Studio 2005 was then starting to act up (problems to access some log file when I was starting or leaving Visual Studio).
Then I've uninstalled all sql server again. Visual Studio was then completely messy (problems with the components in the tool box, problems with refactor for visual basic, Ideablde Dev Force, Kripton Toolkit, ...) So I also uninstalled Visual Studio 2005 and all these related components.
After that, I used the Windows installer cleaner utility to clean my system (http://support.microsoft.com/default.aspx/kb/290301/en-us).
How can I now mannage to reinstall my products, in wich order and in wich version, to be able in the end to develop my applications and reports, knowing than I've licence for Vista Professional edition, in French; and installed it in 64 bits, I've licence for SQL server 2005 standard edition, in French too and licence for Visual Studio 2005 Standard edition, in English ?
|||Am I really the first one trying to develop on a Vista 64 bits using Visual Studio 2005 and SQL server 2005 ?|||I'm having exactly the same problems as you (except in English!)
When I try to install Reporting Services on my Vista x64 machine, the following happens:
* In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
* On the following section, Reporting Services is greyed out so cannot be installed.
All of the blogs and posts on this matter suggest going into "Turn Windows Features on / off" and enabling various IIS7 features. However, even though I have ticked every possible IIS7 feature the problem remained.
I have also installed SP2, but again this didn't help when I returned to the original installation.
What is the solution?
|||
I have exactly the same problem installing SQL Server 2005 Express SP1 or SP2 on a Vista Ultimate 64 bits with all IIS7 features enabled: RS cannot install because I have registered the 64 bits version of ASP.NET.
I also use VS 2005 which I have it installed on my system.
Bye.
|||Well, at least, I know now than I am not the only one having the problem, and so than it is probably not related to a mistake I could have done ...|||I'm another frustrated developer trying to figure out the magic combination of steps required to install both Visual Studio 2005 Professional and SQL Server 2005 Standard on my Windows Vista Ultimate 64 machine.
Would love to hear a solution. I've also posted on the following thread earlier:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1780190&SiteID=1
|||
Im not a programmer/developer or anything but i have been trying to install SQL Server 2005 onto my laptop (Vista Ultimate 64) pretty much all day.
Could it have something to do with the fact that because we are using a 64bit operating system, we cannot install the 32bit version of .NET?
Im sure after installing Vista 64 i tried to update .NET 2 using the 32bit version and was told i needed the 64bit version.
SQL Server 2005 Express Setup is 32bit, so its looking for software we cannot install right?
Then again i may be totally wrong ..... i dunno, i just dont want to have to format my laptop to reinstall XP or Vista 32
Finally! I know WHY I cannot get the enterprise version of SQL to download on Vista. Thank you!
I have been trying desperately for the past 2 days because of an onlne class that I am taking. I will try the Standard edition of SQL. Please keep your fingers crossed for me...
Thanks again, I have been SO frustrated!
E.
I do not expect any kind of an answer to the following question, but I have to ask it...
Why would MS release an operating system that does not support all of their current applications?!!!
Wednesday, March 7, 2012
Installation of SQL Server 2005 + RS fails on a vista 64 bits
Hello,
I'm trying to install a version of SQL server 2005 with reporting services on a vista 64 bits.
I've a licence for SQL server 2005 standard edition in French, my vista is in French, and I'm using visual studio standard edition in English to develop. I would like to develop reports using SQL server to include these reports in my applications developped with Visual Studio.
Wich version of SQL server should I install ? I've tryed to install SQL server express 2005 with advanced feature SP2 (english version) and then later the standard edition (French version) (each time uninstalling all SQL server components between tries), but I got problems with reporting services each time.
I got first a warming saying than reporting services is 32 bits and IIS is 64 bits, I so allowed IIS to run 32 bits ASP .Net, but after that, I now get a problem of .Net registration in IIS as warming message on the line concerning Reporting services during the install of SQL Server, and it doesn't even offer to install RS on the next window.
I reinstalled the DotnetFX64 to be sure, but still get the same message. If I look in the IIS the application pools are looking me to be normal, with the ASPNET 32 bit code allowed.
Are you installing 32-bit SQL Server 2005 Standard on 64-bit Vista? Can you install 64-bit SQL Server 2005?
Vista is a client operating system and it does support all SQL Server 2005 editions except Enterprise edition. So SQL Server 2005 Standard Edition and SQL Server 2005 Express should be supported on Vista.
By default, IIS is not turned on Vista. When you turn on IIS on Vista, please make sure you als select "IIS Backward Compatibility". Otherwise, RS cannot be installed successfully.
|||I tried to install first SQL express with advanced services, then the 64 bits version SQL server standar edition, but it looks like it still was trying to install the reporting services in 32 bits mode.
I've well installed the IIS backward compatibility, indeed.
I just made a new try, and here are the warming I'm getting now, and I can't select reporting services in the list (sorry, the warmings are in French) :
- Critère d'enregistrement de version ASP.Net (Avertissement)
Messages
Critère d'enregistrement de version ASP.Net
échec de la recherche de l'enregistrement de version ASP.Net
avec Microsoft Internet Information Services (IIS).
- Catalogue COM Plus requis (Avertissement)
Messages
Catalogue COM Plus requis
En cas d'chec, le programme d'installation de SQL Server restaure l'installation
mais ne peut pas supprimer tous les fichiers .manifest. Pour contourner ce problème,
renommez les fichiers, puis excutez à nouveau le programme d'installation.
Pour plus d'informations, voir Procdure : contourner les checs de contr?le COM+
du programme d'installation de SQL Server.
|||
I've again tried to install the standard edition in French.
Reporting services were still not installing, still complaining about the registration of ASP.net in IIS. I then tried to apply the SP2, and it didn't install at all, complaining than some part of SQL server (like the management studio) where in 32 bits. In the end, all points of the SP2 updates failed. Visual Studio 2005 was then starting to act up (problems to access some log file when I was starting or leaving Visual Studio).
Then I've uninstalled all sql server again. Visual Studio was then completely messy (problems with the components in the tool box, problems with refactor for visual basic, Ideablde Dev Force, Kripton Toolkit, ...) So I also uninstalled Visual Studio 2005 and all these related components.
After that, I used the Windows installer cleaner utility to clean my system (http://support.microsoft.com/default.aspx/kb/290301/en-us).
How can I now mannage to reinstall my products, in wich order and in wich version, to be able in the end to develop my applications and reports, knowing than I've licence for Vista Professional edition, in French; and installed it in 64 bits, I've licence for SQL server 2005 standard edition, in French too and licence for Visual Studio 2005 Standard edition, in English ?
|||Am I really the first one trying to develop on a Vista 64 bits using Visual Studio 2005 and SQL server 2005 ?|||I'm having exactly the same problems as you (except in English!)
When I try to install Reporting Services on my Vista x64 machine, the following happens:
* In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
* On the following section, Reporting Services is greyed out so cannot be installed.
All of the blogs and posts on this matter suggest going into "Turn Windows Features on / off" and enabling various IIS7 features. However, even though I have ticked every possible IIS7 feature the problem remained.
I have also installed SP2, but again this didn't help when I returned to the original installation.
What is the solution?
|||
I have exactly the same problem installing SQL Server 2005 Express SP1 or SP2 on a Vista Ultimate 64 bits with all IIS7 features enabled: RS cannot install because I have registered the 64 bits version of ASP.NET.
I also use VS 2005 which I have it installed on my system.
Bye.
|||Well, at least, I know now than I am not the only one having the problem, and so than it is probably not related to a mistake I could have done ...|||I'm another frustrated developer trying to figure out the magic combination of steps required to install both Visual Studio 2005 Professional and SQL Server 2005 Standard on my Windows Vista Ultimate 64 machine.
Would love to hear a solution. I've also posted on the following thread earlier:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1780190&SiteID=1
|||Im not a programmer/developer or anything but i have been trying to install SQL Server 2005 onto my laptop (Vista Ultimate 64) pretty much all day.
Could it have something to do with the fact that because we are using a 64bit operating system, we cannot install the 32bit version of .NET?
Im sure after installing Vista 64 i tried to update .NET 2 using the 32bit version and was told i needed the 64bit version.
SQL Server 2005 Express Setup is 32bit, so its looking for software we cannot install right?
Then again i may be totally wrong ..... i dunno, i just dont want to have to format my laptop to reinstall XP or Vista 32
Finally! I know WHY I cannot get the enterprise version of SQL to download on Vista. Thank you!
I have been trying desperately for the past 2 days because of an onlne class that I am taking. I will try the Standard edition of SQL. Please keep your fingers crossed for me...
Thanks again, I have been SO frustrated!
E.
I do not expect any kind of an answer to the following question, but I have to ask it...
Why would MS release an operating system that does not support all of their current applications?!!!
Friday, February 24, 2012
installation issues
I am trying to install SQL 2005 on my new laptop (VISTA), but for some
reason reporting services is not available to install. I have IIS installed
and the services are running. Does anyone know of a reason SRS is not
available?
TIA,
JoeHello,
check this article
http://support.microsoft.com/kb/920201
"In this scenario, you receive the following warning message for the IIS
Feature Requirement item on the System Configuration Check page in the SQL
Server 2005 Setup program:
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. .... "
Best regards,
Radoslaw Lebkowski
U¿ytkownik "jaylou" <jaylou@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:C53A4956-A42D-4EE7-BB34-273B0A97F09A@.microsoft.com...
> Hi all,
> I am trying to install SQL 2005 on my new laptop (VISTA), but for some
> reason reporting services is not available to install. I have IIS
> installed
> and the services are running. Does anyone know of a reason SRS is not
> available?
> TIA,
> Joe
Installation fails on Vista RTM
Hi all!
I couldn't manage to install SQL Server 2005 Express or Standart Edition on Windows Vista. The installation fails with the error message I pasted below:
TITLE: Microsoft SQL Server 2005 Setup
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 'FUSION\SQLServer2005MSSQLUser$FUSION$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.2047.00&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40CnfgSQL%4080%40x3c29
Can someone please help me on this as this is an urgent situation...
Thanks in advance
Derya
This has been posted a few times on here and this thread appears to solve the problem.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=937333&SiteID=1
Thanks,
Sam Lester (MSFT)
Sam,
I am installing sql server 2005 developer edition on the release vista and I am getting the same issue. One of the solutions on the other thread deals with running a command after sql server 2005 is installed:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=907970&SiteID=1
and the other says the install fails as it does in this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=937333&SiteID=1
When the data services tries to install it fails saying the user or group cannot be found. I have adjusted the UAC on vista by disabling it and have made sure that iis 7 is running. I even have the
ii6 compatiblity turned on for vs 2005. The vista installation is a clean install, but since I cannot get sql server 2005 installed on vista I cannot install the november ctp of sp2. Is the only solution to go back to win xp sp2 install sql server 2005 and its sp2 and vs 2005 and then do an update of win xp sp2 to vista, or is a new install needed for sql server 2005 (one where you don't have to unplug the network cable to get "Setting File Attrbibutes" to stop? I am seeing the same issue in many places when I do a search. Please help.
|||Just posting to say I still have this problem too. The suggestions in the thread linked by Sam Lester (which I posted) didn't work either.|||I believe that they all link to this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=907970&SiteID=1
Is this the one you followed and it still doesn't work? If so, perhaps you can ask on that thread as well?
Thanks,
Sam
I have post this on other topic, but my hops get high when I fond this topic..but Let me start from beging
Vista RTM-->SQL Server 2005 Developer Edition-->Setup lead me to this error:
TITLE: Microsoft SQL Server 2005 Setup
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 'MASHINENAME\SQLServer2005MSSQLUser$MASHINENAME$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
Ok I found this thred http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=955752&SiteID=1 where user describe same problem and another link lead me here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=937333&SiteID=1 They are talking about lower case in mashine name. Last post in topic says this
Carsten N?rvig S?rensen wrote:
Thanks.
I had the exact same installation error, with many SQL server editions.
Changing the name of my pc eliminating lower-case and hyphenation solved the problem.
Carsten
MBS IT COE
Yes, in my error description was Masine name like this: MachineName, I chang it in MACHINENAME and start install again...but I have same error. After I hit "Retry" i get this message (cancel is only other option)
TITLE: Microsoft SQL Server 2005 Setup
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size.. Refer to the server error logs and Setup logs for detailed error information.
That is place when Setup tray to exectute some SQL command to configure SQL Server. When I hit cancel (retry it just repeat second error message) setup rool back database engine installaton and go on with setup...it only just a shell of VS, but fail with install of Management Studio and other tools.
I am realy stuck with this and REALY out of options. I see in this theer that some people have same issue and I hope that someome is get a solutions.
Thank you for reading this
Installation fails on Vista RTM
Hi all!
I couldn't manage to install SQL Server 2005 Express or Standart Edition on Windows Vista. The installation fails with the error message I pasted below:
TITLE: Microsoft SQL Server 2005 Setup
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 'FUSION\SQLServer2005MSSQLUser$FUSION$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.2047.00&EvtSrc=setup.rll&EvtID=29521&EvtType=lib%5codbc_statement.h%40Do_sqlScript%40OdbcStatement%3a%3aexecute_batch%40CnfgSQL%4080%40x3c29
Can someone please help me on this as this is an urgent situation...
Thanks in advance
Derya
This has been posted a few times on here and this thread appears to solve the problem.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=937333&SiteID=1
Thanks,
Sam Lester (MSFT)
Sam,
I am installing sql server 2005 developer edition on the release vista and I am getting the same issue. One of the solutions on the other thread deals with running a command after sql server 2005 is installed:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=907970&SiteID=1
and the other says the install fails as it does in this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=937333&SiteID=1
When the data services tries to install it fails saying the user or group cannot be found. I have adjusted the UAC on vista by disabling it and have made sure that iis 7 is running. I even have the
ii6 compatiblity turned on for vs 2005. The vista installation is a clean install, but since I cannot get sql server 2005 installed on vista I cannot install the november ctp of sp2. Is the only solution to go back to win xp sp2 install sql server 2005 and its sp2 and vs 2005 and then do an update of win xp sp2 to vista, or is a new install needed for sql server 2005 (one where you don't have to unplug the network cable to get "Setting File Attrbibutes" to stop? I am seeing the same issue in many places when I do a search. Please help.
|||Just posting to say I still have this problem too. The suggestions in the thread linked by Sam Lester (which I posted) didn't work either.|||I believe that they all link to this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=907970&SiteID=1
Is this the one you followed and it still doesn't work? If so, perhaps you can ask on that thread as well?
Thanks,
Sam
I have post this on other topic, but my hops get high when I fond this topic..but Let me start from beging
Vista RTM-->SQL Server 2005 Developer Edition-->Setup lead me to this error:
TITLE: Microsoft SQL Server 2005 Setup
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 'MASHINENAME\SQLServer2005MSSQLUser$MASHINENAME$MSSQLSERVER' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
Ok I found this thred http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=955752&SiteID=1 where user describe same problem and another link lead me here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=937333&SiteID=1 They are talking about lower case in mashine name. Last post in topic says this
Carsten N?rvig S?rensen wrote:
Thanks.
I had the exact same installation error, with many SQL server editions.
Changing the name of my pc eliminating lower-case and hyphenation solved the problem.
Carsten
MBS IT COE
Yes, in my error description was Masine name like this: MachineName, I chang it in MACHINENAME and start install again...but I have same error. After I hit "Retry" i get this message (cancel is only other option)
TITLE: Microsoft SQL Server 2005 Setup
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size.. Refer to the server error logs and Setup logs for detailed error information.
That is place when Setup tray to exectute some SQL command to configure SQL Server. When I hit cancel (retry it just repeat second error message) setup rool back database engine installaton and go on with setup...it only just a shell of VS, but fail with install of Management Studio and other tools.
I am realy stuck with this and REALY out of options. I see in this theer that some people have same issue and I hope that someome is get a solutions.
Thank you for reading this