Last Post 3/27/2009 6:23:13 PM By lukezy.
1 replies.
| 3/27/2009 5:39:16 PM |
|
LOLIU
Posts: 22
Joined: 5/28/2008
|
Upgrade from 3.0 to 3.1 doesn't work
|
|
Hi,
I just upgrade my site from v3.0 to v3.1. I run the script in Migration folder. Unfortunately, when I tried to access the page http://www.adepower.com/admin/, I got the error page:
SELECT permission denied on object 'aspnet_Membership', database 'ADEPower', schema 'dbo'.
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: SELECT permission denied on object 'aspnet_Membership', database 'ADEPower', schema 'dbo'.
Source Error:
<table width="100%" bgcolor="#ffffcc">
<tbody>
<tr>
<td>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.</td>
</tr>
</tbody>
</table>
Stack Trace:
<table width="100%" bgcolor="#ffffcc">
<tbody>
<tr>
<td>
[SqlException (0x80131904): SELECT permission denied on object 'aspnet_Membership', database 'ADEPower', schema 'dbo'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) +126
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1623
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
</td>
</tr>
</tbody>
</table>
|
| 3/27/2009 6:23:13 PM |
|
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
|
Re: Upgrade from 3.0 to 3.1 doesn't work
|
|
Looks like the permission issue. Find "-- Post-Deployment Script Template" in CreateDB.sql in install directory and run all the "GRANT" SQL statement.
DotShoppingCart Staff
|