ClubSite Template + Sql Server 2005 Not Cooperating...

I've managed to get the clubsite template from asp.net up and running, sorda (http://www.flysniper.com), I get a system error which I believe is related to the fact that my DB isn't working correctly.

I'm trying to configure it to work with ms sql server 2005 which is running on the same machine as the website.

I've followed the instructions of Scott Gu (http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx)

while trying to run aspnet_regsql.exe I get the following error

C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe -S XXXXXXXXXX
-U YYYYYYYY -P ZZZZZZZZZ -A all -d flysniper

Start adding the following features:
Membership
Profile
RoleManager
Personalization
SqlWebEventProvider

......................
An error has occurred. Details of the exception:
An error has occurred while establishing a connection to the server.  When conne
cting to SQL Server 2005, this failure may be caused by the fact that under the
default settings SQL Server does not allow remote connections. (provider: Named
Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Unable to connect to SQL Server database.

 I have tried several different things (shooting in the dark) to resolve this issue, including:

verifing that port 445 is avaliable on the firewall per these directions: http://support.microsoft.com/default.aspx?scid=kb;en-us;839269

configured SQL server 2005 to allow remote connections following these directions: http://support.microsoft.com/kb/914277

with no change in results.

 Anything else I should look into?

Thanks in advance,

Mike