This project has moved. For the latest updates, please go here.

Ticket Desk Setup

Jan 26, 2015 at 11:16 AM
Edited Jan 26, 2015 at 11:18 AM
I am sure this might have been covered but I would like some assistance with setup

My environment

windows 2012 on AD domain
added features/roles
Asp
IIS7.*
SQL EXPRESS 2012 default instance same as server name

Setup done so far

SQL setup and created database from scratch as well as run scripts in database
Created Ticketdesk folder in inetpub wwwroot
Setup new website in IIS pointing at the ticketdesk folder
Setup under IIS authentication windows authentication is enabled, anon is disabled, form based is disabled
Enabled remote errors to debug in web.config
Changed connection strings to

<add name="TicketDeskSecurityConnectionString" connectionString="Data Source=localhost;Initial Catalog=TicketDesk;Integrated Security=True;User Instance=False" providerName="System.Data.SqlClient" />
<add name="TicketDeskEntities"connectionString="metadata=res://*/Models.TicketDeskEntities.csdl|res://*/Models.TicketDeskEntities.ssdl|res://*/Models.TicketDeskEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=localhost;Initial Catalog=TicketDesk;Integrated Security=True;Connect Timeout=30;User Instance=False;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
<add name="ElmahLog" connectionString="Data Source=localhost;Initial Catalog=TicketDesk;Integrated Security=True;User Instance=False" providerName="System.Data.SqlClient" />
On restarting IIS I am now getting the following error

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "TicketDesk" requested by the login. The login failed.

Login failed for user 'IIS APPPOOL.NET v4.5'.
[SqlException (0x80131904): Cannot open database "TicketDesk" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL.NET v4.5'.]

I am definitely not a webserver admin and do not know ASP from a bar of soap. However I can generally follow instructions.

What am I doing wrong?
Coordinator
Jan 26, 2015 at 9:20 PM
You need to create a login for the app pool identity in SQL server.

http://serverfault.com/a/186926