April 24, 2006 at 4:10 am
Hi There
I receive the following errors when I attempt to run enterprise manager from my analyst’s server.
Snap-in failed to initialise
Name: Meta Data Services
CLSID:{1DBA4DD4-EB97-4FD2-AB80-9D0D4BA74034}
And when I access a database and select the following.
Open Table >> Return All Rows
An unexpected error happened during this operation.
Enterprise manager is installed on my analyst server and the databases are on a separate SQL server. When users attempt to access a database from EM on analyst server they receive the above errors. Conversely as a domain admin I can use EM to access the databases from that server.
From the SQL server, the users can access a database and return all tables without issue.
Thanks in advance!
Chris
April 27, 2006 at 8:00 am
This was removed by the editor as SPAM
May 17, 2006 at 12:08 am
"And when I access a database and select the following.
Open Table >> Return All Rows
An unexpected error happened during this operation."
The same thing happens on my development machine. Query analyzer works fine. I can also access tables through applications. I don't get any "snap-in" errors, it just happens when I open EM and try to view a table or use design mode on a table. I have searched for this problem before. A Profiler Trace puts out a whole LOT of data when I use it.
Here is a trace from Profiler saved as sql code.
select name, owner = user_name(uid), crdate, objtype = sysstat & 0xf, id, deltrig from dbo.sysobjects o where power(2, sysstat & 0xf) & 4607 != 0 and not (OBJECTPROPERTY(id, N'IsDefaultCnst') = 1 and category & 0x0800 != 0) and o.name not like N'#%' and o.id = object_id(N'[dbo].[Categories]')
go
use [Northwind]
go
set implicit_transactions off
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
set implicit_transactions on SET TEXTSIZE 2147483647
go
select user_name()
go
IF @@TRANCOUNT > 0 COMMIT TRAN
go
set implicit_transactions off SET TEXTSIZE 64512
go
use [Northwind]
go
use [Northwind]
go
SET TEXTSIZE 2147483647
go
select count(*) from sysobjects where name in ( 'dt_adduserobject', 'dt_droppropertiesbyid', 'dt_dropuserobjectbyid', 'dt_generateansiname', 'dt_getobjwithprop', 'dt_getobjwithprop_u', 'dt_getpropertiesbyid', 'dt_getpropertiesbyid_u', 'dt_setpropertybyid', 'dt_setpropertybyid_u', 'dt_verstamp006', 'dt_verstamp007', 'dtproperties' ) and uid = 1
go
SET TEXTSIZE 64512
go
use [Northwind]
go
use [Northwind]
go
SET TEXTSIZE 2147483647
go
exec dbo.dt_verstamp007
go
SET TEXTSIZE 64512
go
use [Northwind]
go
use [Northwind]
go
SET TEXTSIZE 2147483647
go
select count(*) from sysobjects where uid = 1 and name in ( 'dt_addtosourcecontrol', 'dt_addtosourcecontrol_u', 'dt_adduserobject_vcs', 'dt_checkinobject', 'dt_checkinobject_u', 'dt_checkoutobject', 'dt_checkoutobject_u', 'dt_displayoaerror', 'dt_displayoaerror_u', 'dt_getpropertiesbyid_vcs', 'dt_getpropertiesbyid_vcs_u', 'dt_isundersourcecontrol', 'dt_isundersourcecontrol_u', 'dt_removefromsourcecontrol', 'dt_validateloginparams', 'dt_validateloginparams_u', 'dt_vcsenabled', 'dt_whocheckedout', 'dt_whocheckedout_u', 'dtproperties' )
go
SET TEXTSIZE 64512
go
use [Northwind]
go
use [Northwind]
go
set implicit_transactions off
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
set implicit_transactions on SET TEXTSIZE 2147483647
go
select user_name()
go
IF @@TRANCOUNT > 0 COMMIT TRAN
go
set implicit_transactions off SET TEXTSIZE 64512
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
use [Northwind]
go
April 9, 2007 at 7:44 pm
Reboot the server where SQL Client tools are installed.
April 10, 2007 at 1:13 am
I uninstalled SQL server and deleted all references to it. When I reinstalled it it worked.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply