Re: Installation OK, but can't connect

From: Daniel Strigard (anonymous_at_discussions.microsoft.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 07:56:11 -0800

Hi again Andrea.
Thanks for bearing with me. Hope you aren't boored with me
yet. :) I still have some questions.

>what you can do is using application role

I don't need different roles. Any user of my program must
be able to create and edit the database.

>you only have to add those login/users at install time
and you can even
>hardcode (or better parametrize) those users in your
connection string...

You mean i use "User Id=PredeterminedUser", and then I
tell the person installing to create a user
named "PredeterminedUser"? Can't I create the
PredeterminedUser myself?

>but the server name still remain a variable becouse it is
not known till
>deployment finished..

How do I get the current server name, to assign to my
variable?

>if you install MSDE up to sp3a with default parameters,
the network
>protocols will be disabled so there woul'd be no external
access problem,
>but your MSDE will act as a single desktop database
server...

Thats all I need! I want my application to be a single
desktop application. (Will there be problems if the user
edits MSDE, or already have MSDE or SQL Server installed?)

>anyway, SQL Server and MSDE are quite one click
deployment solutions...

I've found a document on MSDN that explains how to deploy
MSDE together with my program, but It seems to be a quite
complex procedure. If I'm going to take time to do that, I
need to know exactly what the end user has to do when
installing. In what way do I use SQL Server to minimize
the user input on install and setup of MSDE?

Lots of questions, I know, but SQL Serve generates quite a
few questions for me. And I don't understand all I find on
MSDN.

I really appreciate that you help me out Andrea.
/Daniel

Relevant Pages

  • Re: Program FilesMicrosoft SQL Server80?
    ... > When installing MSDE onto the d: ... Are theses things needed for MSDE to ... among all instances with different service pack level, ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: Basic "getting started" Info on MSDE 2000?
    ... > I am looking for basic info on installing and using MSDE. ... > I am trying to install and play with MSDE on my PC. ... SQL Server runs as a service, and you should start it from the ...
    (comp.databases.ms-sqlserver)
  • Re: SQLServerAgent???
    ... >> events in the Event Log, it seems to do something with the network. ... > If both services are 'started', you are running an instance of SQL Server ... > (or MSDE) on your computer. ... > and installing MSDE, then it was installed as part of another application ...
    (microsoft.public.win2000.general)
  • Re: SQL Server Service Manager not started unless network protocol support enabled.
    ... > I am using MSDE as the backend to a VB application I am building and have ... > 1) When initially installing the instance I opted to specify an Instance ... >discovered that I need to enable network support for this to work. ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
Quantcast