Forum Discussion
Help with connecting to SQL Server
I am a user in a Windows domain. I installed SQL Server 2022 Developer on a computer to set up a development environment. Install was successful and I was able to connect to the DB on that computer using SSMS. When I tried doing the same on another computer, also with SSMS, I got error 5 - Access denied. Error also mentions to check if server allows remote connections. I verified that it does.
I am not in the office today, so I can't share screen cap or the long detailed report I got. I found information on error 5, mostly dealing with folder permissions, but the issues described are when attempting to create a database. My issue is I can't even connect to server
Does anyone have any suggestions? Thank you for your time and assistance. Saga
I got error 5 - Access denied.SagaV9 , error 5 is a Windows OS error, it don't come from SQL Server.
SQL logon error is 18456
MSSQLSERVER_18456 - SQL Server | Microsoft Learn
So it must be something beside SQL Server.
Check the connection using ODBC Data Source
