sql server 2008 - Create failed for Login 'NT AUTHORITY\NETWORK SERVICE' ... User does not have permission to perform this action -
i following article http://www.codeproject.com/articles/674930/configuring-iis-asp-net-and-sql-server
to setup database after have setup iis. works initially. can run web application successfully. after make changes access right in network service user, hit error , when go security > logins, see 3 users: builtin/users, sa , stevengai\user.
now, went re-create "network service" (logins > new login), hit error below. should fix this?
title: microsoft sql server management studio
create failed login 'nt authority\network service'. (microsoft.sqlserver.smo)
additional information:
an exception occurred while executing transact-sql statement or batch. (microsoft.sqlserver.connectioninfo)
user not have permission perform action. (microsoft sql server, error: 15247)
the user using create new login not have required permissions.
read this page on msdn explains how create login in sql server. note security segment:
requires alter login or alter login permission on server.
Comments
Post a Comment