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)

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 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

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -