Re: Login without password

From: BP Margolin (bpmargo@attglobal.net)
Date: 08/02/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Fri, 2 Aug 2002 13:59:46 -0400

Sarah,

Consider contacting Microsoft Product Support Services ;-(

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"sarah wong" <sarah@hkpc.org> wrote in message
news:uNmGTedOCHA.1620@tkmsftngp13...
> I've checked the database, there is no "GUEST" user.
> What else can I do?
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Guest account in SQL 2005?
    ... The guest account in SQL Server serves the same basic function as the ... just like you wouldn't grant permissions to the Everyone group in Windows. ... priviledges in the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Is there a way to Use an Application Role with more than one database?
    ... So you are still getting the 'is not a valid user in database' error? ... Did you enable the guest user? ... permissions to systems objects in the ProductionDB?) ... EXEC sp_dboption 'DevelopmentDB', 'db chaining', true ...
    (microsoft.public.sqlserver.security)
  • Re: Guest account in SQL 2005?
    ... You should not need go grant permissions to the guest user as that defeats ... Did you set DB_CHAINING ON for both database A and B? ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Guest Account
    ... The guest accout is a way for people to access a database - NOT the sever. ... There is no login that is directly associated with guest... ... As for the guest account in Northwind/Pubs - yes, ...
    (microsoft.public.sqlserver.security)
  • The sql sever is sql2000 standard edition running on win2000
    ... > to grant stored procedures execution permition to role, ... Master database get Information_Shema as a user. ... > database", sp_helpuser did not show guest user, enterprice manager show it ...
    (microsoft.public.sqlserver.security)