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: * he 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: MSSQL server name / Instance name issue
I believe it is telling you it wants just the server nameNAME-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.ORGmailto: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
Re: MSSQL server name / Instance name issue
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
Re: MSSQL server name / Instance name issue
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
Re: MSSQL server name / Instance name issue
it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen 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
Re: MSSQL server name / Instance name issue
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 instancethen 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
Re: MSSQL server name / Instance name issue
What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 11:16 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 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.commailto:remedy...@gmail.com wrote: it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.commailto: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.commailto: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.commailto:frederick.w.gro...@xo.com wrote: ** I believe it is telling you it wants just the server nameNAME-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.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: Tuesday, August 05, 2014 8:23 AM To: arslist@ARSLIST.ORGmailto: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.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi [remedy...@gmail.commailto:remedy...@gmail.com] Sent: Tuesday, August 05, 2014 08:38 To: arslist@ARSLIST.ORGmailto: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 _ARSlist: Where the Answers Are and have been for 20 years_ Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail
Re: MSSQL server name / Instance name issue
2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, *Shawn Pierson * Remedy Developer | Energy Transfer *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Tuesday, August 05, 2014 11:16 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** 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 instancethen 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
Re: MSSQL server name / Instance name issue
Just to humor the installation script, have you tried putting the IP Address and server name entry into the hosts file on the AR System server where the MS-SQL client is installed? Also try installing the full client (client tools) and see if you can connect the SQL server manager and open a Query Analyzer session. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 12:42 PM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 11:16 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 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 instancethen 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 nameNAME-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
Re: MSSQL server name / Instance name issue
I have tried host, host\named instancehost\named instance:0,porthost\named instance,port host then instance name going insane.. I can login with ssms, and I can query db no problem but the login is as hostname(or IP)\named instance,port name-W12-SQL-1\REMEDY,1435 8.1.01 does not like it with or without port (cause port is in the line below)... I actually built a server (8 of them) and after installation we had to change the ar.conf to hostname,port or they would not run.. I think someone at the Engineering area missed a step... but this was for a SQL Cluster.. it would let you install, but not bounce..now this one will not let me install.. On Tue, Aug 5, 2014 at 2:24 PM, Joe D'Souza jdso...@shyle.net wrote: ** Just to humor the installation script, have you tried putting the IP Address and server name entry into the hosts file on the AR System server where the MS-SQL client is installed? Also try installing the full client (client tools) and see if you can connect the SQL server manager and open a Query Analyzer session. Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Tuesday, August 05, 2014 12:42 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** 2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, *Shawn Pierson * Remedy Developer | Energy Transfer *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Tuesday, August 05, 2014 11:16 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: MSSQL server name / Instance name issue ** 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 instancethen 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
Re: MSSQL server name / Instance name issue
I am wondering if the user of special characters – in the server name is driving the MS SQL client mad. Just for fun, install MS-SQL server on the same network, on a server that has no special characters (and as per someone else’s suggestion on a server that has less than 12 characters in its server name) and see if you have better luck. If so, you could alias the server in the hosts file to REMEDYSQL or some other friendly name like that and give it a try. I had an issue recently with Oracle where the use of @ in a password drove the Oracle client mad if the password was not enclosed within “” in the auth string. And there was a good reason why that happened. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 3:00 PM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** I have tried host, host\named instancehost\named instance:0,port host\named instance,port host then instance name going insane.. I can login with ssms, and I can query db no problem but the login is as hostname(or IP)\named instance,port name-W12-SQL-1\REMEDY,1435 8.1.01 does not like it with or without port (cause port is in the line below)... I actually built a server (8 of them) and after installation we had to change the ar.conf to hostname,port or they would not run.. I think someone at the Engineering area missed a step... but this was for a SQL Cluster.. it would let you install, but not bounce..now this one will not let me install.. On Tue, Aug 5, 2014 at 2:24 PM, Joe D'Souza jdso...@shyle.net wrote: ** Just to humor the installation script, have you tried putting the IP Address and server name entry into the hosts file on the AR System server where the MS-SQL client is installed? Also try installing the full client (client tools) and see if you can connect the SQL server manager and open a Query Analyzer session. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 12:42 PM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 11:16 AM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 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 instancethen 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
Re: MSSQL server name / Instance name issue
Question … Is there any additional info in the install SQL log? I also found an older Microsoft article on setting TCP ports for named instances http://support.microsoft.com/kb/265808 This will let you use a port to specify an instance or use the server’s port and specify the instance with the \ in the server name Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** I have tried host, host\named instancehost\named instance:0,port host\named instance,port host then instance name going insane.. I can login with ssms, and I can query db no problem but the login is as hostname(or IP)\named instance,port name-W12-SQL-1\REMEDY,1435 8.1.01 does not like it with or without port (cause port is in the line below)... I actually built a server (8 of them) and after installation we had to change the ar.conf to hostname,port or they would not run.. I think someone at the Engineering area missed a step... but this was for a SQL Cluster.. it would let you install, but not bounce..now this one will not let me install.. On Tue, Aug 5, 2014 at 2:24 PM, Joe D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** Just to humor the installation script, have you tried putting the IP Address and server name entry into the hosts file on the AR System server where the MS-SQL client is installed? Also try installing the full client (client tools) and see if you can connect the SQL server manager and open a Query Analyzer session. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 12:42 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 2012 os, 2012 sql server (multiple instances) I am using a name instance called remedy. Checking... ssms connects fine with the ip\remedy in the hostname or hostname\remedy which is the named instance name no problem. logged on to the sql server I see the port 1435 coming in from the ip of the remedy server (SSMS) not because of remedy install. On Tue, Aug 5, 2014 at 12:28 PM, Pierson, Shawn shawn.pier...@energytransfer.commailto:shawn.pier...@energytransfer.com wrote: ** What version are you running into this on? I want to say I had that problem with either 7.5 or maybe 7.6.4 but 8.1 doesn’t have that problem in my environment. I wish I could remember how I got around it. This may be my imagination, but there could be something akin to a portmapper on the SQL Server where you aren’t really using 1435. Can you connect with SSMS and then open up a command prompt and type netstat and hit enter and look for that SQL Server and see what port you are actually connecting to? That may be one thing to investigate. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 11:16 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: MSSQL server name / Instance name issue ** 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.commailto:remedy...@gmail.com wrote: it is a NAMED INSTANCE on the SQL Server... that is why the ip/named instancethen the instance name (which is different). On Tue, Aug 5, 2014 at 11:39 AM, patrick zandi remedy...@gmail.commailto: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.commailto: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.commailto:frederick.w.gro...@xo.com wrote: ** I believe it is telling you