Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Change DB Owner

  Asked By: Joel    Date: Nov 22    Category: Sharepoint    Views: 2353

Many of you are probably not DBA's but I figured I'd give it a shot.

One of the tech people deleted my domain SSP account. Now I can't access the DB
to grant ownership to someone else. No Sysadmin accounts can take ownership.

Any idea on how I can force ownership of the table to another account?

It's SQL 2008 server on it's on box.



5 Answers Found

Answer #1    Answered By: Mara Mcintosh     Answered On: Nov 22

Will re-creating the SSP account  fix it?

Answer #2    Answered By: Ashly Baxter     Answered On: Nov 22

I was getting an error when I was trying to create a new SSP. Now
I can create a new SSP.

So I moved all associated sites over to it.

Should I leave the old SSP database on the SQL server or try to detach and
remove it? I've got space on the server.

Answer #3    Answered By: Irene Moss     Answered On: Nov 22

You could make a backup, then delete it.

Answer #4    Answered By: Luis Davis     Answered On: Nov 22

Well I can't delete the SSP from the Moss Admin console. The delete is greyed

I have a feeling I am going to have to find a way to get ownership  of that

Answer #5    Answered By: Olivia Sims     Answered On: Nov 22

I forgot to change  the default SSP........

Didn't find what you were looking for? Find more on Change DB Owner Or get search suggestion and latest updates.