H
I'm experiencing a weird problem, I have a sql server running with lots of different database and corresponding user to each database. Now the problem is that when a given user connects through EM the database in in EM list "no items" for all users except one, and the sa. Now I have just reinstalled the server, thought it was a problem in the software, attached the databases and added the users all the same way, no special settings except for the assign of access as dbo to their own database
Even creating a new database, and adding a new user results in the same stuff...
On my local development machine, doing the exact same thing dowsn't result in the mentioned behavoir
WHY? (the desparate dba)Found that everytime a user who cannot acces databases connects this shows up in the server log
SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
******************************************************************************
* BEGIN STACK DUMP
* 04/16/04 22:38:12 spid 5
* Exception Address = 00402453 (RecBase::Resize(void) + 00000004 Line 0+00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATIO
* Access Violation occurred reading address 0000000
* Input Buffer 68 bytes
* exec sp_MSdbuseraccess N'db', N'%
*
* MODULE BASE END SIZ
* sqlservr 00400000 00B19FFF 0071a00
* ntdll 77F80000 77FFCFFF 0007d00
* KERNEL32 7C570000 7C627FFF 000b800
* ADVAPI32 7C2D0000 7C331FFF 0006200
* RPCRT4 77D30000 77DA0FFF 0007100
* USER32 77E10000 77E74FFF 0006500
* GDI32 77F40000 77F7DFFF 0003e00
* OPENDS60 41060000 41065FFF 0000600
* MSVCRT 78000000 78044FFF 0004500
* UMS 41070000 4107CFFF 0000d00
* SQLSORT 42AE0000 42B6FFFF 0009000
* MSVCIRT 780A0000 780B1FFF 0001200
* sqlevn70 41080000 41086FFF 0000700
* NETAPI32 7B470000 7B4BEFFF 0004f00
* SECUR32 7C340000 7C34EFFF 0000f00
* NETRAP 7B4C0000 7B4C5FFF 0000600
* SAMLIB 7B4D0000 7B4DEFFF 0000f00
* WS2_32 7B4E0000 7B4F3FFF 0001400
* WS2HELP 7B500000 7B507FFF 0000800
* WLDAP32 7B510000 7B539FFF 0002a00
* DNSAPI 7B540000 7B563FFF 0002400
* WSOCK32 7B570000 7B577FFF 0000800
* wmi 7B760000 7B763FFF 0000400
* ole32 7B870000 7B95EFFF 000ef00
* XOLEHLP 7B9E0000 7B9E7FFF 0000800
* MSDTCPRX 7B9F0000 7BAA6FFF 000b700
* MTXCLU 7BAB0000 7BABFFFF 0001000
* VERSION 7BAC0000 7BAC6FFF 0000700
* LZ32 7BAD0000 7BAD5FFF 0000600
* CLUSAPI 7BAE0000 7BAEFFFF 0001000
* RESUTILS 7BAF0000 7BAFCFFF 0000d00
* USERENV 7C0F0000 7C150FFF 0006100
* rnr20 7BB00000 7BB0BFFF 0000c00
* iphlpapi 7BB50000 7BB62FFF 0001300
* ICMP 7BB70000 7BB74FFF 0000500
* MPRAPI 7BB80000 7BB96FFF 0001700
* OLEAUT32 7BBA0000 7BC3AFFF 0009b00
* ACTIVEDS 7BC40000 7BC6EFFF 0002f00
* ADSLDPC 7BC70000 7BC92FFF 0002300
* RTUTILS 7BCA0000 7BCADFFF 0000e00
* SETUPAPI 7BCB0000 7BD3DFFF 0008e00
* RASAPI32 7BD40000 7BD72FFF 0003300
* RASMAN 7BD80000 7BD90FFF 0001100
* TAPI32 7BDA0000 7BDC1FFF 0002200
* COMCTL32 7BDD0000 7BE53FFF 0008400
* SHLWAPI 7BE60000 7BEC4FFF 0006500
* DHCPCSVC 7BED0000 7BEE8FFF 0001900
* winrnr 011F0000 011F7FFF 0000800
* rasadhlp 01200000 01204FFF 0000500
* SSNETLIB 019D0000 019E5FFF 0001600
* SSNMPN70 410D0000 410D5FFF 0000600
* security 01CD0000 01CD3FFF 0000400
* crypt32 7C740000 7C7C6FFF 0008700
* MSASN1 01CE0000 01CEFFFF 0001000
* msafd 02100000 0211DFFF 0001e00
* wshtcpip 02160000 02166FFF 00007000
* SSmsLPCn 021F0000 021F6FFF 00007000
* ntdsapi 02290000 022A0FFF 00011000
* SQLFTQRY 02810000 0282CFFF 0001d000
* CLBCATQ 02830000 028BFFFF 00090000
* sqloledb 028E0000 02952FFF 00073000
* MSDART 02960000 0297EFFF 0001f000
* comdlg32 02980000 029BDFFF 0003e000
* SHELL32 029C0000 02C07FFF 00248000
* MSDATL3 02C10000 02C24FFF 00015000
* oledb32 02FB0000 03015FFF 00066000
* OLEDB32R 03020000 0302FFFF 00010000
* msv1_0 03050000 03070FFF 00021000
* xpstar 410F0000 41133FFF 00044000
* SQLUNIRL 10000000 1002CFFF 0002d000
* WINSPOOL 03080000 0309DFFF 0001e000
* MPR 030A0000 030AFFFF 00010000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 030B0000 030C6FFF 00017000
* ODBC32 030D0000 03101FFF 00032000
* odbcbcp 03110000 03115FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* NDDEAPI 03120000 03126FFF 00007000
* odbcint 03270000 03285FFF 00016000
* SQLSVC 03290000 03295FFF 00006000
* xpstar 032A0000 032ABFFF 0000c000
* srchadm 034E0000 0351DFFF 0003e000
* mssadmws 03520000 03534FFF 00015000
* msi 03820000 03A23FFF 00204000
* athprxy 03A40000 03A47FFF 00008000
* rsabase 7CA00000 7CA22FFF 00023000
* xpsqlbot 04160000 04165FFF 00006000
* DBGHELP 042B0000 042C2FFF 00013000
* msdbi 04AF0000 04B0BFFF 0001c000
* sqlimage 09D20000 09D2CFFF 0000d000
*
* Edi: 00000005:
* Esi: 1BB294EC: 00000000 00000025 00000000 00000000 00000003 0000000B
* Eax: 00000000:
* Ebx: 1BDCFFFD: 20000000 021BD5E0 00000000 E01BDD20 011BDD1F 00000000
* Ecx: 1BB294EC: 00000000 00000025 00000000 00000000 00000003 0000000B
* Edx: 00000E00:
* Eip: 00402453: E183088A 04E9830E 589D840F 4949001E E9830C74 0F077404
* Ebp: 03F2D2A0: 03F2D2B4 005EEA86 00A4C638 03F2D2B0 03F2E3DC 03F2E79C
* SegCs: 0000001B:
* EFlags: 00010246: 003D0052 005C005C 00410047 0049004C 0045004C 00000049
* Esp: 03F2D28C: 1BB294EC 00445CB5 00000000 00000002 1BDCF8D0 03F2D2B4
* SegSs: 00000023:
*******************************************************************************
