Hello,
I have a shared hosting plan which already has aspnetdb.mdf on the server so of course I cannot use that db name for my site...
I have renamed the db and now I get an errorCould not find stored procedure 'dbo.aspnet_CheckSchemaVersion
My question is, how can I make this thing work? All help is greatly appreciated!
Hello my friend,
The aspnet.mdf database is intended for development and testing only, not for production due to performance reasons. When moving into production, you should change your site to use a real full heavyweight SQL Server database. Besides the aspnet tables existing in a different database, there is virtually no difference in terms of the application so you do not need to worry about changing your pages/code. I assume your different sites that you will be hosting will use different databases so this problem you are having will not occur when this has been sorted.
Kind regards
Scotty
|||Scotty,
Ok, so let's say that what you say is true... how do you get all of the membership and users from aspnetdb into another db so that it can be used with my SQL Enterprise edition or any other for that matter
thanks!
|||Hello again my friend,
I usually give the full answer to questions instead of referring to urls but I feel the following url demonstrates it better than I have time to explain: -
http://www.beansoftware.com/ASP.NET-Tutorials/Security-Features.aspx
You might find it useful to take advantage of the ApplicationName property if you wish the different sites that you are hosting to use the same database. Personally, I would always use a a separate database for each application.
Kind regards
Scotty
|||
Scotty,
So far so good... I haven't uploaded the new db yet but I have a feeling that this will work...
Question: where does the machine.config come into play on the hosting/production server?
Is that something that needs to be ftp'd over also?
KS
|||Hello again my friend,
If you have installed .NET on the production server, the machine.config file should be there already. You should not need to change any settings in here. Besides, if you did, you override them using your web.config file in your website.
Machine.config is the top of the tree, its contents apply to all applications. When you create an application, you can overrule these settings by specifying settings in your web.config file. Further down, a web.config file in a subfolder of your application can overrule some settings in your web.config file in your application's root folder. This can go several subfolders deep. Finally, a web page in a folder can overrule some settings in the web.config file of that folder. One such setting is whether to use debugging or not.
Kind regards
Scotty
|||
Scotty,
Alright... sounds good... well, I have uploaded the site and db and now I am getting the error:
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'
I am not sure what that means other than a connection was not made somewhere...
Maybe my connection string is wrong:
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="ConnectionString" connectionString="Server=(local);Database=mff;User ID=xxxx;Password=xxxx;" />
<add name="LocalSqlServer" connectionString="Server=(local);Database=mff;User ID=xxxx;Password=xxxx;" />
</connectionStrings>
I am just not sure... let me know what you think
|||
Hello again,
Have you tried logging on to the SQL Server Management Studio/Enterprise Manager directly with the same credentials that you are using in the web.config? Do this to test the connection, it could be a SQL Server issue; wrong username or password. When you get it working directly, then try it with the website. If you are ever unsure about connection strings, a good resource on this iswww.connectionstrings.com.
Kind regards
Scotty
|||
I can't figure out how to give the database a user and password... maybe that is some of the problem...
When I log into SQL Server I do not need any password or user it is set to windows authentication
thanks for all your help bro'
|||Scotty,
Alright... I got into the db using the credentials and it appears that I can get in fine, BUT when I do... there are no tables... what is going on there? Any ideas?
Kevin
Hi - I have the exact same problem, i.e. have been learning and designing a site using membershio, so default database (ASPNETDB.MDF) created.
All working fine on loical PC but just signed up with hosting company and tried to create database but told that ASPNETDB.MDF already in use, so I have to rename my membership database.
After reading the correspondence on this topic, I still don't understand what I need to do.
Are you saying that with the SQL Express 2005 edition I can't get it to use a different name for the default database?
Are you saying that with a different SQL version (which one - the Developer edition for $49?) that I can?
With whatever version I need, is it a complicated job (remember - I'm a beginner).
I'd really appreciate feedback on this.
Regards,
Garrett
|||
Garrett,
Are you uploading your db directly onto a server as an mdf file OR are you scripting this db to a hosting account? If you are scripting this db to a host, which I assume you are, this will be as simple as changing the name of the db via the script before scripting to the host...
let me know
|||I understand all that now.
I posted the same question in a different part of the forum and got the response I needced.
http://forums.asp.net/p/1200251/2087698.aspx#2087698
Thanks to everyone for the help.
Garrett
No comments:
Post a Comment