Error 402 when attempting install with SQL Server Express

[MBeanland]

I have failed repeatedly with my attempted installations. SQL Express seems to be running fine, but I keep hitting the following error:

Creating a new Vault Professional database on RTR-LEXPARK\SQLEXPRESS...
Creating the SourceGear master database...CREATE DATABASE permission denied in database 'master'.
Vault Professional Setup is exiting due to a failure or cancellation. Error Code = 402

I suspect this is a permission issue, but can't identify what part of the SQL Express configuration needs to be altered to allow the installation to proceed.
Any help would be appreciated.
MLB

[Beth]

You are correct that the issue is with permissions.

When you connect to SQL Express, are you using Windows authentication or SQL authentication?

If you're using SQL authentication, which user login are you using? When using SQL authentication, the user you log in with needs SQL sysadmin permissions, such as 'sa'. This is only for the install, and not for the daily running of Vault.

[MBeanland]

I'm using Windows Authentication.

Should I change to SQL Authentication or can this be made to work with my present configuration?

Thanks,
MLB

[Beth]

Is your Windows login a domain admin or a SQL admin? If you give your own login enough rights, then it will be fine.

Is the SQL Server on a different machine than the Vault server or the same machine? If they're on a different machine, then I'd suggest using SQL authentication instead and logging in with 'sa'.

[MBeanland]

What I have done since my last post is to fire up the SQL Server [2014] Management Studio and, using my Windows Authentication login, I have both connected to the master DB and created a DB for test purposes.

So far as I can tell from the install log, the Vault installation is able to open and connect to SQL server. bit it fails when attempting to create a DB.

I cannot identify anything in SQL Server Express that is not functioning or mal-configured and the Vault installation program offers no parameters that I can set so that things will work properly.

[MBeanland]

To answer your question from above...SQL Server is installed and running on the same machine that I'm trying to install Vault on.

[Beth]

Run a command prompt as administrator and then run the installer from that command prompt. Then let me know your results.

[MBeanland]

Identical outcome; install log is below

Looking for IIS Version
Configuring your new Vault Professional Installation
Requesting the IIS Process User...
Modifying VaultAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Integrated
Modifying VaultShadowFolderAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Integrated
Modifying VaultIndexAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Integrated
Modifying VaultNotifyAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Integrated
Modifying SgDavAppPool...
Properties: Id=ApplicationPoolIdentity, .NET=v4.0, Mode=Classic
Creating Applications in IIS for web services...
VaultService application created.
Creating Applications in IIS for Vault Professional Work Item web services...
Vault Professional application created.
Creating Applications in IIS for VaultShadowFolder web services...
VaultShadowFolder application created.
Creating Applications in IIS for Find in Files Index web services...
VaultIndexService application created.
Creating Applications in IIS for Notification web services...
VaultNotificationService application created.
Creating Applications in IIS for SdDav web services...
SgDav application created.
Creating Virtual Directories...
VaultService Virtual Directory created.
Vault Professional Virtual Directory created.
VaultShadowFolder Virtual Directory created.
VaultIndexService Virtual Directory created.
VaultNotificationService Virtual Directory created.
SgDav Virtual Directory created.
Requesting Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for existing databases...Not found.
Creating a new Vault Professional database on RTR-LEXPARK\SQLEXPRESS...
Creating the SourceGear master database...CREATE DATABASE permission denied in database 'master'.
Vault Professional Setup is exiting due to a failure or cancellation. Error Code = 402

[Beth]

permission denied in database 'master'.

Still not enough rights. You might try using SQL authentication and login with the 'sa' account. Then let me know your results.

[MBeanland]

One problem solved, now on the the next one:
The Install Solution:
1. Read the post from Beth very carefully and follow it exactly--i.e., I ran the install from a command prompt thinking that as I had Admin rights, that would be sufficient...then I remembered that Admin rights have to be specifically invoked in order to apply. So I was able to install both the Vault Server and the Client Application.

New problem;
--The server login page is asking me to logon with the "the "admin" username and the password that you supplied during the install"
I did not provide an specific user name as I set the configuration to use Windows Authentication. I did provide an password, which I have used to no avail.
My Windows user name and password do not work
My email address and Windows password do not work
Neither of the above will work with the Vault Password that I provided

[Beth]

Login name for the Vault admin web page is always just admin.

The password would have been what you had to type twice into a window during the install. Check that you didn't accidentally have caps lock on or any of the usual password trip-ups.

If it still won't work, you have two options.
1) Have a user with admin level rights login to the Vault admin web page and change the admin password,
or
2) Uninstall Vault, but choose the option to keep the database, then install again. During the install, you will get the chance to set the password again.

[MBeanland]

Fixed.

I've no doubt you're pulling your hair out by now, but thanks for your help.
MLB

[Beth]

You're welcome. I'm fine.