Problem setting up SQL 2005 server connection

[ie1jch]

I can not connect to the server while running aspnet_regsql.exe I got the following message
The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting 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)

Please help
Thanks

[bruce]

try prepend the hostname w/ tcp:

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[ie1jch]

Can you explain step by step how to Prepen the hostname.
Thanks

[bruce]

you would run the command like this

aspnet_regsql.exe -S tcp:[DB Server Name] -U [DB login] -P [Password] -A all -d [Database name]

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)