Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
Connection String

Answered Connection String

  • Saturday, December 08, 2012 9:12 PM
     
      Has Code
    Sign In to Vote
    0

    Hello there, I have created a windows form using ADO.NET inside of it to write/update/delete from a table in my SQL server.

    Now my porject is working fine with no problems with I use it on my PC where I created my SQL database table, but what I want not is to install this windows form on another machine which is connected to the same network at my work, but I dont know how can I change the connection string so that the other machine could access it from my machine through our work network.

    Here is my connection string right now which is working fine locally:

     

    Dim cn As New SqlConnection
            cn.ConnectionString = "Data Source=.;Initial Catalog=master;Integrated Security=True"

    Now to access my pc at work I have to enter a user namer and password for windows to be able to be logged in, lets say my user name is operator and pass is 123, what changes do I have to do to this code to make it work? Note that I am using Visual Studio 2010 and VB.NET, thanx in advance.
    • Moved by ArthurZMVP Monday, December 17, 2012 2:57 PM Does not relate to SSIS (From:SQL Server Integration Services)
    •  
     

All Replies