Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

DotNetNuke Marketplace
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

FCKeditor Project
Salaro -- Skins and more
OnyakTech
The best choice for your web site host, email hosting, and domain registration.
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Install It!  connectionString for SqlDataProvider error
Previous Previous
 
Next Next
New Post 2/2/2006 8:30 PM
User is offline Eddie Eagle
3 posts
10th Ranked


Re: connectionString for SqlDataProvider error 
I also have this problem, Am running sql server 2000 sp3 on sbs 2003 premium. I have tried everything you wrote here, but am still getting the same error. Hmm, giving it up soon
 
New Post 2/3/2006 3:16 AM
User is offline Evgeny Shapiro
30 posts
10th Ranked


Re: connectionString for SqlDataProvider error 
This post is actualy dedicated to connection strings and the whole using of SQL Server... But still... There are several cases in such situation: First. Your SQL Server is configured for windows authentication string only (my local choice). This means that the authentication is provided by Windows user system. An example of connection string for such situation: Server=(local);Database=<Database name>;Integrated Security=SSPI;  Be sure to add the ASPNET user in two places in Enterprise Manager: 1. in the Security node of the local SQL Server\Logins. 2. in the Databases\<Database name>\Users. Be sure that ASPNET user have the dbowner permission. The second choice is for SQL Server authentication. In this case you should specify the User ID and Password in the connection string an example:
Server=(local); Database=<Database name>;User ID=<User name>; Password=<User password>;
This string shoud appear in the web.config file in two places. The connectionStrings and appSettings. Be sure that no other connectionString specified.

  DkAmirit
Best regards, Evgeny
 
 Page 3 of 3Previous123 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Install It!  connectionString for SqlDataProvider error
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


SINA101
WANT A SPECial sIte iN TAIWAN?
sina101.com 		Web Development and Strategy Firm
The Risdall Interactive Agency s websites, strategies, branding, & promotion in digital space.
www.Risdall.net/ 		Windsor Management Group
Fund Accounting Software for K12 Education.
Infinitevisions.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP