Re: No Security

Hello John,

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 know virtually nothing about XP Embedded so I'll ask a question: does it participate in domain logins at all? That is, does a user have to sign into it to use? If not, you may not be able to use Integrated Security and would need to install and configure accounts using standard logins.

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?

More or less. Enterprise Manager (from SQL 2000) doesn't manage MSDE instances. SSMS (from SQL 2005) is supposed to however. You could, however, avoid the "move to server" step with it and just register the remote instances in SSMS.


Any other details you can share?

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/


.

Relevant Pages

  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... one BizTalk is installed on? ... machines (both for SQL and DTC) is not blocked by firewalls and new MSDTC ... Multi-computer configuration using Windows Server 2003 or Windows XP ... >>all associated databases. ...
    (microsoft.public.biztalk.general)
  • RE: Clustering a standalone SQL server + storage array
    ... working as expected with out error your ready to install sql server. ... log files to the data and log shared drives you setup as part of the cluster. ... Our apps team look after a trading system that uses an HP DL360 server ... running SQL 2000 SP3a with a few small databases on it. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 servers with multiple instances
    ... Microsoft SQL Server MVP ... given the same number of user databases. ... we've decided to use SQL 2005. ... SQL 2005 clustering? ...
    (microsoft.public.sqlserver.setup)