hi there im getting the following errors when trying to run the script to publish the membership aspnetdb on Winhost server: Code: Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 48 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 52 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 79 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 83 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 93 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 53 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 58 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 87 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 92 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'aspnet_UsersInRoles_AddUsersToRoles', because it does not exist or you do not have permission. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'aspnet_UsersInRoles_RemoveUsersFromRoles', because it does not exist or you do not have permission. is it likely to be catastrophic?
What do you mean run the script to publish the membership aspnetdb? Did you read this kb article for instructions on how to setup Membership/roles provider on our server? http://support.Winhost.com/KB/a619/how-to-configure-the-aspnet-membershiproles-provider.aspx
hi ray i have already set up the membership and roles that i want and everything is fine on my local copy of the database, i encountered those errors when running the script i created from the same database file when trying to execute it against the Winhost database, basically just trying to copy everything across
How did you run the script? If the ASP.Net membership/roles schema has been setup on your local database then you may want to use the Restore/Backup tool in the control panel to upload it to our server. http://support.Winhost.com/KB/a771/how-do-i-generate-or-restore-a-backup-of-my-database.aspx
hi ray when i created the membership database i did it locally, so the whole this was sitting in my app data folder, then i went and added a whole bunch of other tables and built out my model on this database on my development computer, i publish the db and create a script locally to execute against the Winhost db i create in control panel, i execute the script in sql server management studio, the main problem is that these errors are coming back and saying that i dont have permission to copy the membership procedures which would enable me to manage roles in the database remotely. If you have a solution to this it would be great as Im pretty hamstrung if i cant add users to roles in the production db.
I don't know what kind of script you are running but these errors mean it is first looking for these objects. Its not that you do not have permission its just that it does not exist. Cannot find the object 'aspnet_UsersInRoles_AddUsersToRoles', because it does not exist or you do not have permission. Msg 15151, Level 16, State 1, Line 1 Try this, first use the Restore/Backup tool in your Winhost control panel to have a backup of your database. Then delete the database and recreate it. Try using the same database name and database login. Then run a backup of your local database on your computer. You should get a .bak file. Read this kb article to restore that .bak file on our SQL server. What you are basically doing is starting from scratch on our SQL server and reloading all the tables and objects that is on your local database to our SQL server. Now, I am assuming that your "LOCAL DATABASE" has the required objects, stored procedures, data, and triggers to run your web site hosted on our server. But to be on the safe side its best you take a backup of your database on our SQL server so if you need to revert back to the old version of your database you have the backup for it. http://support.Winhost.com/KB/a771/how-do-i-generate-or-restore-a-backup-of-my-database.aspx
Hi Ray Im just running a .sql script that i created in VS from my databse by clicking publish to provider. The wierd thing is those stored procedures are there in the db.
hi ray thanks i know about putting use[databsename] and then go but thats not the problem, this is the first time im uploading the site so theres no need for backups of the databse, do you reckon i should create a backup of my local copy and restore it on your servers? how do you go about creating a .bak file from a db? thanks,
To create a backup of your local database, go to SSMS, navigate to your database and right click on it. Go to Task/Backup. Once you have a backup file of your local database read this kb article. http://support.Winhost.com/KB/a771/how-do-i-generate-or-restore-a-backup-of-my-database.aspx