The Web Developer Companion

Aspnet_regsql.exe Tool : Could not open a connection to SQL Server

2007-08-14T17:00:00.000-07:00

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

Does this error look familiar. Well, when working with the "Aspnet_regsql.exe"(a.k.a. Asp.net sql server registration tool) Tool, you can configure your existing database to store tables, stored procedures, and functions related to the Built-in Membership, Profile, Role Management, and Personalization Providers that ships with Asp.net 2.0. When attempting this process you will sometimes encounter the error above or more like the one below:

To resolve this issue, simple change the server name to the instance name for the database. (Ex. "Myserver\sqlexpress" instead of "Myserver") You should now be able to click the "Database" drop down error without recieving an error message. Make note of the screen shot below:

I hope this helps. Happy Programming!

Geek Squad or Thief Squad

2007-08-14T16:42:00.000-07:00

Are you paying the right price for computer service? This video exposes some of the small to BIG computer shops out there and how they can easily rip you off!

ASP.NET 2.0 Unleashed - Would someone care for some DotNet?

2007-05-07T22:11:00.000-07:00

For those of you who are new to Dot Net or are reviewing some of the features of the framework, theres a good book by the name of
ASP.NET 2.0 Unleashed". It provides nice detail examples and very simple to understand topics on the ASP.NET 2.0 framework. And for those of you that are new to the OOP(Object Oriented Programming) world, this is a good start! Check it out here.