Click here to Skip to main content
14,384,969 members
Rate this:
Please Sign up or sign in to vote.
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
Updated 17-May-19 21:47pm
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

Rate this:
Please Sign up or sign in to vote.

Solution 1

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.
   

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100