Last post Apr 16, 2012 09:32 AM by Silverlight.Shailendra
Apr 16, 2012 06:46 AM|Silverlight.Shailendra|LINK
I am using MySql for my web application. I fetched the data, searched it. But when i'm creating a new user by using CreateUserWizard it shows me below error message regarding SQL Server. And I am not using SQL Server.
It is working fine on my local machine...
Apr 16, 2012 06:58 AM|nijhawan.saurabh|LINK
By default the role provider uses SQLExpress DataSource, you need to point it to your MySQL Datasource now in your web.config.
Apr 16, 2012 07:01 AM|Silverlight.Shailendra|LINK
Yes!!! i made all required changes there. And it is working fine on my local machine.. This error message is displaying over the server (globally).
Apr 16, 2012 07:10 AM|nijhawan.saurabh|LINK
Ok you mean createuserwizard was working fine on your local machine?
If yes, did you check the Data Source property of your connectionstring twice?
Are you able to access DB from the application on the server?
Apr 16, 2012 08:36 AM|ruipedromachado|LINK
For what i have read , the Login Controls only work with SQLserver/Express, witch is the membership provider microsoft makes available.
To make it work with other data source you need to create a """custom membership provider""". ( witch is a pain in the....) i tryed with access and gave up, it was simpler to create a login system with my access DB.
it probably is working on your computer becouse you might have the menbership configured there along with the default microsoft sqlexpress DB, but as soon as you deploy the site to your application server ....it dies :).
just guessing :)
Apr 16, 2012 09:09 AM|Silverlight.Shailendra|LINK
No I can create a user on my local machine... but when i publish it it is not working....
Apr 16, 2012 09:22 AM|ruipedromachado|LINK
exacly , so you do have the membership configured on your local machine. For sure you are using MSSQL and SQLExpress.
since you dont have SQLExpress installed on your server , when you deploy it crashes.
Apr 16, 2012 09:32 AM|Silverlight.Shailendra|LINK
Yes!!! i commented <membership> in web.config file... and it is working fine now.... now my all records saved successfully in MySQL table.