How can aspnet get login rights
in [Programming SQL]
|
From: Tony Johansson on 7 Jan 2010 05:21 Hello! I have a web site using ASP.NET that is using the famous Northwind database. If I use suser_sname in my program and use IIS wich is using account ASPNET I get hempc\aspnet. If I use suser_sname and run from within VisualStudio I get the hempc\Tony because that is the account that I use to login to the computer Setting in Windows *************** If I look at My Computer->Manage and select users I can see that I have a user names ASPNET that DOESN'T belong to any group such as Users or administrator. Settings in SQL Server express ************************ If I look at Security->Logins I have the following three accounts BUILTIN\Administrator BUILTIN\Users sa Now to my question. How can ASPNET log in to SQL Server when this user doesn't belong to any group. I double check in My Computer->Manage and select users. I absolutely sure that ASPNET account doesn't belong to any group. So can anybody explain how ASPNET get login rights to my SQL Server express 2005 ???? //Tony
From: Uri Dimant on 7 Jan 2010 05:31 ASPNET account is only used by aspnet_wp.exe in IIS 5 (or IIS 5 compatible mode for IIS 6). If you use IIS 6 and above where worker process name is w3wp.exe, you can disable ASPNET even if you do ASP.NET development. http://weblogs.asp.net/mschwarz/archive/2003/03/31/4515.aspx http://msdn.microsoft.com/en-us/library/ms178329.aspx "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message news:jAi1n.14381$U5.222471(a)newsb.telia.net... > Hello! > > I have a web site using ASP.NET that is using the famous Northwind > database. > If I use suser_sname in my program and use IIS wich is using account > ASPNET I get > hempc\aspnet. > If I use suser_sname and run from within VisualStudio I get the hempc\Tony > because that is > the account that I use to login to the computer > > > Setting in Windows > *************** > If I look at My Computer->Manage and select users I can see that I have a > user names ASPNET > that DOESN'T belong to any group such as Users or administrator. > > Settings in SQL Server express > ************************ > If I look at Security->Logins I have the following three accounts > BUILTIN\Administrator > BUILTIN\Users > sa > > Now to my question. > How can ASPNET log in to SQL Server when this user doesn't belong to any > group. I double check in > My Computer->Manage and select users. I absolutely sure that ASPNET > account doesn't belong to any group. > > So can anybody explain how ASPNET get login rights to my SQL Server > express 2005 ???? > > > //Tony >
From: Tony Johansson on 7 Jan 2010 06:34 I have IIS 5 Have you an answer to my question that I posted in the previous mail. //Tony "Uri Dimant" <urid(a)iscar.co.il> skrev i meddelandet news:Otp%23US4jKHA.3792(a)TK2MSFTNGP02.phx.gbl... > ASPNET account is only used by aspnet_wp.exe in IIS 5 (or IIS 5 compatible > mode for IIS 6). If you use IIS 6 and above where worker process name is > w3wp.exe, you can disable ASPNET even if you do ASP.NET development. > > > http://weblogs.asp.net/mschwarz/archive/2003/03/31/4515.aspx > http://msdn.microsoft.com/en-us/library/ms178329.aspx > > > > > "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message > news:jAi1n.14381$U5.222471(a)newsb.telia.net... >> Hello! >> >> I have a web site using ASP.NET that is using the famous Northwind >> database. >> If I use suser_sname in my program and use IIS wich is using account >> ASPNET I get >> hempc\aspnet. >> If I use suser_sname and run from within VisualStudio I get the >> hempc\Tony because that is >> the account that I use to login to the computer >> >> >> Setting in Windows >> *************** >> If I look at My Computer->Manage and select users I can see that I have a >> user names ASPNET >> that DOESN'T belong to any group such as Users or administrator. >> >> Settings in SQL Server express >> ************************ >> If I look at Security->Logins I have the following three accounts >> BUILTIN\Administrator >> BUILTIN\Users >> sa >> >> Now to my question. >> How can ASPNET log in to SQL Server when this user doesn't belong to any >> group. I double check in >> My Computer->Manage and select users. I absolutely sure that ASPNET >> account doesn't belong to any group. >> >> So can anybody explain how ASPNET get login rights to my SQL Server >> express 2005 ???? >> >> >> //Tony >> > >
From: Uri Dimant on 7 Jan 2010 06:49 Tony ASPNET account belongs only to the Users group on that computer, that is strange you do not see it Are you sure that it is not there? "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message news:xFj1n.14388$U5.222365(a)newsb.telia.net... >I have IIS 5 > > Have you an answer to my question that I posted in the previous mail. > > //Tony > > "Uri Dimant" <urid(a)iscar.co.il> skrev i meddelandet > news:Otp%23US4jKHA.3792(a)TK2MSFTNGP02.phx.gbl... >> ASPNET account is only used by aspnet_wp.exe in IIS 5 (or IIS 5 >> compatible mode for IIS 6). If you use IIS 6 and above where worker >> process name is w3wp.exe, you can disable ASPNET even if you do ASP.NET >> development. >> >> >> http://weblogs.asp.net/mschwarz/archive/2003/03/31/4515.aspx >> http://msdn.microsoft.com/en-us/library/ms178329.aspx >> >> >> >> >> "Tony Johansson" <johansson.andersson(a)telia.com> wrote in message >> news:jAi1n.14381$U5.222471(a)newsb.telia.net... >>> Hello! >>> >>> I have a web site using ASP.NET that is using the famous Northwind >>> database. >>> If I use suser_sname in my program and use IIS wich is using account >>> ASPNET I get >>> hempc\aspnet. >>> If I use suser_sname and run from within VisualStudio I get the >>> hempc\Tony because that is >>> the account that I use to login to the computer >>> >>> >>> Setting in Windows >>> *************** >>> If I look at My Computer->Manage and select users I can see that I have >>> a user names ASPNET >>> that DOESN'T belong to any group such as Users or administrator. >>> >>> Settings in SQL Server express >>> ************************ >>> If I look at Security->Logins I have the following three accounts >>> BUILTIN\Administrator >>> BUILTIN\Users >>> sa >>> >>> Now to my question. >>> How can ASPNET log in to SQL Server when this user doesn't belong to any >>> group. I double check in >>> My Computer->Manage and select users. I absolutely sure that ASPNET >>> account doesn't belong to any group. >>> >>> So can anybody explain how ASPNET get login rights to my SQL Server >>> express 2005 ???? >>> >>> >>> //Tony >>> >> >> > >
From: Erland Sommarskog on 7 Jan 2010 08:23 Tony Johansson (johansson.andersson(a)telia.com) writes: > I have a web site using ASP.NET that is using the famous Northwind > database. If I use suser_sname in my program and use IIS wich is using > account ASPNET I get hempc\aspnet. >... > Settings in SQL Server express > ************************ > If I look at Security->Logins I have the following three accounts > BUILTIN\Administrator > BUILTIN\Users > sa > > Now to my question. > How can ASPNET log in to SQL Server when this user doesn't belong to any > group. BUILTIN\Users sounds to me like a group that includes all users on the machine. Including ASPNET. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|
Next
|
Last
Pages: 1 2 Prev: I have now probably done a very silly thing Next: Migrating/Promoting Schemata and Rows |