Sql server management studio on client side refusing to connect with SQL server

Question

0.00/5 (No votes)

See more:

Gooday
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:
Active= yes
Enabled= yes
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.

Posted 17-May-19 10:49am

Member 10590098

Updated 17-May-19 20:47pm

Add a Solution

Comments

phil.o 17-May-19 17:24pm

The error you get suggests that there is no communication problem between the server and the client.
Does exist a SQL account with name 'Administrator' in the SQL instance you are trying to connect to?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2019-05-17T11:27:00

Are these machines in a Active Directory domain environment or workgroup?

The client is actually connecting to the SQL Server. You wouldn't be getting the authentication failed error if it didn't.

In a domain environment, every machine that's a member of the directory shares and trusts the exact same account database, maintained by the domain.

In a workgroup, every machine has its own account database. Every machine will only trust its own account database.

The problem you're having sounds like these machines are in a workgroup. You setup the account called "Administrator" and its password on the client machine. Well, the server has its own account called Administrator. Its password is not the same as the Administrator account on the client machine.

The server does not know anything about your client machines account database and will not trust it if it did. Setup the Administrator account on the server, then you can use those credentials to login to the SQL Server from the client machine. The server will lookup any credentials you enter in its own account database, not the clients.