From the local PC windows authentication seems to work, but from remote pc's
te client seems to logon as guest.
Do i need to install MSDE on a windows server edition to get the windows
authentication working ?

Appreciate if any friends here can do me a favour by telling me whether MS
SQL Server 2005 Express can be installed on Windows XP Embedded ?
I have run the SQL setup file and while the setup process was trying to
start the SQL database service, the Setup screen prompted "The SQL ...

i'm trying to upgrade to sp4 using the following command:
<setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
UPGRADEPWD=password /L*v C:\MSDELog.log>
it starts, then stops, without giving me an error.

Our clients are using MSDE. Our VB application provides simple full backup
feature usng DMO. We have noticed that their recent backup size goes to 2GB.
to investigate, When backup taken from enterprise manager it is 60 MB. What
could be the rerasons?. The clients are doing ...

Beim Umschreiben einer Abfrage von Access XP auf SQL (bzw. MSDE)
bin ich auf ein interessantes Problem gestossen.
Gem. Access Hilfe ist die T-SQL Funktion für Weekday
DATEPART(dw,x)

In the icon tray is the SQL icon with a green arrow that briefly shows a red
dot to the lower right of the arrow.  All programs that use SQL work fine.
I am just wondering what the red dot means?  It is like a heart beat to show
it is acitive?  Or does it indicate an issue?

We are in dire need of a redistributable Profiler for MSDE installed on
our
client's machines.
Does anyone know:

I created a small test app that opens an sql database on the same machine
(TESTPC).
When i move the compiled app to another pc in the network i receive this
error:

I'm trying to install some apps onto one of my server 2003 boxes, on one
server it all goes fine, on the other however the msde installations all
give up and rollback I just get errors in the event logs that state that the
installation failed. Any ideas? It won't even let me install ...

When I run a backup sentence, query analizer shows me anything like this:
The string could be crypted 0x80090016 (KeySet doesn't exist)
any idea?
Thanks,,

Anyone know of a tool (hopefully free???) to capture sql queries sent to and
MSDE 2.0 database?  

I wonder if it is allowed to use SQL 2000 Enterprise Manager to manage all
of the MSDE installatie we have?
We have a SQL 2000 server. But the MSDE database used on some laptops have
nothing to do with the SQL Server.

First my apologize for cross posting. It's already posted in
sqlserver.programming. But I see this group would also help me.
I'm creating an appplication with some stored procedures. The stored
procedure needs to return the @@Identity of the table's new record. The

When i call ADOConnection.Connected := False
The connection with the MSDE server is still opened, why that?
I want to close that connection with the server
The connection is only closed when my application is terminated

I'm about to install an MSI-packaging software, which needs either MS SQL
(we don't have it) or MSDE. I already have WSUS running and it uses WMSDE.
Can I install install MSDE (distributed with the software) without screwing
up WSUS/WMSDE?