How can I set Sql Server Reporting Services 2008 to non-Sharepoint-integrated mode?

My Sql Server 2008 instance was originally installed as an Enterprise trial on my Vista x64 PC.  After the trial period expired, I downgraded it to Standard Edition.  

I installed SSRS 2008 in Sharepoint integrated mode.  But, I have not installed Sharepoint.  When I go to run SSRS from my localhost, I get the error that appears below.  I'd rather not install Sharepoint as my target machine will not have it.  How do I change SSRS so that it will run in non-Sharepoint-integrated mode?  Is there an easier way than uninstalling and resinstalling it?

Uninstalling SSRS doesn't look easy.  I reran the setup from a DVD and selected the "Add features to an existing instance" option.  When I got to the [Feature Selection] step, all the checkboxes that were checked, including [Reporting Services], were disabled.  I could not uncheck it.  And SSRS does not have its own entry in the Visa Control Panel Programs and Features.  I really don't want to uninstall Sql Server entirely to get this done.



The application domain WindowsService_0 failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointObjectModelNotInstalled: The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
   at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
   at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
   at System.Reflection.Assembly.Load(String assemblyString)
   at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
.
   at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread(Object firstStart).

Open in new window

carlkelleyAsked:
Who is Participating?
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.

carlkelleyAuthor Commented:
I was just able to successfully uninstall SSRS via the command line.  I opened a CMD window as Administrator, navigated to my Sql Server 2008 DVD drive, and entered the command that appears below. "MySqlServerInstanceName" was obtained from the Services listing for SSRS in parenthesis.
setup.exe /ACTION=uninstall /FEATURES=RS /INSTANCENAME=MySqlServerInstanceName

Open in new window

0
carlkelleyAuthor Commented:
When I tried to reinstall SSRS using the "ACTION=install" of the above command line, I noticed that it would not allow me to choose the installation directory.  It chose C:\Program Files\... when it was on B: before.  I decided to let the setup proceed, but it failed in the final installation stop with the following error:
SSRSinstallerror.gif
0
carlkelleyAuthor Commented:
So, now my problem has changed a bit from my original question.  Now I need to know who to install SSRS 2008 without Sharepoint-integration on my Vista x64 PC.  I just discovered an /INSTANCEDIR= parameter thanks to http://msdn.microsoft.com/en-us/library/ms144259%28SQL.100%29.aspx.  I'll try that next.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

carlkelleyAuthor Commented:
I reran the command line install including the /INSTANCEDIR= parameter and got the same 0x84B4000 error on the final step.
0
carlkelleyAuthor Commented:
I found the setup log file at C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100411_194142\Detail.txt.  It included the following lines that told me I had an invalid /INSTANCEDIR parameter.
2010-04-11 19:43:30 Slp: Sco: Attempting to get directory information for path C:\Program Files\Microsoft SQL Server\
2010-04-11 19:43:30 Slp: Sco: Attempting to get directory information for path C:\Program Files\Microsoft SQL Server\
2010-04-11 19:43:30 Slp: Sco: Attempting to get directory information for path C:\Program Files (x86)\Microsoft SQL Server\
2010-04-11 19:43:30 Slp: Sco: Attempting to get directory information for path C:\Program Files (x86)\Microsoft SQL Server\
2010-04-11 19:43:30 Slp: Sco: Attempting to get directory information for path B:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER2K8
2010-04-11 19:43:30 Slp: Sco: Attempting to get directory information for path B:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER2K8
2010-04-11 19:43:30 Slp: Hosting object: Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings failed validation
2010-04-11 19:43:30 Slp: Validation for setting 'The specified directory does not match the directory of currently installed features.' failed. Error message: InstanceDir
2010-04-11 19:43:30 Slp: Error: Action "ValidateFeatureSettings" threw an exception during execution.

Open in new window

0
carlkelleyAuthor Commented:
The following command successfully installed SSRS:
setup.exe /ACTION=install /FEATURES=RS /INSTANCENAME=MySqlServerInstanceName /INSTANCEDIR
="B:\Program Files\Microsoft SQL Server"

Open in new window

0
carlkelleyAuthor Commented:
The [Supplemental Information] displayed on the last step of the SSRS setup indicated that it was installed without Sharepoint integration:
Reporting Services

The Reporting Services installation options that you specified in Setup determine whether additional configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed the program files only, you must run the Reporting Services Configuration tool to deploy the report server.

To install the Reporting Services Add-in for SharePoint Technologies, start the rsSharePoint.msi in the Setup folder on the SQL Server 2008 installation media after SQL Server Setup is complete.

Open in new window

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
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
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.