 |
|
|
|
Joined: 5/4/2010
Posts: 42
|
|
|
Greetings, I am having problems installing dnn7. I have an environment with two servers. server 1 is running win server 2008 r2, iis7. Server 2 is running win server 2008 r2 with sql server 2008 r2. I watched the installation videos many times but they don't seem to cover this particular situation. I can't seem to perform the recommended action, to use a windows account for the SQL permissions and file permissions, because I'm in a domain, and SQL server installation is on a separate server. So I have to use SQL Server permissions, or the connection string won't work (I already tried with a domain account, no go). The installation apparently completes without errors, but then the website is unable to load. Any help for installation in an environment like mine would be much appreciated.
|
| |
|
|
 | |
|
|
|
Joined: 1/19/2004
Posts: 924
|
|
|
Create a separate account to connect to the database and use that during the installation. The fact that it's on a different server doesn't matter as long as you have the proper credentials and access to the database server.
Mark
|
| |
|
|
| |
|
|
|
your SQL server needs to be configured for "mixed authentication", to allow using local sql server accounts, which is required, if not both servers are in the same domain.
|
| |
|
|
| |
|
|
|
Joined: 5/4/2010
Posts: 42
|
|
|
I have a separate, SQL Server login for my database. It has the proper credentials. I see that the installation appears to complete fully, and the database tables and objects all appear to be in place. My SQL Server is in the same domain as my web server, and SQL Server is using mixed authentication. I looked at the log table in the database and see this in particular at the beginning of the log, not sure if this may be the root of the problem 2da7b23e-1f81-4f87-9dbc-6e350ef49f6b GENERAL_EXCEPTION 4 NULL NULL NULL NULL 2012-12-13 09:30:07.520 System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'TabName', table 'DotNetNuke.dbo.Tabs'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The 'AddTab' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args)
at DotNetNuke.Data.SqlDataProvider.ExecuteScalar[T](String procedureName, Object[] commandParameters)
at DotNetNuke.Data.DataProvider.AddTabToEnd(TabInfo tab, Int32 createdByUserID)
at DotNetNuke.Entities.Tabs.TabController.AddTabInternal(TabInfo tab, Int32 afterTabId, Int32 beforeTabId, Boolean includeAllTabsModules)
at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean includeAllTabsModules)
at DotNetNuke.Services.Upgrade.Upgrade.AddPage(Int32 portalId, Int32 parentId, String tabName, String description, String tabIconFile, String tabIconFileLarge, Boolean isVisible, TabPermissionCollection permissions, Boolean isAdmin)
at DotNetNuke.Services.Upgrade.Upgrade.AddPage(TabInfo parentTab, String tabName, String description, String tabIconFile, String tabIconFileLarge, Boolean isVisible, TabPermissionCollection permissions, Boolean isAdmin)
at DotNetNuke.Services.Upgrade.Upgrade.AddHostPage(String tabName, String description, String tabIconFile, String tabIconFileLarge, Boolean isVisible)
at DotNetNuke.Providers.FiftyOneClientCapabilityProvider.Components.FeatureController.AddClientResourceAdminHostPage()
at DotNetNuke.Providers.FiftyOneClientCapabilityProvider.Components.FeatureController.UpgradeModule(String version)
at DotNetNuke.Entities.Modules.EventMessageProcessor.UpgradeModule(EventMessage message)
ClientConnectionId:a79e2b4a-853f-419c-9a5e-bae57d441d27Source NULL 19
|
| |
|
|
| |
|
|
|
Joined: 5/4/2010
Posts: 42
|
|
|
I got a successful install, but I can't point to exactly what finally made it work. I had been changing the "host" account name, website name, and using the blank template. This time I left those settings as their default values and it worked.
|
| |
|
|
| |