Yash, can you comment on the follow...

yorri · March 26, 2004, 7:39pm

How is the migration to win5 going and is this still happening?? I am not having any problems on win1 but I understood that you would be migrating all the accounts.
Do you plan on fixing the email notification for the forum? I didn’t realize how useful it was until I didn’t have it anymore hehe
Is the problem with the web sql admin tool fixed? There were 2 other threads going somewhere (one of the main reasons I am asking about #2…easier to know when threads are being posted in) and it seems that you are ignoring them or missing them or something. Haven’t seen any word about it.

Thanks

Yash · March 27, 2004, 3:14am

Yes, this is being planned. We are actually going to do a test migration tonight. We are looking into a different approach to this migration that should avoid the problems we faced with the previous approaches
I’ll have to move this forum to a linux server. I’ll try to complete that tonight as well
I’m sorry about this. I’ll have it setup tonight as well on a Windows 2000 server

yorri · March 28, 2004, 8:16am

[QUOTE=Yash]

Yes, this is being planned. We are actually going to do a test migration tonight. We are looking into a different approach to this migration that should avoid the problems we faced with the previous approaches
I’ll have to move this forum to a linux server. I’ll try to complete that tonight as well
I’m sorry about this. I’ll have it setup tonight as well on a Windows 2000 server
[/QUOTE]

any update(s) on this??

I tried to connect to the sqlwebadmin tool but it looks like it is completely gone now.

Yash · March 28, 2004, 10:52am

OK, an update:

We tried doing a test migration and it didn’t go very well. The physical resource creator errored out and we are working with PSOFT to resolve that
SQLwebadmin will take another 24 hours. We just migrated the JodoHost/WWG server to florida. Once resolution takes place, I’ll reinstall sqwebadmin
I’ll be be moving the forum to a linux server right after that

Yash · April 1, 2004, 8:16pm

an update:

migration plan still being worked on
Email notification fixed, forum moved to linux server
SQL admin fixed, read announcement above

Ron · April 1, 2004, 8:19pm

yep!! looks like email notification working now

yorri · April 1, 2004, 8:21pm

Where is that animated clapping icon

Yash · April 1, 2004, 8:21pm

just want to confirm, are you getting emails now?

Yash · April 1, 2004, 8:27pm

sqladmin instructions are here:
http://support.jodoshared.com/showthread.php?t=1641

yorri · April 1, 2004, 8:33pm

[QUOTE=Yash]
just want to confirm, are you getting emails now?
[/QUOTE]

Yes it is working again, thanks Yash.

Checking out the sql admin tool but still getting errors

==============
ERROR

Exception of type System.Web.HttpUnhandledException was thrown.

at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain()
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

COM object with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not registered.

at SqlAdmin.SqlServer.Connect()
at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()

Yash · April 1, 2004, 8:33pm

wow, ok, will be working on sqladmin first thing tomorrow.
Subspace, what component do you think was missing?

yorri · April 2, 2004, 12:39am

Also wondering when you will put horde on the mail.domain.com page? You mentioned a while back that you would.

I think a few people would like to see this happen (including myself).

Thanks

LegalAlien · April 2, 2004, 1:16am

[QUOTE=yorri]
Also wondering when you will put horde on the mail.domain.com page? You mentioned a while back that you would.

I think a few people would like to see this happen (including myself).

Thanks
[/QUOTE]

I would also like to see this.

eko · April 2, 2004, 8:51am

WebSQL error still there reads:

ERROR

Exception of type System.Web.HttpUnhandledException was thrown.

at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain()
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

COM object with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not registered.

at SqlAdmin.SqlServer.Connect()
at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()

SubSpace · April 2, 2004, 11:13am

[QUOTE=Yash]
wow, ok, will be working on sqladmin first thing tomorrow.
Subspace, what component do you think was missing?
[/QUOTE]

One of the components that’s installed along with MS SQL Server client side utilities. It’s possible to get it running without installing the utilities ( http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q248/2/41.asp&NoWebContent=1 ) but it seems somewhat complicated.
Installing the utilities on the server might be easiest.

Yash · April 2, 2004, 11:17am

I guess it will be best to install this directly on the MS SQL server

SubSpace · April 2, 2004, 11:35am

No, it needs to be installed on the webserver that is running the webinterface. So unless you want to enable IIS on the SQL Server and install the webinterface there, that wouldn’t help.

I’ve also made a redistributable package according to the instructions on the Microsoft site ( http://support.microsoft.com/default.aspx?scid=kb;en-us;326613 ) and uploaded it here. I did not test this however, just followed the instructions.

Makes you wonder why they don’t just offer their own redistributable installation package for it

Yash · April 2, 2004, 11:45am

IIS is installed on the MSSQL servers because HSphere communicates through ASP scripts

I did not see that thing about SQL-DMO. Will check it out and see if it works

Yash · April 2, 2004, 12:08pm

I had our DB administrator check and he said that all the 7 sql dmo files were already installed in their directories and registered on the sqladmin server.

So something else is missing

DirtBag · April 2, 2004, 1:17pm

I downloaded this program and ran it on my local computer and it worked fine with my local SQL Server, but when I tried to connect to mssql1.jodoshared.com I got that error. So I can’t really understand how this can be because of missing COMs on the webserver ?(