|
|
 |
RE: FN-FORUM MSDE Database....
date posted 18th January 2003 10:01
MSDE authentication mode can be changed from the registry. The following
key controls how MSDE is autheticated;
HKEY_LOCAL_MACHINESOFTWAREMicrosoft MSSQLServerMSSQLServerLoginMode
Values are:
0 = Windows authentication
1 = Mixed mode (Either Windows or IP/UID/PWD connections)
2 = IP/UID/PWD connections only
Note that the default sa password after install is null.
-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] On Behalf Of Andy
Macnaughton-Jones
Sent: 17 January 2003 22:34
To: [EMAIL REMOVED]
Subject: RE: FN-FORUM MSDE Database....
I've installed MSDE several times without any problems. Just did the
full install and job done. When you install it though, the system
account is set for windows authenticaion only so you can't login via IP
and SQL Server persmissions. So you have to use enterprise manager on
the SAME machine (or at least on the domain that you have windows
authentication rights on) to then change the server settings to SQL
authentication and then you can use the standard IP/UID/PWD type
connections.
-----Original Message-----
From: James Murphy [EMAIL REMOVED]
Sent: 17 January 2003 21:37
To: [EMAIL REMOVED]
Subject: Re: FN-FORUM MSDE Database....
Quoting Julian Templeman [EMAIL REMOVED]
> Anyone here know anything about getting the desktop engine version of
> SQL Server to run?
I didn't keep notes, but I do recall this being a tad more interesting
than
perhaps it might have been.
Two questions: First, did you change anything from the default params as
it
went in; Second, is there a little app running in your tray to control
the
database?
James Murphy
Consett, County Durham.
========
Advertise with Freelancers.net +Additions+
http://www.freelancers.net/advert.php
Freelancers and Freelance Jobs:
http://www.freelancers.net
Forum FAQs:
http://freelancers.netrickery.com
To unsubscribe please email:
[EMAIL REMOVED]
If you have difficulties unsubscribing please email:
[EMAIL REMOVED]
---
[This E-mail scanned for viruses by Declude Virus]
========
Advertise with Freelancers.net +Additions+
http://www.freelancers.net/advert.php
Freelancers and Freelance Jobs:
http://www.freelancers.net
Forum FAQs:
http://freelancers.netrickery.com
To unsubscribe please email:
[EMAIL REMOVED]
If you have difficulties unsubscribing please email:
[EMAIL REMOVED]
|
|
|
