Focal Point
[CLOSED] SQL Server adapter

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9327007695

January 09, 2011, 11:47 PM
Enigma006
[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,


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

When you create the connection use Password Passthrough.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

January 10, 2011, 01:39 PM
Enigma006
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?


8.1.05
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...


Francis


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