Re: Administering MSDE with Enterprise Manager
From: Andrew Chalk (achalk_at_XXXmagnacartasoftware.com)
Date: 09/21/04
- Next message: STech: "Best practices for remote users"
- Previous message: Greg Low [MVP]: "Re: Administering MSDE with Enterprise Manager"
- In reply to: Stephen Dybing [MSFT]: "Re: Administering MSDE with Enterprise Manager"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Sep 2004 19:58:41 -0500
Found it. The install command that I used:
SETUP SAPWD="wombat" created 'Windows Only Authentication'. A registry tweak
changed it to mixed, and then I could log on. Not sure exactly why Windows
authentication failed except that the admin name and pwd were different on
the MSDE machine from those on the machine that I was connecting from.
"Stephen Dybing [MSFT]" <stephd@online.microsoft.com> wrote in message
news:OZrDqW0nEHA.2616@tk2msftngp13.phx.gbl...
> Even if you can figure out your connectivity problem, it's probably not
> legal anyway. From the Appropriate Uses of MSDE FAQ at
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp:
>
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
>
> A. You can only use SQL Server tools and services in conjunction
with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE in
> conjunction with a properly licensed copy of SQL Server 2000. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
>
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
>
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
>
>
> There's not enough information in your post to determine whether or not
it's
> legal, but in the vast majority of instances it's not and I'm told that it
> requires a room full of lawyers and white board to figure out. There are a
> bunch of 3rd-party tools out there that might be of use. Have a look at
> Aaron's list at http://www.aspfaq.com/show.asp?id=2442.
>
> --
> Sincerely,
> Stephen Dybing
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Andrew Chalk" <achalk@XXXmagnacartasoftware.com> wrote in message
> news:%23VTyAG0nEHA.1160@tk2msftngp13.phx.gbl...
> > Can I administer SQL 2000 MSDE Release A from SQL Server's Enterprise
> > Manager (EM) located on another machine on the same network?
> >
> > When I try to do this the EM setup wizard locates the host running MSDE
> > but
> > it cannot connect either with Windows authentication or the strong
> > password
> > created during MSDE's install.
> >
> > EM can see other instances of SQL Server 2000 on the network (these are
> > not
> > MSDE).
> >
> > MSDE is running on XP (SP1) and EM is running on W2K workstation.
> >
> > Many thanks.
> >
> >
>
>
>
- Next message: STech: "Best practices for remote users"
- Previous message: Greg Low [MVP]: "Re: Administering MSDE with Enterprise Manager"
- In reply to: Stephen Dybing [MSFT]: "Re: Administering MSDE with Enterprise Manager"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
