SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unspecified error MS visual database tools


Unspecified error MS visual database tools

Author
Message
Jason Crider
Jason Crider
SSChasing Mays
SSChasing Mays (605 reputation)SSChasing Mays (605 reputation)SSChasing Mays (605 reputation)SSChasing Mays (605 reputation)SSChasing Mays (605 reputation)SSChasing Mays (605 reputation)SSChasing Mays (605 reputation)SSChasing Mays (605 reputation)

Group: General Forum Members
Points: 605 Visits: 2232
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
netwenchao
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 0
just restart mssqlserver service!
mhunsake
mhunsake
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 21
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
thulium
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
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
Laurence Surat
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 231
If you are accessing from a client machine try installing the latest version. (New Version of Management Studio)
whunter31
whunter31
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 111
Fix unspecified error (MS Visual Database Tool) in Microsoft SQL Server Management Studio
Is common situation when a developer in the process of migration from MS SQL Server 2005 to 2008 try to get access to both databases from one Visual Designer tool. If you will try to display data located on MS SQL Server 2008 from MS SQL Server management studio for 2005 server you will get the follow error:


Unspecified error
(MS Visual Database Tools)

------------------------------

To fix this problem, just download new version of Management Studio.
Patricia-535207
Patricia-535207
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 0
I am getting this error after trying to upgrade 2005 to 2008R.
It failed because it wanted for me to remove 2005 tools and when I cancelled it removed some tools, but I do not what tools it removed.
I think this has to do with 2008R not been tested properly.
2008R cannot work with 2005!

I tried then to remove 2008R (well the bits it installed), it seemed to uininstall properly but it is still there! I just cannot get rid of it!

I can link to my hosting company server where from I can create and design my tables but cannot use my own!

I will call Microsoft tomorrow morning, but I guess tech support will not know what to do.... as usual...

Microsoft used to be one of the best company for supporting developers but in the last 5 years the client care has dropped dramatically.
Hehe
tony.serva
tony.serva
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 8
Great solution found here: http://harshgupta71.blogspot.in/2013/02/the-specified-module-could-not-be-found.html

Essentially, delete the files located here:
C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8
and then replace with the ones Gupta has available on his site.

I did this and problem was solved.
zyzy
zyzy
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 134
Thanks a lot for Gupta's link. This did not only solve the database diagram issues but also solve my SASS "specified module could not be found".
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search