How to add local account of another computer to sql server?
I need to add a user (\network_service) to a different computer's sql server logins. How can I do this? I am attempting to search for the account, but it is not finding it. In SQL Server:
Security >
Right-Click Logins >
Click "Search" >
attempt to find 开发者_开发问答\\<computername>\network_service
attempt to find \\<computername.domainname>\network_service
attempt to find <computername>\network_service
...nothing is working. I am searching under "all locations". This is to get a dotnetnuke website running with using a separate server for its sql database. Supposedly, I need to add the NETWORK_SERVICE account as a sql server login.
Any ideas?
http://msdn.microsoft.com/en-us/library/ff647402.aspx
Network Service on one computer is Network Service on all; It is a limited-privilege, authenticatable user account common to all Windows NT machines. So, you should be able to simply grant the DB server's Network Service user access to the DB, and then applications, whether local or remote, that are authenticating themselves as Network Services should get the same access.
精彩评论