Hi,
Complete newb here - so I apologize ahead of time if my questions are of nuisance level. I am trying to rebuild a website for my children's small private school (no budget) and decided on DotNetNuke as the foundation. I greatly appreciate any help that you can provide. However, before attempting to install it on an external host server, I decided to first attempt an installation on my XP Pro SP3 machine. I'm beginning to think that was a mistake.
My installed tools are IIS 6, SQL Server 2005, SSMSE & VWD 2008 Express. I have followed Mr. Hock's tutorial to the best of my understanding (which I admit is limited). After attempting 3 clean installations with no success, I would pay for help if I could. The problem that occurs after running the installation is:
(under construction page)
Error Installing DotNetNuke
Current Assembly Version: 04.09.02
ERROR: Could not connect to database specified in connectionString for SqlDataProvider
I have no idea what information will be helpful to you, I am including the message if I attempt to simply bring up the "site." :
Login failed for user 'dnnJMSdbAdmin'. 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 'dnnJMSdbAdmin'. 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 'dnnJMSdbAdmin'. The user is not associated with a trusted SQL Server connection.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +428
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +233
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +343
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +175
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +45
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +207
DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.GetLogTypeConfigInfo() +71
DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfo() +101
DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfoByKey(String LogTypeKey, String LogTypePortalID) +65
DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.AddLog(LogInfo objLogInfo) +75
DotNetNuke.Services.Log.EventLog.LogController.AddLog(LogInfo objLogInfo) +193
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082
I have tried using both (local) and machine-name\server_name in the connection strings in web.config without success.
Again, thank you for your assistance.
Lon Diffenderfer