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