Hi Mahdi and welcome to our :)

You should be able to just upload your files using FTP and then you'll need to modify the web.config with the new credentials for accessing the database.

If you have not got any information about how to access the database from your hosting company you should probably get in touch with them to receive the credentials you'll need to setup the database. Since you have migrated from CE SQL to SQL server 2009 already you should be able to make a backup of the database, which you can the upload to the database server. You can learn more about how to make the backup here https://msdn.microsoft.com/en-us/library/ms187510.aspx

Hope this helps :)

/Jan

Hi Jan thanks a lot for reply :) I convert my Sql and make a backup and then I upload it. but now I don't know how is the web.config modify for sql server database ( mdf & ldf )

Hi Mahdi

Your web.config on the live server should have it's connectionstring updated with the new information about the live database :)

/Jan

I haven't changed mine yet. But this guide was the guide I was going to use.

http://www.geektantra.com/2012/10/umbraco-deployment-exporting-ms-sql-ce-database-to-ms-sql-server-express/

It also explains what you need to change in your web config file.

thanks Laurens Gregoir. I did what you said and now I have this error. I really don't know what should I do. this is my website: http://customer.sinapardazesh.ir/

Seems you have a access rights issue. Did it worked before the switch from the MSSQL DB to the SQL?

Check if all user right settings are correct.

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6 and IIS 7, and the configured application pool identity on IIS 7.5) that is used if the application is not impersonating. If the application is impersonating via , the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET access to a file, right-click the file in File Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

Hi Mahdi,

Are you still having issues with setting up your SQL connection?

is working on a reply...