Thanks for the reply.
I am using the Express version of Vs, Visual Web Developer. Does it make a difference? And I tried running aspnet_regsql.exe but there's an error.
"Unable to connect to SQL Server 2005 because there is an error in remote connection. Named Piped Provider could not open a connection"
But I checked SQL Server and I have enabled Remote connection.