galwhe.blogg.se

Sql error 18456 severity 14 state 38
Sql error 18456 severity 14 state 38












sql error 18456 severity 14 state 38

Please check the, scroll to the section about state 38. Also possible that the database user mapped to the login lacks permissions to it. State 38 indicates that most likely the login is valid, but something is wrong with the connection parameters. find the user under - Security, right click, properties, check the **Login name** under General, needs to be filled, not blank. How are you trying to access the database, from SSMS or from some app using the connection string? In any case, what is the default database of the login? Is it set to master (usual default) or to the database to which the login cannot connect? If you can connect to the instance via SSMS (using some other login), please check the properties of the database user in question (should be mapped to that login), i.e.














Sql error 18456 severity 14 state 38