Re: No Security
- From: "John Reynolds" <jreynold@xxxxxxxxxx>
- Date: Wed, 8 Mar 2006 10:24:38 -0500
Well, here's my delimma:
I'm using SQL 2005 with XP Embedded on a Windows 2003 Server. All
applications installed successfully. When XP Embedded attempts to connect
to the databases to update them, it tells me it cannot connect and tells me
that possible reasons are security.
I think I'm just missing something. Security really isn't an issue. All
the users will have access to the databases and all will have full access.
No user will have more rights than the other. Basically it will be wide
open. This is why I thought turning off security would resolve this.
I would like to mention...............Usually XP Embedded is installed using
MSDE for the databases. However, we want to have a shared location for the
databases. We want to export the XP databases from a pc and import them
into an empty database on the server and connect to that server remotely to
work with the databases. We were informed that the only way to make this
happen was with SQL Server. Apparently this is not possible with MSDE.
Does anyone disagree with this?
Thanx!
"Kent Tegels" <ktegels@xxxxxxxxxxx> wrote in message
news:b87ad7414bf28c810a72b78e070@xxxxxxxxxxxxxxxxxxxxx
Hello John,
1. Is it possible to setup SQL 2005 with no security?
Generally speaking, no, since everything runs in a principal context. You
at least have to have "user" to do any queries, for example. You also need
a login into the instance to connect and do any work.
2. If not, how do I set it up to use windows users for
authentication?
You just install it using the defaults.
3. Does that type of authentication require Active Directory?
Not per se, it will use the local machine user account system on
non-joined machines. It also works with NT4-style directories.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
.
- Follow-Ups:
- Re: No Security
- From: Kent Tegels
- Re: No Security
- References:
- No Security
- From: John Reynolds
- Re: No Security
- From: Kent Tegels
- No Security
- Prev by Date: Re: No Security
- Next by Date: how to transfer logins between 2k5 instances
- Previous by thread: Re: No Security
- Next by thread: Re: No Security
- Index(es):
Relevant Pages
|
