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

Forum

Subject: Database error
Prev Next
You are not authorized to post a reply.

Author Messages
derpir
DNN Creative Magazine Subscriber
Nuke Active Member
Nuke Active Member
Posts:37


05 Sep 2008 10:52 AM  
Hello

I am trying to transfer my website from localhost to my live site. After attaching the DB and changing the web config I got an error when I debugged in VS, I got this...

Login failed for user 'felpal. The user is not associated with a trusted SQL Server connection.

whats wrong?
how can I fix it?

please help

best regards
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325

05 Sep 2008 10:57 AM  
have a look here

Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
derpir
DNN Creative Magazine Subscriber
Nuke Active Member
Nuke Active Member
Posts:37


05 Sep 2008 11:28 AM  

Hello

thanks for the tip Lee but I can't find were to change the Authentication mode on my SQL Server express 2005, In the post were craig bescribes how he did, I wonder if its different in the SQL Server express 2005?

I just can't find where to change it...sorry

regards

leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325

05 Sep 2008 11:33 AM  
I just checked and it does have it:

Right click on the SQL server node - this is the node with the green arrow on it
Properties
Security

Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
derpir
DNN Creative Magazine Subscriber
Nuke Active Member
Nuke Active Member
Posts:37


05 Sep 2008 11:40 AM  
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


When craig says change to SQL Server and Windows Authentication mode
the trouble is that I can't find were to change this even though Craig desbribes it very well,

The only thing is that I can only find windows authentication mode but not the 'SQL Server and Windows Authentication mode' as Craig refers to. they are seperated not together, I can only chose one of them not them together?

Thats why I am asking if there could be a difference between 2005 and 2008 visually?

best regards
derpir
DNN Creative Magazine Subscriber
Nuke Active Member
Nuke Active Member
Posts:37


05 Sep 2008 11:46 AM  
nailed it!!!

but how do I restart with the configuration tool?

regards

//newbie
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325

05 Sep 2008 11:50 AM  
go to programs / microsoft sql server 2005 / configuration tools / SQL server configuration manager.

Click on SQL Server 2005 Services

Right click on SQL Server (SQL Express) (with the green arrow)
Select Restart


Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
derpir
DNN Creative Magazine Subscriber
Nuke Active Member
Nuke Active Member
Posts:37


05 Sep 2008 12:00 PM  

Yeees!!!

thank so much Lee!!!

I will continue this by looking at video nr 3 on how to transfer from localhost to live site.

thank you!

You are not authorized to post a reply.



ActiveForums 3.7

Latest Forum Posts

DNN Intranet Localhost by amine97
Hi, I would like to start an Intranet for my division (65 users) but only 10 users will have the ed...
RE: Menu's, menu's, and more menu's! by roadshow41
Well, I've purchased the Snapsis CSSMenu.  Installing it is turning out to be more complicated than ...
RE: Reversing Limited Access to the Admin Menu by wynnjon
OK-So I've updated the TABS table entries in the database and set the previously modified entries (t...
RE: localhost Install issues by leesykes
If you go to the subscribe page and click on the get free trial button - this takes you to a page wh...
localhost Install issues by cdees
I've set up a local host and want to run DNN for a local development machine.  The host is set up; h...
RE: Reversing Limited Access to the Admin Menu by wynnjon
That is what I thought.  So for my clients that will need to manage user accounts, I can not limit t...
RE: Reversing Limited Access to the Admin Menu by leesykes
I seem to recall it doesn't work
RE: Reversing Limited Access to the Admin Menu by wynnjon
Thanks Lee-  I will give that a try.An additional question- If you place the "User Accounts" page un...
RE: Reversing Limited Access to the Admin Menu by leesykes
all you need to do is reverse the process within the SQL tables.Compare the data to the other rows i...
RE: Module not working when logged off. by leesykes
thanks for the info,
Reversing Limited Access to the Admin Menu by wynnjon
Hi!  I followed the tutorial for limiting the access to the admin menu.  What a great thing!However,...
RE: Trouble installing! Designer trying to be a Developer. by leesykes
glad to hear you found a solution, thanks,
RE: Skim Question by leesykes
You could but you will not be able to have an XHTML compliant page as the SolpartMenu is non-complia...
RE: Include in Menu - Weird Request by leesykes
For your sitemap.xml file - use GSiteCrawlerYou could create the site map before moving the sub menu...
RE: Trouble installing! Designer trying to be a Developer. by awright14
It looks like I had ASP installed in the wrong order.  Copying and pasting this into the Run Command...
RE: Need Help Changing Containers Contentpane's Text Color by leesykes
Hello,Have you tried adding a class to the content area of your container and then styling the p, a,...
RE: Vertical SolpartMenu by leesykes
hello,If you wish to display the admin and host menus within the house menu, you need to enable it i...
RE: Firefox Does Not Display WMV File In Media Module by leesykes
Hello,I have just tested this and I can play a wmv file in Firefox 3.0.3, so it does suggest that it...
RE: advice wanted convert site to DNN while keeping existing asp functionality by leesykes
You could try using the IFrame module in DotNetNuke and then just link the IFrame to the current pag...
RE: Need Help Changing Containers Contentpane's Text Color by CROKeefe
Thanks for the quick update... I know it looks broken right now, but I had the TITLE classes working...
AppTheory
RSS Feeds