but if I take the slash out and put it into the instance name it fails as well. DB Information: Hostname or IP :: Hostname IP instance name : blank --- invalid instance
if Hostname or IP :: Hostname IP instance name : remedy is says "Instance name remedy is not validfor host ip/port " "Detected the sql server instance name-w12-sql-1\remedy for the host ip /port 1435 " It tells you what it should be but cannot accept it.. On Tue, Aug 5, 2014 at 10:27 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > ** > > 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 > *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 > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"