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

Forum

Subject: user is not associated with a trusted SQL Server connection
Prev Next
You are not authorized to post a reply.

Author Messages
obautista
DNN Creative Magazine Subscriber

Posts:10

16 Aug 2008 12:19 AM  
I am trying to install Starter package on a Vista PC.  I have SQL Server 2005 installed on Server 3003.  When I attempt to run I am getting this message:

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

I have ensured SQL Server is on SQL Server and Windows Authentication Mode.  Below is my connection string.  I do not know how to connect to my SQL Server. 

Can anyone please help.  I created both Windows account on my Server 2003 box and a SQL Server account - neither work.  Which one should I be using?  I connect to SQL Server using Windows Authentication mode.

<add name="SiteSqlServer" connectionString="Server=BAUTISTASERVER\BAUTISTA_SQL_DEV;Database=dnn;Integrated Security=True;trusted_connection=true;User ID=dnnuser;Password=*;" providerName="System.Data.SqlClient" />

jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2371


16 Aug 2008 6:38 PM  
This is an issue with the database connection. Try connecting but not as a trusted user. Of, configure your SQL Server so that the user specified in your connection string is a trusted user.

Joe Craig
DNN Creative Support
Subscribe to the website
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > user is not associated with a trusted SQL Server connection



ActiveForums 3.7

Latest Forum Posts

Restricting DateEditControl till date by coder247
Hi All,   We are using the DateEditControl (for obvious reasons!!) in our application. But we want t...
RE: Email Set UP per Portal by jncraig
I think that the answer depends on how email is configured at your host. You'll probably have to co...
RE: skin/container error load by jncraig
I would suggest checking permissions for directories. Does this occur only when you upload a skin...
RE: Add New Profile Properties by jncraig
Hmmm ... I don't have an answer. Does anyone else?
RE: No Access for me too by ristori
it is ok now. Thanks for this action.
skin/container error load by islandman
Has anyone else run across this error when loading skins or containers from site settings?I am using...
Email Set UP per Portal by islandman
How do I set up a unique email address per domain name off 1 hosting environment. for example...m...
RE: localhost Install issues by cdees
Lee: I wanted to follow up on this for anyone following this thread. I have been unable to solve t...
RE: Add New Profile Properties by WSI
HI Joe, The DNN version is 4.5.5. Thanks, Cliff
Change Skin on URL by vinita
Hi,Can the skin be changed based on the url used to access a portal. Multiple portal aliases may be ...
problem creating child portal by kabamaro
  Hello all i have 4 Aliases for my parent portal , lets call them X,y,Z,WIn all Aliases i can creat...
problem creating child portal by kabamaro
  Hello all i have 4 Aliases for my parent portal , lets call them X,y,Z,WIn all Aliases i can creat...
Best DNN portal ever! by derpir
I have been a subscriber since august 2008, and DNNCreative.com is simply the best DNN Portal, their...
RE: skinning trouble by derpir
Hello Yes could you be so kind and take a look att the htm-file and css-file.I would be very gratef...
Search function is not working by kishorpawar
I am using Seach module in my project but not working, i have set   host setting alsoHost --> Schedu...
RE: backend is changing from sql2005 to sql2008 by leesykes
hello,There should not be any code changes needed, but you'll need to make sure that SQL 2008 upgrad...
RE: skinning trouble by leesykes
Hello,I would need to see your code to help you with this one, you can zip up your files and attach ...
RE: Installing DotNetNuke 4.9.00 on VWD 2005 w/ SQL server 2008 by leesykes
I have run a test with SQL Server 2008 express and DotNetNuke installed in exactly the the same way ...
RE: Issue 39 Interview by leesykes
thanks Bill, glad it was useful, we will have a think about the best way to approach this,Thanks,
RE: Issue 39 Authentication by leesykes
yes I have a live site in 4.9.0 at it seems stable as well.
AppTheory
RSS Feeds