Page 1 of 1

PA - DSN for SQL Server instance

Posted: Tue Aug 01, 2017 2:07 am
by yyi
I'm sure somebody has a SQL Server connection with an instance name connected to PA control ?
it's not possible to enter the backslash "\" in datasource host:port
PA_DSN.jpg
PA_DSN.jpg (31.57 KiB) Viewed 3307 times
so did/does anyone have any solution or workarounds to get the connection going?

Thanks!

Re: PA - DSN for SQL Server instance

Posted: Thu Aug 03, 2017 2:32 am
by kangkc

Re: PA - DSN for SQL Server instance

Posted: Fri Aug 04, 2017 3:52 pm
by yyi
Thanks kangkc, the link provided some clues and it appears in this case, the instance name could be a red herring. After some testing, connectivity problem starts with windows server 2003 running sql server 2005. Hopefully my support ticket with ibm may yield some answers...

Re: PA - DSN for SQL Server instance

Posted: Thu Aug 10, 2017 5:28 am
by yyi
Well it turns out, that win svr 2003 sp2 running sql 2005 will work with a hotfix:-

https://support.microsoft.com/en-us/hel ... r-2003-sp2
hotfix.PNG
hotfix.PNG (5.8 KiB) Viewed 3163 times