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"
