Post reply

Unable to create network service user back

  • June 13, 2015 at 12:33 am

    #297819

    Hi, when I try to create network service user from Ms SQL Server Management Studio, I got this error below. What should I do to solve this?

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    Create failed for Login 'NT AUTHORITY\NETWORK SERVICE'. (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

    ------------------------------

    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    User does not have permission to perform this action. (Microsoft SQL Server, Error: 15247)

  • June 15, 2015 at 8:13 am

    #1805456

    Hi,

    Have you tried using the T-SQL syntax? Additionally have you checked that you started SSMS using the "Run as Administrator" explicit option? Minimal role required for creating logins is securityadmin. I also would suggest to review events in the system and application event logs just in case is there any other issue related with the OS.

    USE [master]

    GO

    CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

    GO

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply