mercredi 28 janvier 2015

Login failed for user - Error: 18456, Severity: 14, State: 38


I am trying to run and ADODB command in MS Access 2012 to exec a stored proc in our SQL server 2008R2 database, but I keep getting error 38 and SQL profiler shows the following: Error: 18456, Severity: 14, State: 38. 2015-01-28 12:59:27.34 Logon Login failed for user 'NordenDevel'. Reason: Failed to open the explicitly specified database. [CLIENT: 82.71.5.169]


This user (NordenDevel) login works on this database (NordenWeb) in SQL Management Studio and in Visual Studio, so the database is working fine and I do not see how it could be a permission issue.


Can anyone suggest what I could do to find out what's wrong? Many thanks, YAOWSC





Aucun commentaire:

Enregistrer un commentaire