View previous topic :: View next topic |
Author |
Message |
Per
Joined: 27 Apr 2012 Posts: 1
|
Posted: Fri Apr 27, 2012 11:52 am Post subject: Authentication Server with SQL database |
|
|
My IIS server is 64 bit, so it seems that using the Access database is a no go.
So far I've created a SQL database and run Install.aspx. The tables have been created, but Install.aspx crashed when trying to write to Web.config (missing write permisssions).
I've tried to setup Web.config manually (guessing at an OleDb provider), but that didn't work out...
What should the Web.config connection string look like?
(Do automatic install in the world of IIS ever work?) |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Fri Apr 27, 2012 12:33 pm Post subject: |
|
|
The best option would be to change your IIS permissions to allow the application to write to the Web.Config file then run the install again (you can remove the write permission after this).
While you can setup the Web.Config file manually to connect to the database you cannot then encrypt the connection strings. This represents a security vulnerability if someone is able to gain read access to the Web.Config file. You can just run the Install.aspx on your local authentication server (deselecting the "Encrypt Connection" option) to see the web.config file. It should be something like:
Code: | <?xml version="1.0"?>
<configuration>
<appSettings>
<add key="CheckCallerIP" value="True" />
<add key="MaxCallsPerIPAddress" value="10" />
<add key="IPAddressResetPeriod" value="60" />
<add key="DatabaseType" value="MSSQL" />
<add key="EncryptConnectionData" value="False" />
<add key="SqlServer" value=".\SQLEXPRESS" />
<add key="SqlDatabase" value="Authentication" />
<add key="SqlIntegratedSecurity" value="False" />
<add key="SqlUser" value="sa" />
</appSettings>
<connectionStrings>
<add name="AuthenticationConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Authentication;Persist Security Info=True;User ID='sa';Password='password'" providerName="System.Data.OleDb" />
</connectionStrings>
<system.web>
<compilation debug="false" />
<authentication mode="Windows" />
</system.web>
</configuration> |
_________________ Infralution Support |
|
Back to top |
|
|
|