Skip to main content
V
VINO12-Amethyst
12-Amethyst
April 19, 2013
Solved

Can't Install Windchill using SQL Server 2008 R2

  • April 19, 2013
  • 1 reply
  • 3614 views

Hi,

I am trying to install windchill 10.1 M020 with MS Sql Server2008 R2 as a Database.I have successfully installed ms sqlserver 2008 r2 with named instance.Then while Installing the Windchill using psi Solution Installer I'm getting the error.

I have added the screen shots of my psi installer and the error dialog box.I have added the hostname,Instance name,Port number correctly I hope.And I'm not sure about the SQL Server DNS Registered Host Name so I have tried with the server name with instance name,my system name anyway it giving the same error.Also I have checked my sql server also It is working fine.I really don't know what the problem is.Please find the attachment and any help will be useful for me.

The following is my error

Failed to connect to the database. Please check the login credentials (Hostname, Instance name, Port number and User connection information).

*SQL Server DNS Registered Host Name:

Installed SQL Server Instance Name (Named Instance only):

*TCP Port Number for SQL Server Instance:

*Password for User sa:

Best answer by VINO

After tried with everything in hostname I finally solved that issue..When we install SQL with named instance it won't automatically listen to the port 1433.So we need to change the port to default 1433 port and we need to restart the services.Changing the port number can be done by start->all programs->sqlserver 2008 r2-->configuration tools->sqlserver configuration..In that we have to change..Problem fixed.

1 reply

L
lmartin1-Visitor
1-Visitor
April 23, 2013

Hello,

maybe you have an error in the configuration of : "SQL Server DNS Registred Host Name" --> try with GTO25 only

Regards

Laurent

V
VINO12-AmethystAuthorAnswer
12-Amethyst
April 26, 2013

After tried with everything in hostname I finally solved that issue..When we install SQL with named instance it won't automatically listen to the port 1433.So we need to change the port to default 1433 port and we need to restart the services.Changing the port number can be done by start->all programs->sqlserver 2008 r2-->configuration tools->sqlserver configuration..In that we have to change..Problem fixed.

Terms & ConditionsCookie settingsAccessibility statement