Help with the DB settings. · YAF.NET Support Forum

Guillermo
53% (Neutral)
YAF Forumling Topic Starter

14 years ago

Hello!

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!

Sponsor

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Guillermo
53% (Neutral)
YAF Forumling Topic Starter

14 years ago

Hi!

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:

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

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:?:

Important Information:

The YAF.NET Support Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close