Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Problem to associate a database with a website View modes: 
User avatar
Member
Member
al.lx-orange - 3/6/2012 5:37:08 AM
   
Problem to associate a database with a website
Hello

I just installed kentico on a virtual machine (vmWare). The installation went well and I must now continue with the database setup wizard. and the problem is this: I can't login. I'll try to describe my actions as clearly as possible:
1 / on the step1 screen, when I selected mode "Use Sql Server Account", the connection is not authenticated ('login failed)
-note: I am that this account exists in sql Manager Studio-

If I choose the second option ("use integrated windows authentication") I can access step 2 but the account specified ("net asp NT Authority NetWork SERVICE" does not exist in sql server!)
What is this account ?

2 / on the Step2 screen ("database instance") if I selected one base Kentico existing, I have the following message: the database doesn't exist. And if I selected "new database" I have this error message:
"An error occurred when creating database: [DataConnection.ExecuteQuery]: Query: CREATE DATABASE [KenticoCMSTEST] COLLATE SQL_Latin1_General_CP1_CI_AS: caused exception: CREATE DATABASE permission denied in database 'master'."

I assigned all the rights of creation, modification, dbcreator, sysadmin etc...to the local account.


Do you have an idea of the problem please?
Thank you very much for your help

User avatar
Kentico Developer
Kentico Developer
kentico_ivanat - 3/6/2012 6:21:03 AM
   
RE:Problem to associate a database with a website
Hi,

could you please take a look at the following part of database installation. It describes a difference between types of authentication and permissions which are needed for particular users. It should help you.

Best regards,
Ivana Tomanickova

User avatar
Member
Member
al.lx - 3/6/2012 9:02:44 AM
   
RE:Problem to associate a database with a website
Hello Ivana


In fact I had already read this link but probably not well enough because the reading I realized my error: I did not re create the NT AUTHORITY NETWORK SERVICE account in sql server! Now it's ok! So many thanks to you;-)
However, I have another question:
I have destroyed by error the IIS default web site. Must I repeated the entire installation of Kentico or is there another solution for that ? Because now, address http: / / localhost/CMSdesk peak in a vacuum!
Thank you very much
Alain

User avatar
Member
Member
al.lx - 3/7/2012 2:17:25 AM
   
RE:Problem to associate a database with a website
it's ok for my last question .. problem set !
thank's very much
good day to all ;-)

User avatar
Member
Member
tapojitroy77-gmail - 1/1/2013 10:25:47 AM
   
RE:Problem to associate a database with a website
thanks al.lx. save a lot of time of mine.