Error when trying to log in to SQL server

I've just finished developing a web app, which works fine on my PC, running IIS locally. It uses windows authentication and a trusted connection to retrieve data from SQL server. So far so routine. When I deploy the app to my live server, it returns the error:

Login failed for user '\'

The stack trace seems to indicate that it's at the point where the app tries to retrieve data that the error occurs. I proved this by changing my connection string to explicitly define the log on, and it retrieved the data no problem.

I set up a very simple webform with a label on, to return what it thought the user's log on name was, and it returns the correct name.

Any ideas as to why the username isn't being correctly passed to SQL server?Have you made sure the Web Account is a valid user of the SQL Server? If the IIS box and the SQL box are different you have to ensure the user has network rights too.|||Yes, the user (me!) definitely has rights on the SQL server. How come it works locally on my PC, but not on the server?

What network rights do you think I should investigate?

Thanks.|||Sorry I mis-read your original post, I didn't notice that your site was using NT Authentication. So here is my mental checklist:
1. Web Server has access to the Domain server to authenticate the user
2. The Web Server isn't the Domain Server
3. SQL Server security logins knows about the Windows user/user group
4. The SQL Database knows about the Windows user/user group

I mentioned the network security because when you use anon web access the user must have network access to go across machines. That "shouldn't" be an issue here.

Also run SQL Profiler to see if the user is getting set to SQL and then going wrong. Sounds more like its a problem on the web server though, something wrong with the impersonation.|||I'm positive that the user is being authenticated properly on the app, because when I load a simple page with a label which displays the user name, it displays correctly. For some reason this user name isn't getting passed to SQL server correctly.

I tried deploying the application to the box which has the SQL server running, and gess what? It worked. So does this mean that the first box can't access the domain server? Any idea how I can check that?

I'll have a think, and let you know how I get on.

Cheers.|||Hang on, just cause you're using Web Authentication doesn't mean it will impersonate the user onto SQL Server. Do you set the principal security when the user connects?

Check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch03.asp

Error trying to install reporting services

I have verified that iwam_computer is enabled and in sync.
error mesage -
Internet Information Services 5.0 (IIS) or later is either not installed, or
it is configured in a way that is incompatible with a Reporting Services
installation.
log -
Microsoft SQL Server 2000 Reporting Services Setup beginning at Mon Jan 24
09:22:42 2005
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='WindowsInstallerComp::Init'>
<Func Name='WindowsInstallerComp::IsRequired'>
<Func Name='DotNetFxComp::Init'>
<Func Name='DotNetFxComp::IsRequired'>
<EndFunc Name='DotNetFxComp::IsRequired' Return='F' GetLastError='0'>
SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:414}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
<Func Name='SqlSetupFilesComp::Install'>
<Func Name='BootstrapPackageLogic'>
<Func Name='InstallBootstrapPackage'>
/I "E:\SQLRSEVAL\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033" /qn
<EndFunc Name='InstallBootstrapPackage' Return='0' GetLastError='183'>
<EndFunc Name='BootstrapPackageLogic' Return='0' GetLastError='183'>
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED, cancel_state=0,
is_done=1, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:420}
<EndFunc Name='UpdateComponents' Return='0' GetLastError='183'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Machine = ISOVDEVWAC8, Article = IIS, Result = 0 (0x0)
<Prerequisite Name="IsVS71Installed" Checked="Registry"
Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1" Found="Can not open key"
Expected="No error" Result="Fail" />
Machine = ISOVDEVWAC8, Article = VSNET, Result = 60351 (0xebbf)
Machine = ISOVDEVWAC8, Article = ASPNET, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = MDAC, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = DTC, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = SERVEROS, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = SHAREPOINT, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = AUTHZ, Result = 0 (0x0)
<Prerequisite Name="AreRSAccountsValidInstalled" Checked="User accounts"
Item="IWAM_machineName" Found="Not exist or not enable" Expected="Exist and
enabled" Result="Fail" />
Machine = ISOVDEVWAC8, Article = RSACCOUNTS, Result = 60357 (0xebc5)
**************
ISOVDEVWAC8
**************
Report Designer component requirement
<B>Explanation:</B> Visual Studio .NET 2003 is not installed.
<B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
install Report Designer. Or, continue Setup to complete the installation
without Report Designer.
Report Server component requirement
<B>Explanation:</B> Internet Information Services 5.0 (IIS) or later is
either not installed, or it is configured in a way that is incompatible with
a Reporting Services installation.
<B>Action:</B> To install the Report Server and Report Manager components,
you must first install Internet Information Services 5.0 (IIS) or later, and
then verify that the Web server configuration requirements are compatible
with Setup. Check the Setup documentation for more information about Web
server configuration requirements.
Report size = 1050
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
Bootstrap\LOG\RSStp_.cab"seems error comes from these line
> <Func Name='InstallBootstrapPackage'
> /I "E:\SQLRSEVAL\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033
/q
> <EndFunc Name='InstallBootstrapPackage' Return='0
GetLastError='183'
> <EndFunc Name='BootstrapPackageLogic' Return='0
GetLastError='183'
>
Did you find how to solve it ? i got the same problem..
Thank|||o
in my case i used to install it with the command line options wher
some errors are but if you used the response file it's the same
For example do not use REINSTALL=All; it just failed, us
REINSTALLMODE=omus or amus (omus works
Also RS_BooksOnline_EN is not a valid entry even you see it everywher
on Ms Docs (bull...
use RS_BooksOnline and not RS_BooksOnline_EN
Hope it will hav helped yo