Solution to connection failure of ASP. NET Website management tools under Silverlight 4

In Silverlight 4.0, an error occurs when you open the "Security" tab using ASP. NET Website management tool.:"SelectA problem may occur in the specified data storage zone because the server name or credential is invalid or the permission is insufficient. It may also be caused by the absence of the role manager function. Click the following button to redirect to the page where you can select a new data storage area. The following message may help diagnose the problem: unable to connect to the SQL Server database."

 

This problem occurs because the ASP. NET Website management tool cannot connect to the configuration database. After the database is created, you need to configure it before applying the database. Because vs2010 web server is used and IIS is not used, you only need to configure it.. net global configuration file, which is used by the web project of Silverlight 4.0. the Net Framework version is 4.0. Therefore, the configuration. net 4.0 framework. config to solve the above problem.

 

The procedure is as follows:

1. Create an aspnetdb Database
Open the Microsoft Visual Studio 2010 -- Visual Studio Tools -- Visual Studio command prompt (2010), enter "aspnet_regsql", and create the aspnetdb database as prompted.
 
2. modify the configuration file
Open the directory "C: \ WINDOWS \ Microsoft. NET \ framework \ v4.0.30319 \ config", find the machine. config file, go to the connectionstrings configuration section, and modify the content as follows:
<Add name = "localsqlserver" connectionstring = "Data Source = (local); initial catalog = aspnetdb; Integrated Security = true" providername = "system. Data. sqlclient"/>
 
3. Save the configuration file and restart ASP. ne.TWebsite management tools