changing IIS process user

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
nwang
Posts: 20
Joined: Tue Oct 31, 2006 12:56 pm

changing IIS process user

Post by nwang » Thu Jun 17, 2010 5:39 pm

vers 4.1.2

I am testing our Vault migration from SQL2000 to SQL2008. My original setup was Custom (web.config Identity Impersonation) using an NT account to connect to SQL and I wanted to go with Machine this time around but it the Vault installation is not accepting it. Usually I am getting error 1280:
Ensuring that sgvaultuser has access to the database...Cannot alter the login 'sgvaultuser', because it does not exist or you do not have permission.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280
Am I missing something or is this possible?

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: changing IIS process user

Post by lbauer » Thu Jun 17, 2010 8:03 pm

If you're using SQL Server authentication in the SQL Server setup portion of the installation, you need to give the installer the SA account name and password (or use an account with equivalent permissions) so the installer can create the sgvaultuser account, upgrade the database, etc.
Linda Bauer
SourceGear
Technical Support Manager

nwang
Posts: 20
Joined: Tue Oct 31, 2006 12:56 pm

Re: changing IIS process user

Post by nwang » Mon Jun 21, 2010 11:17 am

thanks Linda

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: changing IIS process user

Post by lbauer » Mon Jun 21, 2010 12:49 pm

You're welcome. :)
Linda Bauer
SourceGear
Technical Support Manager

Post Reply