3 Replies - 986 Views - Last Post: 30 July 2013 - 09:28 PM

#1 Adqusit  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 158
  • Joined: 02-March 13

Network related or instance related error occurred

Posted 05 July 2013 - 11:39 PM

Hi. I made a project in VS 2005 and SQL 2005. Daily i do my homework and at morning take my work to office, where i work on same project. But when i run the program on my office computer, so it gives error that, Network-related or instance related error occurred while establishing a connection to SQL.The server was not found or was not accessible.. But DB is attached and tables showing data.

This is my connection string, in vb.net, at module level.

Public strCn As String = "Data Source = (local); Initial Catalog = DDB; Integrated Security = false; User ID = sa; Password = xxx;"

My PC system name and Office computer system names are separate. Kindly guide me for this.

Is This A Good Question/Topic? 0
  • +

Replies To: Network related or instance related error occurred

#2 andy_pleasants  Icon User is offline

  • D.I.C Head

Reputation: 41
  • View blog
  • Posts: 122
  • Joined: 08-July 10

Re: Network related or instance related error occurred

Posted 11 July 2013 - 02:05 AM

Is there a version of SQL Server on your work machine? And has the database been attached to this instance?
Was This Post Helpful? 0
  • +
  • -

#3 thava  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 180
  • View blog
  • Posts: 1,606
  • Joined: 17-April 07

Re: Network related or instance related error occurred

Posted 17 July 2013 - 05:47 AM

i have some suggestions here
  • Do you have MSSQL server on your office system
  • if yes Then Did you check the Database is there
  • if yes Then Did you check the Name of the Database is DDB
  • if yes Did you check whether the password is same as your home

Was This Post Helpful? 0
  • +
  • -

#4 Adqusit  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 158
  • Joined: 02-March 13

Re: Network related or instance related error occurred

Posted 30 July 2013 - 09:28 PM

View Postthava, on 17 July 2013 - 05:47 AM, said:

i have some suggestions here
  • Do you have MSSQL server on your office system
  • if yes Then Did you check the Database is there
  • if yes Then Did you check the Name of the Database is DDB
  • if yes Did you check whether the password is same as your home


Yes MSSQL is there
Yes the DB is there?
What is DDB?
yes password is same

But in my office i've named instance and at home i have default instance. (I think this is the reason for being troubled).

This post has been edited by Adqusit: 30 July 2013 - 09:29 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1