VB.Net App config settings for server deployment

Posted on 2012-09-02
Last Modified: 2012-09-03
Software: VS & Sql server 2005

I use the following connections settings to deploy a windows application to workstations. What changes would I have to make to connect a workstation to a client server (MS small business server 2011 essentials).
This is not a remote connection.

    <add name="MyName.My.MySettings.MySQLConnectionString"
      connectionString="Data Source=MAIN;Initial Catalog=MySQL;Integrated Security=True;Connect Timeout=20"
      providerName="System.Data.SqlClient" />

Question by:dave_sky
    1 Comment
    LVL 83

    Accepted Solution

    Just change the data source name to the name of that server (also include the instance name of sql server if its a named instance).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (…
    For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK ( for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now