Andrea, you made the tool that I am using to interface with msde 2000. What
a nice help. I have been using the developer edition of sql for about a year
and am now trying to understand msde for a real project installation. I
guess I am just going thru new msde user difficulties. I installed msde and
when I tried to access it with dbamgr2k, I got "SQL Server does not exist or
access is denied". It took me a while to figure out that I needed to select
the trusted user button vice work with the sa/password combination. Anyway,
I am now able to see msde in the dbamgr2k tool and work with it. What is
the easiest way to move my existing database to msde using your tool?
Thanks,
Fred Herring
[quoted text, click to view] "Andrea Montanari" wrote:
> hi Fred,
> Fred Herring wrote:
> > I have installed msde 2000 but my application cannot recognize it.
> > Does msde require that iis be installed and running on the hosting
> > machine? Does the hosting machine have to be setup as a server or
> > can msde just be used as a local database for a single computer
> > application without iis.
>
> IIS is not required to run MSDE... what do you mean by
> > I have installed msde 2000 but my application cannot recognize it.
> what kind of error/exception are you reported with?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
>
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org > DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>
hi Fred,
[quoted text, click to view] Fred Herring wrote:
> I have installed msde 2000 but my application cannot recognize it.
> Does msde require that iis be installed and running on the hosting
> machine? Does the hosting machine have to be setup as a server or
> can msde just be used as a local database for a single computer
> application without iis.
IIS is not required to run MSDE... what do you mean by
[quoted text, click to view] > I have installed msde 2000 but my application cannot recognize it.
what kind of error/exception are you reported with?
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
[quoted text, click to view] Fred Herring wrote:
> now able to see msde in the dbamgr2k tool and work with it. What is
> the easiest way to move my existing database to msde using your tool?
>
the easiest way is a backup/restore or a detach/attach operation
operation...
just be sure to verify the database owner after the attach/restore, and that
no orphaned users (database users no more mapped to their SQL Server
standard logins)
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
