x

Create Login

Create Login [\TestAccount} from Windows Go

That's the command I'm using to create a login, however, I keep getting, "msg 15401, level 16, state 1, line 1 windows nt user or group '\TestAccount' not found. Check the name again". Error. I created a new user Called TestAccount under the computer management, so the user is there.

more ▼

asked Jul 04, 2013 at 02:45 PM in Default

avatar image

sgonza2975
0 2 2 3

You've got a } instead of a ] there - is that in your script, or just a typographical / transcription error?

Jul 04, 2013 at 04:25 PM ThomasRushton ♦♦
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Try tweaking it as:

 CREATE LOGIN [ComputerName\TestAccount] FROM WINDOWS;  
 GO
 
more ▼

answered Jul 04, 2013 at 03:09 PM

avatar image

Blackhawk-17
12.1k 30 36 42

(comments are locked)
10|1200 characters needed characters left

Verify that the Windows login still exists in the domain. Your network administrator may have removed the Windows login for specific reasons, and you may not be able to grant that login access to the SQL Server.

Syn: Create Login [ComputerName\Loginname] from Windows

more ▼

answered Jul 04, 2013 at 03:18 PM

avatar image

skpani
630 22 26 30

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2149
x107
x17

asked: Jul 04, 2013 at 02:45 PM

Seen: 1073 times

Last Updated: Jul 04, 2013 at 04:26 PM

Copyright 2017 Redgate Software. Privacy Policy