Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

sqlserver issues
minhsangd
#1 Posted : Thursday, March 31, 2011 7:20:41 AM(UTC)
Rank: Advanced Member
Groups: Registered

Joined: 3/16/2011(UTC)
Posts: 67
Location: vietnam
i downloaded Content_DBProviders
i copied .dll in sqlserver on Content_DBProviders to root bin Folder
i copied SqlServer.config to root same location with web.config
i created a database named Kooboo_CMS

when Run Cms from visual i got error:

Invalid object name 'SampleSite.Article'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'SampleSite.Article'.
NashRus
#2 Posted : Thursday, March 31, 2011 9:39:32 PM(UTC)
Rank: Newbie
Groups: Registered

Joined: 3/24/2011(UTC)
Posts: 3
Location: Moscow
Copy Content_DBProviders to root bin Folder
And only than First Run CMS and begin work with CMS
zguoqi
#3 Posted : Friday, April 01, 2011 1:41:20 AM(UTC)
Rank: Administration
Groups: Registered, Administrators

Joined: 9/2/2009(UTC)
Posts: 695
Location: xiamen
When you switch to a new content provider, existing sites which you created with previous content providers can not be converted automatically. You may create a new site to verify whether everything works correctly or not.

It is recommended to only switch on a fresh CMS.
Regards,

Vincent

Kooboo Team
minhsangd
#4 Posted : Friday, April 01, 2011 3:42:19 AM(UTC)
Rank: Advanced Member
Groups: Registered

Joined: 3/16/2011(UTC)
Posts: 67
Location: vietnam
not working..
zguoqi
#5 Posted : Friday, April 01, 2011 4:06:59 AM(UTC)
Rank: Administration
Groups: Registered, Administrators

Joined: 9/2/2009(UTC)
Posts: 695
Location: xiamen
Let me try it and come back to you!
Regards,

Vincent

Kooboo Team
minhsangd
#6 Posted : Friday, April 01, 2011 4:34:03 AM(UTC)
Rank: Advanced Member
Groups: Registered

Joined: 3/16/2011(UTC)
Posts: 67
Location: vietnam
im using a fresh CMS and config like above....
i looking into database, there are no tables....
maybe i config wrong :-? CMS maybe cannot regconize connectionstring :-?
if true, how to config?
tienvu
#7 Posted : Friday, April 01, 2011 6:01:26 AM(UTC)
Rank: Advanced Member
Groups: Registered

Joined: 2/3/2011(UTC)
Posts: 52
Location: HCM
Hi minhsangd,

I have got the problem same to you, error message:

"Server Error in '/KooBooCMS3' Application.
Cannot open database "Kooboo_CMS_V3" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET v4.0'. "

I have changed Login User to "Database=Kooboo_CMS_V3;User ID=sa;Password=xxxxxx;" in SqlServer.config, but It didn't work.

Wait for zguoqi's information.
jifeng
#8 Posted : Friday, April 01, 2011 7:17:09 AM(UTC)
Rank: Administration
Groups: Administrators, Registered

Joined: 9/3/2009(UTC)
Posts: 1,555
Location: Xiamen China
HI,

After you change the SQLServer.config, you have to restart the application manually.
Regards,

Jifeng Huang

Kooboo Team

Microsoft ASP.NET MVP
zguoqi
#9 Posted : Saturday, April 02, 2011 7:09:16 AM(UTC)
Rank: Administration
Groups: Registered, Administrators

Joined: 9/2/2009(UTC)
Posts: 695
Location: xiamen
This is I have found out. Indeed, it seems like some buggy. We have corrected it now.

1. download both kooboo_cms.zip and the content_provider.zip

2. setup Kooboo website and copy the SQL content provider into Kooboo CMS bin folder.

3. run the CMS and try to create a new site, get the error of authorization failed.

4. Open the Kooboo disk folder, find the sqlserver.config, create a new blank SQL database and correct the connection string there.

5. Go back to Kooboo CMS, delete the previously created website and recreate a new website.

Everything works fine after all these troubles.

Agreed that is not a nice solution, we have changed this part now. Will be updated soon.
Regards,

Vincent

Kooboo Team
minhsangd
#10 Posted : Monday, April 04, 2011 4:07:29 AM(UTC)
Rank: Advanced Member
Groups: Registered

Joined: 3/16/2011(UTC)
Posts: 67
Location: vietnam
thanks :)
minhsangd
#11 Posted : Monday, April 04, 2011 4:22:28 AM(UTC)
Rank: Advanced Member
Groups: Registered

Joined: 3/16/2011(UTC)
Posts: 67
Location: vietnam
my sqlserver.config
Code:

<SqlServerSettings xmlns="http://schemas.datacontract.org/2004/07/Kooboo.CMS.Content.Persistence.SqlServer" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Connections><ConnectionSetting><ConnectionString>Server=.\SQLExpress;Database=ks_kooboo; Trusted_Connection=Yes;</ConnectionString><Name>Sample</Name></ConnectionSetting></Connections><CreateDatabaseSetting>Server=.\SQLExpress;Database=ks_kooboo; Trusted_Connection=Yes;</CreateDatabaseSetting><SharingDatabase>true</SharingDatabase><SharingDatabaseConnectionString>Server=.\SQLExpress;Database=ks_kooboo; Trusted_Connection=Yes;</SharingDatabaseConnectionString></SqlServerSettings>


but when i run, CMS use Kooboo_cms database,
:-/
freh
#12 Posted : Monday, December 26, 2011 11:36:24 PM(UTC)
Rank: Newbie
Groups: Registered

Joined: 11/24/2011(UTC)
Posts: 1
Location: Germany
Hi Vincent,

There is a little problem in SqlServerHelper class, if no .SQLExpress is installed on the local machine.
In this case the method TestConnection will run into a timeout.
So please change this method to:

using (var conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
return conn.State == ConnectionState.Open;
}
catch (Exception)
{

return conn.State == ConnectionState.Closed;
}

}

with this I was able to change connectionstrings in SQLServer.config after first call of Kooboo CMS.
Now all went fine, and the schema for a new site was created on remote SQL Server.

Regards

Franz
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.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.184 seconds.