12:53:41.86 Logon Login failed for user ''. The error below was captured on the SQ Server. We have tried connecting via Visual Studio and disabling their firewall but are not able to get a login. When the new developers try and access SQL they can via SQL authentication but not windows. My username and password match that of the domain. I am able to use windows authentication with the username being LAPTOPNAME\Username. Myself and one other developer can log in using windows but the others can not. We can log in remotely using SQL authentication. We have a SQL server on our domain with the developers and myself connecting via a VPN.Īll of us can log into the domain as well as remote desktop to the SQL box and log in SQL there as well. I've read through this message and many others but have not been able to find a solution.
MICROSOFT SQL SERVER ERROR 18452 INSTALL
I am going to try to install the Developer edition on Machine A to see if there is a difference, but I somehow don't think that it will make a difference. I can connect to other resources ( \\MachineA\C$ works from MachineB and \\MachineB\C$ works from MachineA). I have checked Name resolution on both machines, no issues found. I have run the SQL Server Surface Area Configuration on both machines and tried to configure them exactly the same. The user is not associated with a trusted SQL Server connection. Then tries to connect to database engine on MachineA (remote SQL Server) fails with error: User1 logs onto MachineB and uses SQL Managment Studio to connect to database engine on MachineB (local SQL Server), everything works. Then tries to connect to database engine on MachineB everything works. User1 logs onto MachineA and uses SQL Managment Studio to connect to database engine on MachineA (Local SQL Server), everything works.
User XXX\User1 is added to Adminitrators group User XXX\User1 is added to Administrators group
0 kommentar(er)
