New error!

It never gets old...

Here is what I get now after moving the DB, attaching it, recreating users, checking web.config, moving website files exactly as they were, etc.

Server Error in '/' Application.
--------------------------------------------------------------------------------

Login failed for user 'theburbblog.com'. The user is not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'theburbblog.com'. The user is not associated with a trusted SQL Server connection.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace:


[SqlException (0x80131904): Login failed for user 'theburbblog.com'. The user is not associated with a trusted SQL Server connection.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +204
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
   DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.GetLogTypeConfigInfo() +68
   DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfo() +108
   DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfoByKey(String LogTypeKey, String LogTypePortalID) +62
   DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.AddLog(LogInfo objLogInfo) +72
   DotNetNuke.Services.Log.EventLog.LogController.AddLog(LogInfo objLogInfo) +176

 
 

I would really appreciate some additional help on this issue.

I know that DNN is free- but I have been an advocate of it for quite a while, getting other people to use it- helping them where I can.  This seems to be a major drawback to me.  I simply can not get this thing moved from one physical machine to another.  I'm not using any shared hosting plans- I have full access to the two machines.  I would love to be able to move this- to help someone else run a DNN instance on their home PC for testing, and move it to a live server when it's ready.  I don't know where else to look to for help.  At this point, I am paying $150/month to keep two sites up, because I can't get them moved.  My other DNN sites running were small enough that I just gave up and used the amazing copy/paste method to move them.  What kind of techie does that make me?  So please help.  Even if it's just pointing me in the right direction.  DNN is getting WAY too expensive for a free-open-source product at this point.  Had I known it would take me this much time and money to get a single site (or multiple sites) moved, I never would have used DNN in the first place.  I feel that with every step I've taken, I'm just a few simple clicks or config files away.  I think once my issues are ironed out, I can be a moving machine, and get 50 sites moved a day if I needed to.

Let me know what additional info you need to help solve this.  If someone is daring enough to do a confrence call with me, and some sort of desktop sharing, I will set it up!  Anything that will cost me less than $150 per month to get this issue resolved.