http://technet.microsoft.com/en-us/library/ms191229%28v=sql.105%29.aspx
shows the format: but it appears remedy does not follow it? also the drop down never works, but I guessed that was another bug. On Tue, Aug 5, 2014 at 12:01 PM, patrick zandi <remedy...@gmail.com> wrote: > it is a NAMED INSTANCE on the SQL Server... > that is why the ip/named instance then the instance name (which is > different). > > > > On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi <remedy...@gmail.com> > wrote: > >> Lets start with the environment: >> When logging into MSSQL server management studio I use the following >> settings. >> Servername : name-w12-sql-1\remedy >> instance name : remedy >> >> with sa password and Voila.. no problems. >> if I view connection properties it says: >> Server name:: name-w12-sql-1/remedy,1435 >> instance name:: remedy >> >> With 2012 sql server you can create seperate instances within itself. >> hope that makes sense. >> >> >> >> On Tue, Aug 5, 2014 at 11:11 AM, patrick zandi <remedy...@gmail.com> >> wrote: >> >>> 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 >>> >> >> >> >> -- >> Patrick Zandi >> > > > > -- > Patrick Zandi > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
