Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Login failure

Author  Topic  Liam Starting Member 6 Posts Posted - 2010-08-12 : 14:29:10 Hi I'm going crazy with this problem, hopefully you can help I have a Service broker queue with activation, this kicks off a stored procedure. Profiler and suser_sname() shows me this is executing as COMPANY\grounduser who is a sys admin. the database is set to trusted so I can access msdb to send emails with dbmail I can also do inserts / updates and deletes on the database. I can access stored procedures for spatialware if I login as COMPANY\grounduser in SSMS. However, I cannot execute a stored procedures for spatialware if I allow the broker queue to activate it (even though all info tells me its executing as COMPANY\grounduser, I get the following error Error: 18456, Severity: 14, State: 6. Message Login failed for user 'COMPANY\grounduser'. [CLIENT: <local machine>] * Exception Address = 10003DF4 Module(libspatialware+00003DF4) * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION * Access Violation occurred reading address 00000010 Exception happened when running extended stored procedure 'xp_rtree_bat_delete_trigger' in the library 'libspatialware.dll'. SQL Server is terminating process 169. Exception type: Win32 exception; Exception code: 0xc0000005. I have given as many privileges to COMPANY\grounduser as I can think of for the database, msdb and master. What is it unable to login to? any help greatly appreciated SS 2005 SP3 MapInfo Spatialware MS Server 2003