SQL Session Database Name?

[Guest]

Hi,

Has anyone seen a problem with connection to a sql session database that has
an underscore "_" in the name such as:
aspnetstate_it

.... if you look at the error message it says that the object
'aspnetstate.dbo.aspstatetempapplications' is invalid.

thanks!
Bill

 

[Guest]

in asp.net 2.0, If you renamed the default ASPState database, you'll need to
specify the name in your connection string's database= parameter.

<sessionState mode="SQLServer" sqlConnectionString="Data
Source=YourServer;Integrated Security=True; database=aspnetstate_it"
sqlCommandTimeout=30; allowCustomSqlDatabase="true">

 

[Guest]

yes - I do speficy the aspnetstate_it name in the connection string.

 

[Guest]

Bill,

I'm not sure about the error but I found this
http://support.microsoft.com/kb/317604

Just wondering if you created a perisistent version of the db instead (if
you haven't already) if that would work.