Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by anastasiafed
-
dtsrun error
Hi I have a dts package that executes another package as one of it's tasks. Both packages are stored as structured storage files. I am trying to execute the parent package from command prompt using the dtsrun utility. The package executes successfully until it gets to the step that should...- anastasiafed
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Data Transformation Services
-
Analysis Services Security
Ok, we figured it out. If anyone ever has the same problem: If Microsoft Windows NT® 4.0 or Windows® 2000 integrated security is used, the logon account associated with the MSSQLServerOLAPService service must have permissions to access data sources that Analysis Services administrators can...- anastasiafed
- Post #4
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Analysis Services Security
Thank you! I don't think this option is available when you check Win NT authentication. Also, I checked that NT users are OLAP Administrators on both machines (server and workstations).- anastasiafed
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Analysis Services Security
I use Windows NT authentication to connect to the data source (SQL Server 2000). I am able to test the connection successfully as well as see db objects, and create dimensions and cubes. However when I try to process a dimension/all dimensions, or a cube/all cubes, I get the following error...- anastasiafed
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
