Problem setting up SQL 2005 server connection

Discussion in 'ASP.NET 2.0' started by ie1jch, Feb 17, 2006.

  1. 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
     
  2. Bruce

    Bruce DiscountASP.NET Staff

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

    Bruce DiscountASP.NET Staff

    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
     

Share This Page