How to hack "Failed to query a list of database names from the SQL Server"

Sometimes ASP.NET Configuration Tool(ASP.NET) is a pain in the ass when trying to add aspnet.db for role management.

By default on Vista the current user on the machine is not a member of SysAdmin on SQL Server 2005/2008.

So here is the trick.

1-Open Sql Server Surface Area Configuration tool from C:\Program Files\Microsoft SQL Server 2005/2008.






2-When the screen pops up click on Add New Administrator.





-on top right make sure that User to provision=Username of the pc
-on your left (Available Privileges) select Member of SQL Server SysAdmin and click on the right arrow (>)
-click ok and you should be ready to go.

My name is Talley Ouro,Developer in Raleigh,NC
Blog: http://talleyblogs.blogspot.com/
Email:johnstalley@live.com