0
I have installed Windows Server 2012 in server and also having SQL Server 2015 setup on the same. SQL Server is configured to accept remote connections. It was working perfectly fine till today.
What happened is, I tried to login to SQL Server and it didn't allowed me to login(here i am connecting the sql server with SSMS from remote machine). So i tried to login in to server and check for the issue, but i am not able to login to server as it says the same password is wrong.
Here, strange thing is, as said earlier i am connecting the database remotely, so my web application which is in PHP-CI is working perfectly and connecting the database as it should be.
So, in short
- Cant not login to Server
- Can not Login to SQL Server via SSMS(Remotly)
- Can login/Connect to SQL Server via Web Application
here, i am using the same ip, id, password to connect to Sql Server on SSMS and the webapp both. Any guesses why it is happening or solution to this problem?
Are you trying to connect to the instance using the SA account? Is your PHP-CI application using the same login? Or did you create a second login? – spikey_richie – 2019-07-11T15:01:46.720
No i have created the 2nd login for connections. not using SA – The N World – 2019-07-11T15:07:18.567
And using SSMS, can you connect to the instance using the 2nd login? – spikey_richie – 2019-07-11T15:12:45.537
No not using SSMS. I can connect using PHP WebApplication that i am developing. SSMS gives login verification error – The N World – 2019-07-11T15:43:42.960