Re: "Best Practices" way to distribute MSDE

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 07/08/04

  • Next message: Carl Karsten: "Re: Posible bugs in MSDE 2000 Service packs" 
    Date: Thu, 8 Jul 2004 04:41:43 +0200

    hi Ian,
    "Ian Boyd" <admin@SWIFTPA.NET> ha scritto nel messaggio
    news:%23fiy0DIZEHA.2516@TK2MSFTNGP10.phx.gbl...
    > How do you determine if an SQL Server is already installed?

    you can (locally) check the registry, instantiate SQL-DMO (which only tells
    if SQL-DMO is locally present) and try a connection to the server... this
    can be done via Ado/Ado.Net too...

    > If so, how do you detect if your database is already installed?

    query the database catalogue for it's name... SQL-DMO/Ado/Ado.Net

    > How do you detect if you login is already created?

    if you can't connect with that login, it's not there... or SQL-DMO or
    sp_helplogins 'login2test' via Ado/Ado.Net

    > If you login is not already created, but your database is, how do you
    relink
    > them?

    strange situation, isn't it? =;-D
    eventually, just re-add your login and grant db access, as long as all
    object privileges... SQL-DMO/Ado/Ado.Net

    > If you login is already there, but the database isn't how do you handle
    it?

    you just create the database... and then go on granting db access and object
    privileges... SQL-DMO/Ado/Ado.Net

    just use traditional common sense =;-) 

    -- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://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
  • Next message: Carl Karsten: "Re: Posible bugs in MSDE 2000 Service packs"

    Relevant Pages

    • Re: backupRestore progress bar
      ... SQL-DMO is an acronym for SQL Distributed Management Object and is a full ... object model to manage and administer SQL Server.. ...
      (microsoft.public.sqlserver.msde)
    • Re: Problem Executing Stored Procedures
      ... Both SQL Server and Agent are running under the Local System account so they ... should have enough privileges. ... The same application that is having problems with SQL-DMO also uses SQL-DMO ... and both procedures you are mentioning are run with success... ...
      (microsoft.public.sqlserver.msde)
    • RE: How to find available SQL Server on local network
      ... QueryInterface for interface SQLDMO.NameList failed??? ... > You can do this using SQL-DMO. ... > You can also connect to an SQL Server instance and enumerate all objects for ... >> Using VB.NET how can I find all available SQL Server on a local network and ...
      (microsoft.public.dotnet.general)
    • RE: How to find available SQL Server on local network
      ... Doesn't it show instances installed on local machine? ... > You can do this using SQL-DMO. ... > You can also connect to an SQL Server instance and enumerate all objects for ... >> Using VB.NET how can I find all available SQL Server on a local network and ...
      (microsoft.public.dotnet.general)
    • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
      ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
      (microsoft.public.sqlserver.connect)
    Loading