Archive for April 19th, 2009

First install SQL Server 2008 & Reporting Services 2008: first settings

April 19, 2009

Here are some hints occurs frequently in fist steps after installing SQL Server 2008 and Reporting Services 2008.

During design step of a SQL Server table, you get this message in a two-buttons popup (cancel, save text file):

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.

Well, self-explaining isn’t it ?
Ok ;( here is a hint:
and uncheck “Prevent saving changes that require table re-creation” option.

Prevent saving changes that require the table to be re-created

What about Reporting Services?
You’ve just run throught “Reporting Services Configuration Manager”, accepting all default configs,
but you get this error when you access both to /REPORTS and /REPORTSERVER:

The report server has encountered a configuration error. (rsServerConfigurationError)

This is a bit tricky: most likely you forgot to configure ReportServer database. 😉


Two hints in a row. 🙂

source: SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted
source: Reporting Services 2008 Configuration Mistake

Technorati tags: SQL Server, Reporting Services