Re: Desktop Engine User Login

From: Andrew J. Kelly (ajkellynospam_at_attbi.com)
Date: 04/26/03 

Date: Fri, 25 Apr 2003 19:19:23 -0400

You should check out BooksOnLine. This is the help file for sql server and
has much information to help you use osql and the associated commands. You
might want to check out sp_addlogin as well. Here are some links for some
utilities to manage an MSDE instance.

http://www.aspenterprisemanager.com/ MSDE & Web Tool
http://www.support.microsoft.com/?id=325003 Manage MSDE with oSql
http://www.zeta.org.au/~extrasql/
Low cost Web Admin tool
http://microsoft.com/downloads/details.aspx?FamilyId=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en
Web Admin app
http://www.laplas-soft.com/exec-intro.htm 

-- 
Andrew J. Kelly
SQL Server MVP
"Marc" <marcblakely@toast.net> wrote in message
news:021201c30b68$64e501e0$a401280a@phx.gbl...
> Could someone inform me on how to create a user id for the
> Desktop Engine so that I may access it through a local Web
> application?
>
> I am new to SQL Server and understand the Desktop Engine
> does not have a GUI Admin app.  I've also researched and
> discovered the osql dos prompt utility, but it's not
> exactly user friendly.
>
> Could anyone help this budding Web application developer
> in accessing SQL Server Desktop Engine.
>
> Thank you to all who reply!
>
>

Relevant Pages

  • Re: Create Job to dump SP results into a text file.
    ... But its output is in a strange format. ... > As the first content you get, it is because the missing of some switches in> the OSQL utility, and the -L is an exclusive switch in osql utility, so you> get the content of 'The -L parameter can not used in combineation with> others parameters.' ... Could you connect the SQL Server via Query Analyzer by SQL Server> authentication using 'sa'? ...
    (microsoft.public.sqlserver.programming)
  • RE: windows update error SBS2003
    ... Critical Update for SQL Server 2000 Desktop Engine on Windows ... "adaniel" wrote: ... > events when Windows Update tries to install an update for SBS2003. ...
    (microsoft.public.windows.server.sbs)
  • Re: Create Job to dump SP results into a text file.
    ... the OSQL utility, and the -L is an exclusive switch in osql utility, so you ... Could you connect the SQL Server via Query Analyzer by SQL Server ... To enable TCP/IP server network library by the Server Network Utility, ...
    (microsoft.public.sqlserver.programming)
  • Re: Can you use osql in DTS?
    ... Columnist, SQL Server Professional ... > osql. ... > DECLARE @curDate As DateTime ... > @chartime into a stored procedure that I would call. ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... Columnist, SQL Server Professional ... > osql. ... > DECLARE @curDate As DateTime ... > @chartime into a stored procedure that I would call. ...
    (microsoft.public.sqlserver.programming)