Sunday, February 26, 2012

Databases not displayed in Enterprise manager

Hi
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 56
*
* Exception Address = 00402453 (RecBase::Resize(void) + 00000004 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
* Input Buffer 68 bytes -
* exec sp_MSdbuseraccess N'db', N'%'
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B19FFF 0071a000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C627FFF 000b8000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7DFFF 0003e000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 7B470000 7B4BEFFF 0004f000
* SECUR32 7C340000 7C34EFFF 0000f000
* NETRAP 7B4C0000 7B4C5FFF 00006000
* SAMLIB 7B4D0000 7B4DEFFF 0000f000
* WS2_32 7B4E0000 7B4F3FFF 00014000
* WS2HELP 7B500000 7B507FFF 00008000
* WLDAP32 7B510000 7B539FFF 0002a000
* DNSAPI 7B540000 7B563FFF 00024000
* WSOCK32 7B570000 7B577FFF 00008000
* wmi 7B760000 7B763FFF 00004000
* ole32 7B870000 7B95EFFF 000ef000
* XOLEHLP 7B9E0000 7B9E7FFF 00008000
* MSDTCPRX 7B9F0000 7BAA6FFF 000b7000
* MTXCLU 7BAB0000 7BABFFFF 00010000
* VERSION 7BAC0000 7BAC6FFF 00007000
* LZ32 7BAD0000 7BAD5FFF 00006000
* CLUSAPI 7BAE0000 7BAEFFFF 00010000
* RESUTILS 7BAF0000 7BAFCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* rnr20 7BB00000 7BB0BFFF 0000c000
* iphlpapi 7BB50000 7BB62FFF 00013000
* ICMP 7BB70000 7BB74FFF 00005000
* MPRAPI 7BB80000 7BB96FFF 00017000
* OLEAUT32 7BBA0000 7BC3AFFF 0009b000
* ACTIVEDS 7BC40000 7BC6EFFF 0002f000
* ADSLDPC 7BC70000 7BC92FFF 00023000
* RTUTILS 7BCA0000 7BCADFFF 0000e000
* SETUPAPI 7BCB0000 7BD3DFFF 0008e000
* RASAPI32 7BD40000 7BD72FFF 00033000
* RASMAN 7BD80000 7BD90FFF 00011000
* TAPI32 7BDA0000 7BDC1FFF 00022000
* COMCTL32 7BDD0000 7BE53FFF 00084000
* SHLWAPI 7BE60000 7BEC4FFF 00065000
* DHCPCSVC 7BED0000 7BEE8FFF 00019000
* winrnr 011F0000 011F7FFF 00008000
* rasadhlp 01200000 01204FFF 00005000
* SSNETLIB 019D0000 019E5FFF 00016000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 01CD0000 01CD3FFF 00004000
* crypt32 7C740000 7C7C6FFF 00087000
* MSASN1 01CE0000 01CEFFFF 00010000
* msafd 02100000 0211DFFF 0001e000
* 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:
************************************************** *****************************