| Author | Messages | |
benjamin ruoff
New Poster
Posts:2
 | | 10/17/2007 2:32 PM |
| Hello Guys, Im trying to install DNN 04.06.02 but I always get this strange error code when I´m trying to start the installationprocess by executen the http://localhost/dotnetnuke/install/install?mode=install. I edited the web.config file as it is shown in the video tutorial. Why is dnn not creating any tables and stored procedures ? Has anybody a clue how to fix that prob | | | |
| Mitchel Sellers
Site Admin/Owner
Guru
Posts:5644
| | 10/17/2007 2:43 PM |
| My guess is that it is having difficulties connecting to the database.
Have you triple checked that both of your connection strings were modified to meet your needs? | |
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.
3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
| benjamin ruoff
New Poster
Posts:2
| | 10/18/2007 1:32 AM |
| Yes I checked them for about 10 times, the settings must be correct. In my own c# .net applications my local database server works just fine. I use the MS SQL Server 2000, is this maybe a problem ? | | | |
| Mitchel Sellers
Site Admin/Owner
Guru
Posts:5644
| | 10/22/2007 10:29 AM |
| SQL 2000 isn't a problem at all.
Can you see any tables created in your database? | |
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.
3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
| John Terpening
New Poster
Posts:9
| | 10/22/2007 6:17 PM |
| ...seeing the same error in your forum statistics now, Mitchel:
Most Active:The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
Most Views:The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
Most Replies:The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
Statistics Last Created:10/22/2007 6:22 PM | |
Priceline Bid Database | |
| mrichardson
New Poster
Posts:12
| | 03/31/2008 7:54 AM |
| Did anyone solve their 'stored procedure' issue?
we're having same problem.
seem to think that the problem is not related to our web config connection settings or installation of dotnetnuke, but more to do with security or permissions issue,
as we also get this error when connecting to another database (not dnn) from same web server to the same sql server.
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"
| | | |
| Mitchel Sellers
Site Admin/Owner
Guru
Posts:5644
| | 03/31/2008 9:49 AM |
| | The issue with the login failed for the user (null) is typically due to an expired lan login when using integrated security....if you are not using integrated security, be sure to set it to false, or simply omit the declaration from the connection string. | |
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.
3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
| lauren
New Poster
Posts:2
| | 06/04/2008 12:47 PM |
| I am having this same error. I think I'm getting to my database, and there really isn't a GetPortalAliasByPortalID in the stored procedures.
So I started installing 4.8.3 this morning. It went through the database test and the install of the database starting at some previous version and proceeding through. Then it stopped as it said it had an error accessing website/portals/_default/03.00.08 (permission error), even though I had set up the NETWORK SERVICES and the ASPNET users to have full permission on the entire WEBSITE directory.
So after some investigation and redoing the permissions (even though I thought them correct), I tried to run http://localhost/dotnetnuke again, and it wouldn't work. It gave me an error.
SO I deleted the database and recreated, redownloaded the software, re-set up the web.config and rerun.
Now when I go in to http://localhost/dotnetnuke, I get an error that the application is not available, please try again later.
Then, if I try again, I get:
Server Error in '/dotnetnuke' Application.
--------------------------------------------------------------------------------
The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
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.InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
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:
[InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.]
System.Data.SqlClient.SqlCommand.DeriveParameters() +947206
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
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.Data.SqlDataProvider.GetPortalAliasByPortalID(Int32 PortalID) +87
DotNetNuke.Entities.Portals.PortalAliasController.GetPortalAliasByPortalID(Int32 PortalID) +35
DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasLookup() +74
DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasInfo(String PortalAlias) +14
DotNetNuke.HttpModules.UrlRewriteModule.RewriteUrl(HttpApplication app) +3342
DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +1180
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
There are 3 stored procedures in the database (finddatabaseversion, getdatabaseversion, and updatedatabaseversion) and no tables.
Help would be greatly appreciated.
| | | |
| lauren
New Poster
Posts:2
| | 06/04/2008 12:47 PM |
| I am having this same error. I think I'm getting to my database, and there really isn't a GetPortalAliasByPortalID in the stored procedures.
So I started installing 4.8.3 this morning. It went through the database test and the install of the database starting at some previous version and proceeding through. Then it stopped as it said it had an error accessing website/portals/_default/03.00.08 (permission error), even though I had set up the NETWORK SERVICES and the ASPNET users to have full permission on the entire WEBSITE directory.
So after some investigation and redoing the permissions (even though I thought them correct), I tried to run http://localhost/dotnetnuke again, and it wouldn't work. It gave me an error.
SO I deleted the database and recreated, redownloaded the software, re-set up the web.config and rerun.
Now when I go in to http://localhost/dotnetnuke, I get an error that the application is not available, please try again later.
Then, if I try again, I get:
Server Error in '/dotnetnuke' Application.
--------------------------------------------------------------------------------
The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
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.InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
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:
[InvalidOperationException: The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.]
System.Data.SqlClient.SqlCommand.DeriveParameters() +947206
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
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.Data.SqlDataProvider.GetPortalAliasByPortalID(Int32 PortalID) +87
DotNetNuke.Entities.Portals.PortalAliasController.GetPortalAliasByPortalID(Int32 PortalID) +35
DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasLookup() +74
DotNetNuke.Entities.Portals.PortalSettings.GetPortalAliasInfo(String PortalAlias) +14
DotNetNuke.HttpModules.UrlRewriteModule.RewriteUrl(HttpApplication app) +3342
DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +1180
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
There are 3 stored procedures in the database (finddatabaseversion, getdatabaseversion, and updatedatabaseversion) and no tables.
Help would be greatly appreciated.
| | | |
| Mitchel Sellers
Site Admin/Owner
Guru
Posts:5644
| | 06/05/2008 12:33 AM |
| Those errors are typically from incorrect connections.
Take your connection information from the web.config, and try to manually connect to the server to see if it works. | |
-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.
3Essentials is my recommended Shared Hosting Provider
This site is hosted on a VPS from HostMySIte.com
Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!
To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs | |
| Ruprict
New Poster
Posts:1
| | 06/24/2008 4:59 PM |
| Last time I had this error, it was b/c I wasn't connecting to the database as dbo. Check the owner of your db (In Mgt Studio, right-click Properties) If you need to change the owner there is stored proc to do this, that goes somethign like:
USE [db]
GO
EXEC sp_changedbowner 'owner'
GO
Hope this is useful. | | | |
|
|