Microsoft SQL Server Error 904

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Data Corruption » Microsoft SQL Server Error 904

13 posts, Page 2 of 2

««1 2

Microsoft SQL Server Error 904

Rate Topic

Display Mode

Topic Options

Author

Message

romelyncomia

Posted Tuesday, October 26, 2010 12:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 26, 2010 1:02 AM
Points: 2, Visits: 36

thank you

ZERONA

Post #1010559

romelyncomia

Posted Tuesday, October 26, 2010 12:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, October 26, 2010 1:02 AM
Points: 2, Visits: 36

thank you

ZERONA

Post #1010560

striker-baba

Posted Thursday, July 05, 2012 10:45 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:35 PM
Points: 72, Visits: 355

Hello Friends, thanks for sharing the info on this. This is very helpfull. I got the same issue today and did multiple things......

1. the database is msdb, which caused the issue.
2. I figured out the issue is with Full Text files associated to my userdb's and I am having access denied issues even though my service account have full access to the file locations.
3. restart sql server did not work for me. I was able to rename the msdb physical files ever after sql restart. which means msdb is not connected to sql.
4. FINALLY, I rebooted server and then it worked..... :)..... and I think its the file permission issues.... and am assuming permissions were refreshed and am able to connect.

gud luck with this... this is a serious problem if its on prod. Make sure you have the backups available as a last option.

Post #1325565

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions