Good morning from Spain!
I've an app. in c# which works with a sql server. To find it (i don't like
dirty the user register) i use one dns server where i added one entry with
the name of my server. Using the namespace System.Net i resolve the name to
ip address, so i know the computer where the server is (if we move it we
change the dns entry, so we haven´´t to do anything in the client). But when
i try to connect to the sql server, with the string conexion:
"Server:"+computer+"....", where computer contains the ip of the server, it
dies. I think the reason is that the sql server has an instance, and i have
to connect to that instance; before i did this to connect:
conString = @"Server=EVIUS\VSdotNET;database=SIIA;UId=Miguel;p wd=;Integrated
Security=SSPI;";
now, the question!! how can i know the name of the instance of a sql server
if i know the ip address of that server? i have trie with sqldmo but i have
never used it... i'm lost...
Thanks for all.
Pd.- Excuse my English, languages and i are in war...