Click here to Skip to main content
15,878,048 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Which class is used for accessing sql server registered instance names in .net application? Is there any way to access the sql server's registered instances on different systems connected through LAN, in .net application???
Posted
Comments
Monjurul Habib 9-Mar-11 13:44pm    
Share, what is the error? Does it work when you used from the server but not from another computer on the LAN? What is your sql server edition ?

1 solution

You can either use System.Data.SqlClient or something like an Entity Data Model. You access specific instances using the connection string.

If, on the other hand you wish to find out what instances are running on a particular machine/network just as Sql Server Management Studio does when you browse for more servers, I'd have a look at SMO:

http://msdn.microsoft.com/en/library/ms212724.aspx[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900