Where are the SQL services?

[tyip]

Sorry if this is a basic question, but I'm an SQL newbie. Here goes...

I have been trying to install SQL Server 2005 since it is a prerequisite for Vault 4.1.1. I installed the full Enterprise edition and all seemed to go without a hitch. After launching the SQL Server Management Studio, I was prompted to enter a Server Name. First question:

1. What do I enter as the Server Name, Authentication, Username, and Password if I have not configured anything?

After not being able to get past this, I thought I would check to see if SQL was even running. It appears that the services are not even installed. By that I mean that using the Computer Management application, I do not see any SQL-related services in the service list, let alone running. So...

2. Why don't I see any services listed? Is this normal?

A more general question is:

3. How do I verify that SQL was installed properly and is running?

Thanks in advance,
Tom

[lbauer]

Here's some informatioin that should help --

1. Installing SQL Server 2005

http://msdn2.microsoft.com/en-us/library/ms143219.aspx

2. Verify SQL Server is running:


http://msdn2.microsoft.com/en-us/library/ms143673.aspx

[tyip]

Thanks for the tips.

I believe that I have been able to install SQL 2005 successfully. Now I get this error when installing Vault 4.1.1:

Looking for IIS Version
Configuring your new Vault Installation
Requesting the IIS Process User...Requesting Vault Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for an existing databases...Not found.
Creating a new Vault database on .\sqlexpress...
Creating the SourceGear master database...OK
Creating the SourceGear source control database...OK
Creating SourceGear master stored procedures...OK
Creating SourceGear source control stored procedures...OK
Adding Data to SourceGear master database...OK
Adding Data to SourceGear source control database...OK
Adding the admin user...OK
The user, VAGRANT\ASPNET, could not be added as a SQL Server login. Please verify the windows account exists on this machine.

Note, on some database collations check the case of the user's name.
Vault Setup is exiting due to a failure or cancellation. Error Code = 402


Any ideas how to fix this?

Thanks in advance,
Tom

[lbauer]

The installer is having a problem with the machine account, VAGRANT\ASPNET.

What OS are you installing Vault on? Is it 32- or 64-bit?

Does the VAGRANT\ASPNET account exist on the Vault Server machine?

Is your SQL Server on the same machine or a different machine than the Vault Server?

Could you send a copy of the Vault _install.log log file to me at support at sourcegear.com Attn: Linda? It's in your user's temp directory.

[simbonk]

Hello,

I am installing this software, and I believe I am having the same problem as the posting in this thread. Did this ever get resolved?

Installing Vault on XP Pro and connecting to a MS SQL 2005 Database on Windows 2003 Server.

Thanks!

[lbauer]

We didn't hear back from the other user.

Send me a copy of the Vault Server installation log. It's called Vault_install.log and is in your user's temp directory on the server machine. Send it zipped up to support at sourcegear.com, Attn: Linda.

Please add a link to this post in your email.

[lbauer]

The errors in the installation log tell me that you are trying to use the machine account for the IIS process model on the Vault server machine and Windows authentication for the SQL Server which is on a different machine. The machine account is a local account and would not have access to the SQL Server machine.

The solution is to:

--use a domain account for the IIS process model,
--or use the machine account, but in the SQL Server setup portion of the installation, use SQL Server authentication. The installer will create an account called sgvaultuser that Vault will use to communicate with the database.


HelpSpot 124912