We do have 2 windows servers(xx.xx.xx.118 and xx.xx.xx.119) and also we do have 2 SQL servers installed on those windows servers(xx01 and xx02).
The customer gave us one separate username(user1) to login to windows and SQL servers but while trying to login to xx01 SQL server from 118 servers we are getting the Error:18456. We able to connect to xxo2 SQL server from 118 servers with the same user.
We are unable to connect to xx01 SQL server from 119 windows server also with the same username(user1). We are able to connect to xx02 SQL server from 119 windows server.
We also got the Administrator account details both windows servers but unfortunately, Admin is also not having access to SQL servers.
I have gone through different URLs and tried all the available options but couldn't get the access.
Tried to run as different user...to change any settings first we don't have any user able to access.
The customer has no idea regarding other users having access to SQL servers and also they are not aware of sa account details.
The windows are virtual machines and we RDP to those servers.
Can someone suggest me how to get access to those SQL servers and resolve the issue?