topic Re: VAULT SERVER 2013 - Failed connecting to SQL Server in Vault Forum

VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Sat, 23 Jun 2012 20:45:04 GMT

Hi,

I've upgrade from 2012 to 2013 but when I want to install the Vault Server 2013 an error message appears:

Failed connecting to SQL Server –

server=localhost\AUTODESKVAULT;user id=sa;password=*****

I've appreciate if anybody can help me.

Regards.

Re: VAULT SERVER 2013 - Failed connecting to SQL Server

olearya — Mon, 25 Jun 2012 00:34:33 GMT

Hi There,

2 things to check:

Can you check that SQL is actually running and secondly you will need to make sure that if you have changes the sa password this is modified during the install settings.

If you have the SQL Management Studio installed this is easy to test.

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Mon, 25 Jun 2012 07:27:05 GMT

Start a CMD on the server and enter the command

iisreset

Then try again to connect from the Vault client.

If it doesn't works, check your Default Web Site : you must have only one Default Web Site. (problem occurs on French OS in my experience)

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Mon, 25 Jun 2012 13:55:33 GMT

Hi,

I have a clean backup. So, I've uninstalled everything about the old adms 2012, SQL server to make a clean installation.

I also have ran the "Scripttool.exe" and solved some errors but still have one that I can´t solve. Please see the attached image.

Message: "Checking ASP Status The given path's format is not supported."

Regards.

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Mon, 25 Jun 2012 15:27:48 GMT

I've tried to install the Vault server on another machine and here comes again the ASP message with a variation. Pleas see the attached image.

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

JamesMcMullen — Mon, 25 Jun 2012 19:48:02 GMT

If you attempt to browse to the location listed in the link, does the file exist? Based on this error and the one you mentioned above, I am thinking that there is something wrong with the media. But, let's make sure that is the case.

-Jim

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Mon, 25 Jun 2012 20:17:53 GMT

Yes. The files are in the media but with a little difference in the path.

The setup ask for:

D:\INVENTOR 2013\x64\ADMS\Program Files\Autodesk\ADMS 2013\Tools\TestASPNet.msi

instead the "TestASPNet.msi" files exists in:

D:\INVENTOR 2013\x64\en-US\ADMS\Program Files\Autodesk\ADMS 2013\Tools\TestASPNet.msi

The variation in the path is the "en-US" folder.

So. I've decided to copy the files into the path asked for the setup and now I got the nex message:

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

JamesMcMullen — Mon, 25 Jun 2012 20:43:34 GMT

I am making the assumption that this might be a download. Where was the source? Unfortunately, we have 3 different ways that someone can get the Vault. Also, are you using an English OS or a different language? I would like to reproduce the issue here to help better explain a solution.

Thanks,

Jim

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Mon, 25 Jun 2012 20:53:46 GMT

Thanks Jim.

In fact. The machine has an Spanish OS, and the install media is an english version. The media was downloaded from the upgrade link of the e-mail sent by Autodesk. So, I´ve installed the Suite for inventor but still I can´t setup the Vault server.

Regards,

Carlos Buitrago

Colombia.

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

JamesMcMullen — Mon, 25 Jun 2012 21:04:36 GMT

Can you try switching the "INVENTOR 2013" to "V_Server"? Also, what happens when you run the MSI directly?

-Jim

Re: VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Mon, 25 Jun 2012 21:20:40 GMT

I switched the "INVENTOR 2013" to "V_Server", and ran the Scripttool and remains the same message.

Then, I´ve ran the MSI file and the message changed to:

Also I´ve looked the IIS manager and this is the state:

Regards,

Carlos Buitrago

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Mon, 25 Jun 2012 22:27:11 GMT

I've switched the "INVENTOR 2013" to "V_Server" and ran the MSI file and this is the new message:

I've checked the IIS manager and this is now the state:

Regards,

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

JamesMcMullen — Tue, 26 Jun 2012 14:09:46 GMT

It looks like it is something within the MSI itself where I was thinking it was a path issue to the MSI. I am going to have to pass this along to the install team and see what they can recommend. To get a fast response, I would open up a help ticket with Autodesk.

-Jim

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Tue, 26 Jun 2012 23:18:23 GMT

Ok. Thank you very much.

I'll contact the Autodesk help.

Regards.

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

samuel.seah — Thu, 28 Jun 2012 04:36:36 GMT

Hi Carlos,

Please have a look at the pre-check log file. Inside the log file under the row "Checking ASP Status", can you provide us with the detailed information that is displayed over there?

Thanks,

Samuel

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Thu, 28 Jun 2012 13:16:34 GMT

Hi.

This message is shown in that row:

"Unable To find MSI file:D:\INVENTOR 2013\x64\ADMS\Program Files\Autodesk\ADMS 2013\Tools\TestASPNet.msi"

Thanks,

Carlos Buitrago.

Re : VAULT SERVER 2013 - Failed connecting to SQL Server

samuel.seah — Fri, 29 Jun 2012 07:05:20 GMT

I was unable to reproduce the issue on my machine. Will you be able to provide me with the following details:

1) The type of Inventor Suite which you have downloaded (Product Design/Factory Design)

2) The setup.ini file inside the install folder

Thanks,

Samuel

Re: VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Tue, 03 Jul 2012 13:30:48 GMT

Hi, Samuel.

1) Factory Design Suite Premium

2) Setup.ini file attached.

Re: VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Tue, 03 Jul 2012 18:25:59 GMT

The computer has an spanish OS. Windows 7 64 bit, and the Autodesk Vault server 2013 is in english version. Can be this a reason for those setup problems?.

Regards,

Carlos Buitrago.

Re: VAULT SERVER 2013 - Failed connecting to SQL Server

Anonymous — Tue, 03 Jul 2012 20:46:26 GMT

When I see the error log file, It seems that the setup is searching for a folder in the path: "\\Autodesk Factory Design Suite 2013\x86\en-US\edmprechecks" ...., but when I look into the media I don't see any folder called edmprechecks.

I think that the media for Windows 7 64 bit, may be incomplete.

Can you take a look?

Regards,

Carlos Buitrago.