I have a problem configuring the Web.config and dnnyafnet.config for the DotNetNuke
I'm not sure what I should put in the DB string.
I have DNN 4.x with a Microsoft SQL Server 2000.
In the web.conf I have the next string connection for the DNN and it works:
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
So, with this string. What should I put in the dnnyafnet.config file? This is what I have:
<connstr>data source=.\SQLExpress;timeout=90;integrated security=SSPI</connstr>
I tried putting 'initial catalog
' attribute but I get an error because the table does not exist. Do I have to create a table in Database.mdf:?: Do I have to put a reference to the Database.mdf DB:?:
I read in this forum that as far as I don't have user name and password because I'm using authentication with Windows, I should put 'integrated security=SSPI
Thanks in advance!