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  |  

telerik -- supercharge your DNN websites
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

Click here to go to dev.live.com for Windows Live developer resources
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
 


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.
 


DocuPeak Business Process Management RAD
Comprehensive enterprise and government process management. Forms, documents, indexing, workflow, views, content intelligence, capture, etc. Point and click rapid application development.
www.Webiplex.com 		ADefWebserver.com
DotNetNuke® Module Development Help Website
ADefWebserver.com 		Get Smarter Mail, SmarterStats, SmarterTickets
Windows mail server, web log analytics, and customer service management software - Free Editions Available!
www.smartertools.com

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