That's because your asp.net application is running on local asp.net account.
Either use username/password when connecting to sql server (not recommended)
or run your asp.net application under a trusted account.
If your sql server is on the same machine then you could add asp.net account
to the sql server logins.
What OS are you running on?
Re: sqlserver connection - need help desperately! ... > You are connecting to a remote SQL Server ... > The SQL Server accepts both Windows and SQL Server authentication. ... > SQL Server login that's authorized to use your database. ... > the ASP.NET account in the SQL Server. ... (microsoft.public.dotnet.framework.aspnet)
Re: Error 15401 using sp_grantlogin (not addressed by current KB articles) ... Restarting Windows 2000 resolved the problem for this particular account,... confused when it sees a duplicate SID.... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ... (microsoft.public.sqlserver.security)
Domain user cannot connect with integrated security ... We noticed a SQL process on our development SQL server (SQL 2k, ... I asked the user to use integrated security and not the local account - ... The domain user who is connecting is a member of a local group on the ... (microsoft.public.sqlserver.security)
Re: SharePoint V3 Install Error ... But it our case it had to do with Group Policies that forbid the account of ...WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search... whatever you are installing WSS as sufficient rights to the SQL Server... (microsoft.public.sharepoint.windowsservices)
Re: access deny the sa account ... > authority, is it possible to disable the account sa to access the ... not with SQL Server logins.... Andrea Montanari (Microsoft MVP - SQL Server) ... (microsoft.public.sqlserver.msde)
