Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work properly...so, I eventually, dropped to a command prompt, did a netstat -a -n -o, and looked for the process ID of the SQL Server Process, and found what port it was running on, and used that in the installer... Afterwards, the Remedy service doesn't have issue connecting, because it uses the native client, not the same thing the installer does Just a thought for you to get over this hump :) On Sun, Feb 22, 2015 at 6:49 PM, Joe D'Souza jdso...@shyle.net wrote: ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\*jmdsouza* and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\*jdsouza* (not [SERVERNAME]\*jmdsouza*) for ITSM 8.1.02, I chose the AR System and the AR Clients as the options for my installation and at the prompt for the “AR System Server and Database Information”, I entered the local [SERVERNAME] where all the red masked info is below. I entered the password of [CAMARO\*jmdosuza*] When I press Next, after a brief while, my next screen I am met with the error “TCP/IP connection to the host Camaro2015 using port number 1433 failed. Possible causes: Database services are not available/running or Network configuration is not configured correctly for TCP/IP protocol or IP or host name/ port number is incorrect.” On my MS-SQL Server Configuration Manager, I have enabled both the Client and Server TCP/IP protocol.. What might I be missing? Cheers Joe _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Hey Carl, I am on SP4 of MS-SQL 2008 – forgot to add that. Both the server and the agent are / were running at the time I got the error. I had tried the install without pre-creating the database, got that same error so had given it a shot by pre-creating a database which is when I took the screen shots that I added. I should have mentioned that I did try the install without pre-creating the database. I haven’t tried mixed-mode yet. So if all else fails (after reading other responses I have got), I’ll give mixed mode authentication with and without pre-creating a database. Cheers Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Monday, February 23, 2015 2:29 AM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Hi Joe, A couple of things: * Install SP1 for MSSQL 2008. * Check that both the SQL Server and SQL Server Agent services are running in Windows. * The SSI will install its own instance of the Database as ARSystem/ARAdmin, so no requirement to pre-create this. * If you are having trouble with the Windows Authentication, you can enable the mixed mode authentication in the MSSQL Server - ensure you check the password policies if doing so as although it may allow you to set a password it will enforce the strength on external connections, so you may need to disable this setting on the sa user. Sounds like there is a process not running although the client can connect, you can always disable the firewall to see if it is rules related also (and log the connections to check missing port openings). _ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: 23 February 2015 01:49 To: arslist@ARSLIST.ORG Subject: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\jmdsouza and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\jdsouza (not [SERVERNAME]\jmdsouza) for ITSM 8.1.02, I chose the AR System and the AR Clients as the options for my installation and at the prompt for the “AR System Server and Database Information”, I entered the local [SERVERNAME] where all the red masked info is below. I entered the password of [CAMARO\jmdosuza] When I press Next, after a brief while, my next screen I am met with the error “TCP/IP connection to the host Camaro2015 using port number 1433 failed. Possible causes: Database services are not available/running or Network configuration is not configured correctly for TCP/IP protocol or IP or host name/ port number is incorrect.” On my MS-SQL Server Configuration Manager, I have enabled both the Client and Server TCP/IP protocol.. What might I be missing? Cheers Joe _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
I hit send too soon. About the firewall, isn’t inbound connections to port 1433 all that is required for the installer to connect to the MS-SQL server? Does it require any other inbound port to be opened? Cheers Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Monday, February 23, 2015 2:29 AM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Hi Joe, A couple of things: * Install SP1 for MSSQL 2008. * Check that both the SQL Server and SQL Server Agent services are running in Windows. * The SSI will install its own instance of the Database as ARSystem/ARAdmin, so no requirement to pre-create this. * If you are having trouble with the Windows Authentication, you can enable the mixed mode authentication in the MSSQL Server - ensure you check the password policies if doing so as although it may allow you to set a password it will enforce the strength on external connections, so you may need to disable this setting on the sa user. Sounds like there is a process not running although the client can connect, you can always disable the firewall to see if it is rules related also (and log the connections to check missing port openings). _ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: 23 February 2015 01:49 To: arslist@ARSLIST.ORG Subject: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\jmdsouza and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\jdsouza (not [SERVERNAME]\jmdsouza) for ITSM 8.1.02, I chose the AR System and the AR Clients as the options for my installation and at the prompt for the “AR System Server and Database Information”, I entered the local [SERVERNAME] where all the red masked info is below. I entered the password of [CAMARO\jmdosuza] When I press Next, after a brief while, my next screen I am met with the error “TCP/IP connection to the host Camaro2015 using port number 1433 failed. Possible causes: Database services are not available/running or Network configuration is not configured correctly for TCP/IP protocol or IP or host name/ port number is incorrect.” On my MS-SQL Server Configuration Manager, I have enabled both the Client and Server TCP/IP protocol.. What might I be missing? Cheers Joe _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work properly...so, I eventually, dropped to a command prompt, did a netstat -a -n -o, and looked for the process ID of the SQL Server Process, and found what port it was running on, and used that in the installer... Afterwards, the Remedy service doesn't have issue connecting, because it uses the native client, not the same thing the installer does Just a thought for you to get over this hump :) On Sun, Feb 22, 2015 at 6:49 PM, Joe D'Souza jdso...@shyle.net wrote: ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\jmdsouza and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\jdsouza (not [SERVERNAME]\jmdsouza) for ITSM 8.1.02, I chose the AR System and the AR Clients as the options for my installation and at the prompt for the “AR System Server and Database Information”, I entered the local [SERVERNAME] where all the red masked info is below. I entered the password of [CAMARO\jmdosuza] When I press Next, after a brief while, my next screen I am met with the error “TCP/IP connection to the host Camaro2015 using port number 1433 failed. Possible causes: Database services are not available/running or Network configuration is not configured correctly for TCP/IP protocol or IP or host name/ port number is incorrect.” On my MS-SQL Server Configuration Manager, I have enabled both the Client and Server TCP/IP protocol.. What might I be missing? Cheers Joe _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Laurent, I think you’re bang on target! LJ’s suggestion to check netstat output to see the port SQL was using instead of assuming it will automatically use the default port did help to confirm that this might be the solution as I noticed the dynamic port was set to 49438 and on netstat I was getting TCP[::]:49438 [::]:0 LISTENING 2056 Where 2056 was the PID of the SQL-Server On removing the dynamic port setting and setting the port to 1433 as instructed on that article I now get this on netstat on restarting the SQL server and getting a new PID of 3888. TCP[::]:1433 [::]:0 LISTENING 3888 I think it should work now. Yet to run installer. I know I do not need to restart the server but will do so just in case... Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work properly...so, I eventually, dropped to a command prompt, did a netstat -a -n -o, and looked for the process ID of the SQL Server Process, and found what port it was running on, and used that in the installer... Afterwards, the Remedy service doesn't have issue connecting, because it uses the native client, not the same thing the installer does Just a thought for you to get over this hump :) On Sun, Feb 22, 2015 at 6:49 PM, Joe D'Souza jdso...@shyle.net wrote: ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\ jmdsouza and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Makes sense. So that 2000 entries restriction is only when I actually start using the system for my demo purposes correct? I’ve paused without hitting next until I’m able to confirm that. Since I’m setting this up on my personal PC with the end goal to get onto the version 9.0 beta test bandwagon, getting a trial license might be a little complicated for me. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 2:13 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Cool ^_^ It should install correctly since it's just a database restore when installing with SSI :) On 23 Feb, 2015,at 07:55 PM, Joe D'Souza jdso...@shyle.net wrote: Thanks guys, LJ’s suggestion of checking the actual port the MS-SQL server was using helped approaching the solution. The article Laurent forwarded nailed it where it showed where the dynamic port was set. Had to null that out and set the TCP Port to 1433. Now the installer is past the error and prompted me for the sa login and password. Since I am setting up a demo system, if I leave the license keys blank and go forward, will it still install the apps with no issues? I understand the limitations of not being able to insert more than 2000 records etc. as it used to be in the past. I’m ok with that for this demo instance. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work properly...so, I eventually, dropped to a command prompt, did a netstat -a -n -o, and looked for the process ID of the SQL Server Process, and found what port it was running on, and used that in the installer... Afterwards, the Remedy service doesn't have issue connecting, because it uses the native client, not the same thing the installer does Just a thought for you to get over this hump :) On Sun, Feb 22, 2015 at 6:49 PM, Joe D'Souza jdso...@shyle.net wrote: ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work properly...so, I eventually, dropped to a command prompt, did a netstat -a -n -o, and looked for the process ID of the SQL Server Process, and found what port it was running on, and used that in the installer... Afterwards, the Remedy service doesn't have issue connecting, because it uses the native client, not the same thing the installer does Just a thought for you to get over this hump :) On Sun, Feb 22, 2015 at 6:49 PM, Joe D'Souza jdso...@shyle.net wrote: ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\ jmdsouza and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\ jdsouza (not [SERVERNAME]\ jmdsouza ) for ITSM 8.1.02, I chose the AR System and the AR Clients as the options for my installation and at the prompt for the “AR System Server and Database Information”, I entered the local [SERVERNAME] where all the red masked info is below. I entered the password of [CAMARO\ jmdosuza ] When I press Next, after a brief while, my next screen I am met with the error “TCP/IP connection to the host Camaro2015 using port number 1433 failed. Possible causes: Database services are not available/running or Network configuration is not configured correctly for TCP/IP protocol or IP or host name/ port number is incorrect.” On my MS-SQL Server Configuration Manager, I have enabled both the Client and Server TCP/IP protocol.. What might I be missing? Cheers Joe _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Thanks guys, LJ’s suggestion of checking the actual port the MS-SQL server was using helped approaching the solution. The article Laurent forwarded nailed it where it showed where the dynamic port was set. Had to null that out and set the TCP Port to 1433. Now the installer is past the error and prompted me for the sa login and password. Since I am setting up a demo system, if I leave the license keys blank and go forward, will it still install the apps with no issues? I understand the limitations of not being able to insert more than 2000 records etc. as it used to be in the past. I’m ok with that for this demo instance. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work properly...so, I eventually, dropped to a command prompt, did a netstat -a -n -o, and looked for the process ID of the SQL Server Process, and found what port it was running on, and used that in the installer... Afterwards, the Remedy service doesn't have issue connecting, because it uses the native client, not the same thing the installer does Just a thought for you to get over this hump :) On Sun, Feb 22, 2015 at 6:49 PM, Joe D'Souza jdso...@shyle.net wrote: ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\ jmdsouza and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\ jdsouza (not [SERVERNAME]\ jmdsouza ) for ITSM 8.1.02, I chose the AR System and the AR Clients as the options for my installation and
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Cool ^_^ It should install correctly since it's just a database restore when installing with SSI :) On 23 Feb, 2015,at 07:55 PM, Joe D'Souza jdso...@shyle.net wrote: Thanks guys, LJ’s suggestion of checking the actual port the MS-SQL server was using helped approaching the solution. The article Laurent forwarded nailed it where it showed where the dynamic port was set. Had to null that out and set the TCP Port to 1433. Now the installer is past the error and prompted me for the sa login and password. Since I am setting up a demo system, if I leave the license keys blank and go forward, will it still install the apps with no issues? I understand the limitations of not being able to insert more than 2000 records etc. as it used to be in the past. I’m ok with that for this demo instance. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work properly...so, I eventually, dropped to a command prompt, did a netstat -a -n -o, and looked for the process ID of the SQL Server Process, and found what port it was running on, and used that in the installer... Afterwards, the Remedy service doesn't have issue connecting, because it uses the native client, not the same thing the installer does Just a thought for you to get over this hump :) On Sun, Feb 22, 2015 at 6:49 PM, Joe D'Souza jdso...@shyle.net wrote: ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\ jmdsouza and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
I don't think it does On Mon, Feb 23, 2015 at 1:27 PM, Joe D'Souza jdso...@shyle.net wrote: ** Oh ok.. I want to run 8.x at least for a day or two to get a “look feel” of the new features on 8.x over 7.6.04 before I upgrade that instance to the 9.0 beta. So far I’m aware of new 8.x features over 9.0 only through some documentations and reading some of the ARS list postings of them. Will the 9.0 Beta key work for 8.x? Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing *Sent:* Monday, February 23, 2015 3:17 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, ITSM requires that the Remedy server be licensed...so, for 'Demo' purposes, if you plan on installing ITSM, you will need to get a Trial license for your server before you can install it...otherwise, you can use the un-licensed Remedy server for evaluation purposes onlythe 9.0 Beta License Key is in the forumswhich you have access to, so you should be able to find it :) On Mon, Feb 23, 2015 at 12:20 PM, Joe D'Souza jdso...@shyle.net wrote: ** Makes sense. So that 2000 entries restriction is only when I actually start using the system for my demo purposes correct? I’ve paused without hitting next until I’m able to confirm that. Since I’m setting this up on my personal PC with the end goal to get onto the version 9.0 beta test bandwagon, getting a trial license might be a little complicated for me. Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *laurent matheo *Sent:* Monday, February 23, 2015 2:13 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Cool ^_^ It should install correctly since it's just a database restore when installing with SSI :) On 23 Feb, 2015,at 07:55 PM, Joe D'Souza jdso...@shyle.net wrote: Thanks guys, LJ’s suggestion of checking the actual port the MS-SQL server was using helped approaching the solution. The article Laurent forwarded nailed it where it showed where the dynamic port was set. Had to null that out and set the TCP Port to 1433. Now the installer is past the error and prompted me for the sa login and password. Since I am setting up a demo system, if I leave the license keys blank and go forward, will it still install the apps with no issues? I understand the limitations of not being able to insert more than 2000 records etc. as it used to be in the past. I’m ok with that for this demo instance. Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *laurent matheo *Sent: *Monday, February 23, 2015 1:00 PM *To: *arslist@ARSLIST.ORG *Subject: *Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe -- *From:** Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] On Behalf Of LJ LongWing* * Sent: Monday, February 23, 2015 10:31 AM* *To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG* *Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 * ** Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Oh ok.. I want to run 8.x at least for a day or two to get a “look feel” of the new features on 8.x over 7.6.04 before I upgrade that instance to the 9.0 beta. So far I’m aware of new 8.x features over 9.0 only through some documentations and reading some of the ARS list postings of them. Will the 9.0 Beta key work for 8.x? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 3:17 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, ITSM requires that the Remedy server be licensed...so, for 'Demo' purposes, if you plan on installing ITSM, you will need to get a Trial license for your server before you can install it...otherwise, you can use the un-licensed Remedy server for evaluation purposes onlythe 9.0 Beta License Key is in the forumswhich you have access to, so you should be able to find it :) On Mon, Feb 23, 2015 at 12:20 PM, Joe D'Souza jdso...@shyle.net wrote: ** Makes sense. So that 2000 entries restriction is only when I actually start using the system for my demo purposes correct? I’ve paused without hitting next until I’m able to confirm that. Since I’m setting this up on my personal PC with the end goal to get onto the version 9.0 beta test bandwagon, getting a trial license might be a little complicated for me. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 2:13 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Cool ^_^ It should install correctly since it's just a database restore when installing with SSI :) On 23 Feb, 2015,at 07:55 PM, Joe D'Souza jdso...@shyle.net wrote: Thanks guys, LJ’s suggestion of checking the actual port the MS-SQL server was using helped approaching the solution. The article Laurent forwarded nailed it where it showed where the dynamic port was set. Had to null that out and set the TCP Port to 1433. Now the installer is past the error and prompted me for the sa login and password. Since I am setting up a demo system, if I leave the license keys blank and go forward, will it still install the apps with no issues? I understand the limitations of not being able to insert more than 2000 records etc. as it used to be in the past. I’m ok with that for this demo instance. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 10:31 AM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work properly...so, I eventually, dropped to a command prompt, did a netstat -a -n -o, and looked for the process ID of the SQL Server Process, and found what port it was running on, and used that in the installer... Afterwards, the Remedy service doesn't have
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Joe, ITSM requires that the Remedy server be licensed...so, for 'Demo' purposes, if you plan on installing ITSM, you will need to get a Trial license for your server before you can install it...otherwise, you can use the un-licensed Remedy server for evaluation purposes onlythe 9.0 Beta License Key is in the forumswhich you have access to, so you should be able to find it :) On Mon, Feb 23, 2015 at 12:20 PM, Joe D'Souza jdso...@shyle.net wrote: ** Makes sense. So that 2000 entries restriction is only when I actually start using the system for my demo purposes correct? I’ve paused without hitting next until I’m able to confirm that. Since I’m setting this up on my personal PC with the end goal to get onto the version 9.0 beta test bandwagon, getting a trial license might be a little complicated for me. Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *laurent matheo *Sent:* Monday, February 23, 2015 2:13 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Cool ^_^ It should install correctly since it's just a database restore when installing with SSI :) On 23 Feb, 2015,at 07:55 PM, Joe D'Souza jdso...@shyle.net wrote: Thanks guys, LJ’s suggestion of checking the actual port the MS-SQL server was using helped approaching the solution. The article Laurent forwarded nailed it where it showed where the dynamic port was set. Had to null that out and set the TCP Port to 1433. Now the installer is past the error and prompted me for the sa login and password. Since I am setting up a demo system, if I leave the license keys blank and go forward, will it still install the apps with no issues? I understand the limitations of not being able to insert more than 2000 records etc. as it used to be in the past. I’m ok with that for this demo instance. Joe -- *From: *Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *laurent matheo *Sent: *Monday, February 23, 2015 1:00 PM *To: *arslist@ARSLIST.ORG *Subject: *Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe -- *From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] On Behalf Of LJ LongWing* * Sent: Monday, February 23, 2015 10:31 AM* *To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG* *Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 * ** Joe, Just the other day I was helping a friend setup a 'home install' of Remedy, and I was having difficulty trying to get the DB running on 1433, just as you are describingI went through the configuration, enabled TCPIP, configured it to run on 1433 in all the places I could find, for all of the IP's, etc...couldn't get it to work properly...so, I eventually, dropped to a command prompt, did a netstat -a -n -o, and looked for the process ID of the SQL Server Process, and found what port it was running on, and used that in the installer... Afterwards, the Remedy service doesn't have issue connecting, because it uses the native client, not the same thing the installer does Just a thought for you to get over this hump :) On Sun, Feb 22, 2015 at 6:49 PM, Joe D'Souza jdso...@shyle.net wrote: ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Conversely, if I get a trial license for 8.x and then upgrade that instance later to 9.0 beta, will I have to redo the license and get a new beta license? Or will that trial license continue to work? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 3:29 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** I don't think it does On Mon, Feb 23, 2015 at 1:27 PM, Joe D'Souza jdso...@shyle.net wrote: ** Oh ok.. I want to run 8.x at least for a day or two to get a “look feel” of the new features on 8.x over 7.6.04 before I upgrade that instance to the 9.0 beta. So far I’m aware of new 8.x features over 9.0 only through some documentations and reading some of the ARS list postings of them. Will the 9.0 Beta key work for 8.x? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 3:17 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Joe, ITSM requires that the Remedy server be licensed...so, for 'Demo' purposes, if you plan on installing ITSM, you will need to get a Trial license for your server before you can install it...otherwise, you can use the un-licensed Remedy server for evaluation purposes onlythe 9.0 Beta License Key is in the forumswhich you have access to, so you should be able to find it :) On Mon, Feb 23, 2015 at 12:20 PM, Joe D'Souza jdso...@shyle.net wrote: ** Makes sense. So that 2000 entries restriction is only when I actually start using the system for my demo purposes correct? I’ve paused without hitting next until I’m able to confirm that. Since I’m setting this up on my personal PC with the end goal to get onto the version 9.0 beta test bandwagon, getting a trial license might be a little complicated for me. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 2:13 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Cool ^_^ It should install correctly since it's just a database restore when installing with SSI :) On 23 Feb, 2015,at 07:55 PM, Joe D'Souza jdso...@shyle.net wrote: Thanks guys, LJ’s suggestion of checking the actual port the MS-SQL server was using helped approaching the solution. The article Laurent forwarded nailed it where it showed where the dynamic port was set. Had to null that out and set the TCP Port to 1433. Now the installer is past the error and prompted me for the sa login and password. Since I am setting up a demo system, if I leave the license keys blank and go forward, will it still install the apps with no issues? I understand the limitations of not being able to insert more than 2000 records etc. as it used to be in the past. I’m ok with that for this demo instance. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0 LISTENING 2056 Looks like I might need to use port 49438 for that installer? If I use that, would I need to reset it back to 1433 anywhere after the installation? Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, February 23, 2015 10:31 AM To: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
- Start Sql Server Configuration Mangager - Open SQL Server Network Configuration - Protocols for MSQLSERVER - Check that TCP/IP is enabled and it is assigned to port 1433 (or another port) -- J 2015-02-23 2:49 GMT+01:00 Joe D'Souza jdso...@shyle.net: ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\*jmdsouza* and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\*jdsouza* (not [SERVERNAME]\*jmdsouza*) for ITSM 8.1.02, I chose the AR System and the AR Clients as the options for my installation and at the prompt for the “AR System Server and Database Information”, I entered the local [SERVERNAME] where all the red masked info is below. I entered the password of [CAMARO\*jmdosuza*] When I press Next, after a brief while, my next screen I am met with the error “TCP/IP connection to the host Camaro2015 using port number 1433 failed. Possible causes: Database services are not available/running or Network configuration is not configured correctly for TCP/IP protocol or IP or host name/ port number is incorrect.” On my MS-SQL Server Configuration Manager, I have enabled both the Client and Server TCP/IP protocol.. What might I be missing? Cheers Joe _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
I have used the SSI installer with bad licenses before (due to the case sensitive nature of MAC address on the BMC license generator) and all worked fine. I licensed it after. Cheers, Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@gmail.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: February-23-15 16:10 To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Hummm maybe it's a bit different since Joe is using SSI installer? He doesn't install component per component but it's a database restore. But well anyway I'm not a license expert :p SSI (Suite Stack Installer) Installation should go fine, I don't know about the use later... On 23 Feb, 2015,at 09:17 PM, LJ LongWing lj.longw...@gmail.com wrote: ** Joe, ITSM requires that the Remedy server be licensed...so, for 'Demo' purposes, if you plan on installing ITSM, you will need to get a Trial license for your server before you can install it...otherwise, you can use the un-licensed Remedy server for evaluation purposes onlythe 9.0 Beta License Key is in the forumswhich you have access to, so you should be able to find it :) On Mon, Feb 23, 2015 at 12:20 PM, Joe D'Souza jdso...@shyle.net wrote: ** Makes sense. So that 2000 entries restriction is only when I actually start using the system for my demo purposes correct? I’ve paused without hitting next until I’m able to confirm that. Since I’m setting this up on my personal PC with the end goal to get onto the version 9.0 beta test bandwagon, getting a trial license might be a little complicated for me. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 2:13 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Cool ^_^ It should install correctly since it's just a database restore when installing with SSI :) On 23 Feb, 2015,at 07:55 PM, Joe D'Souza jdso...@shyle.net wrote: Thanks guys, LJ’s suggestion of checking the actual port the MS-SQL server was using helped approaching the solution. The article Laurent forwarded nailed it where it showed where the dynamic port was set. Had to null that out and set the TCP Port to 1433. Now the installer is past the error and prompted me for the sa login and password. Since I am setting up a demo system, if I leave the license keys blank and go forward, will it still install the apps with no issues? I understand the limitations of not being able to insert more than 2000 records etc. as it used to be in the past. I’m ok with that for this demo instance. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port manually (which is not the case in the real / full SQL Server): http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx On 23 Feb, 2015,at 06:52 PM, Joe D'Souza jdso...@shyle.net wrote: LJ, That is strange. And you might be right on this one. I just ran a netstat result (hadn’t even thought of that as I had accepted all defaults as far as ports were concerned during the MS-SQL install) and assumed that 1433 was the port the SQL server was listening on. It seems its not. The PID for MS-SQL server is 2056 and this is what I see for that PID on a netstat. TCP[::]:49438 [::]:0
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
That’s good to know for future reference. I was hoping that was the design as it would hurt installation timelines if one had to wait for a license to be made available until starting to install given that getting a license there is an external dependency especially for a new site where sometimes it takes a while to get all the information required to generate the key. Cheers Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: Monday, February 23, 2015 9:29 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 I have used the SSI installer with bad licenses before (due to the case sensitive nature of MAC address on the BMC license generator) and all worked fine. I licensed it after. Cheers, Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@gmail.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: February-23-15 16:10 To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** Hummm maybe it's a bit different since Joe is using SSI installer? He doesn't install component per component but it's a database restore. But well anyway I'm not a license expert :p SSI (Suite Stack Installer) Installation should go fine, I don't know about the use later... On 23 Feb, 2015,at 09:17 PM, LJ LongWing lj.longw...@gmail.com wrote: ** Joe, ITSM requires that the Remedy server be licensed...so, for 'Demo' purposes, if you plan on installing ITSM, you will need to get a Trial license for your server before you can install it...otherwise, you can use the un-licensed Remedy server for evaluation purposes onlythe 9.0 Beta License Key is in the forumswhich you have access to, so you should be able to find it :) On Mon, Feb 23, 2015 at 12:20 PM, Joe D'Souza jdso...@shyle.net wrote: ** Makes sense. So that 2000 entries restriction is only when I actually start using the system for my demo purposes correct? I’ve paused without hitting next until I’m able to confirm that. Since I’m setting this up on my personal PC with the end goal to get onto the version 9.0 beta test bandwagon, getting a trial license might be a little complicated for me. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 2:13 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Cool ^_^ It should install correctly since it's just a database restore when installing with SSI :) On 23 Feb, 2015,at 07:55 PM, Joe D'Souza jdso...@shyle.net wrote: Thanks guys, LJ’s suggestion of checking the actual port the MS-SQL server was using helped approaching the solution. The article Laurent forwarded nailed it where it showed where the dynamic port was set. Had to null that out and set the TCP Port to 1433. Now the installer is past the error and prompted me for the sa login and password. Since I am setting up a demo system, if I leave the license keys blank and go forward, will it still install the apps with no issues? I understand the limitations of not being able to insert more than 2000 records etc. as it used to be in the past. I’m ok with that for this demo instance. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Monday, February 23, 2015 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 Btw, are you using the real SQL Server or the Express version? I just realized that you had express in your instance name. If it's the Express version it seems you have to setup the 1433 port
Re: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
Hi Joe, A couple of things: · Install SP1 for MSSQL 2008. · Check that both the SQL Server and SQL Server Agent services are running in Windows. · The SSI will install its own instance of the Database as ARSystem/ARAdmin, so no requirement to pre-create this. · If you are having trouble with the Windows Authentication, you can enable the mixed mode authentication in the MSSQL Server - ensure you check the password policies if doing so as although it may allow you to set a password it will enforce the strength on external connections, so you may need to disable this setting on the sa user. Sounds like there is a process not running although the client can connect, you can always disable the firewall to see if it is rules related also (and log the connections to check missing port openings). _ Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: 23 February 2015 01:49 To: arslist@ARSLIST.ORG Subject: Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008 ** I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\jmdsouza and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\jdsouza (not [SERVERNAME]\jmdsouza) for ITSM 8.1.02, I chose the AR System and the AR Clients as the options for my installation and at the prompt for the “AR System Server and Database Information”, I entered the local [SERVERNAME] where all the red masked info is below. I entered the password of [CAMARO\jmdosuza] When I press Next, after a brief while, my next screen I am met with the error “TCP/IP connection to the host Camaro2015 using port number 1433 failed. Possible causes: Database services are not available/running or Network configuration is not configured correctly for TCP/IP protocol or IP or host name/ port number is incorrect.” On my MS-SQL Server Configuration Manager, I have enabled both the Client and Server TCP/IP protocol.. What might I be missing? Cheers Joe _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Error while setting up my demo instance of AR System and ITSM Management Suite 8.1.02 on MS-SQL 2008
I did try that yesterday. It is just too overwhelming with multiple choices that look like they might mean the same product when choosing the product you are seeking compatibility information for. And after choosing BMC Remedy IT Service Management Suite and extracting the Excel file, I got the file that I had posted in an earlier response which had a URL for a PDF doc having an address that no longer exists. Anyway got the PDF file from Laurent who had downloaded it at a time when that URL had worked. I’m now facing another issue. I successfully installed the MS-SQL server 2008, and configured it so that it’s Management Studio could connect to the server (had some firewall issues initially where I had to expose port 1433 to inbound connections – for fun I also exposed the sqlserv.exe for inbound traffic so it would work even if the SQL port was changed down the line). I’m assuming that is more than enough to guarantee SQL client connectivity to the SQL server when running the ITSM stack installer. I tried to connect with the above settings and no problems. I can get into the SQL server – it’s a one tiered setup for demo purposes. I have my MS-SQL server installed as a named instance supporting Windows Authentication. I then created a ARSystem database, and created an SQL login with windows authentication [SERVERNAME]\jmdsouza and made this Login the dbo of the ARSystem where [SERERNAME] is the red part of the masked information in the screenshot. Subsequently when installing the preconfigured stack installer logged into Windows as [SERVERNAME]\jdsouza (not [SERVERNAME]\jmdsouza) for ITSM 8.1.02, I chose the AR System and the AR Clients as the options for my installation and at the prompt for the “AR System Server and Database Information”, I entered the local [SERVERNAME] where all the red masked info is below. I entered the password of [CAMARO\jmdosuza] When I press Next, after a brief while, my next screen I am met with the error “TCP/IP connection to the host Camaro2015 using port number 1433 failed. Possible causes: Database services are not available/running or Network configuration is not configured correctly for TCP/IP protocol or IP or host name/ port number is incorrect.” On my MS-SQL Server Configuration Manager, I have enabled both the Client and Server TCP/IP protocol.. What might I be missing? Cheers Joe _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
