Forums (Obsolete)

Member

kingni78-hotmail - 9/28/2009 3:34:50 AM

Cannot open database "KenticoCMS"

I tryed to deploy the site on IIS server but the below erorr message has came
(
Cannot open database "KenticoCMS" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
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: Cannot open database "KenticoCMS" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Cannot open database "KenticoCMS" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +428
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
CMS.DataProviderSQL.DataConnection.Open() +113
CMS.DataProviderSQL.DataConnection.PrepareCommand(String queryText, Object[,] queryParams, QueryTypeEnum queryType, Boolean allowTransaction, Boolean& closeConnection, Boolean& commitTransaction) +511
CMS.DataProviderSQL.DataConnection.ExecuteReader(String queryText, Object[,] queryParams, QueryTypeEnum queryType, CommandBehavior commandBehavior) +70
)
would u please tell me what to do to resolve the problem .. by the way i have a free license for the IIS domin ..


Kentico Developer	kentico_helenag - 9/28/2009 6:06:42 AM RE:Cannot open database "KenticoCMS" Hello, Could you please check the connection string in your web.config? It seems the credentials are not correct. Please see also this article about troubleshooting SQL Server connection problems: http://devnet.kentico.com/docs/devguide/sql_server_connection_problems.htm Best regards, Helena Grulichova


Member	kingni78-hotmail - 9/30/2009 1:37:31 AM RE:Cannot open database "KenticoCMS" Thanx for help Helena ...


Member	Ayman - 9/30/2009 2:20:17 AM RE:Cannot open database "KenticoCMS" But how could Could i change the credentials of the web.config ?


Kentico Developer	kentico_helenag - 9/30/2009 3:41:46 PM RE:Cannot open database "KenticoCMS" Hello, you may change it in the string like this one: <add name="CMSConnectionString" connectionString="Persist Security Info=False;database=xxx;server=yyy;user id=aaa;password=zzz;Current Language=English;Connection Timeout=240;" /> Best regards, Helena Grulichova

Member

Ayman - 10/3/2009 2:19:59 AM

RE:Cannot open database "KenticoCMS"

Hey Helena

I check out the string in web.config and i found it right as u wrote above ..
bye the way i can't even open the desck manager ..

I read the toutrial and i descove that in the free virson of kentico i must keep " powred by keticon and kentico logo in the site " but i delete it .. is this is could be the reson of the problem .. if it's the reason how could i open the desk manager to but pwoerd by kentico again ...??

Kentico Support

kentico_radekm - 10/5/2009 9:02:14 AM

RE:Cannot open database "KenticoCMS"

Hello.

What error message are you receiving during an attempt to open Site Manager? The same as in your first post or a different one? As for Kentico CMS deployment, have you followed appropriate instructions in http://devnet.kentico.com/docs/devguide/index.html -> Installation and deployment?
As for Powered by Kentico, according to license agreement, you are expected to use this web part (Powered by Kentico) on your site, but this is not the reason of your problem, it is just a web part. If the error message is different than above, and you followed installation and deployment instructions, could you please provide me with screenshot of this error message? Thank you.

Best Regards,
Radek Macalik


Member	biancas-packtpub - 8/18/2010 4:45:22 AM RE:Cannot open database "KenticoCMS" Im getting the same error. This is my connection string. Do i need to change it? <add name="CMSConnectionString" connectionString="Persist Security Info=False;Integrated Security=SSPI;database=KenticoCMS;server=TEST68-PC\SQLEXPRESS;Current Language=English;Connection Timeout=240;" />

Member

kentico_michal - 8/19/2010 6:06:55 AM

RE:Cannot open database "KenticoCMS"

Hi,

Could you please check whether your current Windows account credentials are valid for SQL server account, since you are using integrated security?

More information about SQL server connection problems can be found at
http://devnet.kentico.com/docs/devguide/index.html?sql_server_connection_problems.htm

Best regards,
Michal Legen