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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Lou Arnold (Lou_Arnold_at_nospam.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 22:53:51 GMT

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: Cant create ADP database on MSDE using MS Access
    ... but no database is created and I ... > I've tried the SQL Server group but they can't solve it. ... > potential requirement for named pipes if Windows Authentication is to ... "Administrator" and "SA" are still 2 different ...
    (microsoft.public.access.setupconfig)
  • Re: security error in IIS logs (401.2 error)
    ... I initially thought it was being blocked by a proxy on our network. ... "Integrated Windows authentication is disabled by default if you ... Server 2003 w/ SP-1. ... I have attached my IIS log below. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Windows authentication from ASP.net application to Sql Server
    ... | Subject: Re: Windows authentication from ASP.net application to Sql Server ... | server or on the same server with the IIS/ASP.Net? ... Use a single fixed impersonate account, ... | client/server to use restricted kerberos delegation which has critical ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cant link a document in the project server 2003 PWA
    ... I have windows authentication enabled for users. ... for userid and password while accessing documents, issues, risks. ... work fine on server where wss and project server is installed. ... and change my account to use windows authentication, ...
    (microsoft.public.project.pro_and_server)
  • Re: Windows Authentication Access Denied Error
    ... on all the folders specified on msdn for asp.net required access list ... It confirms that the issue has nothing to do with IIS and is specific ... using Windows Authentication. ... SQL Server Express engine are installed to the E directory on the server. ...
    (microsoft.public.inetserver.iis.security)