Re: Newbie: guest account with SSPI
From: Jeff Dillon (jeff_at_removeemergencyreporting.com)
Date: 11/04/04
- Next message: news.microsoft.com: "Copy DB structure into a new DB"
- Previous message: Sasan Saidi: "RE: Best way to setup data structure"
- In reply to: steve: "Newbie: guest account with SSPI"
- Next in thread: Bob Simms: "Re: Newbie: guest account with SSPI"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 4 Nov 2004 09:30:15 -0800
At a mininum, you need to add a SQL login for MYDOMAIN/johnd
However, may I suggest you create a Local Group on the SQL Box, add domain
users to the Local Group, then create a login for this group
Jeff
"steve" <noemail.@try.com> wrote in message
news:S%sid.15419$v03.79247@wagner.videotron.net...
> Hi,
> I have the following problem:
>
> I have created a VB application where the connection string uses SSPI. I
> think this is Windows Authentication. I dont provide any specific
> username/pass
>
> I am the owner of my database and I asked the admin to add 2 more users as
> dbo's.
>
> The tables belong to dbo and I have mingled with all sorts of permissions
> through Enterprise Manager.(basically right clicked everywhere and gave
> everybody at least datareader privileges)
> The two dbo's have no problem accessing the database through the VB
> interface. However no one else from the same Windows Domain can login. We
> get the message "Login failed for user MYDOMAIN/johnd ".
>
> In the guest account Login Name column there is no entry, which i think is
> right.
>
> 1) Is this a Windows Authentication problem or an SQL server problem?
>
> 2)Instead of me asking my colleagues to run the application everytime i
> change the settings in my DB, is there a way to emulate a guest account
> access in the DB?
>
> TIA
> -steve
>
>
>
- Next message: news.microsoft.com: "Copy DB structure into a new DB"
- Previous message: Sasan Saidi: "RE: Best way to setup data structure"
- In reply to: steve: "Newbie: guest account with SSPI"
- Next in thread: Bob Simms: "Re: Newbie: guest account with SSPI"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
