Unspecified error MS visual database tools

Question

Unspecified error MS visual database tools

rafaelbonfa

SSC Veteran

Points: 272
More actions
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.

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

brendan.hargie SSC Journeyman Points: 85 More actions · Answer 1

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 More actions · Answer 2

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 More actions · Answer 3

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 More actions · Answer 4

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 More actions · Answer 5

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 More actions · Answer 6

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 More actions · Answer 7

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 More actions · Answer 8

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

-- Kit

kanikagupta2704 Valued Member Points: 69 More actions · Answer 9

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 More actions · Answer 10

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.

MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter

netwenchao SSC Rookie Points: 37 More actions · Answer 11

netwenchao

SSC Rookie

Points: 37

April 19, 2010 at 8:07 pm

#1154247

just restart mssqlserver service!

mhunsake Valued Member Points: 65 More actions · Answer 12

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 More actions · Answer 13

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 More actions · Answer 14

If you are accessing from a client machine try installing the latest version. (New Version of Management Studio)