web.config problems

[Spondishy]

Hi,

I'm using SQL Server session state, but the user I'm using to access
this has a pound sign (£) in the password. This works locally, but not
on the server stating that the web.config contains invalid characters.
I've copied the machine.config from the server to my machine, but this
still works. Can anyone point me to what the problem could be. BTW I
can't change the password to something without a £ sign.

<sessionState mode="SQLServer" sqlConnectionString="Data
Source=dbserver;Initial Catalog=database;User=username;pwd=ASASN£11az"
cookieless="false" timeout="20" allowCustomSqlDatabase="true" />

Thanks in advance.

 

[Guest]

I'm using SQL Server session state, but the user I'm using to access
this has a pound sign (£) in the password. This works locally, but not
on the server stating that the web.config contains invalid characters.
I've copied the machine.config from the server to my machine, but this
still works. Can anyone point me to what the problem could be. BTW I
can't change the password to something without a £ sign.

Hmm, can you replace the pound sign with £ ?
If not then you could encrypt the password in the registry and access it
from there. See:
http://msdn.microsoft.com/library/en-us/dnnetsec/html/SecNetHT11.asp?frame=true