Creating a database with an MSDE installation

Hello,
I'm Trying to setup a XP workstation with the msde sql server engine, but I
can't find a way to create a database or import a database with it.
greetings
hi,
rgerla wrote:
> Hello,
> I'm Trying to setup a XP workstation with the msde sql server engine,
> but I can't find a way to create a database or import a database with
> it.
> greetings
MSDE comse with no tools but oSql.exe, a command line tool you can use for
both administrative task and DML operations.. please have a look at
http://support.microsoft.com/default...;EN-US;q325003 for further
info about oSql..
for your convenience, syou can have a look at a prj of mine, at the link
following my sign., which provide a free user interface similar to Microsoft
Enterprise Manager to administer and manage MSDE... further tools, both
commercial and free can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Using DBAMgr To access the MSDE installation I get the follow error while
trying to logon:
-2147203052 - [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
for user 'sa'. Reason: Not associated with a trusted SQL Server Connection
What am I doing wrong?
"Andrea Montanari" wrote:

> hi,
> rgerla wrote:
> MSDE comse with no tools but oSql.exe, a command line tool you can use for
> both administrative task and DML operations.. please have a look at
> http://support.microsoft.com/default...;EN-US;q325003 for further
> info about oSql..
> for your convenience, syou can have a look at a prj of mine, at the link
> following my sign., which provide a free user interface similar to Microsoft
> Enterprise Manager to administer and manage MSDE... further tools, both
> commercial and free can be found at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
rgerla wrote:
> Using DBAMgr To access the MSDE installation I get the follow error
> while trying to logon:
> -2147203052 - [Microsoft][ODBC SQL Server Driver][SQL Server]Login
> failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server Connection
> What am I doing wrong?
MSDE installs by default enabling only WinNT (trusted) connections and
disabling standard SQL Server connections (userid=xxx; password=xxx)
you can modyfy this behaviour both at install time, specifying the
SECURITYMODE=SQL parameter to the setup.exe MSDE boostrap installer, or
later, at run time, modifying a Windows registry key,
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
for a default instance,
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
LoginMode=2
for a named instance...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply