如何将用户添加到域计算机名称到SQL数据库表 [英] How do I add a user to domain computer name to SQL database table

问题描述

我有一个Biztalk组件正在调用我的本地数据库，但它使用域名/服务器名称来尝试连接，但SQL不允许连接，不断收到错误



这是SQL日志中的错误

消息
登录失败 用户'  Domain \ComputerName $ 。原因：找不到与提供的名称相匹配的登录信息。 [客户：<本地机器>] 

我试过从ssms GUi添加用户还尝试添加用户来自

CREATE登录[< domainname> \< computername> $]



但仍然收到错误



请有人帮忙



我尝试过的事情：



我试过从ssms GUi添加用户并尝试添加用户来自

CREATE登录[< domainname> \< computername> ; $]

解决方案

'。原因：找不到与提供的名称相匹配的登录信息。 [客户：<本地机器>]

我试过从ssms GUi添加用户还尝试添加用户来自

CREATE登录[< domainname> \< computername>

但仍然收到错误



请有人帮忙



我是什么尝试过：



我试过从ssms GUi添加用户并尝试添加用户来自

CREATE登录[ <域名> \<计算机名>

I have a Biztalk component which is making a call to my local db but it is using the Domainname/server name to try and connect but SQL is not allowing connection, keep getting an error

This is the error from the SQL Log

Message
Login failed for user 'Domain\ComputerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

I have tried adding the user from ssms GUi and also tried adding the user from
CREATE Login [<domainname>\<computername>$]

But still getting the error

Please could someone assist

What I have tried:

I have tried adding the user from ssms GUi and also tried adding the user from
CREATE Login [<domainname>\<computername>$]

解决方案

'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

I have tried adding the user from ssms GUi and also tried adding the user from
CREATE Login [<domainname>\<computername>

But still getting the error

Please could someone assist

What I have tried:

I have tried adding the user from ssms GUi and also tried adding the user from
CREATE Login [<domainname>\<computername>

这篇关于如何将用户添加到域计算机名称到SQL数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！