Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rafael.soteldo
Starting Member
36 Posts |
 Posted - 2014-02-12 : 09:15:45
|
| 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; GOI 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 |
|
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2014-02-12 : 10:57:31
|
This may be a localization problem.Try:SET LANGUAGE us_english;CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS; |
 |
|
|
rafael.soteldo
Starting Member
36 Posts |
Posted - 2014-02-13 : 08:34:05
|
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 |
|
|
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2014-02-13 : 09:32:45
|
The following should show you the logins:SELECT loginnameFROM 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. |
|
|
|
|
|
|
How can I create NT AUTHORITY\NETWORK SERVICE Log?