You need to Register for free and Login to post a message in the forum.

Forum

Forums > DotNetNuke® > DotNetNuke® Questions
Subject: error in SQL Server authentication login password
Prev Next
You are not authorized to post a reply.

Author Messages
msr
Nuke Newbie
Nuke Newbie
Posts:1
20 May 2008 3:00 PM  
Hi,

I'm in the process to transfer a dnn site from localhost to live.
I've followed instructions from videos in "transferring localhost to live site" tutorial...

In my local SQL Server 2005 installation => SQL Server Management EXPRESS => when I have to create a new security login name => I select "SQL Server Authentication" and I write and rewrite password (imagine 10 char) + click OK with no error and new login is created ...

BUT: when I click again in the new created login to see it again it allways appears an unknown password with 15 char that I don't know when it comes from ... I've never been able to change this "default 15 char password" ...

Obviously when I update "web.config" file with new connection string I don't know what password to include ... And when I try to start up the dnn site I obtain the following error message:

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: Error de inicio de sesión del usuario 'dnn_test2'. =>> is my login database user

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: 

<PRE>[SqlException (0x80131904): Error de inicio de sesión del usuario 'dnn_test2'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +435
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +204
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
   DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.GetLogTypeConfigInfo() +68
   DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfo() +108
   DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfoByKey(String LogTypeKey, String LogTypePortalID) +62
   DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.AddLog(LogInfo objLogInfo) +72
   DotNetNuke.Services.Log.EventLog.LogController.AddLog(LogInfo objLogInfo) +188
</PRE>
jncraig
Nuke Master II
Nuke Master II
Posts:2030
20 May 2008 8:48 PM  
Are you sure that the password isn't just being shown as a string of asterisks: ***********?

This is a standard security precaution.

You also have to give the new login db ownership privileges.
Joe Craig
DNN Creative Support
Subscribe to the website
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > error in SQL Server authentication login password


ActiveForums 3.7

Latest Forum Posts

Best so far for me by mortymoose
This skin is CSS standard compliant.  I understand though that the solpart menu causes it not to val...
RE: centering a page in dnn by mortymoose
No I don't think there is any way to fix that.  It makes sense though because the scroll bar is actu...
RE: Host and Admin user login not working on remote host by paulrobinson
Yes I can register a user and login as that user. It is just the admin and host users which are not...
RE: New CSS site feedback please! by puuri
Everything, including the Flash elements, seemed to work fine during my viewing. I was trying to fi...
RE: MY FIRST DNN SITE by puuri
I just took a look and made it through just fine. I am very new to DNN and working towards generati...
centering a page in dnn by kawal
I have centered my DNN web pages using {text-align: center;} in the Body element.  This works fine, ...
RE: redirecting registered user to a specific page by puuri
I think I found the area that Joe describes by logging in as the Admin user and then from the Admin ...
RE: File Manager Upload (intermittent error) by dnnmq
Per Lee's suggestion, I removed NETWORK SERVICE from the website root then re-added it with Full Con...
RE: Solpartmenu and line breacks by saintX
Hello Lee and thanks for the answer. Obviously the page name can't exceed to more than 50 charcters....
RE: redirecting registered user to a specific page by saintX
Hello and thank you for the answer. May you please kindly explain me more specific where to find the...
RE: App_GlobalResources Runtime Error/Issue With Pre-Compiled Version of 4.08.04 Source Code by jncraig
I think that you'd probably be better served asking question like those over on the DotNetNuke forum...
RE: App_GlobalResources Runtime Error/Issue With Pre-Compiled Version of 4.08.04 Source Code by fletcherdunton
Hi Joe:That makes perfect sense, but I failed to mention that some of the code that I'd added is not...
RE: App_GlobalResources Runtime Error/Issue With Pre-Compiled Version of 4.08.04 Source Code by jncraig
I wouldn't recommend either of those approaches.You don't have to use the source code version of Dot...
App_GlobalResources Runtime Error/Issue With Pre-Compiled Version of 4.08.04 Source Code by fletcherdunton
This thread may be answered somewhere else, so forgive me and point me to the solution.  I'm current...
RE: Database error by derpir
Yeees!!! thank so much Lee!!! I will continue this by looking at video nr 3 on how to transfer fro...
RE: Database error by leesykes
go to programs / microsoft sql server 2005 / configuration tools / SQL server configuration manager....
RE: Database error by derpir
nailed it!!! but how do I restart with the configuration tool? regards //newbie
RE: Database error by derpir
You put me on the right track there. Turns out that I had server authentication set to 'Windows Au...
RE: Issue 22 - Login failed for user xxxx by leesykes
I just checked and it does have it: Right click on the SQL server node - this is the node with th...
RE: Database error by leesykes
I just checked and it does have it:Right click on the SQL server node - this is the node with the gr...
DotNetNuke Modules
RSS Feeds