I have a Windows Server 2012 named "XYZ" and an SQL server instance named "XYZ". If I connect via Server=XYZ; it seems to work fine. On the other hand, if I try to connect via Data Source= I am simply unable to come up with the proper string...I've tried:
.\XZY (local) XZY\XYZ (local)\XYZ XYZ etc.
For reference, the full connection string I used:
Data source=????; Initial Catalog=DatabaseName; user id=***;password=***; Integrated Security=false; MultipleActiveResultSets=true
Is there possibly a reason why Data Source= would not be working at all perhaps? Do I need to install or change some setting to get it to work?