Re: Q: Named pipes and Windows (integrated) authentication

From: Michael C (nospam_at_lol.net)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 01:49:05 GMT

By the way, if you don't have SQL Enterprise Manager, there's an MSDE
version available from http://www.valesoftware.com. I would recommend using
something with a GUI interface to set up your MSDE - it's a lot easier than
using osql.

Thanks,
Michael C.

"Lou Arnold" <Lou_Arnold@nospam.com> wrote in message
news:40fc4a07.19880216@nntp.flfrd.phub.net.cable.rogers.com...
> Kevin...
> I log in as the Administrator on both machines.
>
> > Trusted Connections or Windows Authentication is when the client uses
> >his windows authentication to connect to the server. If you are not in a
> >domain, then you'd have to use Workgroup security to make this work.
> >A user needs first to be able to authenticate to the server either using:
> > a) Windows credentials
> > b) SQL username and password
> Lou>> Don't understand what you mean by Workgroup security. Are you
> saying I cannot use Windows Authentication? The other choices are
> Mixed or SQL Server security modes. The objective was to use Windows
> "credentials", but is this possible without a domain controller??
>
> >Once you've connected, it will check your credentials for permission to
> >create objects like databases or stored procedures.
> Lou>>Yes, understood.
>
> >Creating databases is only acomplished after you've already connected.
Try
> >using the SQL tools to see if your user has the correct privledges.
>
> Lou>>Don't know which SQL tools unless you are referring to osql.exe
> or MSDE Plus.
> Lou>> However, since I log onto the MS Access computer as the
> Administrator, will this not let me create a database on the server
> computer?? If not, How would I configure the permissions to allow me
> to do this?
> Lou>>Thanks.
>

Relevant Pages

  • Re: Q: Named pipes and Windows (integrated) authentication
    ... >By the way, if you don't have SQL Enterprise Manager, there's an MSDE ... >>>his windows authentication to connect to the server. ... >>>Creating databases is only acomplished after you've already connected. ...
    (microsoft.public.sqlserver.connect)
  • Re: MSDE - list databases, describe tables, migrate from Access?
    ... Go into SQL prompt using ... > I am new to SQL Server but have been using Access for a while. ... > installed MSDE to evaluate it for use in small business ... > I can't see how to get the list of databases, tables, and columns that I ...
    (microsoft.public.sqlserver.server)
  • GUI utility for MSDE with DTS
    ... I know there's plenty of MSDE managment utilities out there to help us with ... a nice GUI for MSDE. ... What I like about using Enterprise Manager which comes with the SQL Server ... I need to import data from other databases on my workstation via non-SQL ...
    (microsoft.public.sqlserver.msde)
  • Re: Logging to MSDE
    ... > MSDE is a performance limited version of MS-SQL. ... You will need to use something else to setup the databases. ... > So with that in mind setting up ISA for MSDE should be identical to ... setting it up for SQL 2000. ...
    (microsoft.public.isa.configuration)
  • Re: Using MSSQL 2000 database in MS Access?
    ... While I have experience with MSSQL via the developer ... Can databases developed for use by MSSQL 2000 be used by MS Access 2000 ... process for use of my MS SQL databases by MS Access 2000 or later users. ... > server you should have a license to redistribute MSDE. ...
    (borland.public.delphi.database.ado)