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

[HOUSEMENU] token not working by whred5
HiI have been playing around with the Lazy_Days skin in an effort to learn css based skinning, I hav...
RE: Building a website with DNN by freedom22
Lee or Joe, I meant that the skin.css file I downloaded has classes like .main_dnnmenu_item td w...
RE: Building a website with DNN by freedom22
Lee, thanks for your reply. I did find the files. I am going through your tutorail, and in video7...
RE: page publish date by leesykes
I would suggest you view these tutorials:User Accounts new features User Accounts and User Settings ...
RE: page publish date by jncraig
I'm not quite sure that I understand you, but ... on the user accounts page there are these options:...
RE: Best so far for me by jncraig
I like the Snapsis CSS Nav Menu. You'll find it at Snapsis.com.
RE: How to limit access to the admin menu.... by leesykes
Hello,Simply reverse the process, you can copy the settings from one of the other admin menu items t...
RE: How to limit access to the admin menu.... by tallorder
Shame about the parent page drop down being grey out since any Site Administrator is going to want t...
RE: Host and Admin user login not working on remote host by paulrobinson
A couple of quick questions: 1. Can I format the login page to the same as my other Text/HTML mo...
RE: Host and Admin user login not working on remote host by leesykes
Hello,Great, glad to help, have you had a look here for some SEO articles and interviews
RE: A question about permission? by leesykes
ok great, glad to help,
RE: A question about permission? by derpir
Your e-mail helped thanks I now have all my permissions set as they should. thanks
RE: Host and Admin user login not working on remote host by paulrobinson
Lee, Thanks for your help on this - there was actually a character dropped off the end of the machi...
RE: A question about permission? by derpir
one question... After getting the permissions... Shouldn´t I be able to do all my development at...
RE: Solpartmenu and line breacks by leesykes
Hello,If you have a look in the CSS Reference Book p108Word-wrapThis is an Internet Explorer 5.5 or ...
RE: A question about permission? by derpir
Thank you Lee! I sent your reply suggestion and I hope they will understand better what I wanted fr...
RE: A question about permission? by leesykes
hello,In order for DNN to operate correctly it needs full read and write permissions for the Network...
RE: Host and Admin user login not working on remote host by leesykes
you will be able to register as a new user if the machine keys are incorrect, but can you login as a...
RE: centering a page in dnn by leesykes
Yes I have not come across a solution to that either and I think it occurs in all browsers.Thanks,
RE: redirecting registered user to a specific page by leesykes
if you are experimenting with users, I would suggest you look at these tutorials:User Accounts new f...
DotNetNuke Modules
RSS Feeds