ms sql check named instance

iis5_rulez · Post by **iis5_rulez** » Thu Dec 19, 2002 4:23 am

hi,

i want to check a named instance of sql thru the ms sql check... but i dont get a connection... i can however check the default instance...

i cant find an option how to check it...

KS-Soft · Post by **KS-Soft** » Thu Dec 19, 2002 5:33 pm

I am not SQL Server administrator. But I checked microsoft.public.sqlserver newsgroup and found several recommendations:
1) use ".instancename" instead of server name
2) use "server\instance"
3) use Client Network Utility to create an alias name for the instance and use that alias as server name

Regards
Alex

iis5_rulez · Post by **iis5_rulez** » Fri Dec 20, 2002 7:03 am

i'd tried the first 2 already. but that didnt seem to work... i'll look into the third solution...