connect sql server

• satishbhargav4u

  SSC Enthusiast

  Points: 139

  More actions

  August 7, 2009 at 11:59 pm

  #132604

  I have 2 pc. In both pc SQL server 2005 install.

  I want connect to sql server of another Pc.

  So how can i connect to another pc.

  If i write

  connectionString="Data Source=100.12.255.32;Initial Catalog=shopping;Integrated Security=True;MultipleActiveResultSets=False;Packet Size=4096;Application Name="Microsoft SQL Server Management Studio"" providerName="System.Data.SqlClient"

  then it gives the error.

  if i open sql server and enter

  server name,server type,authentication of second pc then it give error.