• Guillermo
  • 53% (Neutral)
  • YAF Forumling Topic Starter
14 years ago

I have a problem configuring the Web.config and dnnyafnet.config for the DotNetNuke module.

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!


  • Guillermo
  • 53% (Neutral)
  • YAF Forumling Topic Starter
14 years ago

I have solved one problem :-d, but I get another one 😞

I had no idea of what DB I had. But I had download the DbaMgr2k and with that I could check the name of the database, the name of the user, etc :)

I have pu this:

	<connstr>data source=(Local);initial catalog=YAF;user id=DNN;timeout=90;</connstr>
	<!-- Enable URL Rewriting is NOT available with DNN -->

Where initial catalog  is the name of the database that I have created with the DbaMgr2k tool under (Local) and know I don't have problems with the connection.

But.... 😞 Know I get the next error: "Ful-Text search is not installed, or a full-text component cannot be loaded". Any idea:?:
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button