Discussion: NT AUTHORITY problem
Afficher un message
Vieux 28/03/2008, 09h40   #2
Charles Wang[MSFT]
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut RE: NT AUTHORITY problem

Hi Gary,
I understand that you would like to know if you can remove the NT
AUTHORITY\NETWORK SERVICE user from your SQL Server database and then use
the user account ASPNET as the dbo user of your database.
If I have misunderstood, please let me know.

Yes, sure! You can replace the NT AUTHORITY\NETWORK SERVICE account with
your ASPNET account by the following steps:
1. Log on your SQL Server instance with a system administrator;

2. Create the new login ASPNET in SQL Server Management Studio (SSMS). If
you are using SQL Server 2000, please use Enterprise Manager (SSEM) to
explicitly create the new login under the Security folder. Of course, you
can also run the following T-SQL statement to add the login:
sp_grantlogin N'ASPNET'
Go
exec sp_defaultdb N'ASPNET', N'<your database name>'
Go

3. In SQL Query Analyzer or SSMS, run the sp_changedbowner to change your
database owner from NT AUTHORITY\NETWORK SERVICE to ASPNET.
EXEC sp_changedbowner N'ASPNET'
Go

4. If there is no other database using the network service account and if
you delete the login NT AUTHORITY\NETWORK SERVICE from your SQL Server
instance, you can do this in SSMS or SSEM by manually deleting the login
under the Security folder or running the following T-SQL statement:
EXEC sp_revokelogin N'NT AUTHORITY\NETWORK SERVICE'
Go

Hope this s. Please feel free to let me know if you have any other
questions or concerns.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======




  Réponse avec citation
 
Page generated in 0,06594 seconds with 9 queries