I believe it is telling you it wants just the server name NAME-w12-sql-1 as a slash is not valid in the name of a machine · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address. .Clients cannot communicate to the Server unless they can resolve into an IP address
Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: Tuesday, August 05, 2014 8:23 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** Patrick: Years ago (maybe ARS 4.x?) I encountered a problem where the application server wouldn't connect to a database instance if the name was longer than 12 characters. Maybe try creating an alias in the LMHOSTS file? FWIW, --Phil ________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.com] Sent: Tuesday, August 05, 2014 08:38 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: QQ: MSSQL server name / Instance name issue ** I am sure I am just missing the obvious today.. Win: 2012 - connecting to an instance of the 2012 sql server Servername :: NAME-W12-SQL-1\REMEDY,1435 (mssql connection settings) Instance name :: remedy SA password it says:: · The instance name REMEDY is not valid for the host NAME-w12-sql-1 / port 1435 · Detected the SQLServer instance NAME-W12-SQL-1\ REMEDY for the host dtg-w12-sql-1 / port 1435 So I put in the following:: hostname NAME-W12-SQL-1\REMEDY Instance name : remedy System installer says: · The installer is unable to resolve NAME-w12-sql-1\REMEDY into an IP address.Clients cannot communicate to the Server unless they can resolve into an IP address If I put in the IP address \ REMEDY is says same thing. I know it is something silly, it must be the fly on my nose (too close). if I put in NAME-W12-SQL-1 (it says it should be the above) do I need to create some sort of Alias? like in the /etc/hosts? or registry? for it to get accepted. -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"