Welcome Guest Search | Active Topics | Log In | Register

Help with the DB settings. Options · View
Guillermo
#1 Posted : Wednesday, June 18, 2008 12:54:27 PM

Rank: YAF Forumling


Joined: 6/18/2008
Posts: 5
Location: Madrid
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:

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


Code:
<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.mdfQuestion Do I have to put a reference to the Database.mdf DBQuestion

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
#2 Posted : Thursday, June 19, 2008 4:00:39 PM

Rank: YAF Forumling


Joined: 6/18/2008
Posts: 5
Location: Madrid
Hi!

I have solved one problem Very Happy, but I get another one Sad

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 Smile

I have pu this:

Code:
<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.... Sad Know I get the next error: "Ful-Text search is not installed, or a full-text component cannot be loaded". Any ideaQuestion
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.3 RC2 | YAF © 2003-2008, Yet Another Forum.NET
This page was generated in 0.064 seconds.

SourceForge.net Logo Powered by ASP.NET v2.0 411ASP.NET