Wednesday, March 28, 2012
Installion problem with SQL Express April CTP
SQL Server Setup could not connect to the database service forserver configuration. The error was: {Microsoft}{ODBC Driver Manager}Data source name not found and no default driver specified Refer toserver error logs and setup logs for more information. For details onhow to view setup logs, see "How to View Setup Log Files" in SQL ServerBooks Online. Error No:29545
which I don't get since I have SQL Server 2000 Dev Edtion running,Win 2K sp4. I couldn't find anything in the MS KB to explain why it'sdoing so.. anything I missed perhaps?
Well, what does the setup log file have to say about the failure?
sql
Installing/Configuration
I'm
pretty new to this reporting services thing. I've installed it on my PC
and it runs fine. However, other PCs on my LAN can't access the reports
through their browser. I think there is an issue with IIS also involved
because they cannot even browse to the default website on my PC. There
may also be some security related issues as well (with IIS, Reporting
Services and my SQL Server 2005 database).
Is there any step
by step guide on how to configure all these three things properly for
remote access available that anyone can recommend?
Or can anyone give me advice?
Thanks,
Frank
Does the URL use the IP addy or machine name when they try to access the default website? If uses the machine name, try the IP address.
Are you on a workgroup or domain?
Can they ping your machine by name?
Is there an explicit error in the browser other than 404 not found?
What is the security model being used in IIS: Anonymous, IWA (integrated windows authentication)?
These are just a few questions to get us going in the right direction
Monday, March 26, 2012
Installing SQLExpress on XPHome
The software install hangs when the install goes out to check for my machine configuration.
No error codes or anything. I have to go to task manager to stop the install. It may can take two or three times to End Task before the setup actually stops.
Thanks for any help.
Check out the Setup log files located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more information about setup problems. You should also check the summary.txt file that is one directory up as that frequently points to the log where you will find the problem listed.
Regards,
Mike
I think I have the same problem, the installer doesn't go further than "checking installed IIS" and I think I have found the correct log.
In the end of the file it says something about IIS, it looks like this:
<EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='1008'>
PerfTime Stop: Write_sqlWellKnownAccountNames : Fri Apr 07 20:53:08 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='1008'>
Action ended 20:53:08: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (c) (74:44) [20:53:08:906]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS
Action start 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (74:24) [20:53:08:906]: Invoking remote custom action. DLL: C:\DOCUME~1\Simon\LOKALA~1\Temp\MSI17.tmp, Entrypoint: CheckIIS
<Func Name='LaunchFunction'>
Function=CheckIIS
MSI (c) (74!34) [20:53:08:921]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: CheckIIS
PerfTime Start: CheckIIS : Fri Apr 07 20:53:08 2006
<Func Name='CheckIIS'>
Action 20:53:08: CheckIIS. Detecting Installed IIS
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'.
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'.
Skipping RS Feature Dependency Check
<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.
However, I don't know what to do about it. Do you know anything else about the problem after reading this? How should I do to install SQL Server Express?
|||The end of my log-file looks identical to yours... I dont't seem to figure it out either..
Anybody?
Thanks!
EDIT:
After uninstalling, cleaning registry and restarting for about 40 times I found an old CD with SQL Server 2000 Evaluation Copy.
When trying to install this I get the error "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."
When I restart I see no improvent...
Does this help helping us?
Thanks
/Martin
|||I am having the exact same problem , it hangs where
it says checking IIs . I have been trying to get this
running for hours now . Microsoft please help us
I need this program to work very soon .....
Best wishes to all
TWS
Installing SQLExpress on XPHome
The software install hangs when the install goes out to check for my machine configuration.
No error codes or anything. I have to go to task manager to stop the install. It may can take two or three times to End Task before the setup actually stops.
Thanks for any help.
Check out the Setup log files located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more information about setup problems. You should also check the summary.txt file that is one directory up as that frequently points to the log where you will find the problem listed.
Regards,
Mike
I think I have the same problem, the installer doesn't go further than "checking installed IIS" and I think I have found the correct log.
In the end of the file it says something about IIS, it looks like this:
<EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='1008'>
PerfTime Stop: Write_sqlWellKnownAccountNames : Fri Apr 07 20:53:08 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='1008'>
Action ended 20:53:08: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (c) (74:44) [20:53:08:906]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS
Action start 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (74:24) [20:53:08:906]: Invoking remote custom action. DLL: C:\DOCUME~1\Simon\LOKALA~1\Temp\MSI17.tmp, Entrypoint: CheckIIS
<Func Name='LaunchFunction'>
Function=CheckIIS
MSI (c) (74!34) [20:53:08:921]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: CheckIIS
PerfTime Start: CheckIIS : Fri Apr 07 20:53:08 2006
<Func Name='CheckIIS'>
Action 20:53:08: CheckIIS. Detecting Installed IIS
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'.
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'.
Skipping RS Feature Dependency Check
<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.
However, I don't know what to do about it. Do you know anything else about the problem after reading this? How should I do to install SQL Server Express?
|||The end of my log-file looks identical to yours... I dont't seem to figure it out either..
Anybody?
Thanks!
EDIT:
After uninstalling, cleaning registry and restarting for about 40 times I found an old CD with SQL Server 2000 Evaluation Copy.
When trying to install this I get the error "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."
When I restart I see no improvent...
Does this help helping us?
Thanks
/Martin
|||I am having the exact same problem , it hangs where
it says checking IIs . I have been trying to get this
running for hours now . Microsoft please help us
I need this program to work very soon .....
Best wishes to all
TWS
sqlINstalling sql2005 Express
Something about ASP.NET. O yes, it is Vista Business.
System Configuration Check
- WMI Service Requirement (Success)
Messages
* WMI Service Requirement
* Check Passed
- MSXML Requirement (Success)
Messages
* MSXML Requirement
* Check Passed
- Operating System Minimum Level Requirement (Success)
Messages
* Operating System Minimum Level Requirement
* Check Passed
- Operating System Service Pack Level Requirement. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed
- SQL Server Edition Operating System Compatibility (Success)
Messages
* SQL Server Edition Operating System Compatibility
* Check Passed
- Minimum Hardware Requirement (Success)
Messages
* Minimum Hardware Requirement
* Check Passed
- IIS Feature Requirement (Success)
Messages
* IIS Feature Requirement
* Check Passed
- Pending Reboot Requirement (Success)
Messages
* Pending Reboot Requirement
* Check Passed
- Performance Monitor Counter Requirement (Success)
Messages
* Performance Monitor Counter Requirement
* Check Passed
- Default Installation Path Permission Requirement (Success)
Messages
* Default Installation Path Permission Requirement
* Check Passed
- Internet Explorer Requirement (Success)
Messages
* Internet Explorer Requirement
* Check Passed
- COM Plus Catalog Requirement (Success)
Messages
* COM Plus Catalog Requirement
* Check Passed
- ASP.Net Version Registration Requirement (Warning)
Messages
* ASP.Net Version Registration Requirement
* Failed to find the ASP.Net Version Registration with Microsoft Internet
Information Services (IIS).
- Minimum MDAC Version Requirement (Success)
Messages
* Minimum MDAC Version Requirement
* Check Passed
- Edition Change Check (Success)
Messages
* Edition Change Check
* Check Passed
ThanksMark,
You will either need to enable ASP on II6 (Disabled by default) or register
it so you can then enable it, to register refer
http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
to enable,
Open IIS Manager > Select Web Service Extensions, select the appropiate
service and "Allow" it..
Cheers
Matt
"Markgoldin" wrote:
> I have this report while installing this product.
> Something about ASP.NET. O yes, it is Vista Business.
> System Configuration Check
> - WMI Service Requirement (Success)
> Messages
> * WMI Service Requirement
> * Check Passed
>
> - MSXML Requirement (Success)
> Messages
> * MSXML Requirement
> * Check Passed
>
> - Operating System Minimum Level Requirement (Success)
> Messages
> * Operating System Minimum Level Requirement
> * Check Passed
>
> - Operating System Service Pack Level Requirement. (Success)
> Messages
> * Operating System Service Pack Level Requirement.
> * Check Passed
>
> - SQL Server Edition Operating System Compatibility (Success)
> Messages
> * SQL Server Edition Operating System Compatibility
> * Check Passed
>
> - Minimum Hardware Requirement (Success)
> Messages
> * Minimum Hardware Requirement
> * Check Passed
>
> - IIS Feature Requirement (Success)
> Messages
> * IIS Feature Requirement
> * Check Passed
>
> - Pending Reboot Requirement (Success)
> Messages
> * Pending Reboot Requirement
> * Check Passed
>
> - Performance Monitor Counter Requirement (Success)
> Messages
> * Performance Monitor Counter Requirement
> * Check Passed
>
> - Default Installation Path Permission Requirement (Success)
> Messages
> * Default Installation Path Permission Requirement
> * Check Passed
>
> - Internet Explorer Requirement (Success)
> Messages
> * Internet Explorer Requirement
> * Check Passed
>
> - COM Plus Catalog Requirement (Success)
> Messages
> * COM Plus Catalog Requirement
> * Check Passed
>
> - ASP.Net Version Registration Requirement (Warning)
> Messages
> * ASP.Net Version Registration Requirement
> * Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS).
>
> - Minimum MDAC Version Requirement (Success)
> Messages
> * Minimum MDAC Version Requirement
> * Check Passed
>
> - Edition Change Check (Success)
> Messages
> * Edition Change Check
> * Check Passed
>
> Thanks
>|||While I am using Vista that I dont have right now but I am opening I IS
Manager on my XP box
and I dont see Web Service Extensions. Can you please give me more details?
"Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
> Mark,
> You will either need to enable ASP on II6 (Disabled by default) or
> register
> it so you can then enable it, to register refer
> http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
> to enable,
> Open IIS Manager > Select Web Service Extensions, select the appropiate
> service and "Allow" it..
> Cheers
> Matt
>
>
> "Markgoldin" wrote:
>> I have this report while installing this product.
>> Something about ASP.NET. O yes, it is Vista Business.
>> System Configuration Check
>> - WMI Service Requirement (Success)
>> Messages
>> * WMI Service Requirement
>> * Check Passed
>>
>> - MSXML Requirement (Success)
>> Messages
>> * MSXML Requirement
>> * Check Passed
>>
>> - Operating System Minimum Level Requirement (Success)
>> Messages
>> * Operating System Minimum Level Requirement
>> * Check Passed
>>
>> - Operating System Service Pack Level Requirement. (Success)
>> Messages
>> * Operating System Service Pack Level Requirement.
>> * Check Passed
>>
>> - SQL Server Edition Operating System Compatibility (Success)
>> Messages
>> * SQL Server Edition Operating System Compatibility
>> * Check Passed
>>
>> - Minimum Hardware Requirement (Success)
>> Messages
>> * Minimum Hardware Requirement
>> * Check Passed
>>
>> - IIS Feature Requirement (Success)
>> Messages
>> * IIS Feature Requirement
>> * Check Passed
>>
>> - Pending Reboot Requirement (Success)
>> Messages
>> * Pending Reboot Requirement
>> * Check Passed
>>
>> - Performance Monitor Counter Requirement (Success)
>> Messages
>> * Performance Monitor Counter Requirement
>> * Check Passed
>>
>> - Default Installation Path Permission Requirement (Success)
>> Messages
>> * Default Installation Path Permission Requirement
>> * Check Passed
>>
>> - Internet Explorer Requirement (Success)
>> Messages
>> * Internet Explorer Requirement
>> * Check Passed
>>
>> - COM Plus Catalog Requirement (Success)
>> Messages
>> * COM Plus Catalog Requirement
>> * Check Passed
>>
>> - ASP.Net Version Registration Requirement (Warning)
>> Messages
>> * ASP.Net Version Registration Requirement
>> * Failed to find the ASP.Net Version Registration with Microsoft
>> Internet
>> Information Services (IIS).
>>
>> - Minimum MDAC Version Requirement (Success)
>> Messages
>> * Minimum MDAC Version Requirement
>> * Check Passed
>>
>> - Edition Change Check (Success)
>> Messages
>> * Edition Change Check
>> * Check Passed
>>
>> Thanks|||Hi Mark,
What version of IIS are you running ?
...Matt
"Mark Goldin" wrote:
> While I am using Vista that I dont have right now but I am opening I IS
> Manager on my XP box
> and I dont see Web Service Extensions. Can you please give me more details?
> "Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
> news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
> > Mark,
> > You will either need to enable ASP on II6 (Disabled by default) or
> > register
> > it so you can then enable it, to register refer
> >
> > http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
> >
> > to enable,
> > Open IIS Manager > Select Web Service Extensions, select the appropiate
> > service and "Allow" it..
> >
> > Cheers
> >
> > Matt
> >
> >
> >
> >
> >
> > "Markgoldin" wrote:
> >
> >> I have this report while installing this product.
> >> Something about ASP.NET. O yes, it is Vista Business.
> >>
> >> System Configuration Check
> >>
> >> - WMI Service Requirement (Success)
> >> Messages
> >> * WMI Service Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - MSXML Requirement (Success)
> >> Messages
> >> * MSXML Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Operating System Minimum Level Requirement (Success)
> >> Messages
> >> * Operating System Minimum Level Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Operating System Service Pack Level Requirement. (Success)
> >> Messages
> >> * Operating System Service Pack Level Requirement.
> >>
> >> * Check Passed
> >>
> >>
> >> - SQL Server Edition Operating System Compatibility (Success)
> >> Messages
> >> * SQL Server Edition Operating System Compatibility
> >>
> >> * Check Passed
> >>
> >>
> >> - Minimum Hardware Requirement (Success)
> >> Messages
> >> * Minimum Hardware Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - IIS Feature Requirement (Success)
> >> Messages
> >> * IIS Feature Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Pending Reboot Requirement (Success)
> >> Messages
> >> * Pending Reboot Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Performance Monitor Counter Requirement (Success)
> >> Messages
> >> * Performance Monitor Counter Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Default Installation Path Permission Requirement (Success)
> >> Messages
> >> * Default Installation Path Permission Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Internet Explorer Requirement (Success)
> >> Messages
> >> * Internet Explorer Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - COM Plus Catalog Requirement (Success)
> >> Messages
> >> * COM Plus Catalog Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - ASP.Net Version Registration Requirement (Warning)
> >> Messages
> >> * ASP.Net Version Registration Requirement
> >>
> >> * Failed to find the ASP.Net Version Registration with Microsoft
> >> Internet
> >> Information Services (IIS).
> >>
> >>
> >> - Minimum MDAC Version Requirement (Success)
> >> Messages
> >> * Minimum MDAC Version Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Edition Change Check (Success)
> >> Messages
> >> * Edition Change Check
> >>
> >> * Check Passed
> >>
> >>
> >>
> >> Thanks
> >>
>
>|||Well, on Vista it is 7. On Xp whatever comes with it.
"Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
news:2F90EE6E-9D66-4671-8A94-9D39280B0F86@.microsoft.com...
> Hi Mark,
> What version of IIS are you running ?
> ...Matt
> "Mark Goldin" wrote:
>> While I am using Vista that I dont have right now but I am opening I IS
>> Manager on my XP box
>> and I dont see Web Service Extensions. Can you please give me more
>> details?
>> "Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
>> news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
>> > Mark,
>> > You will either need to enable ASP on II6 (Disabled by default) or
>> > register
>> > it so you can then enable it, to register refer
>> >
>> > http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
>> >
>> > to enable,
>> > Open IIS Manager > Select Web Service Extensions, select the appropiate
>> > service and "Allow" it..
>> >
>> > Cheers
>> >
>> > Matt
>> >
>> >
>> >
>> >
>> >
>> > "Markgoldin" wrote:
>> >
>> >> I have this report while installing this product.
>> >> Something about ASP.NET. O yes, it is Vista Business.
>> >>
>> >> System Configuration Check
>> >>
>> >> - WMI Service Requirement (Success)
>> >> Messages
>> >> * WMI Service Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - MSXML Requirement (Success)
>> >> Messages
>> >> * MSXML Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Operating System Minimum Level Requirement (Success)
>> >> Messages
>> >> * Operating System Minimum Level Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Operating System Service Pack Level Requirement. (Success)
>> >> Messages
>> >> * Operating System Service Pack Level Requirement.
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - SQL Server Edition Operating System Compatibility (Success)
>> >> Messages
>> >> * SQL Server Edition Operating System Compatibility
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Minimum Hardware Requirement (Success)
>> >> Messages
>> >> * Minimum Hardware Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - IIS Feature Requirement (Success)
>> >> Messages
>> >> * IIS Feature Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Pending Reboot Requirement (Success)
>> >> Messages
>> >> * Pending Reboot Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Performance Monitor Counter Requirement (Success)
>> >> Messages
>> >> * Performance Monitor Counter Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Default Installation Path Permission Requirement (Success)
>> >> Messages
>> >> * Default Installation Path Permission Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Internet Explorer Requirement (Success)
>> >> Messages
>> >> * Internet Explorer Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - COM Plus Catalog Requirement (Success)
>> >> Messages
>> >> * COM Plus Catalog Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - ASP.Net Version Registration Requirement (Warning)
>> >> Messages
>> >> * ASP.Net Version Registration Requirement
>> >>
>> >> * Failed to find the ASP.Net Version Registration with Microsoft
>> >> Internet
>> >> Information Services (IIS).
>> >>
>> >>
>> >> - Minimum MDAC Version Requirement (Success)
>> >> Messages
>> >> * Minimum MDAC Version Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Edition Change Check (Success)
>> >> Messages
>> >> * Edition Change Check
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >>
>> >> Thanks
>> >>
>>|||I have no clue what do I need to do on my Vista to make RS running, not even
running, at least get installed.
I think it's time for a modern OS to have "Format hard drive" as addition to
Ok, Cancel.
"Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
> Mark,
> You will either need to enable ASP on II6 (Disabled by default) or
> register
> it so you can then enable it, to register refer
> http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
> to enable,
> Open IIS Manager > Select Web Service Extensions, select the appropiate
> service and "Allow" it..
> Cheers
> Matt
>
>
> "Markgoldin" wrote:
>> I have this report while installing this product.
>> Something about ASP.NET. O yes, it is Vista Business.
>> System Configuration Check
>> - WMI Service Requirement (Success)
>> Messages
>> * WMI Service Requirement
>> * Check Passed
>>
>> - MSXML Requirement (Success)
>> Messages
>> * MSXML Requirement
>> * Check Passed
>>
>> - Operating System Minimum Level Requirement (Success)
>> Messages
>> * Operating System Minimum Level Requirement
>> * Check Passed
>>
>> - Operating System Service Pack Level Requirement. (Success)
>> Messages
>> * Operating System Service Pack Level Requirement.
>> * Check Passed
>>
>> - SQL Server Edition Operating System Compatibility (Success)
>> Messages
>> * SQL Server Edition Operating System Compatibility
>> * Check Passed
>>
>> - Minimum Hardware Requirement (Success)
>> Messages
>> * Minimum Hardware Requirement
>> * Check Passed
>>
>> - IIS Feature Requirement (Success)
>> Messages
>> * IIS Feature Requirement
>> * Check Passed
>>
>> - Pending Reboot Requirement (Success)
>> Messages
>> * Pending Reboot Requirement
>> * Check Passed
>>
>> - Performance Monitor Counter Requirement (Success)
>> Messages
>> * Performance Monitor Counter Requirement
>> * Check Passed
>>
>> - Default Installation Path Permission Requirement (Success)
>> Messages
>> * Default Installation Path Permission Requirement
>> * Check Passed
>>
>> - Internet Explorer Requirement (Success)
>> Messages
>> * Internet Explorer Requirement
>> * Check Passed
>>
>> - COM Plus Catalog Requirement (Success)
>> Messages
>> * COM Plus Catalog Requirement
>> * Check Passed
>>
>> - ASP.Net Version Registration Requirement (Warning)
>> Messages
>> * ASP.Net Version Registration Requirement
>> * Failed to find the ASP.Net Version Registration with Microsoft
>> Internet
>> Information Services (IIS).
>>
>> - Minimum MDAC Version Requirement (Success)
>> Messages
>> * Minimum MDAC Version Requirement
>> * Check Passed
>>
>> - Edition Change Check (Success)
>> Messages
>> * Edition Change Check
>> * Check Passed
>>
>> Thanks
Friday, March 23, 2012
Installing SQL Server Reporting Services
Hi All,
I have just installed SQL Server Reporting Services and done the settings on Reporting Services Configuration.
The Server Status is 'green ticked' and it is Running, the Report Server Virtual Directory, Report Manager Virtual Directory, Windows Service Identity, Web Service Identity and Database Setup are all setup and 'green ticked'
But when I go to the Reports in IE:http://localhost/Reports I get the following error:
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I have googled this but do not seems to have a suitable solution for me. Please help.
Thanks in advanced.
Hi,
From the error message you provided, do you run your Reporting Service on Vista?
Since Reporting Services SP1 and earlier do not run on Windows Vista, you need to install SP2 for reporting service.
If you try to run an SP1 report server on Windows Vista, you will encounter the following errors:
|||
Hi,
Thanks for the comment. I have actually solved the problem now.
First: Stop Reporting Services
Second: Restart IIS
Third: Start Reporting Services
Then try browsinghttp://localhost/reports and it worked.
Cheers.
Monday, March 19, 2012
Installing SQL Server 2005 Express
Downloaded the program and followed the instructions (as vague as they are) the only thing I see to execute is the configuration tools. I am certain I have missed something. Can anyone assist?
Many thanks!!
SQL Server Express, like most independent database systems these days does not run as a visual application the way Internet Explorer or Notepad do, instead it runs automatically behind the scenes as a system service.
Have you tried to connect to the already running instance on your PC with a version of Visual Studio (including Express)? Have you tried to connect to it with one of the included management tools?
Also, be sure to grab a copy of SQL Server Management Studio Express from the SQL Express download page to give you even more management options.
|||thank you