I need to restore my database to SQL server 2008. Currently we are having our database in SQL Server 2005 in one server. We need to take the back up of that database and move that database to SQL server 2008 in another server. I can find the steps to move 2008 to 2008 or 2008 to 2005. But i cant find any documents or guidelines to move 2005 to 2008. How i can i do this?
Situation - Server running windows server 2003 and SQL Server 2005. About 18 various databases on the server. We need to upgrade to Windows Server 2008R2 and SQL Server 2008. We can't afford to lose any of the databases (if I did my life as I know it would be over...)
What's the safest / simplest way - and how do I get all the users and roles done as well?
How do configure a trusted connection between IIS 7 and SQL Server 2005?
My webapp was working fine with Windows Authentication enabled in IIS. Now, in order to solve a problem, we need to use a trusted connection. Unfortunately, enabling the trusted connection in the web.config broke the webapp.