Hi Guys

I have published my website to a hosting server,after configuring the site to use Sql Server 2005.I changed the connection string in the web.config file to point to the sql server 2005 instead of sql express.
However the problem is i am getting the following error when i try to access the website using its url.

System.Configuration.Provider.ProviderException: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.

The funny thing is that when i test the website from my development machine,it connects well to the remote sql server 2005 database without any problem.

Can someone help me fix this please

How does your connection string look like?

Maybe you need to talk to your host; they may have set certain security restrictions on SQL Server, or have a FAQ explaining how to connect to your database.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

My connection string looks like:
connectionString="Data Source=ip address,port;Network Library=DBMSSOCN;Initial Catalog=mssql530;User ID=xxxx;Password=xxxxx" providerName="System.Data.SqlClient"

i am using a different database host from my website host.

In that case, talk to your hosts; they may not allow incoming or outgoing traffic for SQL Server....

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.