PA - DSN for SQL Server instance

Post Reply
User avatar
yyi
Community Contributor
Posts: 111
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

PA - DSN for SQL Server instance

Post by yyi » Tue Aug 01, 2017 2:07 am

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 291 times
so did/does anyone have any solution or workarounds to get the connection going?

Thanks!
win2012 svr: tm1 v10.2.2 x64, client v10.2.2 x64/PA 2.0, win10, excel 365.

kangkc
Community Contributor
Posts: 166
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

Re: PA - DSN for SQL Server instance

Post by kangkc » Thu Aug 03, 2017 2:32 am


User avatar
yyi
Community Contributor
Posts: 111
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

Re: PA - DSN for SQL Server instance

Post by yyi » Fri Aug 04, 2017 3:52 pm

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...
win2012 svr: tm1 v10.2.2 x64, client v10.2.2 x64/PA 2.0, win10, excel 365.

User avatar
yyi
Community Contributor
Posts: 111
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

Re: PA - DSN for SQL Server instance

Post by yyi » Thu Aug 10, 2017 5:28 am

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 147 times
win2012 svr: tm1 v10.2.2 x64, client v10.2.2 x64/PA 2.0, win10, excel 365.

Post Reply