I keep getting an SQL Error, when I go into .NET Users SQL Network Interfaces, error:26 - Error Locatin Server/Instance Specfied It's been a long day, and I am sure I am missing something. Where do I setup this SQL connection, as I just created the database. My goal is so I can just a simple login/password to protect a diretcory on the site.
Maybe that is the head scratcher part that I am missing... Even if I am just using it for the IIS7 Authentication, I have to wire in web.config in that directory to point the sql server? How do I go about setting up any type of table/procedure structure that would be needed in the hosted SQL server.
It actually sounds like you're trying to use the ASP.NET Membership provider which can configure with the guidance of this Knowledge Base article: http://support.Winhost.com/KB/a619/how-to-configure-the-aspnet-membershiproles-provider.aspx
