March 27, 2015 at 11:56 am
My account is part of an AD group which is sysadmin on the server but for some reason I'm not able to log into SQL using SSMS. I tried even with the service account which is giving me a login failure.
Did someone face this issue?
March 27, 2015 at 12:12 pm
Are you receiving a specific error message? I had this error today. The error message was along the lines "A network-related error or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible." To resolve it, I had to enable Names Piepes and TCP/IP protocols under SQL Server Network Configuration in Configuration Management. Hope that helps.
March 27, 2015 at 12:35 pm
DBAHeels (3/27/2015)
Are you receiving a specific error message? I had this error today. The error message was along the lines "A network-related error or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible." To resolve it, I had to enable Names Piepes and TCP/IP protocols under SQL Server Network Configuration in Configuration Management. Hope that helps.
Error:18456. login failed for user xxx.
I don't think it's related to the protocols as they are all enabled.
March 27, 2015 at 1:53 pm
Are you trying to login locally from your machine or from the server(try both ways)?
Can you check if the SQL Server Services are enabled?
Can you check the error-log on the server and copy paste the exact error message....
How about other members in the Active Directory group ... are they getting the same error or is it only for your account?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply