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

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:
go to TOOLS\OPTIONS\DESIGNERS\TABLE AND DATABASE DESIGNERS popup,
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. šŸ˜‰

rs2008_database_reportserver

Woitla’.
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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: