Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Installation Error - The stored procedure Installation Error - The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
Previous
 
Next
New Post
11/5/2007 12:13 PM
 

Hello all,

I installed DNN462 on my local computer. The installation succeeded.

I tried to install DNN462 on my host twice.
In the first time, when I run the installation, I got the error:
"The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist."
My hosting company solved the problem. I got back the installation wizard and I succeeded in the installation process.
In the second time, I got the same error:
"The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist."
And my hosting company is now trying to help me.

Can someone explain:
Why do I get the above error?
How can I prevent it?

Thanks in advance for your help
Nir

 
New Post
11/5/2007 12:18 PM
 

Nir,

This error message is generally caused by an invalid connection string or the specified user not being able to log in to the database. Generally if you refresh your page you will expose the "real" error message. I would see if this is the case and go from there.

hope that helps,

Ian


Software Engineer
Co-Founder, dnnGallery
Stack Overflow: Ian Robinson
Twitter: @irobinson
Linked In: Ian Robinson
 
New Post
11/5/2007 12:57 PM
 

Hello Ian,

Thanks for your answer.

My hosting company say that I have permissions to my DB (db_owner).
I can't access the DB permissions and see if they are right.
But I asked them to check it many times and they still say I have permissions.
I checked the strings to my DB and so did my hosting company.

If I refresh my page I see the same error message. So this is not where I can start.

Nir

 
New Post
11/5/2007 1:13 PM
 

Nir,

Do you have the ability to log in to the database manually using the credentials supplied in your connection string (using SQL Server Management Studio for example)? If so, I would try this to make sure they are valid. Excercising these credentials will give you the final answer as to whether that is the problem.

hope that helps,

Ian

 


Software Engineer
Co-Founder, dnnGallery
Stack Overflow: Ian Robinson
Twitter: @irobinson
Linked In: Ian Robinson
 
New Post
11/7/2007 10:49 AM
 

Hi Nir, Hi lan,

i think your problem only causes the "web.config" I had this problem a few days aggo, too.

Now I will copy a post from me I posted a month aggo:

 

Copy

<add
          name="SqlDataProvider"
          type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
          connectionStringName="SiteSqlServer"
          upgradeConnectionString=""
          providerPath="~\Providers\DataProviders\SqlDataProvider\"
          objectQualifier=""
          databaseOwner="dbo"/>

I put this commands in one Line, looks like this:

<add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider" objectQualifier="" databaseOwner="dbo"/>

 

Be patiant that you ONLY copy the values (in "") from your old web.config!

I know, normaly you can write it in one line. It sounds very stupid but try it.

 

You have to copy this Values:

 

<connectionStrings>................</connctionStrings>

<appSettings>.......(2 times of "<add key="SiteSql...")   <-- Very important for you Nir, I think!

<add key="UseInstallWizard" value="false"/>

<machineKey validationKey="..."............... />

<codeSubDirectories> .................</codeSubDirectories>

<add name="SqlDataProvider....(look at the top of this Post there is the String)..../>

I hope that i could help you

greetings Marc

PS: Sorry for my bad english.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Installation Error - The stored procedure Installation Error - The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out