SQLServerCentral / Discuss Content Posted by Jereme Guenther / Article Discussions / Article Discussions by Author / Alternative to the Microsoft MMC Console / Latest Posts

RE: Alternative to the Microsoft MMC Console

Jereme Guenther — Wed, 02 Aug 2006 10:54:00 GMT

I agree, I get so Enthusiastic about sharing my new discoveries with people that I often make simple mistakes in my presentations. I am still working on the idea of creating something then coming back and looking over it again a few days later. My lack of patience skills is not helping in this area.

Hopefully my last couple of posts have helped clear up the problems which were found in my posted files.

Is this different than the RDP snap-in from the admin tools pack? Not really, in fact the MMC consol itself actually provides broader functionality in that it allows for various types of stap-ins in one consol. The whole purpose of my idea is for those who specifically use the RDP snap-in and would like greater focused functionality. This focused functionality comes in the form of Alphebetized and grouped servers, and web based functionality.

RE: Alternative to the Microsoft MMC Console

Jereme Guenther — Wed, 02 Aug 2006 10:46:00 GMT

Hi Willhaney, just go ahead and delete the include file line altogether. I had put that in there as a foobared place holder where people could put their own included connection files. It seems to have caused more troubles than it was worth. See my previous post for the constants which were included in this file.

RE: Alternative to the Microsoft MMC Console

Jereme Guenther — Wed, 02 Aug 2006 10:43:00 GMT

The constants that were stored in my include files which you need are these:

AnonUser = "myUserName"AnonPword = "mySQLPassword"

Const adCmdStoredProc = &H0004

strConn = "Provider=SQLOLEDB.1;" & _ "Initial Catalog=MyDatabase;" & _ "Data Source=MyDatabaseServer;" & _ "User Id=" & AnonUser & "; " & _ "Password=" & AnonPword

As a side note, the adovbs file actually ships with windows. Whether good or bad, many web developers include that file when dealing with server objects and the constants contained within the adovbs file.

As to the ConvertText function, that one was totally my fault for not including it. Here it is, you should be able to put it right before the do loop at the top of the connections.asp file.

Function ConvertText(Value) If IsNull(Value) then ConvertText = "" Else ConvertText = Value End IfEnd Function

RE: Alternative to the Microsoft MMC Console

willhaney — Wed, 02 Aug 2006 10:40:00 GMT

Congratulations on the birth!

The error I was getting was this:

The include file 'inc/stuff.inc' was not found.

Are you saying that the file, stuff.inc, which is to be an include in connections.asp has the script to create tables?

I’m confused.

Will

RE: Alternative to the Microsoft MMC Console

Jereme Guenther — Wed, 02 Aug 2006 10:21:00 GMT

The /inc folder simply contained my connections to my SQL server. Seeing as this is a SQL server specific site, I assumed that people would know how to create databases, tables, and connections to the database. For those that need help in this area, here is the script to create the table and stored proc.

USE [MyDatabase]GO/****** Object: Table [dbo].[Servers] Script Date: 08/02/2006 09:06:16 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Servers]( [MyDatabase_ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Active] [bit] NULL, [Location] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Description] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL) ON [PRIMARY]

GOSET ANSI_PADDING OFF

/**************************Stored Procedure**************************/

USE [MyDatabase]GO/****** Object: StoredProcedure [dbo].[spTSWeb] Script Date: 08/02/2006 09:16:21 ******/SET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE [dbo].[spTSWeb] ASSelect [Name] ,Location AS Loc ,Description AS DescFrom ServersWhere Active = 1Order By Location,Servers_Name

RE: Alternative to the Microsoft MMC Console

Jereme Guenther — Wed, 02 Aug 2006 10:03:00 GMT

Sorry all, I have been gone for the last week due to my wife having our second child.

Thanks to Steve Jones, the zip file available for download within the article now includes the files needed for the right click and disconnect functionality.

RE: Alternative to the Microsoft MMC Console

willhaney — Thu, 27 Jul 2006 11:03:00 GMT

I'm also getting an error when running the Connections.asp page

Active Server Pages, ASP 0126 (0x80004005)The include file 'inc/stuff.inc' was not found./test/NewMMC/Connections.asp, line 5

RE: Alternative to the Microsoft MMC Console

Mr.No — Thu, 27 Jul 2006 00:24:00 GMT

Great article, thanks.

RE: Alternative to the Microsoft MMC Console

philcart — Wed, 26 Jul 2006 19:39:00 GMT

Nice short article, but probably a little too short and definately needs some screenshots. Maybe after "a couple hours", a extra couple of hours should have been spent making everything presentable.

The provided download should be easy to setup and get working. Unfortunately there seems to be a couple of missing files, the asp page calls a stored procedure that is not mentioned or provided in the download. It seems other posters have had other various issues as well.

Maybe I'm missing something, but how is this any different that the Remote Desktop snap-in provided in the Windows Server 2003 Admin Tools Pack?

RE: Alternative to the Microsoft MMC Console

rlively-343684 — Wed, 26 Jul 2006 16:21:00 GMT

I posted this once but it went to the wrong place. The original post went here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=280&messageid=297580. I couldn't find a way to delete that post.

I am having difficulty setting this up to work. I have a virtual directory in IIS with the pages downloaded to it, and I have installed the tswebsetup.exe from http://www.microsoft.com/windowsxp/downloads/tools/rdwebconn.mspx.

In connections.asp these files are referenced:

<!-- #INCLUDE FILE="/conn.inc" --><!-- #INCLUDE FILE="/adovbs.inc" --><!-- #INCLUDE FILE="/inc/Func.inc" -->

But these files are not included in the zip file for download, and there is no mention in the article as to the contents or format these files need in order to work on the page. I get this error when I visit the page:

Error Type:Active Server Pages, ASP 0130 (0x80004005)File attribute '/conn.inc' cannot start with forward slash or back slash./newmmc/connections.asp, line 4

I thought conn.inc would include the servers to include in the list, but it looks like it wants to connect to a SQL Server to get that list, so I created a new DB and added a ServerList table and an SP for the page to call to get the list.

I got past the error stemming from the constant adCmdStoredProc not being defined by downloading adovbs.inc from here: http://www.asp101.com/articles/john/adovbs/default.asp.

That brought me to this error, which is probably because I need the function which is defined in Func.inc?

Error Type:Microsoft VBScript runtime (0x800A000D)Type mismatch: 'ConvertText'/newmmc/connections.asp, line 22

On another topic, does this forum only work for IE? I tried with both Opera 9 and FireFox 1.5 and neither one would let me type into the reply box, and there were multiple JavaScript errors reported in both error consoles.

RE: Alternative to the Microsoft MMC Console

robert-249275 — Wed, 26 Jul 2006 16:15:00 GMT

As you are missing the /inc folder, and files, what is the db table structure. this sounds like a great idea but the missing files obscure the solution you used....

RE: Alternative to the Microsoft MMC Console

Dale Corey — Wed, 26 Jul 2006 15:55:00 GMT

Jereme,

Not bad for your second article. I read your first one too on Printing in .NET. Keep up the good work! You have a very helpful style.

RE: Alternative to the Microsoft MMC Console

Jereme Guenther — Wed, 26 Jul 2006 15:04:00 GMT

Good idea, sorry this is only my second article. I will remember that suggestion for next time.

RE: Alternative to the Microsoft MMC Console

Dale Corey — Wed, 26 Jul 2006 14:48:00 GMT

Jereme,

Great article! A few screen shots would have been nice...

RE: Alternative to the Microsoft MMC Console

Jereme Guenther — Wed, 26 Jul 2006 11:18:00 GMT

Cory, are you trying to setup the whole thing, or just the right click and disconnect feature?

If it is just the disconnect feature then PM me with your email and I will send it to you.

If you are trying to set the whole thing up for the first time, then I don't think you will need an increadibly indepth programming skill set.

RE: Alternative to the Microsoft MMC Console

Cory E. — Wed, 26 Jul 2006 10:54:00 GMT

Thanks! I will ask around and see what help I can get.

RE: Alternative to the Microsoft MMC Console

Jereme Guenther — Wed, 26 Jul 2006 10:51:00 GMT

It's not that difficult, but if you are trying to do it on your own then you will definitely need a good programming skill set in javascript or vbscript.

RE: Alternative to the Microsoft MMC Console

Darek Tomyn — Wed, 26 Jul 2006 09:46:00 GMT

Great work and thanks for sharing! My hunch is that I have used this ActiveX control when using Virtual Server but I definitely have never attempted to use the control in my own custom page.

RE: Alternative to the Microsoft MMC Console

Cory E. — Wed, 26 Jul 2006 08:44:00 GMT

Well, I tried this, but it looks like this may be outside my skill set...is there anything special that needs to be done to make this work? I am more a DBA, not a programmer...

RE: Alternative to the Microsoft MMC Console

C_C_ — Wed, 26 Jul 2006 06:19:00 GMT

Haven't tried it out yet, but just read your article. Cool Concept!

Thanks for sharing, will give it a whirl.

-CG.

RE: Alternative to the Microsoft MMC Console

Jereme Guenther — Thu, 13 Jul 2006 13:02:00 GMT

Since the writting of this article I have developed the right click and disconnect idea. If you would like the files for this then PM (click on my username) me or post an email address and I will ship them off to you.

I also noticed that the area in which the activeX object opens isn't always consistent. While it typically only changes by a few pixels at a time, I haven't been able to figure out why yet.

Alternative to the Microsoft MMC Console

Jereme Guenther — Thu, 13 Jul 2006 11:59:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jGuenther/alternativetothemicrosoftmmcconsole.asp