How to connect SQL Server 2005 using IP address

Please tell me how to connect SQL Server 2005 usgin IP address

Page 1 of 1

2 Replies - 2969 Views - Last Post: 04 January 2010 - 11:41 AM Rate Topic: -----

#1 srinivas.gopu  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 19-December 09

How to connect SQL Server 2005 using IP address

Post icon  Posted 19 December 2009 - 03:13 AM

Hello,

Please tell me how to connect to SQL Server 2005 using IP address.

Thanks and Regards,
Gopu Srinivas.
Is This A Good Question/Topic? 0
  • +

Replies To: How to connect SQL Server 2005 using IP address

#2 karimi  Icon User is offline

  • Banned
  • member icon

Reputation: -9
  • View blog
  • Posts: 104
  • Joined: 29-May 09

Re: How to connect SQL Server 2005 using IP address

Posted 19 December 2009 - 05:49 AM

Just assing the ip address of remote PC in the server portion of connection string

as

server=192.168.0.1; user=sa;pass=sa;
Was This Post Helpful? 0
  • +
  • -

#3 blaknar  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 19-September 09

Re: How to connect SQL Server 2005 using IP address

Posted 04 January 2010 - 11:41 AM

In your VB.net application look for "app.config" file and add this codes inside

 <connectionStrings>
	<add name="MyConnectionString" connectionString="Data Source=192.168.1.2\SQLEXPRESS;Initial Catalog=SQLDBName;Persist Security Info=True;User ID=sa;Password=sa" providerName="System.Data.SqlClient" />
  </connectionStrings>

This post has been edited by blaknar: 04 January 2010 - 11:43 AM

Was This Post Helpful? 0
  • +
  • -
Page 1 of 1