Installing MSDE 2000 Release A on a XP Home Machine

Hi,
I'd like to install MSDE 2000 Release A on a XP Home machine via the
command-prompt switches and parameters. I have two areas of ignorance:
1) At first blush, it seems to me that I'll have disparate server names. By
this I mean that when I install MSDE on my computer to conduct the
development, it will have the name "Server_Name"\"Instance_Name". My
server's called "Dell," So I'll have a MSDE instance of,
DELL\"Instance_Name" On the other hand, the target server, an XP Home
machine, is called "SherPerf." So this server instance will be named
SHERPERF\"Instance_Name"
I plan on using an Access adp front end. I don't know how to code viable
connection strings around disparate server names. I.E. in development I'm
connecting to server name #1; but, in production I'm connecting to server
name #2.
What am I missing?
2) If I want to use Windows Authentication, should I create a new user? If
so, what groups should this user be part of? Is it standard practice to
create a user account for MSDE programmatically? If so, how do I do this?
LDAP?
I realize this is a lot to ask. Thanks in advance.
--
Mark Holahan
You application should utilize a configuration file or the registry to store
the ADO connection string or the parameters for the connection string. Then
you would simply change the configuration information to point to another
server. Making a connection string for a different server is easy - just
replace one server name with another. See the Books Online for more
information about ADO or ADO.NET connection strings and how to construct
them.
Jim
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:unoBXFtDFHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I'd like to install MSDE 2000 Release A on a XP Home machine via the
> command-prompt switches and parameters. I have two areas of ignorance:
> 1) At first blush, it seems to me that I'll have disparate server names.
> By this I mean that when I install MSDE on my computer to conduct the
> development, it will have the name "Server_Name"\"Instance_Name". My
> server's called "Dell," So I'll have a MSDE instance of,
> DELL\"Instance_Name" On the other hand, the target server, an XP Home
> machine, is called "SherPerf." So this server instance will be named
> SHERPERF\"Instance_Name"
> I plan on using an Access adp front end. I don't know how to code viable
> connection strings around disparate server names. I.E. in development I'm
> connecting to server name #1; but, in production I'm connecting to server
> name #2.
> What am I missing?
> 2) If I want to use Windows Authentication, should I create a new user? If
> so, what groups should this user be part of? Is it standard practice to
> create a user account for MSDE programmatically? If so, how do I do this?
> LDAP?
> I realize this is a lot to ask. Thanks in advance.
> --
> --
> Mark Holahan
>
|||Thanks Jim! Yes...of course. Can you tell I haven't done this before?
Do you have any comment regarding my second question?
Many thanks.
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:%23ioGNN0DFHA.3536@.TK2MSFTNGP15.phx.gbl...
> You application should utilize a configuration file or the registry to
> store the ADO connection string or the parameters for the connection
> string. Then you would simply change the configuration information to
> point to another server. Making a connection string for a different server
> is easy - just replace one server name with another. See the Books Online
> for more information about ADO or ADO.NET connection strings and how to
> construct them.
> Jim
> "Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
> news:unoBXFtDFHA.2600@.TK2MSFTNGP09.phx.gbl...
>
|||Regarding question #2 - If your computers are not a member of a domain then
Windows authentication will be of less importance and all user will be local
to the machine they are running on. If you have the chance to use Windows
security then what groups the users are a member of is entirely up to you.
Ideally you would make the groups the logins to the server and the add the
user to the groups. That way you do not have to add each user individually
as a login to the server.
Jim
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:eaXlKZ2DFHA.3824@.TK2MSFTNGP10.phx.gbl...
> Thanks Jim! Yes...of course. Can you tell I haven't done this before?
> Do you have any comment regarding my second question?
> Many thanks.
>
> "Jim Young" <thorium48@.hotmail.com> wrote in message
> news:%23ioGNN0DFHA.3536@.TK2MSFTNGP15.phx.gbl...
>

Installing 2000 Client via SMS

Can someone point me to documentation on how to install the SQL Client
install via SMS to include the developer libraries? Our SMS admin has
created a package using WISE, but cannot get it to install consistently.
HELP!
Check out BOL topic Performing an Unattended Installation for information on
using SMS
"Cathy Soloway" wrote:

> Can someone point me to documentation on how to install the SQL Client
> install via SMS to include the developer libraries? Our SMS admin has
> created a package using WISE, but cannot get it to install consistently.
> HELP!
|||Thanks, but we've long since reviewed them.
"Douglas Guerena" wrote:
[vbcol=seagreen]
> Check out BOL topic Performing an Unattended Installation for information on
> using SMS
> "Cathy Soloway" wrote:

Installation fails for SQL Server 2000

I have attempted to install SQL Server 2000 as the default
instance. Maybe, it is because I attempt to install via
Remote Access.
In this way, I terminate the task. However, I am not able
to remove the default instance (That is terminated before)
AND when I attempt to install again, it asks me to create
a new instance.
Would it be possible for me to remove the corrupted
default instance and install it again ?
ThanksPeter
In Add/Remove programs (Control Panel) you can uninstall SQL Server , can't
you?
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:072701c5b1da$cf5d43f0$a601280a@.phx.gbl...
>I have attempted to install SQL Server 2000 as the default
> instance. Maybe, it is because I attempt to install via
> Remote Access.
> In this way, I terminate the task. However, I am not able
> to remove the default instance (That is terminated before)
> AND when I attempt to install again, it asks me to create
> a new instance.
> Would it be possible for me to remove the corrupted
> default instance and install it again ?
> Thanks|||Hi,
Restart ur machine and try to unstall sql server.
else u can go to control panal remove /add programes and remove sql
server.
or u can over write a new installation on ur previous installation
hope this helps u
from
doller|||I am not able to uninstall SQL Server via Remove / Add programmes.
I have attempted to run setup.exe and try the uninstall option but it still
doesn't work.
Thanks
"doller" <sufianarif@.gmail.com> wrote in message
news:1125901237.773629.261220@.g47g2000cwa.googlegroups.com...
> Hi,
> Restart ur machine and try to unstall sql server.
> else u can go to control panal remove /add programes and remove sql
> server.
> or u can over write a new installation on ur previous installation
> hope this helps u
> from
> doller
>