Focal Point
[CLOSED] SQL Server adapter

This topic can be found at:

January 09, 2011, 11:47 PM
[CLOSED] SQL Server adapter
Hai all

I have a local SQL Server 2008 database on my PC.
How can I create metadata for this database on my localhost? Can someone help me on this? I created for Access db. this sql db has no user id or pwd, goes with windows authentication.,

Thank you..

This message has been edited. Last edited by: Kerry,

HTML,PDF,EXL2K, Active, All
January 10, 2011, 12:08 AM
MSSQL 2008 is accessible through the 2005 interface.

When you create the connection use Password Passthrough.


Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

January 10, 2011, 01:39 PM
I tried the same.
It says server does not exist or access denied. for server name i gave local host and for default database i gave database name
An suggestions on this?

HTML,PDF,EXL2K, Active, All
January 10, 2011, 02:11 PM
Francis Mariani
If you're pointing to your local MS SQL Server database from a WebFOCUS reporting server that's not on your local machine, then localhost cannot be used - try the computer name. In fact, open SQL Server Enterprise Manager and take a look at the name of the server - that's what you should be using - whether the WebFOCUS reporting server is local or not...


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server