Posted on: 11/13/2014 8:02:18 AM | Views : 564

Hi! So I tried to create a ODBC link with SQL server, but there is a problem during the authentification process. When I try to use authentification thanks to SQL server, even with 'sa' user enabled, this error shows up Connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'myUser'. When I try to use authentification with Windows ID, another error shows up : Connection faled: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. The server is a VPS server and there is no domain to configure. I already tried to switch to mixed authentification, with it I can easily connect to SQL server with SQL server Management Studio. I also already browsed SQL Server ...

Go to the complete details ...