Hi,
1. In what Windows directory are the Vault databases stored? I know the answer is somewhere in the KB, but I just can't find it for some reason.
2. I use SQL Server Express Management Studio. I can't log into the vault databases because I guess my Windows user name isn't associated with the vault databases. Where can I add the security credentials so that my Windows user name is granted permissions to see the tables, etc. of the Vault DBs within SQL Server Express Management Studio?
Thanks.
BTW, I am using the latest version of Valut.
Where are the Databases stored *and* SQL Express Mgmt Studio
Moderator: SourceGear
-
jmFightSpam
- Posts: 13
- Joined: Tue Apr 22, 2008 6:45 pm
By default, those databases are normally in the SQL directories. For example, on my test server, there are at C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. They can be configured to be elsewhere though, so if someone else managed them previously, they could be in a different location.
If you have admin rights, you can give yourself access in the Security area of your SQL database. In the properties of your login, you will want to go to User Mappings to give permissions to yourself.
If you don't have the rights to set that, then you might have to log in as 'sa' if you allow SQL authentication or have another administrator log in.
If you have admin rights, you can give yourself access in the Security area of your SQL database. In the properties of your login, you will want to go to User Mappings to give permissions to yourself.
If you don't have the rights to set that, then you might have to log in as 'sa' if you allow SQL authentication or have another administrator log in.