ExecuteNonQuery Error after redeployment

Very useful article just saved me from a day of frustration.

When redeploying an organisation database from a foreign environment, the app pool will not have permission to the new database and must be configured in the SQL database's security settings.

http://www.langalaxy.de/2009/11/system-invalidoperationexception-at-crm-logon/

Rename SQL Server Instance

• For a renamed computer that hosts a default instance of SQL Server, run the following procedures:

  
  

  sp_dropserver  GO sp_addserver , local GO 

  Restart the instance of SQL Server.

• For a renamed computer that hosts a named instance of SQL Server, run the following procedures:

  
  

  sp_dropserver  GO sp_addserver , local GO 

  Restart the instance of SQL Server.

  Then:

  SELECT @@SERVERNAME AS 'Server Name'

  From:

  http://msdn.microsoft.com/en-us/library/ms143799.aspx