EDEALER is the local hostname.sqlservices is local os id with administrator role and as well sysadm role in sql logins.I went thru all your posting on this matter. Reason: Failed to open the explicitly specified database. Thanks!!ĭear Guru'sI am facing the same problem.Login failed for user 'EDEALER\sqlservices'. Have you had a look in SQL Server configuration manager to see if there is a user that matches those credentials. Looks like its from an engine level connection. Thanksĭid they re-register the SPN after changing service account? are there linked servers pointing to this server? web servers using nt authentication? ( I am not sure why this is?)The server role is public and I selected also sysadmin but that didn't help.Hopefully someone could help me to get this fixed. When I use the SQL Profiler and watch to the Audit login this error is not passing by.At the login properties of this user, at the user mapping page I found that the map for master and msdb is selected with the user and a default schema. This error message is comming back every minute into my log file. Anyway, everything is working again but I have still one problem.Error: 18456, Severity: 14, State: 38.Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. I asked to the sys admins if there where any change and they told me they had to rename the administrator account :(. After my holiday I came back and I found some errors in my SQL Server 2008 R2. Hi,First of all I must say I find my way in SQL but I am not higly skilled dba. All ForumsĮrror: 18456, Severity: 14, State: 38 problem
We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.
0 kommentar(er)
