Problem deploying site developed with Sql Ex. To server running Sql Server 2005.

Can someone show me, or direct me, to a source,that shows me how, and what to change,when deploying a website from a development server running Sql Ex to a production server running Sql server 2005.I can’t get the sites to run under Sql server 2005.

They work in Sql Ex. what must I change?The connection string, to what format?and what else?I attached the dB to Sql 2005 and browsed the content in the Sql manager.But can’t get the aspx pages to work on the server.

Help please

What is the error code you get from your ASP application?

When connecting to SQL Express, you normally specify server as <servername>\sqlexpress. When you switch to sqlserver 2005, depending on it instance name, you need to change your connection string if you hard-code the connection string in your ASP app. For default instance, you can use <servername>, for named instance, you can use <servername>\<instancename>.

If you can't resolve your issue, please post your connection string, error message from ASP application and server connectivity configuration, such as whether it is name instance or default instance, whether you have TCP up or browser up and etc.

|||

Thanks Nan Tu for the assistance

This is the connection string error i get:

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

But i have setup the virtual drive as a app in the root.

This is theconnection string:

<connectionStrings>

<add name="ConnectionStringGetSomeThing" connectionString="Data Source=localhost;initial catalog =getsomething.mdf;Integrated Security=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

also TCP and browser are enabled

|||The errormsg is not from connectivity driver, you probably need to ask either in ASP or IIS forums.