I am building an sql server running on windows server and i want to access it through client machines. I have the server running sql server 2012 and under SQL Server Configuration Manager I have the server network protocols TCP/IP set with the following configurations:
IP ALL TCP Dynamic Ports =null
TCP PortAll = 1433
My firewall on my server is disabled and i configured it to filter communication through the port 1433.
On my client, i try to login to the server using the credentials i used when i installed the Sql server software on my server. I allowed both windows and sql credentials to account user "Administrator " simultaneously with a specific password.
On the sql server software, my SSMS, i selected the authentication to SQL SERVER AUTHENTICATION.
I am trying to login with
"Administrator " with its respective password but the client is generating an error which states that i am using incorrect credentials to attempt to login to the server. I disabled the firewall on my client to permit any form of communication from the server but the communication is not yet establishing. I am using intranet as a form of communication for my prototype system. No internet. Therefore i am inviting intrested EXPERT opinion to assist me in solving the respetive problem.
What I have tried:
See description of problem statement.