When you check your TCP/IP properties in SQL manager, did you set the "IP ALL" TCP/IP Port to 1433?
On that installer page, you select the appropriate DB authentication (Windows Auth or SQL Server) depending on how you set up your DB. Host Name will be the name of your windows machine (System Properties) AR System Server Port defaults to 1433 DB instance should be <Hostname>\<Servername> Everything else should be default. Edward Hum From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Remedy Muse Sent: Monday, June 29, 2009 10:30 PM To: [email protected] Subject: Re: SQL failing with port 1433 & Instance Name ** Ok, thanks for that info. I go it. :) I'm in the remedy installer where it lists ip address, port, instance name, db name, db id, server db pw, etc. I've entered the appropriate info. When I click next, I am still getting the message: tcp/ip connection to the host (#) using port number 1433 failed. -----Original Message----- From: Hum, Edward <[email protected]> To: [email protected] Sent: Mon, Jun 29, 2009 9:01 pm Subject: Re: SQL failing with port 1433 & Instance Name ** You can find the instance name through the SQL Config Mgr. Under the SQL Server Network Configuration branch, there will be another branch that says Protocols for <Servername>. Or you can open up your Services (i'm assuming you're on a Windows box), find the SQL Server process, your instance name will be in brackets beside it. Edward Hum From: Action Request System discussion list(ARSList) [mailto:[email protected] <mailto:[email protected]?> ] On Behalf Of Remedy Muse Sent: Monday, June 29, 2009 8:23 PM To: [email protected] Subject: Re: SQL failing with port 1433 & Instance Name ** In the sql config mgr the ports are set to 1433. But exactly where would i see the instance name? -----Original Message----- From: Hum, Edward <[email protected]> To: [email protected] Sent: Mon, Jun 29, 2009 6:48 pm Subject: Re: SQL failing with port 1433 & Instance Name ** In your SQL Configuration Manager, did you set your TCP/IP ports to 1433? The instance name should be what you called your SQL Server database when you installed it. When you log into the Configuration Manager (if you installed the SQL management tools) you should be able to see the Instance name. Edward Hum _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _____ An Excellent Credit Score is 750. See <http://pr.atwola.com/promoclk/100126575x1221823281x1201398699/aol?redir=htt p://www.freecreditreport.com/pm/default.aspx?sc=668072%26hmpgID=62%26bcd=Jun eExcfooterNO62> Yours in Just 2 Easy Steps! _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.13.0/2209 - Release Date: 06/29/09 14:43:00 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
