SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 How can I create NT AUTHORITY\NETWORK SERVICE Log?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rafael.soteldo
Starting Member

36 Posts

Posted - 02/12/2014 :  09:15:45  Show Profile  Reply with Quote
I'm trying to execute the following command in Sql Server Express 2012 (Sql Server Management Studio):

CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS; GO

I get an error saying that Windows NT user group 'NT AUTHORITY\NETWORK SERVICE' was not found,

Where can I create that Loging, or find it for that matter?

(I have Windows 7 Ultimate x64, and I'm using VS2012)


Thanks in advance for your time

-------
Rafael Soteldo

Edited by - rafael.soteldo on 02/12/2014 10:17:08

Ifor
Aged Yak Warrior

585 Posts

Posted - 02/12/2014 :  10:57:31  Show Profile  Reply with Quote
This may be a localization problem.
Try:

SET LANGUAGE us_english;
CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS;
Go to Top of Page

rafael.soteldo
Starting Member

36 Posts

Posted - 02/13/2014 :  08:34:05  Show Profile  Reply with Quote
quote:
Originally posted by Ifor

This may be a localization problem.
Try:

SET LANGUAGE us_english;
CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS;




Hi,

In spanish Network Service is Servicio de red. When I try it as NT Authority\Servicio de red, apparently works. At least it says that the execution was succesful.

Do you think it is really ok? I'm experiencing problems to access the database from an ASP Net app with a service.

Thanks in advance for your time

-------
Rafael Soteldo

Edited by - rafael.soteldo on 02/13/2014 08:35:23
Go to Top of Page

Ifor
Aged Yak Warrior

585 Posts

Posted - 02/13/2014 :  09:32:45  Show Profile  Reply with Quote
The following should show you the logins:

SELECT loginname
FROM sys.syslogins;


If the login exists, your problems are probably to do with access rights.
You can check this by temporarly making the login a member of sysadmin.
Something like:

ALTER SERVER ROLE sysadmin ADD MEMBER [NT Authority\Servicio de red];


If this works, find out what rights you actually need and apply them instead of having the login in sysadmin.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000