I am following example from a Microsoft Press book titled Windows Communication Foundations Step by Step by John Sharpe an in Chapter 5 there is an exercise that , Page 125, where you create and AP.Net Website and use the web configuration management tool in the browser,
“Now that you have deployed, configured, and tested the WCF service by using IIS, you can use
the ASP.NET Administration Tool to define the users and roles that will be permitted to access
the service. To keep things simple, you will create roles (WarehouseStaff and StockControllers)
and users (Fred and Bert) that mimic those you created by using Windows in Chapter 4.
Define users and roles for the WCF service
1. In Visual Studio 2005, in the Website menu, click ASP.NET Configuration.
The ASP.NET Web Site Administration Tool starts. This is actually another Web application
that runs using the ASP.NET Development Server (a stand-alone Web server
installed with Visual Studio 2005, and separate from IIS):”
Well I get the same error when I CLICK on the Security tab I get an error stating:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.
I tried to turn on the role features from the command line from that I found on a microsoft webpage:
I ran the aspnet_regsql.exe from the command line with the appropriate parameters and it worked:
C:\Windows\system32>aspnet_regsql.exe -E -S propmancom\propmancon -A r
Start adding the following features:
but I got the same error when clicking the security tab as before. I even set permission on the C:\Program Files\Microsoft SQL Server directory so the user I am login in as has full permission as an administrator but this failed also.
I am running Windows Vista Extreme Edition,Professional Edition Visual Studio 2005 and a fully legal purchased of SQL Server 2005. If anyone is using the same book, or has access to it and can tell me how to solve this problem feel free to email me email@example.com