Forum Discussion
Solved
ODBCAD isn't showing database instances when trying to create DSN
I've got the community edition of SQL Server 2019 installed. I'm trying to create a DSN using ODBCAD (both 32 and 64). Although I've got two database instances installed (one already there that cam...
olafhelper Thanx! The machine name\database instance name format worked!
I do not see either of those instances
John_Carter56 , if you mean you used the "Search for SQL Server" function, that one isn't and wasn't ever very reliable; ignore it.
Simple enter the server\instance name.
olafhelper Thanx for your reply.
I'm using the "Which SQL Server do you want to connect to?" drop-down field on the "Create a new data source to SQL Server" window of the ODBCAD 32 and 64 applications. I've tried using just the instance name since both instances are local. How would I explicitly reference the "server\instance name"; as "machine name\instance name" or "local\instance name" or what?
- I would use "machine name\instance name", then the DNS setting is for all machines the same.
"Local" works only on the server itself.olafhelper Thanx! The machine name\database instance name format worked!