PA - DSN for SQL Server instance

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

PA - DSN for SQL Server instance

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

Thanks!
Yeon
kangkc
Community Contributor
Posts: 206
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1, PA , TMVGate
Version: 2.x
Excel Version: 36x
Location: Singapore
Contact:

Re: PA - DSN for SQL Server instance

Post by kangkc »

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

Re: PA - DSN for SQL Server instance

Post 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...
Yeon
User avatar
yyi
Community Contributor
Posts: 121
Joined: Thu Aug 28, 2008 4:42 am
Location: Sydney, Australia

Re: PA - DSN for SQL Server instance

Post 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 3161 times
Yeon
Post Reply