Databases :: Use MySQL With A Administration Tool?
Jan 27, 2010I'd like to use mySQL with a administration tool. Which tool should I use on Window Vista?
View 1 RepliesI'd like to use mySQL with a administration tool. Which tool should I use on Window Vista?
View 1 RepliesI created a database in my local sql server, and ran aspnet_regsql.exe on it, which created all the user and membership tables. However, when I click on the "Asp.Net Configuration" button in VS (2010), it open the Asp.Net Web Site Administration Tool, but with an error that say "An error was encountered. Please return to the previous page and try again." (of course there's no "previous page". What is one to do here?
My solution consist of several class libraries (domain, contracts, services, etc, etc) and a Asp.net MVC project. In my web (mvc) project's web.config, my connectionstrings looks as follows (just guessing this matters):
Code:
<connectionStrings>
<add name="ApplicationServices"
connectionString="Data Source=LAP00281;Initial Catalog=ClientManager;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="ClientManagerEntities" connectionString="metadata=res://*/ClientManagerDB.csdl|res://*/ClientManagerDB.ssdl|res://*/ClientManagerDB.msl;provider=System.Data.SqlClient;provider connection string="Data Source=LAP00281;Initial Catalog=ClientManager;Integrated Security=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />
</connectionStrings>
(only reason i want to use this is actually to create two roles, admin and client)
I got an error when trying to configure roles:
The following message may help in diagnosing the problem: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
The schema is there and i configure web.config for using roles.
Web.config
[Code]....
Can this corce by insufficient permission?
i am trynig to connect to sql server 2005 express with Web Site Administration Tool in visual studio 2008 but i got this error in security tab: 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: 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 - No connection could be made because the target machine actively refused it.)
i have already checked following links and done all hint but nothing [URL] i have MSSQLSERVER running but i can not run SQLEXPRESS
i was just using mysql i installed mysql and mysql net connector. its installed successfully but unable tp add to references.
View 3 Replieslogin control portion of Murach's web dev w/ c# book. According to the books instructions, you create a Login.aspx page, add the login control to the page, and create the users and roles for the directories within the asp.net web site configuration tool. I still do not get prompted for user name and passord to access the pages I want to be secured. Why is this? Isn't the asp.net configuration tool supposed to edit the web.config file? I'm trying to follow the book to the letter and ensure that I am following correctly before posting for answers online. According to the book you do not have to edit anything or write code withing login.aspx page.
View 3 RepliesCan anybody tell me where can i access 'website administration tool' in visual studio 2010. I couldn't see any website tab in my IDE.
View 5 Repliesim using web developer 2008, but i didnt found Web Site Administration Tool in menu, some 1 can tell me what is going on?
View 1 RepliesI get the following error while running ASP.Net Web site administration tool: ASP.Net Web site administration tool I am using visual web developer 2008 express edition and windows XP pro version 2002 service pack 3. I am following Microsoft Visual web developer 2008 express edition by Eric Griffin and in chapter 4 I need to use the administrator tool to set up passwords.
View 1 RepliesI have just installed Visual Studio 2010 trial. Previously I have been using Visual Studio Web Developer 2010 Express. Now every time I try to invoke the ASP.net Cofiguration tool either via the icon or through the Project File Menu item, I get the error message "An error was encountered. Please return to the previous page and try again." I am trying to develop a bog standard Silverlight Business Application. There are no other diagnostics. Is there anywhere I can look for more clues or anything else to do to alleviate the problem? or is this something peculiar to the trial version I am using?
I also think it might have something to do with the fact that I have created this Silverlight Business App on a directory on my D: drive and not the normal, default c: drive path and maybe the web sit admin tool is looking somewhere else. Could this have something to do with it? If so what is my remedy?
since installing VS2010 I have problems with configuring membership. Using a online sql database what I prepared with the aspnet_regsql tool tables are there connection string is ok! when I open the ASP net config tool, I do not manage to select the membership provider. Underneath my web config file. can sombody tell me what is wrong??
[Code]....
I'm very new to ASP.Net, but I've put together a reasonable site. I have used the user account and rolls which come with VS.
This all works fine for me, but I want to be able to change user's rolls and folder security when the site is live.
Is there any way of accessing the ASP.Net Web Site Administration Tool once the site has been moved to a production server?
If not is there any easy way to accomplish this other than write pages to do this yourself?
Getting error: "Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."
I am not usign SQL Express
1. Installed VS2008 + sp1 after that Installed SQL 2008 Standard x86 + sp1
2. Used aspnet_regsql to add aspnetdb to the sql (I can see that db in MSSMS)
3. From my WebProject I can access WSAT but when I click on the Provider and try to test I am getting above error.
Tried diffetent settings in the web.config and also check machine.config Check different solutions form different forums but nothing seams to work.
I strongly believe there is something wrong with my <connectionString/> as by default WSAT points to .SQLEXPRESS but I do not know which file should I update (web.config or machine.config or Web.config)
Do I need to add <connectionStrig> tag to web.config ?
i have been trynig to have "ASP.Net Web Site Administration Tool" save all user information in my database , is that doable?
if yes, how i can have all those asp_tables in mine?
I kept getting this using ASP.NET Administration Tool/Security tab: 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. Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
View 3 RepliesIs anyone able to see Web Site --> ASP.NET Configuration if you are creating a web application using File --> New Project --> Visual C# --> Web. If so, how and where?
Base on what I've tried, the menu Web Site --> ASP.Net Configuration appears only if you create a website by File --> New Website.
What I am actually trying to find is the Web Site Administration Tool (WSAT).
I am building a web site and am trying to run the web site administration tool.
I have reinstalled SQL Server 2008 express and have run the command line administration utilites. When I try to run the administration tool, get the following error when I click on the security tab is
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
I have ensured that I have user instances are enabled
When I click on Choose Data Store I get the following error
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
I am using sqlserver express 2008 (Microsoft Web Platform Installer) and visual studio 10 professionnel.
I am also using last Silverlight4_Tools.exe.
When i enter in Web Site Administration Tool / security I obtain this error
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 in diagnosing the problem:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
When I try userprovider
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
I recently installed VWDE 2010 and SQLE 2008 R2 and have built a basic site, but when I try to launch the Web Site Administration Tool, it fails to come up in a browser window. The server starts and I can right click on that and choose "Open in Web Browser", but when I do that an error message immediately shows up saying, an error was encountered. Please return to the previous page and try again with no other information given. When I click on "How do I Use this Tool?" in the top-right corner of the window, it immediately says the following:
Tool Has Timed Out
As a security measure, the Web Site Administration Tool times out after a period of inactivity. Changes to machine.config or web.config may also result in the tool needing to be restarted. To continue configuring your web site, restart the tool. The same message immediately comes up no matter what tab I click on. I have searched the internet and have made sure that the path doesn't have any spaces or non-alphabetic characters, run aspnet_regsql, restarted the IDE as well as the computer, but nothing works.
I am have problem getting the security selection to view properly. Instead of getting roles and so on I get this following error message: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.
View 2 RepliesIm using Visual Studio 2010. I'm new to asp.net. I'm trying to do a simple user login page but whenever I try to launch the Web Administration tool, I keep getting some exception error. The below images is the error I encountered.
View 4 RepliesI Have a problem here with Visual Web devoloper 2010 , When I click the "Asp.net Configuration" , the browser doesn't open the Web Site Administration Tool but the icon does appear in the notification area , on right clicking the icon it opens up the Web Site Administration Tool in the browser and displays "An error was encountered. Please return to the previous page and try again."
On the other hand I don't have any issues using "Asp.net Configuration" with Visual Web Devoloper 2008
Does anyone know how to get to work the authentication mechanism configured using Web Site Administration Tool under Linux running Mono? Is it even possible?
View 3 RepliesI have used ASD.NET code using SQL Database for Transaction operation successfully. By changing the Database Code to interface with MYSQL an Error occurs. If I remove the Transaction Code from within the the application, it works OK by displaying the MYSQL data (Read Only) in the layout of the application. I am using Mysql Essential-4.1.22-win32 and MYSQL Connector ODBC-3.51.2. My objective is to EDIT the MYSQL Data.
View 8 RepliesI have googled the similar problem that many people are facing but I still can't solve mine.I'm trying to visit the ASP.NET Web Site Administration Tool at
http://localhost:49274/asp.netwebadminfilesThe page shows me the error "An error was encountered. Please return to the previous page and try again."Some says it has to do with web.config file, I'm new to ASP.NET, here is my web.config file
[Code]....