Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

The server principal "domain\sqlman" is not able to access the database "test_DBA" under the current security context Expand / Collapse
Author
Message
Posted Saturday, December 5, 2009 6:35 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, September 19, 2014 10:19 AM
Points: 3,087, Visits: 1,435
Hi Bhuvnesh,

Did any of the suggestions help you to solve your problem?





My blog
Post #829388
Posted Monday, May 24, 2010 7:57 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 3, 2010 7:11 PM
Points: 17, Visits: 152
I found the solution to this problem.

use msdb
grant connect to guest
go

Aaron


Aaron
MCITP: Database Administrator, MCITP: Server Administrator, MCTS: Windows Server 2008 Active Directory – Configuration, MCTS: Windows Server 2008 Network Infrastructure – Configuration, MCTS: Windows Server 2008 Application Platform – Configuration, MCTS: SQL Server 2005, MCTS: Microsoft Exchange Server 2007 – Configuration, MCSE 2003, MCSA 2003, MCDBA, Security+, CCNA
https://www.mcpvirtualbusinesscard.com/VBCServer/AaronChristenson/interactivecard
Post #926849
Posted Wednesday, March 16, 2011 1:33 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 26, 2014 6:00 AM
Points: 39, Visits: 301
Thanks -- I had this problem too! The company I work for has things screwed down tight such that the public group can't connect to the db.
Post #1079267
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse