客户端的SQL Server管理工作室拒绝与SQL服务器连接 [英] Sql server management studio on client side refusing to connect with SQL server

问题描述

Gooday

我正在构建一个在Windows服务器上运行的SQL服务器，我想通过客户端机器访问它。我有服务器运行sql server 2012并在SQL Server配置管理器下我有服务器网络协议TCP / IP设置与以下配置：

活动=是

启用=是的

IP所有TCP动态端口= null

TCP PortAll = 1433

我的服务器上的防火墙被禁用，我配置它来过滤通信通过端口1433.

在我的客户端上，我尝试使用我在服务器上安装Sql server软件时使用的凭据登录服务器。我允许Windows和sql凭据同时使用特定密码对用户Administrator进行帐户管理。

在sql server软件上，我的SSMS，我选择了对SQL SERVER AUTHENTICATION的身份验证。

我正在尝试使用

管理员使用其各自的密码登录，但是客户端正在生成错误，该错误表明我使用了不正确的凭据尝试登录到服务器。我在我的客户端上禁用了防火墙，允许从服务器进行任何形式的通信，但通信尚未建立。我使用Intranet作为我的原型系统的一种通信形式。没有网络。因此，我邀请有兴趣的EXPERT意见来协助我解决这个问题。



我尝试过的事情：



请参阅问题陈述说明。

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.

推荐答案

这些计算机是在Active Directory域环境还是工作组中？



客户端实际上是连接到SQL Server。如果没有，您将无法获得身份验证失败错误。



在域环境中，作为目录成员的每台计算机都共享并完全信任同一个帐户数据库，由域维护。



在工作组中，每台计算机都有自己的帐户数据库。每台机器只会信任自己的帐户数据库。



您遇到的问题就像这些机器一样，属于工作组。您在客户端计算机上设置了名为Administrator的帐户及其密码。那么，服务器有自己的帐户管理员。它的密码与客户端计算机上的管理员帐户不同。



服务器对您的客户端计算机帐户数据库一无所知，如果它不信任它没有。在服务器上设置管理员帐户，然后您可以使用这些凭据从客户端计算机登录到SQL Server。服务器将查找您在其自己的帐户数据库中输入的任何凭据，而不是客户端。

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.

这篇关于客户端的SQL Server管理工作室拒绝与SQL服务器连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！