[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 690
  • Last Modified:

VB.Net App config settings for server deployment

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.

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

Thanks!
0
dave_sky
Asked:
dave_sky
1 Solution
 
CodeCruiserCommented:
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).
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now