Ms visual database tools error

Unspecified error (MS Visual Database Tools)

I got this error when trying to “open table” a Sql server 2008 table from the SSMS 2005. There were numerous reports of this problem, while most of them ended up unanswered. The following is an answer I found from a MS person so I guess it’s likely to be authentic.

The answer is, no, you cannot open a 2008 table using the SSMS 2005.

An alternative is to right click the table, and select

1. “script table as”

2. “select to”

3. “new query editor window”

4. Then a new query window, with the “select” statement populated, will appear. You can then simply click the “execute” button.

This is of course not as good as the one right click and left click of the “open table”, but probably the best available option.

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=335534

==============================

• October 30, 2007 at 8:39 am

  #199521

  Hi, i am using sql server management studio 2005 express, and every time i try to open a table in a database i receive this message

  «Unspecified Error (ms visual database tools)»

  And i can’t open the table. Any one can help me? What could be this problem?

  Thank you.

• brendan.hargie

  SSC Journeyman

  Points: 85

  I too am having this issue. It has only started today and I have tried restarting my PC as I thought it may have been an issue with my current session, but continued after. Any help with this issue would be greatly appreciated.

  Regards,

  Brendan Hargie

• FaheemM

  SSC Veteran

  Points: 219

  Hi Increase the no of connections.By default it is 5

  right click sql server instance and go to property

  from there click connections tab

  and increase user connections connected to sql server instance

  you can also use sp_configure stored procedure

• shermdawg

  SSC Rookie

  Points: 29

  I’m having the same issue. The application can connect read and write to the databaae but when I want to see the table data via Visual Database Tools. I get ‘Unspecified Error’. I’ve increased the number of consurrent connections permitted but this makes no difference.

  I think it’s to do with the drivers. I recently uninstalled SSEE 2005 and installed developer edition 2005.

  I then got the following error:

  Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.

  I then installed the following from the Microsoft SQL Server 2008 Feature Pack RC0, June 2008 (as advised by http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3559219&SiteID=17)

  «SQLSysClrTypes

  SharedManagementObjects

  sqlncli10

  These features can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyId=089A9DAD-E2DF-43E9-9CD8-C06320520B40&displaylang=en»

  I am now getting the ‘Unspecified Error’.

  Can anyone help / advise.

  Thanks

• mark stewart-324402

  Valued Member

  Points: 59

  September 22, 2008 at 9:39 am

  #875089

  I, too, am having this problem. I was working just fine with this database last week, but now I can’t even open a table. The only major install was Subversion, but I can’t see that being a problem.

  Looks like I might have to do the whole reinstall thing which doesn’t make me happy. And here I thought these tools were supposed to make me more productive. WTF???????

• fzavat-970238

  Valued Member

  Points: 59

  December 17, 2008 at 11:08 pm

  #914296

  I am haviving this issue too. «Unspecified error MS visual database tools» when attempting to open a table in Management Studio with SQL 2005 express.

  Anybody can give suggestions?

  I am looking in Microsoft archieves but I did not find anything yet. If anybody found an article or a resolution or whatever else please let me know.

  Thank you

• cbeatley

  SSC Rookie

  Points: 32

  This seems to be caused by IE7 and DNS issues. On a workgroup SQL Server, attaempting to connect to a database (using hostname) would end up with unspecified error: MS Visual Database Tools. Using IP address, instead, it goes away. Alternatively, using IE6, it goes away.

  this is a widespread issue & MS don’t seem to acknowledge it

• haider.jaleel

  Valued Member

  Points: 65

  I try to access sql server 2008 form my local machine , it’s normal to login but whenever i open any object i get the same error .

• Kit G

  SSCrazy

  Points: 2888

  Just out of curiosity, had anyone else had this problem with IE8? Or it is just IE7?

  — Kit

• kanikagupta2704

  Valued Member

  Points: 69

  I am having this error in Mozilla fireforx 3.0.8 and it comes only when I try to open table of my remote server or try to design it. Any help out there.

• Jason Crider

  SSCertifiable

  Points: 6019

  I just had a developer who had this same issue.

  Turns out he was trying to open a SQL 2008 database with SSMS 2005.

  He opened up SSMS 2008 and the problem went away.

• netwenchao

  SSC Rookie

  Points: 37

  just restart mssqlserver service!

• mhunsake

  Valued Member

  Points: 65

  I am having the problem as well. It seems to happen when trying to access a database object and I get the error twice before successfully accessing the object.

  For example, I try to view the Design View of a table in SQL 2005/2008 Management Studio and get the «Unspecified Error» message. On the 3rd attempt, I am able to view the Design View.

  Some people are linking Internet Explorer and the «Unspecified Error» together. For what it’s worth, I’m using IE8. But error was happening before I upgraded to IE8.

  Any solutions to the problem would be much appreciated! I get the «Unspecified Error» 15 to 20 times each day.

  Thanks,

  Mike

• thulium

  SSC Rookie

  Points: 27

  I Had the same problem….

  It had to do with SQL Server 2005 And SQL Server 2008.

  When you try to open an SQL Server 2008 table with SQL SSMS 2005 it gives that error.

  Gr

• Laurence Surat

  SSC Rookie

  Points: 29