Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Login creation failed Expand / Collapse
Author
Message
Posted Friday, July 26, 2013 3:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 12:43 AM
Points: 208, Visits: 563
Hello Master,

My client created a local non domain windows account and now they want me to add that acount on SQL Server and want sysadmin rights. My SQL Server is in domain on that machine. While creating user, I am able to search that account (As it is local machine account) but I am not able to create login for the same. I got an error :

"Error 15401: Windows NT user or group '%s' not found".

Is it necessary that new login should be in domain ? OR how can I create login for Nondomain(local account) account ?
Post #1477922
Posted Friday, July 26, 2013 4:24 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 12:43 AM
Points: 208, Visits: 563
Yeah..!! :) I did it.

I was trying to create user with "Windows authentication" as it was local user, I was getting error. I tried with "SQL Server Authentiacation" and it works..!!

Huh, I did it. :)
Post #1477928
Posted Tuesday, September 10, 2013 4:46 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 12:21 AM
Points: 23, Visits: 278
The SQL login you created isn't associated with the local Windows account. You've created a stand-alone login within SQL, which is why it asked you to create a new password instead of using the password of your Windows user. Here is a script that will create the login, and then add it to the 'sysadmin' server role.

USE [master]
GO
CREATE LOGIN [MyDBServer\LocalAccount] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
EXEC sp_addsrvrolemember 'MyDBServer\LocalAccount', 'sysadmin'
GO
Post #1493394
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse