Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 


Thursday, November 20, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
NorthWind Sample
Questions and Answers about our "Soup to Nuts" NukeDK sample of the Northwind Database.
Subject: SQL 2005 and Northwind

You are not authorized to post a reply.   
Author Messages
rmarshall
Welterweight
Posts:27

10/13/2006 5:48 PM Alert 
I installed DNN using SQL 2005 Express, but when I open the database manager for SQLExpress the DNN DB isn't in there. So, I imported the Northwind DB to be able to do some of the ListX examples and I am unable to connect to the Northwind DB just by specifying SELECT * FROM Northwind.dbo.Employees.

What do I need to do to connect to the Northwind database imported into SQL Express 2005 installed on the same system as DNN?

Should I just switch to SQL 2000 so all this looks like I am use to?

Thank you,
Richard M.
pauldes
Immortal
Posts:1392

10/16/2006 10:02 AM Alert 
YOu might want to check to make sure the user in your web.config file for DNN has full access to the Northwind db you created.

ListX....makes you look brilliant, even though you're not.
rmarshall
Welterweight
Posts:27

10/16/2006 11:52 AM Alert 
If I were using SQL 2000 that would be an easy answer. The problem I am having is that SQL 2005 Express is different. There is no username specified in the web.config.

Thank you,
Richard M.
rmarshall
Welterweight
Posts:27

10/17/2006 5:10 PM Alert 
I figured it out. I needed to specify a connection string in the Connections field:
Provider=SQLNCLI;Server=.\SQLExpress;Database=Northwind;Trusted_Connection=Yes;

Thank you,
Richard M.
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > NorthWind Sample > SQL 2005 and Northwind



ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation