Re: Storing/saving sessions on SQL Server
- From: "stephen" <stephen_jn@xxxxxxxxxxx>
- Date: Wed, 10 Jan 2007 10:22:13 -0700
Hi,
Thanks for the information, I Did give the "Username" permissions to the
tables, I tried a couple of them like reader, writer as well as owner but it
gave me the same error... I am definetely doing something wrong
Thanks,
Stephen
"Ciaran O''''Donnell" <CiaranODonnell@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:1593B94C-CF7A-4FB9-A8BE-CFCE75B216C7@xxxxxxxxxxxxxxxx
You need to give the user name someUname access to the database ASPState
with
enterprise manager. If you dont have enterprise manager, download SQL
Server
Management Studio Express
--
Ciaran O''''Donnell
http://wannabedeveloper.spaces.live.com
"stephen" wrote:
Hi all,
I am trying to work with SessionState mode="SQLServer" and have run the
installSQL Script and the good stuff...
While running the program I get
"SQL Server does not exist or access denied. "error
if I have either
sqlConnectionString="data source=localhost;user
id=someUname;password=somePwd"
or sqlConnectionString="data source=127.0.0.1;user
id=someUname;password=somePwd"
setting
and
"Cannot open database requested in login 'ASPState'. Login fails. Login
failed for user 'someUname'. " error
if i use this
sqlConnectionString="data source=(local);user
id=someUname;password=somePwd"
setting
Please advice,
Stephen
.
- References:
- Storing/saving sessions on SQL Server
- From: stephen
- Storing/saving sessions on SQL Server
- Prev by Date: SharpPDF
- Next by Date: Re: CodeDom foreach
- Previous by thread: Storing/saving sessions on SQL Server
- Next by thread: WebRequest timeout changed declaratively
- Index(es):
Relevant Pages
|
