I’ve looked at this KB article: How to configure the ASP.NET Membership/Roles Provider http://support.Winhost.com/KB/a619/how-to-configure-the-aspnet-membershiproles-provider.aspx I have Visual Studio 2010. I have uploaded a SQL DB that has the aspnetdb structures in it and my app. (I’m using example: “Walkthrough: Using Authentication Service with Silverlight Business Application” http://msdn.microsoft.com/en-us/library/ee942449(v=vs.91).aspx) appears to work fine. I am able to login, add a user, etc. My problem is that when I use the Web Site Authentication Tool. I go to the menus and choose “Project; ASP.NET Configuration”, up comes the Web Site Administration Tool, but it is using my local Application: / and my Current User Name: [is my local user name]. This, of course, is useless and generates an error when going to the Security tab. My web.config file (LocalSqlConnection) is pointing to the remote SQL DB on the Winhost server. My understanding is that I should be able to use the Web Site Admin Tool to access permissions on the remote server. What am I missing?
No you cannot use the Web Site Admin Tool directly on the web/SQL server. Unfortunately it can only be used for local web applications. I know it kinds of confusing and I'm still not sure why Microsoft done it this way. The work around to create the rules, users, and provider for your web form on our server is to create a simple web application locally on your computer. Configure the web.config file to connect to our SQL server. So basically you have a web application on your computer but it is pointing to our SQL server. Then use the Web Site Admin Tool to modify/update your rules, user, and providers for your web form hosted on our server.
Ray, thanks for the reply. I still need your help as I am not able to find any examples or further explanation online. I have done the following in VS2010. 1. Created a ASP.NET Web Application. I am able to go to the menus: Project; ASP.NET Configuration and bring up the Web Site Administration Tool and go to security. In the App_Data folder the file ASPNETDB.MDF has been created. 2. Now in Web.config in the <ConnectionStrings> block there is a connection string with the name, “ApplicationServices”. I have changed this connection string to point to my SQLDB on the Winhost server. No I do a Rebuild All and bring up the Web Site Admin Tool again; go to the Security Tab and I get the all too familiar error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) Am I going down the wrong path?
Actually, the easiest way to do this is to download a copy of your website from our server to your computer. You can use FTP it really doesn't matter since you will be opening it in VS 2010. Once you have a copy, open it in VS 2010 and then use the Web Site Administration Tool. Since your website is already configured to connect to our SQL server then all the user names, roles, and rules will be recorded on the SQL server.
Ray, From VS 2010 I downloaded a copy of the website per the instructions. Can see all the files and folders but the icon for the Web Site Administration Tool is not there - any suggestions? Thanks, Terry
Are you sure you are opening the files within your local computer system and not through the server. If you are connecting to the server and remotely viewing your files the Site Administration Tool will not show up.
