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

Re: Storing/saving sessions on SQL Server by stephen

stephen
Wed Jan 10 11:22:13 CST 2007

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@discussions.microsoft.com> wrote in
message news:1593B94C-CF7A-4FB9-A8BE-CFCE75B216C7@microsoft.com...
> 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
>>
>>
>>
>>