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