If you aren't logging in then I would guess you are using
the Welcome screen login option. The user you select is the
user that is logged into windows for you. That is the login
that would access MSDE on your computer if you were using
osql, admin tools, etc. Depending on other settings but
generally if your web site is using Windows Authentication,
it will log into SQL Server using the ComputerName\ASPNET
login.
That's basically how it would work. There is a login
associated with you as well as IIS that can be used as
windows logins in SQL Server.
-Sue
On 22 May 2006 18:40:57 -0700, "RAB" <rabmissouri@xxxxxxxxx>
wrote:
Re: login 101.. ... On Windows 2003, SQL Server 2005 can enforce the Windows password complexity ...Windows authentication - SQL Server uses a special protocol to ask ... user is in the list of allowed logins,... (microsoft.public.sqlserver.security)
RE: How to create a trusted connection ... What do you mean by "creating a Windows login"?... To login SQL Server 2000 using trusted connection, grant the Windows... Group" in SQL Server Books Online to get the concept, ... (microsoft.public.sqlserver.security)
Re: Connecting to SQL from a Windows Service ... There is probably some way to debug this, but that's deeper Windows knowledge than I can dredge up right now. ... I looked into the Event Log and found that when my service ... 1st Login succeeds.... You can try turning on login auditing in SQL Server and then check the ... (microsoft.public.sqlserver.connect)
Re: Trusted SQL Server connection (SQL 2005) ... To be able to login to SQL Server using a Windows account, then a login must be created in SQL Server Security\Login for that account or for a Windows group which consists that Windows account. ... Create login for the Windows group who you want them to be able to login to your SQL Server and assign them necessary permissions for your database objects or whatever. ... (microsoft.public.sqlserver.security)
RE: Password never set - locked out of Windows XP Home ... Ran fixboot last night, and although the system said it had fixed the boot ... I am still stuck in the redundant loop of getting to a pop-up login ... only to not have it shutdown but instead pop back up with the same login box. ... my Windows XP Home system worked great. ... (microsoft.public.windowsxp.accessibility)
