My SQL?

rakkar3 · Post by **rakkar3** » Sat May 06, 2006 2:11 pm

I am trying to install Vault Server and it says it can't connect to a SQL database server. So I installed MySQL and it still says that. If Vault Server does not support My SQL, what free options are available to me to resolve this problem?

dan · Post by **dan** » Sat May 06, 2006 3:45 pm

Microsoft's MSDE and SQL Server are the only two databases supported by Vault. MSDE is free, but has a 2 GB limit on the size of the DB>

rakkar3 · Post by **rakkar3** » Sat May 06, 2006 6:14 pm

I installed MSDE but it still doesn't work.

I have:

SQL Server (local)
Connect using Windows authenticiation

I click "Connect" and it says
"SQL Connection failed. Unable to connect to SQL.
SQL Server does not exist or access deinied"

But I can see it running. Under services (Local) I have SQL Server (SQLEXPRESS) AS "Started"

JimHugh · Post by **JimHugh** » Sun May 07, 2006 9:17 am

Try (local)\SQLExpress

SQLExpress installs as an "instance".

rakkar3 · Post by **rakkar3** » Sun May 07, 2006 9:44 am

That works, thanks. But now I get
"You must use an account that is common to both machines to execute the IIS Process. Press OK to continue the install anyway, or Cancel to Abord this installation"

What does that mean and what should I do to fix it?

JimHugh · Post by **JimHugh** » Sun May 07, 2006 12:40 pm

Haven't seen that error... but the fact that it says "both machines" indicates that you are trying to do a remote install.

Do the server install on the machine that is hosting SQLExpress and IIS, not a workstation.

FWIW, I'm not associated with SourgeGear, just trying to do some peer to peer support.

rakkar3 · Post by **rakkar3** » Sun May 07, 2006 1:02 pm

I'm not doing a remote install.

JimHugh · Post by **JimHugh** » Sun May 07, 2006 2:00 pm

It would be helpful if you stated what you are doing.

Do you meet all of the prereqs in the install guide?

Are you installing as an admin?

What account names?

What OS and version?

What version of the framework?

What paramters are specified during the install

The more info provided, the less back and forth.

rakkar3 · Post by **rakkar3** » Sun May 07, 2006 3:12 pm

This is the version of MSDE
http://www.microsoft.com/sql/editions/e ... fault.mspx

This is the one I downloaded on
http://msdn.microsoft.com/vstudio/express/sql/download/
"Install Microsoft SQL Server 2005 Express Edition"
http://go.microsoft.com/fwlink/?LinkId=65212

I installed it, used the default parameters anytime I was prompted at any stage in the process. I only installed the default components as well.

I have the Microsoft .net framework 2.0 installed.

I am logged in as an admin.

I don't know what you mean by account names. I was never prompted to enter any account names.

I have windows XP service pack 2.

JimHugh · Post by **JimHugh** » Sun May 07, 2006 5:49 pm

And I assume that IIS is installed on your XP workstation? And it was installed before the .Net framework?

The web server is working? You can browse to http://localhost ?

And you are following the steps in the Vault install guide at http://www.sourcegear.com/vault/support/install.html ?

By the account names, I am referring to the info requested at "Checklist before you begin installation" in http://www.sourcegear.com/vault/support ... orial.html

Post by **jclausius** » Sun May 07, 2006 7:57 pm

rakkar3 wrote:That works, thanks. But now I get
"You must use an account that is common to both machines to execute the IIS Process. Press OK to continue the install anyway, or Cancel to Abord this installation"

What does that mean and what should I do to fix it?

This warning comes up when using a named instance with the machine's host name, "(local)", or "." and can be ignored. Click OK to proceed with the installation.