Solved

ASPState Database

Posted on 2004-03-30
4
279 Views
Last Modified: 2012-06-27
what do I change the sqlconnectionstring to be in web.config to make the user that access the ASPState database to always be machinename/ASPNET.  Right now it is using my domain user, but I don't want to add permissions for every domain user.

<sessionState
    mode="SQLServer"
    stateConnectionString="tcpip=127.0.0.1:42424"
    sqlConnectionString="data source=127.0.0.1; integrated security=true"
    cookieless="false"
    timeout="20"
/>

Thanks
0
Comment
Question by:barnetjeb
4 Comments
 
LVL 35

Accepted Solution

by:
YZlat earned 500 total points
ID: 10715516
add the following coe to your web.config file in between <configuration> tags and right after </system.web> tag:


 </system.web>
<appSettings>
 <add key="connStr" value="Provider=Microsoft.Jet.OLEDB.4.0;Password='';User ID=Admin;Data Source=\\myPath\db1.mdb;" />

</appSettings>

</configuration>

Then from your code you can access your connection string as

ConnStr=ConfigurationSettings.AppSettings("connStr")
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now