Notation for connecting to local instance??? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Notation for connecting to local instance???

Does anyone know when to use ".instancename" vs. "(local)instancename" notations for specifying a server name? I have an app that accesses an MSDE instance on the local machine via a UDL file. My app uses both ADO (MDAC 2.7) and SQL-DMO. In many cases the two notations work interchangeably, but I did run into a couple of of situations where one worked and the other didn’t. My current issue is that the (local) version fails when used by an account without local admin rights whereas the DOT notation succeeds… Any thoughts would be greatly appreciated. Thanks in advance,
Chris
If you had installed another SQL Server named instance, the dot was unable to be parsed normally. But if there is still one or more named instance as well as the SQL Server default instance, you need to enter the full name of the computer. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>