I wish I could do a screen capture to let you see where you can see that.. But I am not in front of a ready MS-SQL install..
Did you specify a port while installing SQL? If not it should be 1433. Try installing your patch by using that port.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Kevin Sent: Friday, June 11, 2010 3:35 PM To: [email protected] Subject: Re: Problem installing ARS7.5 patch3 , Vista, Oracle 10g ...now fails under Windows 7, MSSQL 2008!! ** "The port will be in the properties settings of the server in the SQL Server Management Studio. The default SQL Server port is 1433. 1521 is the default Oracle port.." I see no port number listed, only protocol as tcpip. ?? From: Joe D'Souza Sent: Friday, June 11, 2010 8:22 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Problem installing ARS7.5 patch3 , Vista, Oracle 10g ...now fails under Windows 7, MSSQL 2008!! ** Kevin, The port will be in the properties settings of the server in the SQL Server Management Studio. The default SQL Server port is 1433. 1521 is the default Oracle port.. So unless while installing MS-SQL server if you changed the default port of the SQL server to 1521, you should be using 1433. FYI, these are default database client ports for various databases.. MS-SQL - 1433 Oracle: 1521 DB2 - 50000 Sybase - 4100 Informix - 1526 Datadirect Sequelink Server - 19996 Hope this helps.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Kevin Rutenberg Sent: Friday, June 11, 2010 3:13 PM To: [email protected] Subject: Re: Problem installing ARS7.5 patch3 , Vista, Oracle 10g ...now fails under Windows 7, MSSQL 2008!! ** What client? I can connect to SQL Server Management Studio with either Windows Auth or SQL Server Auth. It does not request or specify a port. I am using windows firewall and even tried opening that specific port, no avail. ---------------------------------------------------------------------------- Date: Fri, 11 Jun 2010 15:11:06 -0400 From: [email protected] Subject: Re: Problem installing ARS7.5 patch3 , Vista, Oracle 10g ...now fails under Windows 7, MSSQL 2008!! To: [email protected] ** Are you using port 1521 to connect the SQL client to the database? Is the firewall blocking it? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Kevin Rutenberg Sent: Friday, June 11, 2010 2:50 PM To: [email protected] Subject: Re: Problem installing ARS7.5 patch3 , Vista, Oracle 10g ...now fails under Windows 7, MSSQL 2008!! ** This is getting very annoying...very. I finally decided to try the easier option, MSSQL 2008. I also upgraded my laptop to Windows 7. That all went fine. Then installed MSSQL, set all pre install tasks as per the Install-750.pdf - ARSystem database, ARAdmin user, roles, specified TCP port 1521 I have tried running installer under both Windows Auth and SQL Sever Auth, both give following error and I am unable to proceed. "TCP connection to the host acer using port number 1521 failed, possible causes Database services are not running/available Net config not configured correctly for TCPIP protocol IP or host name/port number is not correct" I can connect to SQL Server Management Studio with either Windows Auth or SQL Server Auth. So why is installer saying it can't connect to d/b instance?? Help, I'll have no more hair shortly or worse - give up! _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
