SQL Server Web Tools

Project License Changed

Fri, 30 Nov 2007 17:28:29 GMT

Microsoft Public License (Ms-PL) This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software. 1. Definitions The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law. A "contribution" is the original software, or any additions or changes to the software. A "contributor" is any person that distributes its contribution under this license. "Licensed patents" are a contributor's patent claims that read directly on its contribution. 2. Grant of Rights (A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create. (B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software. 3. Conditions and Limitations (A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks. (B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically. (C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software. (D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license. (E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

NEW POST: Unable to download!

Nebulus — Tue, 30 Oct 2007 14:34:35 GMT

I'm trying to download the most current release zip file, and the page shows "Updating", flashes the terms of service agreement, and then nothg. Help!

Project License Changed

Thu, 31 May 2007 23:40:29 GMT

Microsoft Permissive License (Ms-PL) This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software. 1. Definitions The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law. A "contribution" is the original software, or any additions or changes to the software. A "contributor" is any person that distributes its contribution under this license. "Licensed patents" are a contributor's patent claims that read directly on its contribution. 2. Grant of Rights (A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create. (B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software. 3. Conditions and Limitations (A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks. (B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically. (C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software. (D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license. (E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

Project License Changed

Mon, 19 Feb 2007 20:10:26 GMT

Microsoft Permissive License (Ms-PL) This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software. 1. Definitions The terms “reproduce,” “reproduction,” “derivative works,” and “distribution” have the same meaning here as under U.S. copyright law. A “contribution” is the original software, or any additions or changes to the software. A “contributor” is any person that distributes its contribution under this license. “Licensed patents” are a contributor’s patent claims that read directly on its contribution. 2. Grant of Rights (A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create. (B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software. 3. Conditions and Limitations (A) No Trademark License- This license does not grant you rights to use any contributors’ name, logo, or trademarks. (B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically. (C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software. (D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license. (E) The software is licensed “as-is.” You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.

User Forum: status of project

vistagrande — Wed, 18 Oct 2006 20:09:37 GMT

Is there anything happening with the SQL Server Web tools project? The MS hosting solution v4 links to this for a web based alternative for hosting clients wanting to access their SQL databases. It seemed like this would be perfect. Perhaps finally something equivalent to phpmyadmin only for MS SQL. However, it appears very alpha. Basic functionality such as browsing tables and changing field content is not working (ASP.NET error). Create table does nothing (looks like that one does not postback to the web.) Is this still a work in progress?

User Forum: RE: Error after 1st time login as Admin

TerryDenham — Thu, 24 Aug 2006 04:54:51 GMT

It looks like this call is failing: child["showAsTab"].ToLower() The reason you would get a null exception is if child didn't have a "showAsTab" attribute. Double-check your sitemap and be sure that you add the attribute "showAsTab" to all your sitemap nodes.

User Forum: Error after 1st time login as Admin

imorrish — Sun, 13 Aug 2006 05:55:45 GMT

Installer.aspx ran fine and Admin account is in the db. Running in a virtual directory under a SharePoint Server 2007 virtual server (with Ttrust = Full). Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: Line 63: foreach (SiteMapNode child in root.ChildNodes) Line 64: { Line 65: if (child.ChildNodes.Count > 0 && child["showAsTab"].ToLower() == "true") Line 66: { Line 67: IList roles = child.Roles; Source File: c:\Inetpub\SQLWebTools\Controls\TabStripControl.ascx.cs Line: 65 Stack Trace: [NullReferenceException: Object reference not set to an instance of an object.] TabStripControl.Page_Load(Object sender, EventArgs e) in c:\Inetpub\SQLWebTools\Controls\TabStripControl.ascx.cs:65 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

COMMENTED ISSUE: Slow Performance

jebuskrust — Fri, 04 Aug 2006 13:59:17 GMT

=== Opened by edle @ 5/15/2006 9:00:42 AM === I saw extremely slow performance going from page to page in this process. Like 30 seconds after clicking a link in some cases before the page changes. Clicking "Manage Databases" took about 60 seconds to display my two databases. Of course the server where those databases live has ~1,400 databases on it, but the hardware isn't a limiting factor. Perhaps the query used to find the databases that I would want to manage could be tweaked for better perf. === Edited by terrydenham @ 5/15/2006 11:25:19 AM === The reason for the performance problem is SMO will give us all databases on the system, whether the user has access to those databases or not. To keep from getting errors when users try to access different databases, the code gets all databases on the server, and then we try to access 1 of the tables in the collection. Just by trying to access tables that we may/may not have permissions to causes SMO to pull back all table information. If this causes an exception, then we remove this database from the list of databases we have access to. If there is a way to call Smo.Databases() and have SMO filter out the database that the user doesn't have access to, we'll use this. Or if we are fine showing the user 1400 databases, even though they may only have permission to a few then we can remove the access check. I need either some technical guidance on whether SMO has the capability to do collection pruning based on the user's credentials, or guidance on whether it's ok to show the users 1400 databases even though they don't have permissions to these. I will do some more digging to see if there is a better/more efficient way to check database permissions than trying to call database.Tables.Count. === Edited by terrydenham @ 5/15/2006 11:42:59 AM === I've changed the code from having to pull back every table object in each database and check if a table is accessible, to using the IsAccessible property on the database object. Now the code reads like this foreach( Smo.Database db in dbc) { if( db.IsAccessible) dbCollection.Add(db); } return dbCollection; === Edited by terrydenham @ 5/16/2006 7:27:51 AM === --> Issue type changed I tried to create 1400 databases to test with but on my laptop SQL Server 2005 consumed 1.6GB with 1400 database and I'm close exceeding my physical memory limites before even opening up VS 2005, so I'm backing away from 1400 databases and going with around 800. Hopefull this will give me enough memory to test the two different approaches. === Edited by terrydenham @ 5/17/2006 1:51:34 PM === --> AssignedTo changed from edle to terrydenham --> Issue type changed === Edited by terrydenham @ 5/19/2006 9:22:13 AM === --> Issue type changed Comments: ** Comment from web user: jebuskrust ** Why would someone use alpha (meaning buggy) software with a ms sql server that houses several thousand databases. :)? Next, usually a big part of lag can also come from the webserver side from having to create the access / error log files on the webserver itself. Since depending on how detailed you want the log to be, the successful resolution of a ip from a gethostname() function can take some time for the function to return a value to the webserver if your local area network's dns server is configured incorrectly (ie its missing IN PTR/IN A records and for the specific ip youre connecting from). Easy solution is on the server that youre connecting (if dns reverse dns isnt configured correclty) is to add to the hosts file your machine and the host its connecting from.80% of Operating systems use the host files in attempting to resolve dns on the local machine before making an attempt to query the primary and secondary ns's

User Forum: Data Types

pcuaap — Sat, 22 Jul 2006 19:35:45 GMT

The query analyzer (i think) give me error when i try to load the datatype nvarchar(max), how i can fix this problem, or what i can do?. I'm new with databases, and not very good, if you can help me i will be very gratefully. Sorry my English i'm from Argentina. Thanks.

CREATED ISSUE: DataType nvarchar(max)

pcuaap — Sat, 22 Jul 2006 19:32:17 GMT

There is a problema with sql queries, i can't load sql server data type nvarchar(max), i don't know if it's something i'm doing wrong or what, but i have tried another software and receive the same error, i think that is a problem of the software. In admin mode i try to create a table with this data type and i cannot do. Please if you can repair this i will be very gratefully. Sorry for my English, i'm from Argentina, and worst, a novice. Thanks.

UPDATED WIKI: Setup and Configuration

edlehman — Mon, 10 Jul 2006 20:37:09 GMT

! Setup and Configuration !! Pre-Install Requirements and Assumptions !!! Assumptions Setup and Configuration instructions assume the following throughout: * The developer installing the software is familiar with setting up websites in IIS, working with ASP.NET, and working with SQL Server 2005. * If any problems are encountered installing or setting up the software, questions will be posted to the Discussions Board. !!! Required Software The following software should already be installed and working correctly in your environment: * SQL Server 2005 * IIS 5.1 or 6 * ASP.NET 2.0 !! [281] !! [282] !! [283]

UPDATED WIKI: Configuration

edlehman — Mon, 10 Jul 2006 20:35:44 GMT

! Configuration !!! 1. Login Browse to http:// and from that page login with the Admin user and password from step 6 under 2.2 Database Setup above. [image:welcome.gif] On the next page, you should be able to just click Login. [image:welcome credentials.gif] You will then arrive at the “Welcome Admin” screen, from there click on the Membership Administration link. [image:welcome admin.gif] From that page, you should click on the Create User link. [image:membership admin.gif] From that page, enter the user name, password (one has been automatically created for you that you can use, note: there are rules enforced around the security of the password), and email address, then click the Create User button. [image:User-pass.gif] You should receive a page that has a confirmation message that the user has been created. Then click the Membership Administration link again. [image:user-pass confirmed.gif] Select the Manage Users link. From that page, you can search for the users, so search on the name you created (note: you can use the % character as a wildcard), then click on that user name to administer it. [image:user management.gif] Make sure the Database Administrator and Database Owner roles are checked (note, as you check the roles they will be auto-saved) [image:user management - roles.gif] !!! 2. Access administration Browse to http:// and login with the user created in step 1 above. Once you arrive at the Home page, you can click on the Administration tab, and then the Manage Databases link. You are ready to start using the SQL Server Web Tools application! !! Send feedback to the GotDotNet project via the Message Board or Bug Tracker (as appropriate).

UPDATED WIKI: Configuration

edlehman — Mon, 10 Jul 2006 20:33:22 GMT

! Configuration !!! 1. Login Browse to http:// and from that page login with the Admin user and password from step 6 under 2.2 Database Setup above. [image:welcome.gif] On the next page, you should be able to just click Login. [image:welcome credentials.gif] You will then arrive at the “Welcome Admin” screen, from there click on the Membership Administration link. [image:welcome admin] From that page, you should click on the Create User link. [image:membership admin.gif] From that page, enter the user name, password (one has been automatically created for you that you can use, note: there are rules enforced around the security of the password), and email address, then click the Create User button. [image:User-pass.gif] You should receive a page that has a confirmation message that the user has been created. Then click the Membership Administration link again. [image:user-pass confirmed.gif] Select the Manage Users link. From that page, you can search for the users, so search on the name you created (note: you can use the % character as a wildcard), then click on that user name to administer it. [image:user management.gif] Make sure the Database Administrator and Database Owner roles are checked (note, as you check the roles they will be auto-saved) [image:user management - roles.gif] !!! 2. Access administration Browse to http:// and login with the user created in step 1 above. Once you arrive at the Home page, you can click on the Administration tab, and then the Manage Databases link. You are ready to start using the SQL Server Web Tools application! !! Send feedback to the GotDotNet project via the Message Board or Bug Tracker (as appropriate).

UPDATED WIKI: Configuration

edlehman — Mon, 10 Jul 2006 20:32:39 GMT

! Configuration !!! 1. Login Browse to http:// and from that page login with the Admin user and password from step 6 under 2.2 Database Setup above. [image:welcome.gif] On the next page, you should be able to just click Login. [image:welcome credentials.gif] You will then arrive at the “Welcome Admin” screen, from there click on the Membership Administration link. [image:welcome admin] From that page, you should click on the Create User link. [image:membership admin.gif] From that page, enter the user name, password (one has been automatically created for you that you can use, note: there are rules enforced around the security of the password), and email address, then click the Create User button. [image:User-pass.gif] You should receive a page that has a confirmation message that the user has been created. Then click the Membership Administration link again. [image:user-pass confirmed.gif] Select the Manage Users link. From that page, you can search for the users, so search on the name you created (note: you can use the % character as a wildcard), then click on that user name to administer it. [image:user management.gif] Make sure the Database Administrator and Database Owner roles are checked (note, as you check the roles they will be auto-saved) [image:user management-roles.gif] !!! 2. Access administration Browse to http:// and login with the user created in step 1 above. Once you arrive at the Home page, you can click on the Administration tab, and then the Manage Databases link. You are ready to start using the SQL Server Web Tools application! !! Send feedback to the GotDotNet project via the Message Board or Bug Tracker (as appropriate).

UPDATED WIKI: Configuration

edlehman — Mon, 10 Jul 2006 20:24:52 GMT

1.1 SQL Server Web Tools Configuration 1. Browse to http:// and from that page login with the Admin user and password from step 6 under 2.2 Database Setup above. On the next page, you should be able to just click Login. You will then arrive at the “Welcome Admin” screen, from there click on the Membership Administration link. From that page, you should click on the Create User link. From that page, enter the user name, password (one has been automatically created for you that you can use, note: there are rules enforced around the security of the password), and email address, then click the Create User button. You should receive a page that has a confirmation message that the user has been created. Then click the Membership Administration link again. Select the Manage Users link. From that page, you can search for the users, so search on the name you created (note: you can use the % character as a wildcard), then click on that user name to administer it. Make sure the Database Administrator and Database Owner roles are checked (note, as you check the roles they will be auto-saved) 2. Browse to http:// and login with the user created in step 1 above. Once you arrive at the Home page, you can click on the Administration tab, and then the Manage Databases link. You are ready to start using the SQL Server Web Tools application! 3. Send feedback to the GotDotNet project via the Message Board or Bug Tracker (as appropriate).

UPDATED WIKI: Setup and Configuration

edlehman — Mon, 10 Jul 2006 20:20:47 GMT

Developer Forum: RE: forget VB folder

edlehman — Wed, 05 Jul 2006 16:16:59 GMT

I just checked the download and didn't have this problem. You should have placeholder.txt in the VB directory, and should be able to find it in the zipped source download.

User Forum: RE: let's get it run - thank you for some help

edlehman — Fri, 30 Jun 2006 15:41:16 GMT

You can download SMO as a separate install from http://www.microsoft.com/downloads/XMO, which will give the SMO libraries without installing SQL on the same box as the web app.

Developer Forum: forget VB folder

michealin — Fri, 30 Jun 2006 03:22:46 GMT

“/SqlWebAdminCS/App_Code/VB/” folder not exist Maybee forget the folder when publish

CREATED ISSUE: login credentials cached

edlehman — Thu, 29 Jun 2006 17:57:18 GMT

=== Opened by AliJas @ 5/29/2006 3:54:17 AM === If I act as a average stupid user, and use the back button to try to switch to a different database server. after login in I return to my previous server instead of the newly selected server. this procedure only works correct if I explicitly choose "change credentials". (which is not available if I logged in on a SQL2000 server (with SQL authentication)).