Re: Creating SQL Server Databases With No Security Restrictions
From: Peter van der Goes (p_vandergoes_at_toadstool.u)
Date: 02/10/05
- Next message: Sue Hoegemeier: "Re: Monitor user changes"
- Previous message: JJ Wang: "NT scheduled tasks"
- In reply to: Ross Presser: "Re: Creating SQL Server Databases With No Security Restrictions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 10 Feb 2005 06:18:24 -0600
"Ross Presser" <rpresser@imtek.com> wrote in message
news:uauu8880rpzp$.dlg@rpresser.invalid...
> On Tue, 8 Feb 2005 12:50:40 -0600, Peter van der Goes wrote:
>
> Perhaps this would do the trick:
>
> EXECUTE sp_grantdbaccess guest
> EXECUTE sp_addrolemember 'db_owner',guest
>
> Sorry, but I couldn't find an equivalent to this in Enterprise Manager, so
> execute it from Query Analyzer.
Unfortunately, the commands didn't alter the situation. However, through
additional experimentation, I've discovered the following:
The database itself is OK, as I can access it in Enterprise Manager. In
Server Explorer, the database appears, but its State property says
"Disconnected" and I get the SQL Server authentication dialog when Server
Explorer attempts to connect. I've checked the database file's network
security properties, and they appear to be set the same as those for the
database files (from the book) that I am able to access in Server Explorer.
Public has full access. I'm beginning to think I'm dealing with a NTFS file
or folder access issue, as the same database is fully accessible through
Server Explorer on a PC with a FAT32 partition?!?
- Next message: Sue Hoegemeier: "Re: Monitor user changes"
- Previous message: JJ Wang: "NT scheduled tasks"
- In reply to: Ross Presser: "Re: Creating SQL Server Databases With No Security Restrictions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
