Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL Server adapter
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] SQL Server adapter
 Login/Join
 
Master
posted
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
 
Posts: 484 | Registered: February 03, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6136 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 484 | Registered: February 03, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL Server adapter

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.