Integrated Security in a Workgroup?

From: Bill Cohagan (bill_at_teraXNOSPAMXquest.com)
Date: 12/01/03 

Date: Mon, 1 Dec 2003 16:20:01 -0600

I'm trying to set up a development environment for developing an ASP.Net app
that needs to access an SQL Server 2000 database. The development will be
taking place on two distinct machines, both in the same workgroup, but there
is no domain or domain controller. Visual Studio.Net (and the ASP app
itself) reference the database using a local account named <machine>\ASPNET.
On machine "B" (where the SQL Server is running) I had no problem setting up
permissions on tables, etc. using user B\ASPNET. But apparently I cannot set
up an account on machine B with the name A\ASPNET (which is what the
development environment on machine A needs).

So, any suggestions on how to all a developer on machine A to use Visual
STudio.Net (2003) to access SQL2000 on machine B via a user id of A\ASPNET?

Thanks in advance,
 Bill

Relevant Pages

  • Re: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)
  • Re: MSVC++ app type choice, form design questions
    ... > 1) MSVC Project definition requires that for an MFC app I choose ... MFC's built-in database support is really built around the document/ ... with the full version of SQL Server, but it's still pretty usable -- ...
    (microsoft.public.vc.mfc)
  • Re: SQL Licensing
    ... it depends on the features you used in your database development. ... If your app works with Express, then go with it not to buy license for SQL Server instances. ...
    (microsoft.public.sqlserver.clients)
  • Re: MSVC++ app type choice, form design questions
    ... >> 1) MSVC Project definition requires that for an MFC app I choose ... At startup the end user sees a summary of the database contents. ... MDAC has full built-in support ... >competing with the full version of SQL Server, ...
    (microsoft.public.vc.mfc)
  • Re: Good Books on SQL Server Mobile
    ... Server 2005" there's a chapter on SQL Server Everywhere Edition, ... database applications using SQL Server Mobile? ... exact process of building and deploying a mobile database. ...
    (microsoft.public.sqlserver.ce)