Re: Here's a rather broad question...

Just as an FYI, for anyone who might care, either now or in the future while
searching through archives...

It turns out the reason IUSR_[MachineName] wasn't part of the selectable
user list for my database (to grant it access) was that this user first had
to be added under the Security entry for the server itself (NOT just the
database)--it had to be added to the 'global' login list. I'm probably not
explaining this quite right as I don't have it in front of me, but suffice
it to say that once I added this user, it became selectable from within that
database.

Which leads me to believe that if I backed up the database, blew away SQL
Server and then reinstalled it (and restored the database) I'd still have to
recreate that user on the server, since the only thing the backed up
database itself contains is a reference to that other list defined for the
server...correct?


.

Relevant Pages

  • Re: What would you use?
    ... If they want to make use of their existing MS SQL Server then, as Alessandro suggested, you can use SQL Express. ... The database is still full MS SQL Server, so should an office outgrow Express, there's no problem upgrading them. ... It's not the browser interface, it is the difference between Paradox access, especially if on a local network, vs accessing a server database, especially if across the internet. ... a browser app, then there is no reason to *also* maintain a desktop GUI. ...
    (borland.public.delphi.non-technical)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)