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:[email protected]] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 3:00 PM To: [email protected] Subject: Re: MSSQL server name / Instance name issue ** I have tried host, host\named instance host\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 <[email protected]> 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:[email protected]] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 12:42 PM To: [email protected] 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 <[email protected]> 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:[email protected]] On Behalf Of patrick zandi Sent: Tuesday, August 05, 2014 11:16 AM To: [email protected] 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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:[email protected]] On Behalf Of Murnane, Phil Sent: Tuesday, August 05, 2014 8:23 AM To: [email protected] 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) [[email protected]] On Behalf Of patrick zandi [[email protected]] Sent: Tuesday, August 05, 2014 08:38 To: [email protected] 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 hyperlink, please e-mail sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Patrick Zandi _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ -- 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"
