Installation problems - Windows 2008

[redwards1966]

I'm having a few problems getting the install to work on our Windows 2008 server. If I log in with a domain account that is a Domain Admin and run setup I'm ok until I need to specify the database server and login. Here I pick another machine (SQL 2008) and choose windows authentication. The error I get is:

SQL Connection Failed
Unable to connect to SQL
Login failed for user 'NT Authority\ANONYMOUS LOGON'

I'm not sure why I would get this error since I'm a domain admin and also as sysadmin for the database server.

Any ideas?

SQL Server authentication is not an option for us.

[Beth]

Is your SQL Server on a different machine?

Is there more than one instance of SQL on that server? If so, then you need to specify the instance. For example, if you used SQL 2008 Express on the same server, then your connection would be .\SQLEXPRESS instead of (local).

The error you are getting is in the middle of the install, correct?

[redwards1966]

Yes, it's on a different machine and no there is only a single default instance. I'm getting that error right after I fill in the screen that asks for DB server name and login.

[Beth]

Which IIS Process model did you choose? Yes, it should still log you in, but it sounds like it might be getting past the initial one and doing something else.

In addition, are both machines on the same domain or is this a workgroup?

[Beth]

I just managed to reproduce the error with two servers that are in a workgroup. Having the SQL Server on another machine in a workgroup will only work with SQL authentication. Either both machines need to join a domain or you need to use your SQL Server Management Studio and allow SQL authentication. Then you could use the 'sa' account during the login, and Vault will then create a new user for itself that is not 'sa' for accessing the databases.

Is it possible your SQL Server or your web server are not domain members, or is it possible you logged into the local machine for the install?

[redwards1966]

Both machines are part of the same domain. When installing, I'm logged on as a domain user.

The IIS Process user is set to custom, with the username being a domain user as well. Are there any specific privileges the IIS Process User needs to have?

[redwards1966]

I never did find the answer to this original issue, but I managed to get the install completed by convincing the db admin to turn sql auth on.

[Beth]

I was working on trying to recreate the scenario, but that will take some time.

Is the server you are installing on a Domain Controller?

There shouldn't be anything special to the user.

If you wish to continue troubleshooting, then send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread. If you're ok with how you are currently running, then I will continue my testing on the side.

[Beth]

I wasn't able to reproduce the issue.