problem with publish ASPNET.mdf

[waleed_89]

hi, i have create users and rolls and all thing work very good on my computer but after upload view exception

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

how can i change connection string for mdf database

pleeease help me
with my regards
thanks in advance

[gep13]

Hello there,

Where exactly are you uploading to? Is it a paid for service?

If so, it is highly likely that there isn't a SQL Server Express instance there to connect to. That is what you are using locally, SQL Server Express.

It is more likely that you have a full SQL Server instance on your host. You will need to confirm this with your hosting provider. If this is the case, then you will have to import your data into this database, and modify your connection string to suit.

You should be able to connect the support team for your hosting provider to figure out the best way to do this for their set up.

Gary