🚀 go-pugleaf

> I've been given an export from SQL Server with all the data. Do you
> know if it would be possible to load this into MSDE?

MSDE is fully functional MS SQL Server just with some little restrictions (5
concurent users and 2 GB database limit).

> User name.

This could depend on installation - if you are using Windows
authentication - connection string in ADO should include "Integrated
Security=SSPI;" and no UserID and Password. Another option is SQL Server
authentication - by default user "sa" is installed with blank password (if
you did not entered password while setup process) - try user name "sa"
(without quotes) and your password or empty password.

Service should be started too - reboot or start service manually. You do not
need domain controller or netword at all. However Windows 2000 or Windows XP
may be needed - I am not sure that MSDE will run on Win9X.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Simon Elliott" <Simon at ctsn.co.uk> �������/�������� � �������� ���������:
news:40b45285$1@newsgroups.borland.com...
> On 26/05/2004, Viatcheslav V. Vassiliev wrote:
> > You can use MSDE (MS SQL Server Desktop Edition - that ships with MS
> > Office, MS Visual Studio etc.) - it MS SQL Server will slow down if
> > there are more than 5 concurent connections (really this means that
> > usually you can have even 100 users) and limit databases to 2 GB.
> >
>
> I'm having a few problems getting MSDE to work. I've installed it from
> my Office 2000 disks but I can't log into it from the osql command line
> utility.
>
> When I installed it, it set up a user for me, the same user as the
> current windows user. I gave it the same password as the current
> windows user to avoid confusion. But now osql won't let me log in as
> this user.
>
> I can't even uninstall it to try to install again as the unintalls
> hield says that a file is in use even when the service is stopped.
>
> Do I need a domain controller or some such on my network before this
> will work? I hope not because currently I don't have one.
> -- 
> Simon Elliott    http://www.ctsn.co.uk