Showing posts with label sbs. Show all posts
Showing posts with label sbs. Show all posts

Wednesday, March 28, 2012

MSDE 2000a installation failure on XP Pro

Hi,
Everyone know why MSDE 2000a is refusing to load on a XP Pro wiht Office SBS installed on it. It seems to have MSDE already but the default instance isn't accessible so I tried to install under another instance name. I have set the SA password.
File and print sharing is installed and running (I think). I'm able to share out folders.
Any suggestions?
Jim
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
hi Jim,
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> ha scritto nel messaggio
news:eIKtRH8eEHA.3028@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Everyone know why MSDE 2000a is refusing to load on a XP Pro wiht Office
SBS installed on it. It seems to have MSDE already but the default instance
isn't accessible so I tried to install under another instance name. I have
set the SA password.
> File and print sharing is installed and running (I think). I'm able to
share out folders.
I'm not aware of such limitation... but, anyway, please add the /L*v
"c:\..\Log.txt" command line parameter in order to
inspect the resulting log file..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

MSDE 2000A EULA / SBS 2003 Web Edition

Hi. I'm a bit confused and wonder whether someone of you can give me some
more information on this.
The EULA for MSDE 2000A states that you cannot use MSDE for hosting
services. Does anyone know what this mean?
I'm running an ASP.Net application and would like to use MSDE as the backend
database. Does this fall into this category?
Or does it mean that if I'm an ISP, I'm not allowed to offer MSDE as a
feature on my hosting packages?
Also, it says that you're not allowed to install any applications on SBS
2003 Web Edition. Does MSDE fall into this category?
Thanks very much for your help!
Martin
Hi Martin,
If you plan on using Webserver I think you need the full version of SQL. As
for SBS webserver 2003 I think you mean Windows Webserver 2003, which is a
lower priced version of windows server with a limited feature set optimized
for webhosting and reducing the cost of server to make it more competitive
in that market place. If you are a programmer look into either the ISV
program or the Action pack program which will help you out with the software
required to setup the development environment.
Regards,
Jeff Loucks
Available Technology
Solutions For Professionals
www.availabletechnology.com
"Martin Feuersteiner" <theintrepidfox@.hotmail.com> wrote in message
news:u$$6SFOcEHA.212@.TK2MSFTNGP12.phx.gbl...
> Hi. I'm a bit confused and wonder whether someone of you can give me some
> more information on this.
> The EULA for MSDE 2000A states that you cannot use MSDE for hosting
> services. Does anyone know what this mean?
> I'm running an ASP.Net application and would like to use MSDE as the
backend
> database. Does this fall into this category?
> Or does it mean that if I'm an ISP, I'm not allowed to offer MSDE as a
> feature on my hosting packages?
> Also, it says that you're not allowed to install any applications on SBS
> 2003 Web Edition. Does MSDE fall into this category?
> Thanks very much for your help!
> Martin
>
>
>

Wednesday, March 7, 2012

msdb Unavailable

I work on a SQL 2000 Standard server that is part of our SBS package. Two days ago we ran a set of MS updates on the server and the residual symptom is that DTS packages, the Import or Export wizard all will not run. The Sql Server Agent service runs under the local system account, however that was true prior to the updates.

The error when attempting to run an import is that the OLEDB connection object is not available. The error occurs when trying to use the Access driver or a DSN. Further investigation indicates that msdb could not be contacted.

Does anyone have an idea as to what might cause this and a workaround?
Thanks,

misdeanI would perform an integrity check (DBCC CHECKDB) of the MSDE database, to se if it is corrupt. It might be because it's late night here, but that's the only reason I could think of now.|||I will give it a try. Somehow, I believe is is related to the MS updates applied the other day. I will run DBCC on it in the AM and post the results.

Thanks,

Keith