How do I tranfer my VB.NET Application files to Windows Web Server 2008 ?

   I developed a ASP.Net and VB.Net website  and  I want to transfer my files to a dedicated Web server running windows server 2008 . I created a database in the SQL Management Studio in the server and I attached my MDF file and How I do establish a Connection String ? What are the things I have to mention in the web.config file .

      In my local system I just placed my mdf file in the App_Data folder and used it for development How do i establish a connection in web server 2008  ?
Who is Participating?
RobertNZanaConnect With a Mentor Commented:
In your web.config file you can create your connection string like this...

For example...

    <remove name="LocalSqlServer" />
    <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
    <add name="MainConnStr" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|main.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.