Object Explorer Connection Fails - Failed To Retrieve Data.......SmoEnum)
Oct 17, 2006
Hi
First up - my apologies if this is not the right forum for this question. Please let me know if there is a more appropriate one for this question.
I have come across an issue with my SQL Server 2005 Express Edition install. It has been running fine since the install (a few months back). And I can still interact (query, update etc) the databases just fine. However, SQL Management Server Studio Express has started to produce an error message when I attempt to connect the Object Explorer.
The error message is shown below.
I have tried to access the link shown in the error message but there is no information provided there.
I can use SQL Management Server Studio Express to run queries on the databases so it would appear that the underlying services are all running OK.
The SQL Server is installed using SQL Authentication only and I have not made any changes to Service accounts or the services themselves. The protocols all appear to be in order too - Shared Memory, Named Pipes, TCP/IP are all enabled.
I have restarted the SQL services and even rebooted the machine, but to no avail.
I would really appreciate if anyone out there could give me some guidance on what may be causing this issue.
Note: The SQL Server is installed on WinXP Pro SP2 running in a VirtualPC. All apps are release versions (no beta or CTP)
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
I´m trying to connect to a integration service hosted in a different machine, but I recive the following message:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) : access denied
I verified and the service that machine is running, maybe could be the user, I´m using windows authentication, I have no problems when I log in in the databse engine.
I just realized recently that a database "XYZ" in the Object Explorer of my SQL Server Management Studio Express (SSMSE) is put in the Database Explorer of my VB 2005 Express for processing a Stored Procedure in executing the SELECT statements (not by using Input and/or Output Parameters) during the ADO.NET 2.0-VB 2005 Express programming, then the content of the database "XYZ" is not in the SSMSE. How can I return the database "XYZ" from the DataBase Explorer of VB 2005 Express back to the Object Explorer of SQL Server Management Studio Express (SSMSE) safely? Please help and advise.
I'm an "old" programmer but new to ASP.NET. I want to get a value from the SQL Dataset. What I would normally do in other environments is iterate through the dataset to get the value I would be intrested in, but I can't figure out how to do this without using a visual data display object like a Grid view. Typically I want to get a value from the database that I then after manipulating it, like multply by 5, use to format something on the page. thanks in advance, Thommie
We are trying to import data into SQL Server 2005 from MySQL 5.0.x using DTS Wizard via MySQLOLE DB Provider developed by Cherry City Software .
We can read BLOB data from MySQL via ADO 2.7 and ADO.NET 2.0. We can also use DTS Wizard to read the data on Preview. For the test, we defined a table as tBlob (lText VARCHAR(9000)) and inserted one record with a few characters. However, DTS Wizard always fails at the executing step with the following error messages:
Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80040E21. (SQL Server Import and Export Wizard)
Error 0xc0208265: Data Flow Task: Failed to retrieve long data for column "lText". (SQL Server Import and Export Wizard)
Error 0xc020901c: Data Flow Task: There was an error with output column "lText" (17) on output "OLE DB Source Output" (11). The column status returned was: "DBSTATUS_UNAVAILABLE". (SQL Server Import and Export Wizard)
Error 0xc0209029: Data Flow Task: The "output column "lText" (17)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "lText" (17)" specifies failure on error. An error occurred on the specified object of the specified component. (SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - tblob" (1) returned error code 0xC0209029. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. (SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with error code 0xC0047038. (SQL Server Import and Export Wizard)
Error 0xc0047039: Data Flow Task: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. (SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0047039. (SQL Server Import and Export Wizard)
This could be a defect in the DTS Wizard. How do we workaround this problem? Any help will be greatly appreciated.
I am trying to load data into a SQL Server table through a web page. I am getting error like this:
Error: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
I am doing the same for other tables in the same db its working fine. but its working for one table alone. The table name is like this (DTD_PUMA_DeliveryPerformance)
Is it cos of table name???
I tried with import/export wizard also its working fine but still its not working for web page.
I don t think its cos of network or OS!! Its with table or some connection property.Pls help me in solving this.
I have SQL Server 2000 (SP4) running on an Windows 2003 SP 1 server. I have started to get the error message "Connection to application object failed - Ensure no program modules have been deleted" when I go into Enterprise Manager.
I have tried reinstalled SQL Server and applied SP4 but to no effect. Can anyone help?
We have a SSIS project where we load lot of image files using an OLE DB Source component and put it across the database as varbinary into OLEDB Destination component.
Things were fine until now where am getting an error like this. alongside the log also reads like,
There is not enough space on the disk. Long data was retrieved and can't be added to the data flow task buffer.
Is this method of loading the files using an OleDb Souce not the efficient one ? If not is there a way I can get this done. Comments are highly appreciated!!
I am using vs 2005 to connect to a remote database. I dont have remote access or any other type of access. I need to setup some constraints on the database, but the object explorer is missing. How can Iincorporate this tab into vs
I downloaded the VWD2005 recentrly, it was really agiant achievement , i appreciate the people who developed such an easy-to-learn web development package. I noticed the difference between VS2002 and VWD2005. I really liked it. (i am sorry if this speech isn't in its right place). Here i have an enquiry, I downloaded the the VWD2005, but i haven't seen the Object Explorer(SQLExpress), although it was included in the downloades?
Im new to Sql Server CE and I am following the procedure in books online to create a new database. Through Sql Server Management Studio, I have version 9.00.2047, books online says to click connect through Object Explorer and then select Sql Server Compact Edition. I dont see this option. I see Sql Server Mobile. Is it the same thing or am I missing something?
Is there a way to stop SQL Server Management Studio (2005) from showing "dbo." on everything in the object explorer. I'd love to turn that off on a database I'm working on as, for example, if you have to find tblMember, you'd have to type d-b-o-.-t-b-l-m before you can actually start jumping to the table you're interested in - whereas in Enterprise Manager (2000) you'd only have to type t-b-l-m if you get my meaning.
A view I created won't show up in "views' in Object Explorer, but will only show up when I script for it (Select * from blah). It also won't go into the ODBC. why?
Here's one thing that I'd like to see come out in some version of the SQL Server Management Studio... The ability to create folders under the database node so that databases can be grouped on one server.
We have over 100 databases on our development server and these are created by a range of consultants and developers and even support staff as needed.
Being able to group the databases by product, etc would be a nice touch since we have client databases that don't fit naming conventions etc.
Multiple instances are another way around this but are expensive and resource hungry - we develop and support models, not use them for transactions too much.
Yes there are 'better' ways such as setting security correctly but we are too busy working and not maintaining.
I've installed SQL Server 2005 SP1 RTM on a Windows 2003 R2 machine (machine A), and my local workstation (machine B).
From machine B, I can use SSMS to connect to SQL Server on machine A. This is using either "New Query" or "Object Explorer".
However, on machine A, SSMS can only connect to machines A or B using the "New Query" option. If I try "Object Explorer" for either, I get the error message "Failed to retrieve data for this request... urn could not be resolved at level Configuration."
I'm not sure what died (no pun intended) since the last time this worked. Any thoughts on this?
Does anyone know why a trigger does not show in SQL Express object explorer? It does exist. I can find it a couple of different ways (VIEW sys.triggers)... and it is working but if I cannot see it how can I modify it? Thank you. Thank youMichael MooreSt Paul MN
How do I find what is keeing SSMS Object explorer from giving a list of tables or stored proc's? Even when you filter on what you are looking for? This will clear up in time, so I am guessing that some process is placing a lock .. but when I run the blocking query, below, I get no result.
SELECT DTL.[resource_type] AS [resource type] , CASE WHEN DTL.[resource_type] IN ('DATABASE','FILE','METADATA') THEN DTL.[resource_type] WHEN DTL.[resource_type] = 'OBJECT' THEN OBJECT_NAME(DTL.resource_associated_entity_id)
In Management Studio, under Registered Servers, I double-click a server name (could be sql 2000 or sql 2005 server) and it apperars in "Object Explorer" where I can work with it. I click the "Save All" button in Management Studio, exit Studio, and re-start Studio. When I do, I find that all the servers I placed under "Object Explorer" are now missing and I need to go through the "double-click the registered server" ritual again. And again, and again.
What am I doing wrong here? Why don't the servers "stick" in Object Explorer?
Under sql 2000 I needed to register my sql server before I could begin working with it under Enterprise Manager. Under sql 2005 I usually setup the server under "Object explorer" and work with it from there. So what does registering a server under sql 20005 do? Why is it needed?
I find it odd that default values do no show when viewing the columns of a table in Managament Studio's Object Explorer pane. Currently I have to issue a Modify on the table, and then click each column to determine if a default value has been specified. Which is quite cumbersome. Is there any way to tell Object Explorer to show me the defaults? I mean it's showing me the datatype and whether or not it can be set to null... why not show the default value too! SQL 2000's Enterprise Manager showed you all this and more when you double clicked a table.
I need to create a job and schedule it in sql server 2005.But the sql server agent option doesnt come under the database instance in the object explorer.Do I have to instal some other component of sql server 2005?
I saved a stored procedure (see below) and I'm not seeing listed within the 'Databases' / 'Remote_Serials' (DB name) / 'Programmability' / 'Stored Procedures' folder within the 'Object Explorer' window.
I'm trying to perform a simple add-info-from-form-into-DB process.
Is it because of the way I put together the procedure? I have a feeling that it is (was going off a video demo, which created it within VB.NET 2008 Express, but I'm not able to connect to the DB from there; it says the file is open, when I completely closed out of SQL Management Studio Express).
Code Snippet ALTER PROCEDURE dbo.spInsertSerialInfo @EmployeeID as nchar(10), @First_Name as nvarchar(50), @Last_Name as nvarchar(50), @HAddress as nvarchar(50), @City as nvarchar(30), @HState as nvarchar(2), @Zip as nvarchar(10), @Phone_Home as nchar(15), @Phone_Cell as nchar(15), @Monitor1 as nvarchar(50), @Monitor2 as nvarchar(50), @PIX_ASA_Box as nvarchar(50), @System_Case as nvarchar(50), @Batt_APC as nvarchar(50), @current_count as int OUTPUT
If I change the 'CommandType.StoreProcedure' to 'CommandType.Text' it seems to find it, but then I get another error saying that the @EmployeeID variable has already been delcared and that I need to have a unique variable.
I'm trying to get some proof of concept reports made for a MOSS / SQL Server 2005 (sp2) Integrated solution. I have a simple report that displays everything in the 'incident' uploaded to the MOSS server, and it works fine.
I've made another report that uses a line chart to plot some averages. This report, called 'Average Control Time by Weekday' works 100% ok in VS2005 preview mode and both reports use the same datasource. The report is uploaded and the dataset is all linked up.
When I view the report (by clicking on it's link on my Sharepoint Site), however, I get an error:
An error has occurred during report processing.
Query execution failed for data set 'DataSource1'.
Invalid object name 'incident'.
I've checked the SQL that was run in the SQL Server Profiler to see what transactions were hitting the database. The query that the report makes when in VS2005 Preview mode is precicely the same as what Sharepoint makes when it tries to render the report.
I made another plain report (just a table view) that uses the same query as the 'Average Control' report and tested it on Sharepoint, and it works perfectly. Any ideas?
p.s. I even asked I-God (http://www.titane.ca/concordia/dfar251/igod/main.html) all he said was that I would need a court order to get rid of the recursion in AIML... and then asked for my credit card number.
My default filter settings are: Name Schema Created How do I add an additional filter such as 'Modified'? I can get into the Filter Dialog box by clicking on the Funnel, but I can't figure out how to add another filter to the list.
Hello,i have created some (test) Web Services in a Sql Server 2005 via theCreate Endpoint Statement. Now i look for a node in the "ManagmentStudio" where i can see these Web Services. But i dont found that. Whatis the plainest way to do that? What alternatives are existent?Thank you,Hans
In the SQL Server 2014 Management Studio's object explorer indexed views with schemabinding don't have an index node. Thus, you can create and drop Indexes for views only via T-SQL. The SQL Server Management Studio 2012 still shows the index node.
Is there some Management Studio setting in version 12.0.2000.8 which I am missing?
ALTER TABLE [dbo].[TableNameExample] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
The table is 110 GB, so will take time to compress. But it is one table in a database with 60 tables. Why would executing this statement, cause lock timeout on Object Explorer in SQL Server Management Studio? Users cannot drill down objects in this database without getting lock timeout.
When I cancel the compression script, users of SSMS can access objects in this database again from the GUI. Why does compressing a specific table affect access to all tables metadata? I cannot find anything on the internet but I am sure this has happened to other people.
Here's my Help About Info: Microsoft SQL Server Management Studio Express 9.00.3042.00 Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205) Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 7.0.6000.16546 Microsoft .NET Framework 2.0.50727.1433 Operating System 6.0.6000
I opened up the Surface Area Configuration Tool and chose the "Surface Area Configuration for Features". Choose "Database Mail" and clicked the checkbox "Enable Database Mail Stored Procedures"
When I go into the Management Studio, I can't see the "Database Mail" node under "Management" I'm thinking I might need a service pack as in the about, I don't see a service pack listed. BUT, when I go to the SQL Server 2005 Express "Service Pack 2" page, there's no option to just download the Service Pack. I recently downloaded (2 weeks ago or so) this Sql Server Express Edition and I'm thinking this might have Service Pack 2 already, but I'm not sure as I don't see it in the "about".
