Vault General Discussion

Vault General Discussion

Reply
Valued Contributor
jdow
Posts: 69
Registered: ‎10-05-2004
Message 1 of 2 (313 Views)
Accepted Solution

Vault Pro Backups and MS SQL Server Guest Account for MSDB database

313 Views, 1 Replies
11-07-2012 12:49 PM

In MS SQL Server their existing several system databases (master, model, msdb, tempdb).  During a customer IT security scan of the Vault SQL server it reported back a security hole.  For these system databases their exists a default SQL Guest account under their security settings.  This account raises as a security risk by the scanners.  The customer went and disabled this SQL Guest account for each of those system databases (as they have done for their other SQL servers), but this time for Vault, the Vault backups stopped working.  Once this SQL Guest account was reenabled the Vault backups continued to work again.

 

My question is...does Autodesk Vault require this SQL Guest account to perform operations like the Vault backup and/or other operations?

 

We found some documentation from MS that indicates that this may be some sort of bug in SQL 2008 and not to disable it.  But my customer wants to hear from Autodesk first on this issue!

 

Thank you!

John

JD

John,

 

Vault doesn't require this account SQL does.  Please have your IT department use the SQL Management Studio and perform a backup of all databases through the studio.  You should have the same issue.

 

See this article: http://support.microsoft.com/kb/2539091

Board Manager
ihayesjr
Posts: 603
Registered: ‎02-01-2006
Message 2 of 2 (308 Views)

Re: Vault Pro Backups and MS SQL Server Guest Account for MSDB database

11-07-2012 01:42 PM in reply to: jdow

John,

 

Vault doesn't require this account SQL does.  Please have your IT department use the SQL Management Studio and perform a backup of all databases through the studio.  You should have the same issue.

 

See this article: http://support.microsoft.com/kb/2539091



Irvin Hayes Jr
Product Manager
Autodesk, Inc.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
New button for Platinum & Gold Subscription customers
Gold & Platinum Subscription customers can alert Autodesk if they require assistance with their forum post

Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.