Hi there,

I'm trying to get dnn 5 to run on an hosted server. Unfortunately the database install wizard fails. My provider uses SQL Server 2005 Sp3 with SQL Server authentification. I can test the database connection successfully, when I hit next I get this Error:

Installing Database - Version 05.00.00...FAILURE ERROR: See D:\Web\HA\17\1724_yfd9a\zw35a3e1\data\Providers\DataProviders\SqlDataProvider\05.00.00.log for more information
I can't find a Logfile with that name, however the File InstallCommon.log (and several others contain this Message:

System.Data.SqlClient.SqlException: Cannot find the user 'sql_ha1724_a', because it does not exist or you do not have permission.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

GRANT EXECUTE TO [sql_ha1724_a]
 

sql_ha1724_a is the name of my SQL Login and also the name of the Database (configured by profider - can't Change it)

The Provider says other customers sucessfully installed dnn, but he presumes they used earlier versions.

When I look in the db after the error (db was empty before) proc, views and tables have been created. The last table ist version, in my local test enviroment the WebServer table would be next.

Can anybody hazard a guess whats foul.

I'm glad for any help.

Florian

I debugged the problem and like to suggest a fix:

        Private Function GetConnectionStringUserID() As String   
            Dim DBUser As String = SqlHelper.ExecuteScalar(UpgradeConnectionString, CommandType.Text, "Select User").ToString()
            Return DBUser
        End Function

The method is locaded in the class SqlDataProvider

The original implementation parses the Connection string - but the Connection string contains the LoginName not the UserID.

I implemented the fix and sucessfully installed the Portal in my hosting account.

Cheers Florian