How do I add a user to domain computer name to SQL database table

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

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

C#

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>$]

Posted 17-Mar-16 0:44am

IsiR_19

Updated 17-Mar-16 0:54am

v2

Add a Solution

Comments

phil.o 17-Mar-16 6:51am

What is the exact error message?
Moreover, the NETBIOS authentication syntax is DOMAIN\SERVER, not DOMAIN/SERVER. Is it a typo?

IsiR_19 17-Mar-16 6:53am

Yes sorry that was a typo

this is the message i am getting from SQL Log files

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

phil.o 17-Mar-16 6:56am

Which login do you try to use: the computer name or the user name?
Also, do you have SQL Server Management Studio? It's much easier to handle accounts from this application.

IsiR_19 17-Mar-16 6:57am

Computer Name.

Yes i do have SQL server management studio, i have tried added the account there as well and get same error

phil.o 17-Mar-16 7:01am

Access should be granted to a user, not a computer.
More precisely, the account that should be configured is the account under which your Biztalk component tries to query the database.

IsiR_19 17-Mar-16 8:07am

Thanks Phil.o

CHill60 17-Mar-16 6:58am

You might need to allow remote access to the sql server ... Configure the remote access Server Configuration Option[^]

IsiR_19 17-Mar-16 8:08am

Remote access is allowed

Herman<T>.Instance 17-Mar-16 10:00am

To which groups does the user belong

RickZeeland 17-Mar-16 10:29am

I once had a similar problem with code using SqlDependency, which occurred after the computer name had been changed:
'Could not obtain information about Windows NT group/user'
But in my case correcting the user name helped.

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)