How To Set NT Authority In Sql 2000?

Sep 18, 2007

We have an application store in a web server using IIS 6.0, however the application is communicating to sql 2000 that is stored in a 2000 server. In IIS 6.0 the application pool is set to Network Services, therefore sql 2000 is looking for a user called 'NT AUTHORITYANONYMOUS LOGON'.

But the login failed, and I don't see how to add NT Authority as a user in a 2000 server like you can in a 2003 server.

In all, we are trying to set permissions to certain users only by using the identity impersonate='true' in the web config file, but even with this setting set to true, and our network information set as a user in sql 2000, we still are denied access to the data.

What are some things we need to look for and what configuration do we need to set?

Thanks,xyz789

P.S.
We also have all the permissions check to have access to all the tables and store procedures for each user.

View 2 Replies

NT Authority Login Failed

Jan 18, 2008

I have googled this to my hearts (dis) content, and all the answers I have found either rely on 1) creating untrusted connections, or 2) hard coding your password into the page. Neither of which I am satisfied with. Here is my scenario:I am using Visual Web Developer 2008 Express Edition to construct an intranet site on my companies corporate network. I am using a development PC which sits not far from the main server I will be utilising for the hosting of the intranet site. I have local admin privileges to this server (as well as the box I am developing on). I do not have privileges to the domain controller (but that doesn't seem important to me anyway).I have created a database in SQL Enterprise Server on the intranet server and am using that database thru my development box. ie, the (test) data is already on the server and I have VWD2008EE access the data directly. Now this works as expected and without problem. I can create data sources and controls and they work on my development box. I can create data access code that also accesses the database, and it works correctly, ie, I see the data. However, when I import the code/pages to the production server, I get this error message: Login failed for user 'NT AUTHORITY/NETWORK SERVICE'."What puzzles me is that the VWD development server can access the database without a problem, yet if the pages run from the server itself, the database is no longer accessible. And it is the same database we are talking about. Disabling any form of security is not an option.Also, Windows authentication (ie using the domain controller) is the ONLY for of authentication available to me.I am guessing I have to add a particular type of user to the production server, but where and how is a little beyond the scope of my knowledge. There is no "Network Service" user (should there be?)Any help would be GREATLY appreciatedFurther info if required:Development PC - Windows XP Pro SP2 on a corporate network, logging in through a domain controllerProduction PC - Windows Server 2003 Enterprise SP2 using IIS V6.0 and SQL Enterprise Manager 8.05.02 (ODBC V: 3.52.0000)This is the code I use to access the SQL server(remember, this works from the development PC to the production SQL server, just not form production PC to production server): Imports System.Data.SqlClientProtected Sub Page_PreRender(byval sender as object, byval e as system.eventargs) Handles me.prerender Dim dbcon as new SqlConnection("Data Source=F001;Initial Catalog=Whiteboard;Integrated Security=true;") Dim myCommand as new SqlCommand myCommand.Connection = dbcon myCommand.CommandText = "SELECT * FROM tbl_rooms ORDER BY [d_date], [r_id], [t_from]"
Dim myReader as SqlDataReader dbcon.Open() ' <-- this is where the error comes in ONLY on production PC '... code which reads the table and prints it (this works)

dbcon.Close
End Sub

View 3 Replies View Related

View Jobs Authority

Jul 12, 2004

Is there a way to grant other users the ability to view jobs run by the SA login short of making them admins ?

-Dave