How do I add NETWORK SERVICE login via SQL Authentication?

sql login sql-server-express sql-server-2005-express
salvationishere picture salvationishere · Jun 21, 2010 · Viewed 16k times · Source

I am trying to add the NETWORK SERVICE login cause I still can’t connect to the AdventureWorks3 database. But I want to add this NETWORK SERVICE login via SQL Server Authentication and not Windows.

When I select Windows authentication, it lets me create this login. But when I select SQL Server Auth, it gives me the following error: Create failed for Login ‘NT AUTHORITY\NETWORK SERVICE’…’NT AUTHORITY\NETWORK SERVICE’ is not a valid name because it contains invalid characters. (MS SQL Server, Error: 15006)

Answer

gbn picture gbn · Jun 21, 2010

NT AUTHORITY\NETWORK SERVICE is the local server account name. When the server is part of a domain, "network service" becomes DOMAIN\ServerName$ and this can be used for a Trusted/integrated/Windows login

CREATE LOGIN [BigCompany\JustOneServer$] FROM WINDOWS

If it's not part of a domain, use a SQL Server login.

Related questions

how to generate OTP and send the password to mobile via sms

I am doing a project of using OTP for the login of the websites, I have created a button named "Generate" once clicked it will create an OTP and send an SMS via HTTP gateway, then it stores the password …

Read More
SQL CREATE LOGON - can't use @parameter as username

I'm a developer and I suck at SQL:) Please help me out here. I'd like to create my own Stored Procedure that creates a Tenant in my SaaS database. In order to do this I need to create a new …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More