This is a discussion on ODBC System DSN change to SQL Authentication within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi I need to change a Windows Authenticated ODBC connection to a SQL Authenticated ODBC system DSN connection. I ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi I need to change a Windows Authenticated ODBC connection to a SQL Authenticated ODBC system DSN connection. I have looked at setting this up via a Login Script and importing a registry key exported off a PCthats correct via a .bat file. The problem is, it imports the key and then says its successful I check the ODBC connection and it hasnt changed. I have rebooted several times but cannot get it to change from Windows to SQL authentication. It runs the script and asks if its oK etc. Stumped, does anyone know of a better way or why this isnt working. The key comes from HKLM!!!!! Thanks John |