How do I connect to my application via http://localhost/..., using
IIS.
I've developed an application via the File System (using the VS Web
server). When I deploy it I change the <appSettingsFro m
MyAppConnString _localhost to MyAppConnString _live (see config settings
below).
Up to now connections have worked fine.
I've never developed via IIS but I want to now. That's because I've
noticed that AJAX seems to work differently when the application is
running via the File System (VS Web Server) or IIS.
The problem is that as soon as I run my application, after connecting
via LocalIIS, niether connection string (see below) is valid.
Why not? What do I need to do locally via IIS and/or SQL Server
Express to get this to work (using integrated security). Am I missing
a machine account or user account?
My account is a local machine administrator.
This is the first time I've tried to connect via IIS since I upgraded
using the recent upgrades for Win XP, VS (SP1) and SQL Server Express
(SP2). I'm using VS 2005 Standard and WinXP SP2.
<appSettings>
<add key="connection String" value="MyAppCon nString_localho st"/>
</appSettings>
<connectionStri ngs>
<add name="MyAppConn String_localdev " connectionStrin g="Data Source=.
\SQLEXPRESS;Int egrated Security=True;I nitial Catalog=MyApp_4 0"
providerName="S ystem.Data.SqlC lient"/>
<add name="MyAppConn String_live" connectionStrin g="packet
size=4096;user id=AliBaba;data source=.;persis t security info=False;
initial catalog=MyApp_4 0;password=letm ein"
providerName="S ystem.Data.SqlC lient"/>
</connectionStrin gs>