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

RE: Server Application Unavailable from localhost by picoallen
OK, I've got things working better now. Not sure why though as I lost track while following all the ...
e-Survey? by mgordon
I need a module that will do the following:When a person comes to a specific page (recreation guide ...
Media Module *not* autostart? by PaulFlynn
Hi,I want to display a number of different .wmv files on a single page, but I'm concerned that the d...
RE: Event Module Scheduler? by mgordon
Never mind. I found out that you need to enable the Event Reminder in the actual Event that you are...
Event Module Scheduler? by mgordon
I have setup a Calendar of Events module on my page and have added events, no problem.  The main pro...
RE: Upgrading from 3.3.7 to 4.8.4 by puuri
I think I saw the answer to your last question on another thread real recently. If you go to the 'L...
Server Application Unavailable from localhost by picoallen
Hello,I have installed DotNetNuke and can open it from within Visual Web Designer, in which case it ...
RE: Upgrading from 3.3.7 to 4.8.4 by joannew
Hi, yes everything seems to be working fine. I get the following when viewing through Host Settings/...
RE: Database Access Error ! by nukedoubt
Got a fix........ 1)  Make sure that both the sqlDataProvider class and the DataProvider class are...
Database Access Error ! by nukedoubt
Error in Database Access : "The type initializer for 'MyCompany.Modules.Search.DataProvider' threw...
RE: Upgrading from 3.3.7 to 4.8.4 by jncraig
If everything "seems" to working normally, perhaps you can ignore it. It is possible that the other...
Upgrading from 3.3.7 to 4.8.4 by joannew
Hi,I've followed the upgrade procedures to upgrade from 3.3.7 to 4.8.4 and received the status repor...
RE: Regular restores to local machine by joannew
Thanks for getting back to me, just to let you know everything is working fine now, I can login as a...
RE: Create Bookmarks/Anchor Points/Page TOC by lb313
Thank you for your help Joe. Kind Regards Lisha Belbin
RE: Issue 22 - Login failed for user xxxx by picoallen
Thanks Joe, You put me on the right track there. Turns out that I had server authentication set t...
RE: How to speed DNN by mmcinulty
jump over to www.snapsis.com and get pageblaster. forum has alot of info about yslow and how to spee...
RE: Regular restores to local machine by jncraig
I've got more questions than answers ... Can you login as administrator and/or host? Can a logge...
RE: Refreshing Bl... IE by ollep
Thanks Guys!! Excelent support. I will - beleive it or not - be away from the computer for three...
Parent Portals and SSL by LucianV
Hi,I need to install and configure on our server several DNN parent portals (different domain names)...
RE: File Manager Upload (intermittent error) by dnnmq
Lee, your attention to this issue is truly appreciated because it's driving me nuts.js is included i...
AppTheory
RSS Feeds