Storing/saving sessions on SQL Server

8 Jan 2007 9:54 PM

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

9 Jan 2007 9:21 AM

Ciaran O''''Donnell

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

Show quote

"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
>
>
>
>

10 Jan 2007 5:22 PM

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

Show quote

"Ciaran O''''Donnell" <CiaranODonn***@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
>>
>>
>>
>>