Could not find stored procedure 'dbo.GetHostSettings'. > Mitchel's Technical Forums

Mitchel's Forums

Subject: Could not find stored procedure 'dbo.GetHostSettings'.

Prev Next

You are not authorized to post a reply.

Author

Messages

fellsusan

New Poster
Posts:9

04/02/2008 12:31 AM
I am getting the following error when attempting to run install.aspx: Could not find stored procedure 'dbo.GetHostSettings'. My connection string is such: Server=ORLANDO\SQLEXPRESS;Database=dnn403;Integrated Security=false;uid=**;pwd=** I believe the databse is installed correctly. Any ideas as to the problem BTW, well written instructions.

Mitchel Sellers User is Offline

Site Admin/Owner
Guru

Guru
Posts:6027

04/02/2008 8:12 AM
The best way to make sure that everything is correct is to do the following 3 steps. 1.) Validate that via SQL Server Management Studio Express that you can connect to the server using the information in your listed string. 2.) Ensure that in your web config that the place that you have these strings is NOT the one that is commented out. This is the common problem is that people will update them correctly, however, the one that was updated is the one that is commented out by default. 3.) Ensure that in your web.config you have the connection string defined in BOTH sections. appSettings and connectionStrings. That should get you going. It might be an SQL Server configuration error not allowing remote connections, which the management studio check will validate otherwise it might be a general DNN config issue....these steps should help you address any/all of those scenarios.

-Mitchel Sellers Microsoft C# MVP, MCITP 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 $25 off your second month! To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs

fellsusan

New Poster
Posts:9

04/02/2008 6:54 PM
Thanks Mitchel, Steps 2 and 3 are verified as being correct. However, regarding Step 1, I am unsure the means in which to validate the connection with the server using my connection string. Does SSME have a procedure in which to do this? Sorry for the newbie question... " border=0>

Mitchel Sellers User is Offline

Site Admin/Owner
Guru

Guru
Posts:6027

04/02/2008 9:07 PM
No problem at all. When you start SQL Management Server it shows you a connection window, by default it uses windows authentication, instead do the following. 1.) Change the server value to that of your connection string 2.) Change the authentication type to SQL Server rather than Windows 3.) Then put in the username/password.

-Mitchel Sellers Microsoft C# MVP, MCITP 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 $25 off your second month! To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs

fellsusan

New Poster
Posts:9

04/02/2008 10:45 PM
Ah…. so… click " border=0> Sorry, brain in need of coffee on that last request…. And yes you were right, as it were a DNN config issue. I am now able to get DNN up and running. Although... Another silly question for you: I’m attempting to upgrade an existing DNN installation from version 4.0.3 to the latest version. In doing so, I wish to trouble shoot the process on my local development platform first. However, I need to get the old version, or one close to it, up and running with the database installed locally. I have downloaded the latest database in a .bak file format from my hosting company. Also, I do have version DNN 4.4.1 loaded on my local machine with a generic database created via SSME up and running successfully, as per your clean install instructions. It is also properly skinned as per the original DNN 4.0.3 version. Now… how do I install the database, as delivered from my hosting company in a .bak file format, towards the fresh DNN 4.4.1 install I have created on to my local machine? I originally thought a restore request with the database I wish to install, while over writing the original db might work… Either I did it incorrectly or my approach was incorrect. Hints and pointers are most welcomed!! BTW, thank you very much in helping me earlier today " border=0>

Mitchel Sellers User is Offline

Site Admin/Owner
Guru

Guru
Posts:6027

04/03/2008 4:51 PM
To properly bring a production environment back for testing you will need a zip of the website AND the database backup and then you can restore the database and configure the website to get it working. I have a Restore guide in my blog that should help!

-Mitchel Sellers Microsoft C# MVP, MCITP 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 $25 off your second month! To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs

fellsusan

New Poster
Posts:9

04/03/2008 7:36 PM
I found the restore guide and I do have a copy in zipped form of both the db and website. I ran through the steps within your guide numerous times and end up with the following install error everytime: Error Installing DotNetNuke Current Assembly Version: 04.00.03 ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException: Cannot open database "us403db" requested by the login. The login failed. Login failed for user 'A3170511'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() 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.ExecuteScript(String Script, Boolean UseTransactions) /**********************************************************/ /* Initialization Script */ /* */ /* */ /* Note: To manually execute this script you must */ /* perform a search and replace operation */ /* for dbo. and */ /* */ /*************************** I have triple checked connection strings and etc... Any ideas?

fellsusan

New Poster
Posts:9

04/03/2008 9:46 PM
Ok... somehow i managed to get the website and db up and running locally " border=0> Any clues as to how i can access the website's Portal websites? The url on the production server is: www.news.mywebsite.com, whilst my local is now: localhost/dnn403. Gosh, I must be sounding like such a newb!

fellsusan

New Poster
Posts:9

04/03/2008 9:46 PM
And Thank you VERY MUCH for all your kind help Mitchel!

Mitchel Sellers User is Offline

Site Admin/Owner
Guru

Guru
Posts:6027

04/04/2008 5:14 PM
Once you have the database restored, you will need to edit the portalalias table values to allow the site to function. If you restored locally to localhost/dotnetnuke you will need to update the value to reflect that path.

-Mitchel Sellers Microsoft C# MVP, MCITP 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 $25 off your second month! To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs

You are not authorized to post a reply.

Forums >Development Discussion >DotNetNuke > Could not find stored procedure 'dbo.GetHostSettings'.

ActiveForums 3.7

Mitchel's Forums

Error Installing DotNetNuke

Current Assembly Version: 04.00.03