Was watching the home cleaning movie aired on Astro and they shared a tips in cleaning off the dried sticker or sellotape, which leave a mark on the wall after years of sticking, easily by just applying turpentine liquid instead of thinner. I was thinking thinner could be use to remove sticker in which I frequently use it to remove the roadtax sticker on car windscreen. It wont work the same for sticker that is sticked on painted house wall.
Written by admin on July 10th, 2011 with no comments.
Read more articles on Entertainment.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database “ASPState” requested by the login. The login failed.
Login failed for user ‘sa’.
Prompted with the infamous error as shown above. If you’re facing the same issue as mine when trying to run a web application connecting to MSSQL 2008 R2, then you might want to try:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -S DB_SERVER_NAME -E -ssadd -sstype p
P/S: browse to the designated folder before executing the program aspnet_regsql.exe
Hope it helps.
Update: IF you hit an error when running the command above like below:
Start adding session state.
…………………..
An error has occurred. Details of the exception:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)
Unable to connect to SQL Server database.
Solution: Proceed to SQL Configuration Manager and browse to SQL Server Network Configuration -> Protocols for MSSQLSERVER then enable Named Pipes. Restart the SQL Server and retry executing the command.
Written by admin on May 7th, 2011 with 1 comment.
Read more articles on Entertainment and Programming.