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
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
|You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General |
To stop receiving these emails, you may unsubscribe now.
|Email delivery powered by Google|
|Google Inc., 20 West Kinzie, Chicago IL USA 60610|