AdventureWorks Report Samples Problem

Hi,
I am trying to deploy the AdventureWorks OLAP cube in C:\Program
Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services
Project but unfortunately the folder "AdventureWorks Analysis Services
Project" does not exist nor does the file Adventure Works DW.dwproj. I have
installed the samples using the Microsoft SQL Server 2005 Samples installer.
Where can I find this directory and project?
Kind regards,
TrevorHi Trevor,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to launch
AdventureWorks Analysis Services Project but cannot find it in the
identified folder. If I have misunderstood your concern, please feel free
to point it out.
Based on my knowledge, please perform the steps below to make sure you have
installed AdventureWorksDW sample datawarehouse and AdventureWorks Sample
OLAP.
- Open Add or remove Programs in Control Panel
- Select Microsoft SQL Server 2005, click Change
- Select Workstation Components under SQL Server 2005 common components,
click Next
- After System Configuration Check, click Next.
- Click Change Installed Components
- Expand Documentation, Samples and Sample Databases, Expand Sample
Databases, Expand AdventureWorksDW Sample Data Warehouse. Make sure
everything was selected and then click Next
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Adventureworks db

I installed adventureworks db onto sqlExpress. It does not show up althought it is in the:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

I look up the database in the Microsoft SQL Server Management Studio Express, But it's not visible. I've turned the service off andon, but it still is not available. Any ideas what has happened.

john welte

The installation of the sample database does not mean that you attached it for use in SQL Server. You will need to use the sp_attach procedure or the command which can be found in Management Studio under Right click the Server > Attach Database > specify the location and the name of the database file > Done :-)

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de

AdventureWorks database question

How can I install theAdventureWorks database on my box where C:\Program Files\Microsoft SQL Server\90\Tools\Samples\ is missing? My SQL 2005 is currently without AdventureWorks OLT. I downloaded the Enterprise trial before uninstalling SQL2005Express. Please help. Thanks.

It looks like the AdventureWorks database can be downloadedhere.

HTH,
Ryan

|||

As I did the following:

exec

sp_attach_db @.dbname=N'AdventureWorks', @.filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @.filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'

Here's what came back:

Msg 1813, Level 16, State 2, Line 1

Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.

Msg 602, Level 21, State 50, Line 1

Could not find row in sysindexes for database ID 24, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

What's wrong here?

Any help is greatly appreciated.

|||

Find instawdb.sql and execute it. This will open "SQL server manegament studio. Enter localhost for servername then click connect. On the sql editor toolbar click execute. wait until get the message "database installed succesfully" in the status bar.

|||

When I do that I get the following error messages:

Microsoft SQL Server 2000 - 8.00.194 (Intel X86)

Aug 6 2000 00:57:48

Copyright (c) 1988-2000 Microsoft Corporation

Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

*** Dropping Database

Msg 208, Level 16, State 1, Line 2

Invalid object name 'master.sys.databases'.

*** Creating Database

Msg 208, Level 16, State 1, Line 5

Invalid object name 'master.sys.master_files'.

Msg 102, Level 15, State 6, Line 11

Incorrect syntax near 'CHECKSUM'.

Msg 911, Level 16, State 1, Line 2

Could not locate entry in sysdatabases for database 'AdventureWorksDW'. No entry found with that name. Make sure that the name is entered correctly.

*** Creating DDL Trigger for Database

Msg 170, Level 15, State 1, Line 9

Line 9: Incorrect syntax near 'max'.

Msg 156, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 3

Incorrect syntax near the keyword 'DATABASE'.

Msg 195, Level 15, State 10, Procedure ddlDatabaseTriggerLog, Line 14

'EVENTDATA' is not a recognized function name.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 15

Line 15: Incorrect syntax near '.'.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 16

Line 16: Incorrect syntax near '.'.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 17

Line 17: Incorrect syntax near '.'.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 25

Line 25: Incorrect syntax near 'max'.

Msg 170, Level 15, State 1, Procedure ddlDatabaseTriggerLog, Line 44

Line 44: Incorrect syntax near '.'.

*** Creating Tables

Msg 2714, Level 16, State 6, Line 2

There is already an object named 'AdventureWorksDWBuildVersion' in the database.

Msg 170, Level 15, State 1, Line 80

Line 80: Incorrect syntax near 'max'.

*** Loading Data

Msg 208, Level 16, State 1, Line 6

Invalid object name 'master.sys.master_files'.

Msg 1779, Level 16, State 0, Line 2

Table 'DimAccount' already has a primary key defined on it.

Msg 1750, Level 16, State 0, Line 2

Could not create constraint. See previous errors.

Msg 1913, Level 16, State 1, Line 2

There is already an index on table 'DimAccount' named 'AK_DimAccount_AccountCodeAlternateKey'.

*** Creating Foreign Key Constraints

Msg 2714, Level 16, State 4, Line 2

There is already an object named 'FK_DimAccount_DimAccount' in the database.

Msg 1750, Level 16, State 0, Line 2

Could not create constraint. See previous errors.

*** Creating Table Views

Msg 170, Level 15, State 1, Procedure vDMPrep, Line 48

Line 48: Incorrect syntax near ';'.

Msg 170, Level 15, State 1, Procedure vTimeSeries, Line 41

Line 41: Incorrect syntax near ';'.

Msg 170, Level 15, State 1, Procedure vTargetMail, Line 62

Line 62: Incorrect syntax near ';'.

Msg 208, Level 16, State 1, Procedure vAssocSeqOrders, Line 7

Invalid object name 'dbo.vDMPrep'.

Msg 170, Level 15, State 1, Procedure vAssocSeqLineItems, Line 12

Line 12: Incorrect syntax near ';'.

*** Creating Functions

Msg 2714, Level 16, State 5, Procedure udfMinimumDate, Line 15

There is already an object named 'udfMinimumDate' in the database.

*** Disabling DDL Trigger for Database

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'TRIGGER'.

*** Changing File Growth Values for Database

Msg 911, Level 16, State 1, Line 2

Could not locate entry in sysdatabases for database 'AdventureWorksDW'. No entry found with that name. Make sure that the name is entered correctly.

*** Shrinking Database

Msg 2520, Level 16, State 12, Line 2

Could not find database 'AdventureWorksDW'. Check sysdatabases.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

And on that download link none of those will install either, they installation stops with an error.

AdomdConnection Error

Hi~

I write a web service by using ADOMD.

When I excute the program under debug mode in my computer for testing,it's ok.

But when I establish this web in the server,and browse(In Server) it to use, the error is happened.

follow is my code & error messahe

Code Snippet

<WebMethod()> _
Public Function Test2() As String
Dim UserIdPwd As String = "Data Source = olapdw;Catalog = STATION;"
Dim advwrksConnection As New AdomdConnection(UserIdPwd)
Dim tmp

advwrksConnection.Open()
tmp = advwrksConnection.Database.ToString + advwrksConnection.Cubes.Count.ToString + advwrksConnection.ConnectionString
advwrksConnection.Dispose()
Return tmp

End Function

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, NT AUTHORITY\NETWORK SERVICE, does not have access to the STATION database, or the database does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, Boolean sendNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.GetPropertyFromServer(String propName, Boolean sendNSCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.get_Database()
at Service.Test2() in C:\Inetpub\wwwroot\Service\App_Code\ASAdminService.vb:line 709

Could some tell me why? or how to check?

Thanks~

This is the same issue as your AMO question:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2032042&SiteID=1

The web service is running under an account that does not have rights to access SSAS, you need to either run the web service under a different account which does have rights to the cube or grant access in SSAS to the account which the web service is currently running under.

If SSAS and IIS are on different machines, the setting up a domain account for the web service and giving it access is probably the way to go. If they are on the same machine your could put the NETWORK SERVICE account in a role in SSAS so that it has rights to access the cubes.

|||

Thanks for your answer~

The problem has already resolved.

Adobe iFilter 5 & SQL Server 2000 full text indexing of PDFs?

hi all! i'm new and hoping you might help me - have searched E V E R Y W H E R E for this answer!!

--my ASP program is running on IIS box (call it "Lucy")

--my ASP program connects to SQL Server 2000 db on another box (call it "Linus") consisting of .doc, .xls, .PDF and the like

--all's well EXCEPT when PDFs are returned! sometimes browser gives blank screen instead of PDF <?> i figure iFilter will "cure" this.

--question:
WHICH SERVER should iFilter be installed on? Lucy (where IIS is running & ASP program is) or Linus (where SQL Server does its full text indexing)?

thanks in advance for any & all help!!
geekgirlYou will have to install IFilter on the box that runs index server. I am not sure why you should be worried about SQL server when you searching documents from a folder.

Are ur documents stored in a database?|||Originally posted by vibhu
You will have to install IFilter on the box that runs index server. I am not sure why you should be worried about SQL server when you searching documents from a folder.

Are ur documents stored in a database?

sorry, YES docs are stored directly in the SQL db. iFilter says to install it "where the index server is" -- but i don't know if that means the *** IIS Index Server*** or the ***SQL Server**** which is doing the full text indexing. <??>

ADO recordcount returns -1

Hi All
Upgraded Vb6 program from Access 2K to MSDE 2K RelA
Now all my checks for rs.recordcount return -1, except if I use Client side
cursor OR
if I use... rs.Open sql, cn, adOpenKeyset, adLockReadOnly
Why is this?
I don't want to use client side cursors and I need to save data so
(adLockReadOnly) is no good
I have found that that checking for rs.eof seems reliable as a substitute
for recordcount but would like to understand the reasoning
Regards
Steve
hi Steve,
steve wrote:
> Hi All
> Upgraded Vb6 program from Access 2K to MSDE 2K RelA
> Now all my checks for rs.recordcount return -1, except if I use
> Client side cursor OR
> if I use... rs.Open sql, cn, adOpenKeyset, adLockReadOnly
> Why is this?
> I don't want to use client side cursors and I need to save data so
> (adLockReadOnly) is no good
> I have found that that checking for rs.eof seems reliable as a
> substitute for recordcount but would like to understand the reasoning
this is quiet normal using ADO recorset as the recordcount will be available
only when the entire rowset has been populated, ant this is true only when a
..movelast operation ins performed and all the data has been transferred..
please be warned that performing a rs.movelast + rs.movefirst can be a
timeconsuming operation for big results...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||> please be warned that performing a rs.movelast + rs.movefirst can be a
> timeconsuming operation for big results...
In addition to that, if you DO need to know how many rows you have
(which OP did not in this case), I would first run a select
count(afield) " and the same from/where clause that you use in the
other query. Actually, in those cases you can sometimes eliminate some
of the INNER JOINS that you might have to use when getting the full
field list, and some of the WHERE clause, too -- which will give you
your rowcount faster.
I do this a lot when I want to display a progress bar.
In addition, when looping through a recordset, I ALWAYS do until
rs.eof...I never use the .rowcount property for anything but advising
the user. Not sure WHY I do this, but I've been doing it for years...
Matt
Matt

ado datasets

hi

i am using older ado datasets in a borland 6 program.

i need to retrieve the data per record count....

example is that i need all 1000 records but i only want to retrieve them 100 at a time....

how will i accomplish this?

This may give you some usable ideas.

Paging Queries
www.aspfaq.com/2120

Admin User Account from Front -end Interface

Hi all,
I would like to create User Account(mean user can admin
user account) from Front-end (using VB 6.0), pls give How
to, sample program or manual how to.
TIAYou can create a new SQL Server login account using sp_addlogin:
EXEC sp_addlogin 'AdminAccount', 'AdminPassword'
Or you can grant an existing windows account access to SQL Server with
sp_grantlogin:
EXEC sp_grantlogin 'MyDomain\AdminAccount'
If the account is to be a server administrator, you can add it to the
sysadmin server role:
EXEC sp_addsrvrolemember 'AdminAccount', 'sysadmin'
or
EXEC sp_addsrvrolemember 'MyDomain\AdminAccount', 'sysadmin'
Note that you shouldn't use a sysadmin login for routine application access.
See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
<thankch@.hotmail.com> wrote in message
news:045b01c3c9c3$6b3384d0$a301280a@.phx.gbl...

quote:

---

> Hi all,
> I would like to create User Account(mean user can admin
> user account) from Front-end (using VB 6.0), pls give How
> to, sample program or manual how to.
> TIA
>

---