Search This Blog

Loading...

Tuesday, July 9, 2013

[SQL 2012] Restore databse from SQL SERVER 2005 to SQL SERVER 2012.

[SQL 2012] Restore databse from SQL SERVER 2005 to SQL SERVER 2012.


Restore databse from SQL SERVER 2005 to SQL SERVER 2012.

Posted: 08 Jul 2013 10:31 PM PDT

Hi,We are in planning phase to migrate our current databases from SQL Server 2005 (SP3 + CU6) to SQL SERVER 2012.Will their be any issue if we take the backup and restore it to the new environmnet(SQL 2012).Is it necessary to apply SP4 on SQL Server 2005 before we plan to migrate.Thanks in advance.Regards,--Vinod

Report Processing login failed error From Application

Posted: 09 Jul 2013 01:25 AM PDT

Hi, we are migrating our database and report server from SQL 2005 to SQL 2012 and we have move DB to new server. i have configured the reporting server to AD user. We also have deployed reports to SQL 2012 reporting server. recently installed SQL 2012 SP1 on this machine. when we configured report server , we were able to get reports from application side without any problem. we have refresh our db recently and now when we call reports from application site we are facing below error.An error has occurred during report processing. (rsProcessingAborted)Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Any idea what setting we have to change, i also tried using execution account but not luck.i check that AD user we are using, is a DB_owner of the accessing DB.Any help will be appreciated

No comments:

Post a Comment