Re: Q: Named pipes and Windows (integrated) authentication
From: Lou Arnold (Lou_Arnold_at_nospam.com)
Date: 07/21/04
- Previous message: Michael C: "Re: Q: Named pipes and Windows (integrated) authentication"
- In reply to: Michael C: "Re: Q: Named pipes and Windows (integrated) authentication"
- Next in thread: Lou Arnold: "Re: Q: Named pipes and Windows (integrated) authentication"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 02:57:56 GMT
Michael,
I understand your comment but your suggestion evades the purpose of
thsi testbed - to establish a configuration for development using
onl;y MS Access. Otherwise we would not be pursuing this matter for
this long. The objective is not just the creation of tables via any
means.
Lou.
PS. Once we release this testbed for more development trials, the
developers will be using MS Access to vreate table.
---- On Wed, 21 Jul 2004 01:49:05 GMT, "Michael C" <nospam@lol.net> wrote: >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. >> > >
- Previous message: Michael C: "Re: Q: Named pipes and Windows (integrated) authentication"
- In reply to: Michael C: "Re: Q: Named pipes and Windows (integrated) authentication"
- Next in thread: Lou Arnold: "Re: Q: Named pipes and Windows (integrated) authentication"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
