Attempting to install SQL Server 2008 R2 I get the following Error " Check whether the Report Server is Correctly Configured .....

I am trying to install SQL Server 2008 R2 . I am not having much luck with this install.

I have searched around but do not see clearly the way to install with the Wizard. (even using msdn)

I have been through the msdn library and do not see how to launch the wizard and how to check through the 3 issues:
1. Check whether the Report Server is Correctly Configured............I do not know how to do that with the Wizard.
2. The database server is running......I do not know where to do that?
3. and you have permissions..............I am logged in as "The Administrator" not just part of a group

Can anyone give me an explanation of how to do that..?
SQLSERVERIntall-ReportingService.png
SQLInstallsOnServer.png
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan McCauleyEnterprise Analytics ManagerCommented:
Are you upgrading your 2005 instance or installing a second instance on the server? From your question and your screenshots, I can't tell which you're doing.

I've never done the Reporting Services configuration during SQL Server install - I've always selected the "Configure this later" option, and then run the standalone Reporting Services configuration wizard after SQL Server is done installing. It's easier to work with and will walk you more clearly though the steps involved in setting it up, including the permissions involved (which may be where you're having an issue). Try installing SQL 2008 R2 and selecting the "Configure later" option of SSRS.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
I have tried both the upgrade and the full install of R2 from 2008 only.

How can I skip the Reporting Services Configuration. Go back and uncheck it I assume...?
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
What if when I go back I cannot click off the selected items. It will not let me uncheck Reporting Services or Analysis Services.....? Any thoughts.
0
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
How can I check this off when I Windows will not allow me to. Here is the screen shot.
SQLSERVERIntall-SelectFeatures.png
0
Ryan McCauleyEnterprise Analytics ManagerCommented:
Ah - you can't change features when you're doing an upgrade, and that's what I initially asked.

Are you currently using Reporting Services? If you're not, you should run the SQL 2005 installer and remove it from your local installation (or run the SSRS 2005 Configuration Wizard and set up SSRS 2005 using the default options - you can do this from your start menu).
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
I wanted to make sure you said use SQL 2005. I have both 2005 and 2008 installed.
I am not sure if you meant I can do this from the start menu with an SQL 2005 or 08 install Disk or if I misunderstood....?
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
I wanted to make sure you said use SQL 2005. I have both 2005 and 2008 installed.
I am not sure if you meant I can do this from the start menu with an SQL 2005 or 08 install Disk or if I misunderstood....?
0
chrismcCommented:
I had error messages similar and it turned out to be because the machine name had been changed since the original SQL server installation. So the upgrade was trying to get SSRS to use an instance name that didn't exist but would allow me to correct it.

You have to change the machine name in sys.servers to make it match the current machine name.

Not sure if that's your issue but's worth a look.
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Where is the sys.servers .......? Is it a file. I think that is what has happened.
Please advise Chrismc.
0
chrismcCommented:
It's a table or view in the master database.
In fact there are some procedures to do the job, sp_dropserver and sp_addserver.
They are probably preferable to use - heres the relevant Microsoft article;
    http://msdn.microsoft.com/en-us/library/ms143799.aspx

Cheers
Chris
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
I tried this out and we did not get it to work any final suggestions. Is there a way to totally remove all instances of SQL 2005 2008 that will let me start over. I should also say that we have Visual Studio 2008 on this machine. Will this impact VS2008 in any way. Currently we are not using any databases from it.
Please advise and thank you for all this. I have no more hair to pull out of my head at this point.
0
chrismcCommented:
To uninstall, first go through the Add/Remove programs and remove everything relevant, which includes anything with Microsoft SQL in the title.

Then, using Windows Explorer, delete any SQL Server directories under program files - this will probably delete the databases too so backup before hand in case you need to recover anything.

Finally, clean the registry. A quick google shows these as the relevant keys;

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
 
VS2008 shouldn't matter in this, it just connects to SQL. It doesn't have the database engine built into it.

I do keep reading that SQL 2005 and SQL 2008 don't co-exist well. I have 2 VM's on my own personal computer to keep them separated. I assume you are installing Developer or Express editions.
I never was able to get SQL 2005 to install on Vista on other peoples machines. After 4 separate attempts I decided it wasn't worth the effort and I've installed SQL server on dev machines and servers probably well in excess of 50 times - so I'm not a novice.
Luckily for me I managed to avoid running that particular piece of rubbish (Vista) on any of my equipment.
Windows XP or Windows 7 is fine.
 
If this still doesn't work, I suggest you look into this here.
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Just wanted to verify everything that has SQL in it except SQLLite which we are actually using for the development. See image below.
SQLUninstall.png
0
chrismcCommented:
Anything with "Microsoft" and "SQL".

Obviously you don't want to nuke your SQLLite installation!

Cheers
Chris
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Okay I think I got everything can you tell me if these look right. I did not see the SYSTEM one you mentioned exactly in REGEDIT. But I did see this one. See images.
SQLUninstall-1.png
SQLUninstall-2.png
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
So I need to remove those two correct then restart and then reinstall SQL Server 2008 latest releases and then go with the Update to SQL Server 2008 R2 then do the Team Foundation Server.....? does that sound about right.
0
chrismcCommented:
Ssee stands for SQL server express edition and the second entry you showed is a reference to a SQL instance.
So, yes, you can remove them.
0
chrismcCommented:
SQL 2008 r2 is a distinct version not an upgrade like a service pack.
My recommendation would be to go straight to R2

If you load up an older version db it will upgrade it for you or you run it in "compatibility" mode.
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
One last thing chrismc (alias Obi One to me) Now do I put SQL Server 2008 and SQL Server 2008 R2 on this box. Then put the Team Foundation Server on here......?
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
One last thing chrismc (alias Obi One to me) Now do I put SQL Server 2008 and SQL Server 2008 R2 on this box. Then put the Team Foundation Server on here......?
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
All your comments were dead on. Thank you. I uninstalled the system and started over.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.