I have VB. NET
I want to build SQL databases on my own PC using VB and
MSDE.
No matter how many ways I install it or passwords I use,
I just cannot get read/write access from witihn VB. I
have upsized the Northwind.mdb.
There seems to be a multidude or service packs for MSDE
and numerous ways of entering passwords.
Could osmeone please just give me a setp by step account
of installing MSDE (with all relevant switches and
passwords), getting a SQL instance on MSDE running and
visible on the manager, upsizing the access database
(with all relevant passwords - what the hell is a trusted
connection?), and then be able to create a view from the
Server Explorer in .NET.
I've been slaving over this for the past two days and
it's driving me nuts. Please help maintain my sanity.
Thanks
Guy
Hi ,
Following are the various parameters available for installing msde along
with examples:
Most installations of MSDE 2000 Release A are made using only these Setup
parameters:
Parameter Description
SAPWD="AStrongPassword" Specifies a strong password to be assigned to the
sa administrator login.
INSTANCENAME="InstanceName" Specifies the name of the instance. If
INSTANCENAME is not specified, Setup installs a default instance.
Other parameters often used to tailor an installation are:
Parameter Description
DISABLENETWORKPROTOCOLS=n Specifies whether the instance will accept
network connections from applications running on other computers. By
default, or if you specify DISABLENTWORKPROTOCOL=1, Setup configures the
instance to not accept network connections. Specify
DISABLENETWORKPROTOCOLS=0 to enable network connections.
SECURITYMODE=SQL Specifies that the instance be installed in Mixed Mode,
where the instance supports both Windows Authentication and SQL
Authentication logins.
DATADIR="data_folder_path" Specifies the folder where Setup installs the
system databases, error logs, and installation scripts. The value specified
for data_folder_path must end with a backslash (\). For a default instance,
Setup appends MSSQL\ to the value specified. For a named instance, Setup
appends MSSQL$InstanceName\, where InstanceName is the value specified with
the INSTANCENAME parameter. Setup builds three folders at the specified
location: a Data folder, a Log folder, and a Script folder.
TARGETDIR="executable_folder_path" Specifies the folder where Setup
installs the MSDE 2000 executable files. The value specified for
executable_folder_path must end with a backslash (\). For a default
instance, Setup appends MSSQL\Binn to the value specified. For a named
instance, Setup appends MSSQL$InstanceName\Binn, where InstanceName is the
value specified with the INSTANCENAME parameter.
When you use DISABLENETWORKPROTOCOLS=0 to enable network support for an
instance of MSDE 2000, applications connecting to the instance over a
network use Microsoft Data Access Components (MDAC). All versions of
Windows supported for use with MSDE 2000 include a version of the MDAC
software that works with MSDE 2000 Release A.
* A trusted connection means the login used to login used to log on to the
machine is the same used by all the applications on the machine for any
authentication mechanism.
Hope this provides you with an answer
Girish sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment