Monday 6 December 2010

ASP.NET Web Setup – Integrated Authentication

I came across an interesting situation when a client could not run my installer to set up their SQL database. It was set to use Windows Authentication and even though the user was set up as an administrator on the SQL server, they could not connect to the database.

After searching around the forums, it seems the MSI file is using the built in local account, and therefore domain specific details are ignored.

The resolution:

Download ORCA tool from Microsoft. See this post here:

http://www.frickelsoft.net/blog/?p=240

Then, when you have ORCA tool, follow this blog

http://ezhnotes.blogspot.com/2008/09/change-msi-to-run-under-custom-actions.html

The ORCA row I changed the type for was:
_B25C9B12_5826_4B28_AD29_C2A033133B53.install    1025    InstallUtil    ManagedInstall

The database was able to be configured correctly when this amendment was made to the MSI file. For now, this is now an extra step in the build process.

No comments:

Post a Comment