I had SQL Server 2008 Developer's Edition on my Window 7 PC. I found that Reporting Services would not run because of rights (My ID has administrator rights, but no password.) I created another ID with administrative rights and a password. I could not enter the report server with the new ID because of rights. I reinstalled reporting services, and got the same problem. I tried to get around the problem by installing SQL Server 2010 Express with Advanced Services. After installation, Reporting Services was grayed out. I uninstalled both SQL Server 2008 and 2010. When I tried to reinstall SQL Server 2008, I got a message that the install couldn't proceed because Visual Studio 2008 needed Service Pack 1.0 (this patch was installed.) I uninstalled Visual Studio, but was left with several parts. I uninstalled each part. The reinstall of SQL Server 2008 got the same message about Visual Studio and Service Pack 1 even though Visual Studio was uninstalled. I need help to reinstall SQL Server 2008 (with SSRS) and Visual Studio 2008 without wiping my C drive.
Already Tried: I had SQL Server 2008 Developer's Edition on my Window 7 PC. I found that Reporting Services would not run because of rights (My ID has administrator rights, but no password.) I created another ID with administrative rights and a password. I could not enter the report server with the new ID because of rights. I reinstalled reporting services, and got the same problem. I tried to get around the problem by installing SQL Server 2010 Express with Advanced Services. After installation, Reporting
Hello, My name is XXX XXX I'll be happy to help you with your installation.
Please let me know when you have entered this chat session and are ready
Hi Joe
I'm here and ready
Great
If I understand correctly, you ultimately want SQL 2008 installed on your PC
Because you have installed and uninstalled several pieces, I think the best way to start fresh would be to get your PC back to a state prior to the first installation.
I had SQL Server 2008 and Visual Studio 2008 on my PC. I need to do some work in Sql Server Reporting Services (SSRS). That is the component that isn't working. SQL Server and Visual studio was working fine, SSRS is the problem.
Is both SQL 2008 and Visual Studio 2008 on your pc right now?
Are you still with me? It shows you typing but I haven't seen a response.
I tried to take it back by uninstalling SQL Server and Visual Studio. Both are uninstalled. When I tried to reinstall SQL Server, I got a message that Visual Studio needs Service Pack 1.
I think in this case a system restore would be the easiest and fastest way to get things back to a working point. Then resolve the permissions issue with SSRS.
Do you want to go that route?
Our chat has ended, but you can still continue to ask me questions here until you are satisfied with your answer. Come back to this page to view our conversation and any other new information. What happens now? If you haven’t already done so, please rate your answer above. Or, you can reply to me using the box below.
I don't want to clear the hard drive.
We can continue to trade messages until we get your problem resolved. You don't need to clear the hard drive. Just restore it to a point in time. When did you start installing SSRS?Please let me know if you need assistance with the system restore. You sound pretty technical literate so I dolt want ti insult you by providing you first grade instructions.
I installed it when SQL Server was installed a year ago. I did use it a few times. I uninstalled it and reinstalled Tuesday.
If everything (except SSRS) was working on Tuesday, then thats where you want to restore your computer to.
Ok
Do you need the steps to perform a system restore?
I don't have a restore disk. What are the steps to restore it to Tuesday?
No need for a restore disk. Thats not what we want to do.
1. Open System Restore by clicking the Start button , clicking All Programs, clicking Accessories, clicking System Tools, and then clicking System Restore. If you are prompted for an administrator password XXXXX confirmation, type the password XXXXX provide confirmation.
2. Follow the steps in the wizard to choose a restore point and restore your computer.
3. Try using a restore point created just before the date and time you started noticing problems. The descriptions of the restore points that are created automatically correspond with the name of an event, such as Windows Update installing an update. System Restore returns your computer to the state that it was in before the restore point that you chose.
Note: Check the Show restore points older than 5 days checkbox to see more than the most recent restore points.
Note: Any restore points that you created, scheduled restore points that Windows created, and those created automatically during the installation of certain programs will be listed here. You cannot use System Restore to undo changes to a date that a restore point does not exist.
If you successfully restored your computer to a previous state, and the computer performs as expected, you are finished.
In the System Restore Window, there are many restore points on 7/24/2012. The earliest one has a description that points to the one of the uninstalls of the parts that were left after I uninstalled Visual Studio (C++). Is there a way to go back earlier, to a point before SQL Server was uninstalled?
Check the "Show restore points older than 5 days" checkbox to see more than the most recent restore points.You cannot use System Restore to undo changes to a date that a restore point does not exist.
On Restore system files and settings, there are two radio button. I chose "Choose a different restore point", next>I checked "Show more restore points" The earlyist is the one I mentioned. So with no restore points early enough, is there any other way?
Unfortunately not. If a date isn't listed there then the only other option would be if you had a complete system backup.Not knowing how much you installed/uninstalled, there could be a chance that the oldest one might work. But there may still be some tweaking to do. I cant guarantee we can start at a stable point if you cant get a desired restore point.It's completely reversable though. Even if you restore to a prior state and it doesn't work, you can still "undo" the restore back to how it is right now.
The earlyist restore point is well past the point where I uninstalled SQL Server. If that is the only option beside wiping the hard drive, then I will try it. How do I continue our conversation once the PC reboots?
,
Just bookmark this page.You should also receive an email when I post a message in reply to you.