Roger Goodwin
Nuke Pro Posts:95
|
01/07/2008 2:51 AM |
|
I am getting the following error messsage, The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.
The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
I have copied the files as instructed using your tutorial. I have no way of backing up the remote database so I have used their suggested method of exporting the database using enterprise manager. The version of dnn is 4.4.1. I have checked the internet for this error message and have had no success with any of their suggestions. please please help as I have been trying to fix this for days.
Regards
Roger |
|
|
|
|
Lee Sykes DNN Creative Staff
Nuke Master VI Posts:4945
|
|
Roger Goodwin
Nuke Pro Posts:95
|
01/07/2008 4:04 PM |
|
I have restored the database and checked the tables. They all seem to be there and have the corect data in them.
As for the user and password I have but this information may not be correct. The database name is correct, I have setup a user as instructed but when I go to enter the permissions I dont have the aspnet items listed only the db i.e
aspnet_membership_basicaccess aspnet_membershipfullaccess etc etc is not listed
the list starts from db_accessadmin.
I am not sure why they are not listed or if this is the problem?
any ideas. |
|
|
|
|
Joseph Craig DNN MVP Posts:11667
|
01/07/2008 4:16 PM |
|
Try logging into your database using SQL Server Management Tool Express, or the regular version. If you can login, check the permissions. If you can login, you at least know that you know the username and password. These should be the ones used in your web.config connection string. |
|
Joe Craig, Patapsco Research Group Complete DNN Support |
|
|
Roger Goodwin
Nuke Pro Posts:95
|
01/07/2008 5:57 PM |
|
when I open management studio express I connect to my database using windows authentication. I have checked that the user name I have given to the database is the same as the one in my web.config file. There are other users listed in here such as dbo, guest, sys as well as the new one i setup rogerg. the rogerg is the one I put into my web.config file. |
|
|
|
|
Joseph Craig DNN MVP Posts:11667
|
01/07/2008 6:18 PM |
|
Roger,
You might want to try to connect to the database using the user/password form of authentication. Then, verify that you have the right permissions. |
|
Joe Craig, Patapsco Research Group Complete DNN Support |
|
|
Roger Goodwin
Nuke Pro Posts:95
|
01/08/2008 12:06 AM |
|
Yes your are right. I can log into sql database manager with the user and password but when I try to access the database It tells me that the select permissions were denied....
As I said earlier I have setup the user as instructed but some of the information was not available for me to select. |
|
|
|
|
Lee Sykes DNN Creative Staff
Nuke Master VI Posts:4945
|
|
Roger Goodwin
Nuke Pro Posts:95
|
01/08/2008 2:42 AM |
|
Hi, I have had a look and db_owner is checked. I have checked everything in this list of roles.
I am using SQL server Express.
Roger |
|
|
|
|
Lee Sykes DNN Creative Staff
Nuke Master VI Posts:4945
|
|
Roger Goodwin
Nuke Pro Posts:95
|
01/08/2008 11:59 AM |
|
Yes I have. And yes it works fine. Had to use dnn 4.6 as that was the only one available. |
|
|
|
|
Lee Sykes DNN Creative Staff
Nuke Master VI Posts:4945
|
|
Roger Goodwin
Nuke Pro Posts:95
|
01/08/2008 1:23 PM |
|
this is interesting. I have attached the database to the sql server manager express as instructed. When I go to add a user to this database I do have the list of database membership roles aspnet_ etc etc where as the install of my existing site wont show any of these permissions. I can access the localhost database using the user name and password with no problems. I am certain this is where my problem is but i have no idea why these are not listed for the database I have restored from my live site. Could this be due to the fact that I cant get a backup of the database and that I can only export the database to my local machine? |
|
|
|
|
Lee Sykes DNN Creative Staff
Nuke Master VI Posts:4945
|
|
Roger Goodwin
Nuke Pro Posts:95
|
01/08/2008 3:48 PM |
|
This is a very sore point. I have asked fasthost to provide me with a back as they do not provide this for me as part of the package. The have refused to either allow me to do a backup or do a backup for me which i can down load.
Fasthost use sql 2000 and I have sql 2005 expres on this pc. Is there any data that might be missing from an export that would be included in a backup?
|
|
|
|
|
Roger Goodwin
Nuke Pro Posts:95
|
01/09/2008 1:56 AM |
|
I should have said that fasthost only allow you to export data into a local data base. Backups are not permitted at all.
Any suggestions as I realy need to get this working. |
|
|
|
|
Lee Sykes DNN Creative Staff
Nuke Master VI Posts:4945
|
01/09/2008 2:01 AM |
|
Ok, I'm not sure. When I used SQL 2000 I don't recall seeing the aspnet permissions, so perhaps that is why you are not seeing them in your SQL express. It might be worth googling and just checking on importing a 2000 database into 2005. It is possible but my hosting providers have always done this, I have not actually attempted it. - I could look into it if you get stuck but I am short for time today so it will probably be quicker if you have a look around.
The one thing I would say is change your hosting provider - seriously - I had a similar situation with a hosting provider where I couldn't obtain a backup easily through the control panel. This site was a complex site where I programmed several modules, it took a lot of time and work. Needless to say one day they upgraded their servers and didn't transfer across the data properly - my site was accidentally deleted.
By the time I looked at my website (I only checked it once a month as it was all automated) all of the hosting providers backups had been deleted. - So I had completely lost a site that prob cost me around $40k to put together with nothing I could do about it.
Get out and change while you can!
|
|
Lee Sykes Site Administrator Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts
Twitter: www.twitter.com/DNNCreative
|
|
|
Roger Goodwin
Nuke Pro Posts:95
|
01/11/2008 2:09 PM |
|
Thankyou for you time with this. I have now managed to get a copy that nearly works. What I had to do was use sql server2000 with enterprise manager which will allow me to export and includes the correct aspnet_ membership roles. When I exported using sql server 2005 and sql server manager these membership roles were missing. After I ran the export I backed up the database and then restored it using sql server express. BINGO it worked fine. I am not sure if sql server manager can or cant do this all i know is that with limited knowledge and the default settings it wont!
The only issue that I do have is that when I open my localhost web site all the pages are there but none of the images are displayed. All I get is the image box with the red x at the top left.
Any ideas?
Thanks again and I will be leaving fasthost as my DNN provider and would not recommend them.
Regards
Roger |
|
|
|
|
Lee Sykes DNN Creative Staff
Nuke Master VI Posts:4945
|
|