Hmph.. I'm getting scared now for Oracle.. ha! I guess there WILL be a learning curve..

Thank you very much for your reply. I am a developer and would very much like to remain as a developer but I am not limiting myself here. No one...

It turned out that there were duplicates.. The problem was that I was trying to join 2 tables and that created duplicates. Creating composite key have solved the problem....

Actually, it's the other way.

category_db_id from table is a PK.

It is also a FK, which gets value from [category] table's FK.

So it's a PK that gets its values...

So in essence, you cannot have a PK that is getting a FK value from another table?

Right, I have 964 DISTINCT category_db_id from category table. But since they are all unique, they should be ok for PKs...?

This is a new table and there is no data in there.

I checked to see whether there were duplicate key from the table that I'm inserting from, and there was...

Anybody been to these kinds of training before? Wonder if this is worth the money.

It turned out to be an Active Directory issue with the permissions from the corporate server.

But just to add a note, there was only 1 service running, which is a...

Forgot to mention that this is a recurring issue and have done uninstall/reinstall for 13 times.

After the re-installation it works perfectly fine. But the next day or two, the problem...

I would thought to reiterate my issue here.

When you click on Database Engine Query button, it does not bring up a Database Engine Query window.

Instead, it brings up Analysis...

Yup. Object Explorer can connect to the server.

Integration Services Project can connect to the server.

Only a Query Window cannot.

I'm not trying to log into my own box. I'm trying to connect to a network server.

The name goes like xxx.xxx.xx.xx/name.

Again, this worked perfectly fine yestserday..

Login mode is set to...

The services screenshot is from my computer.

I'm on my laptop and the SQL Server is of course on the server box. Other people are able to get on it just...

Reboot didn't help. And I'm attaching a screen shot for the services running.

So my computer has a client that connects to a networked server.