CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:
Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.dotnetnuke.getting_started Tags:
Item Type: NewsGroup Date Entered: 3/18/2006 1:42:37 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 0 Views: 8 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
6 Items, 1 Pages 1 |< << Go >> >|
donkeycat
Asp.Net User
DNN4 + SQL 2005 Connection String3/18/2006 1:42:37 PM

0/0

Does anyone know what the connection string would be for a DNN4 + SQL 2005 running on my laptop?

 

When I connect to the SQL 2005 via Visual Studio, the connection string in the properties pane is:

 

Data Source=wxp-7423x42;Initial Catalog=DNN4Development;Integrated Security=True;Pooling=False

 

I can also connect to the SQL 2005 via SQL Management Studio using the WindowsAuthentication
StrongTypes
Asp.Net User
Re: DNN4 + SQL 2005 Connection String3/18/2006 9:53:32 PM

0/0

You might need to add <identity impersonate="true" /> to Web.config.

HTH,
Ryan

Ryan Olshan
Microsoft MVP, ASP.NET
Blog | Group | Website | Strong Coders Community

How to ask a question
donkeycat
Asp.Net User
Re: DNN4 + SQL 2005 Connection String3/18/2006 10:02:41 PM

0/0

Thank you.  Can you tell me where in teh web.config page I need to insert this identity statement?
StrongTypes
Asp.Net User
Re: DNN4 + SQL 2005 Connection String3/18/2006 10:06:35 PM

0/0

In the system.web node.

<?xml version="1.0"?>
<configuration>
    <system.web>
        <identity impersonate="true"/>
    </system.web>
</configuration>

HTH,
Ryan

Ryan Olshan
Microsoft MVP, ASP.NET
Blog | Group | Website | Strong Coders Community

How to ask a question
donkeycat
Asp.Net User
Re: DNN4 + SQL 2005 Connection String3/19/2006 1:53:21 AM

0/0

Thank you for yoru help Ryan!

 

I recieved the following error:

 

ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process.
StrongTypes
Asp.Net User
Re: DNN4 + SQL 2005 Connection String3/19/2006 3:23:37 AM

0/0

Try something along the lines of what is at ConnectionStrings.com:

"Trusted Connection:

"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
   - or -
"Server=Aron1;Database=pubs;Trusted_Connection=True;"
   (both connection strings produces the same result)

(use serverName\instanceName as Data Source to use an specifik SQLServer instance)"

Let me know if that helps.

Ryan

Ryan Olshan
Microsoft MVP, ASP.NET
Blog | Group | Website | Strong Coders Community

How to ask a question
6 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Professional DotNetNuke 4: Open Source Web Application Framework for ASP.NET 2.0 Authors: Shaun Walker, Joe Brinkman, Bruce Hopkins, Scott McCulloch, Patrick J. Santry, Chris Paterra, Scott Willhite, Dan Caron, Pages: 517, Published: 2006

Web:
Connection String for SQL Express 2005 - DNN 4.x - ASP.NET Forums Connection String for SQL Express 2005 - DNN 4.x. Last post 01-23-2006 5:22 PM by timelord. 3 replies. Sort Posts: ...
DNN4 + SQL 2005 Connection String - ASP.NET Forums Re: DNN4 + SQL 2005 Connection String. 03-18-2006, 5:53 PM. Contact ... Re: DNN4 + SQL 2005 Connection String. 03-18-2006, 6:02 PM. Contact ...
SQL Server 2005 DNN 4 0 Sql error message ExecuteNonQuery(String connectionString, CommandType commandType, String ... DNN 4 0 Sql error message - Sanjeet Koppikar 29-Mar-06 03:48 3:48:47 PM ...
Upgrading DNN 3.x to DNN 4.x > Mitchel's Personal Web Portal ... Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy ..... What is the best possible DNN 4 version, as per you ? ...
Error missing file on install of DNN4 - Install It! - DotNetNuke This is a new install of DNN 4 ... Re: Error missing file on install of DNN4 .... Connection String for SQL Server 2005 Express ...
OLEDB Connection string for SQL Server 2005 EXPRESS? > Forums ... Jun 22, 2006 ... OLEDB Connection string for SQL Server 2005 EXPRESS? ... I am using DNN4.3.1 (. NET2.0) and XMod 4.3 Regards , Richard ...
CodeProject: Running DotNetNuke 4.0.2 on Windows XP Home or on any ... As a quick note from my post about the connection string, I am not sure why my SQL 2005 Express is setup on the machine as SQL2005Express instead of ...
Snowcovered.com : Form Master 2008 for DNN4 by Code 5 Systems, LLC ... The Connection String is stored Encrypted to secure the Password. ... Database, SQL Server 2000 & 2005, & 2008 All Editions. DNN Version, 4.5.2 - 4.9.0 ...
DotNetNuke 4 (for Delphi Developers) DNN 4 is built on top of ASP.NET 2.0. It's written in VB, but the implementation .... Connection String for SQL Server 2000/2005 --> ...
DotNetNuke Form Module | Code 5 Systems, LLC. The Connection String is stored Encrypted to secure the Password. Use the Form Query to Pre-Fill Form ... Database, SQL Server 2000 & 2005, & 2005 Express ...




Search This Site:










default field & default button not working in login/create user

dragging absolutely positioned items with cursor

c# -- auto-generate email with verification link

css friendly control adapters is not running with update panel of atlas

splash page 3.0.10

showing messages on asp.net page

how to debug a query?

membership and roles stored procedures...

why my theme is not applied in the editor?

question about c# and asp:calendar control...

asp.net 2.0 and ssl. return to previous page after login

asynchronous operations are not allowed in this context

portal duplication

post to another location

what modules are in my website

generating content on the fly

custom code on installation. is this possible?

using validator in dynamic drop down box

object reference error

slow load

findcontrol returned blank!

a module that "e-mails" logs

get page generation time

publishing a master page to make to view all the users of contentlibrary sharepoint

namespace

function call from another aspx page.

how do i cancel a postback after the submit button is clicked

complie news article project !

executing system commands from asp.net

encrypting strings
 
All Times Are GMT