picoallen
DNN Creative Magazine Subscriber
Nuke Newbie
Posts:4
 |
| 28 Aug 2008 9:00 AM |
|
Hello,
I'm following the 'How to transfer a localhost DNN installation to a live website' tutirial in issue 22, but have hit a brick wall.
Once I've created the new user, assigned it to my DNN database and ammended the web.config file, I get the 'Login failed for user' error that is pasted below.
The installation works corectly before doing this. I've redone it several times over and have repeated it on a second computer - always with the same result.
I've pasted the connection string bits from the web.config file below the error code.
I'm using MSSQL Express 2008 rather than 2005. Perhaps the connection string needs to be different.
Does anyone have any thoughts?
Thanks
Craig Allen
Login failed for user 'craigallen'.
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: Login failed for user 'craigallen'.
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): Login failed for user 'craigallen'.]
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
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +233
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +343
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +175
Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +45
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +207
DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.GetLogTypeConfigInfo() +71
DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfo() +101
DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLogTypeConfigInfoByKey(String LogTypeKey, String LogTypePortalID) +66
DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.AddLog(LogInfo objLogInfo) +75
DotNetNuke.Services.Log.EventLog.LogController.AddLog(LogInfo objLogInfo) +193
|
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
---------------
Connection string bits from the web.config file ...
|
|
|
|
|
jncraig
DNN Creative Staff
Nuke Master II
Posts:2318
|
| 28 Aug 2008 9:06 AM |
|
Use SQL Server Management Studio or the express version to see which username and password will connect to the database. You may need to add new logins at the server level.
Also, I don't know for a fact that DotNetNuke will run with SQL Server 2008. You may need to check that, too. |
|
Joe Craig
DNN Creative Support
Subscribe to the website |
|
|
picoallen
DNN Creative Magazine Subscriber
Nuke Newbie
Posts:4
|
| 28 Aug 2008 10:51 PM |
|
Thanks Joe,
You put me on the right track there. Turns out that I had server authentication set to
'Windows Authentication' mode rather than the required
'SQL Server and Windows Authentication mode.
For anyone else with this problem, you can change the authentication mode by right-clicking your server node in the SQL Management Studio, then going to the security tab.
Then you need to restart the server using the SQL Server Configuration Tool.
Cheers
Craig Allen |
|
|
|
|
CharlesLegg
DNN Creative Magazine Subscriber
Nuke Newbie
Posts:1
|
| 05 Sep 2008 10:54 AM |
|
Thanks picoallen for the tip. The same error was driving me nuts; such a simple solution.
Thanks again. |
|
|
|
|
derpir
DNN Creative Magazine Subscriber
Nuke Active Member
Posts:37
|
| 05 Sep 2008 11:21 AM |
|
Thanks Joe,
You put me on the right track there. Turns out that I had server authentication set to
'Windows Authentication' mode rather than the required
'SQL Server and Windows Authentication mode.
For anyone else with this problem, you can change the authentication mode by right-clicking your server node in the SQL Management Studio, then going to the security tab.
Then you need to restart the server using the SQL Server Configuration Tool.
Cheers
Craig Allen
OK I am using SQL server Express 2005 and I can't really find were to change the authentication mode as Craig describes above.
I have also followed Lees videos and are stuck with this, have anyone give me a helping hand, anyone?
best regards |
|
|
|
|
leesykes
DNN Creative Staff
Nuke Master III
Posts:3325
|
|
beterthanlife
Nuke Newbie
Posts:1
|
| 10 Sep 2008 11:28 AM |
|
Hi all,
really useful post, however I have checked my sqlserver authentication and it is already set to "SQL server and windows authentication mode", yet i still get "
Login failed for user 'xxxx' ".
I know my uid and password are correct, yet I cant connect to the database! PLZZZZZZ HELP!
my web.config connection string is:
Data Source=DB1;Initial Catalog=StudNet;User ID=xxx;Password=xxx
|
|
|
|
|
jncraig
DNN Creative Staff
Nuke Master II
Posts:2318
|
| 11 Sep 2008 9:43 PM |
|
Can you connect to your database using SQL Server Management Studio (or Express version)?
What server address is in your connection string?
Are you using SQL Server or SQL Server Express? |
|
Joe Craig
DNN Creative Support
Subscribe to the website |
|
|