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