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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
