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<mailto: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<mailto: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<mailto: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<mailto: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<mailto:arslist@ARSLIST.ORG>] On Behalf Of Murnane, Phil Sent: Tuesday, August 05, 2014 8:23 AM To: arslist@ARSLIST.ORG<mailto: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<mailto:arslist@ARSLIST.ORG>] On Behalf Of patrick zandi [remedy...@gmail.com<mailto:remedy...@gmail.com>] Sent: Tuesday, August 05, 2014 08:38 To: arslist@ARSLIST.ORG<mailto: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 sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"