Storing/saving sessions on SQL Server

  • Thread starter Thread starter stephen
  • Start date Start date
S

stephen

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
 
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
 
Back
Top