473,397 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Find SQLServer Instance on other computer on LAN

Dear friends,

I am having the following function to find a SQLServer instance. It works fine on local computer. Would you please tell me how to use this function to check an Instance on other computer on a Local Area Network? I am using VS2008 (framework 3.5) and SQL Server Express 2005.

Expand|Select|Wrap|Line Numbers
  1.  Private Function MyInstanceFound(ByVal MyInstanceName As String) As Boolean
  2.         Dim InstanceFound As Boolean = False
  3.         Dim MC As ManagedComputer = New ManagedComputer()
  4.         For Each SI As ServerInstance In MC.ServerInstances
  5.             If SI.Name.ToString = MyInstanceName Then
  6.                 InstanceFound = True
  7.                 Exit For
  8.             End If
  9.         Next
  10.         Return InstanceFound
  11.     End Function
Thanking you in advance.

Regards,
SKPaul
Aug 8 '11 #1
0 1148

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Mats | last post by:
Hi! I have a Windows 2000 computer (let's call it Comp1) that is used as a web server and i have an other computer (Comp2) that has a filebased access-database. How can i through ASP from...
3
by: John M | last post by:
Hello, I have problem when copying the sln application to other computer. The project is on directory phones. The other computer cannot even open the application : doesn't find the...
6
by: dbuchanan | last post by:
I have a Windows Forms application that accesses SQL Server 2k from a small local network. The application has been used for weeks on other systmes but a new install on a new machine retruns...
1
by: joe | last post by:
if i copy the solution and the project file from my computer to other computer. it can't open why? and how to modify the file that can open in anywhere
2
by: XiScO | last post by:
hi! I'm trying to get some info from other computers, I make ping to test that are powered on, then want to get netbios name and MAC. I get the dns name and get only first part as netbios...
9
by: sirimanna | last post by:
sir, Is any one can help me to teach how to see a other computer desktop using networking...i have 15 computer's in my office..i want to see other's computer through networking... please tell...
0
by: adnanahmed714 | last post by:
Hi Experts! i made a application for plant monitoring.Can some one help me , to access(Run+ Monitor) VB application from other Computer on the Network. I just want to monitor the forms on the...
3
by: Boki | last post by:
Hi All, I have finished my first version of program, I use "build" to create BokiProgram.exe I copy this file from bin\release\ I copy it to my desktop folder, it works. I copy this file to...
0
by: aceprahmatkosim | last post by:
I have problem connection database, PHP to MsAccess via ODBC but the DSN place in other computer. How I can do that? $user = "connect"; $password = "pwdmdb"; $dataku =...
1
by: vabh | last post by:
Hello, My computer is connected in LAN and so many other computers too. So, now i want to access any .exe file of any other computer. Before that i am accessing the Computer Name and IPAddress...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.