SQLState configuration

J

Jeff

We're attempting to use SQLState for our Session state on our web
app's.

First, what rights do I have to give to the user to be able to access
the ASPState DB correctly? I've read a few things that suggest the
user needs to have dbo rights to TempDB also.. is this correct? What
other rights does it need? Most of the samples out there show using
userid=sa ... obviously that's not a great solution for a production
system..

Second, are there any ways to secure/hide the UserID/PWD in the
SQLState's connection string?

thanks

jeffpriz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,431
Messages
2,571,678
Members
48,796
Latest member
Greg L.

Latest Threads

Top