Database Diagram Designer Not Working After XP SP2

[slhayden]

I'm using SQL Server 2000 SP3 on Windows XP SP2. After installing the SP2 for XP I'm no longer able to use existing database diagrams. The diagram window will open, but it doesn't contain any objects. Additionally, none to the toolbar controls are working.

If I open these diagrams from another machine they are ok.

Any ideas?

 

[mrdenny]

Enterprise Manager probably got screwed up. Try reinstalled the Enterprise Manager from the SQL CD.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[SQLBill]

Have you openned the proper ports? SP2 closes TCP port 1433 and UDP port 1434 which SQL Server uses. That MIGHT be your problem.

-SQLBill

 

[SQLBill]

First, I apologize for misunderstanding and thinking you were not using SQL Server.

It's still appears to be a programming error - your's or the programs (most likely the programs). Have you tried mrdenny's solution to the original post?

The error appears to indicate that it's expecting one type of input and getting something else. So, without seeing what you are doing, it's going to be hard to solve this one.

Q's: Which version are you using?
At which point do you get the error?
Is there an error number with the message?

-SQLBill



Posting advice: FAQ481-4875