I posted this question originally in the SQL Server forum, then realize it probably is a Windows OS issue that is not specific to SQL. I don't know how to cross post an existing question so I am re-posting it in the Windows OS forums.
Here is the question:
I am a complete NUB to SQL Server. I am using SQL Server Developer Edition 2014 which is installed on several machines in the office.
I have been using Machine 1 (WIn7 Pro, Office Pro 2010, SQL Dev 2014) for my development. I installed SQL created databases and set up the DSN in to connect to the files. All without issue.
I now want to do some work on Machine 2 (Win 7 Pro, Office 2013, SQL Dev 2014) in the office. SQL is installed but I not able to setup a DSN using the Administrative Tools of the OS.
On machine 2, as soon as I click on the ‘File DSN’ tab within ODBC date sources off the Administrative Tools in Control Panel, the app cancels and I have issues. I have included the sequence of screen messages I see when it cancels in the attached document. I don’t know where to proceed from here.
I didn’t even load Visual Studio 2010 on this machine but some of the messages look like unlicensed software is being used. That is not the case. All of my software has legitimate licenses.
On Machine 2, I installed SQL 2014 Dev exactly the same way I did on Machine 1and everything worked fine when setting up and using the DSN. Any ideas why I’m having issues on this one.
I also have Machine 3 (Win 8.1 Pro, Office 2013, SQL 2014 Dev) in the office. I have had no issues setting up DSN’s on that machine. Machine 2 is the only one with issues.
Probably worth mentioning that I had this very same issue on another machine set up the same way (SQL Dev 2014, Win 7 Pro, Office Pro 2013). I returned the original machine when I could not resolve the problem and I am currently working with the one I bought to replace it.
Any help would be greatly appreciated. Please see the attached messages.