Answer Questions

• Keith Chapman db_dtsadmin role

  Our DBA has given me access to MSDB on the SSIS service on one of our servers as db_dtsadmin. When I try to connect to the server using Integration Services in the connect drop down menu, I get the following generic error msg: connect to SSIS service on server 'xxxx' failed: access is denied. I'm told this role should be sufficient to give me access. Do I need other server access roles to use in conjunction with db_dtsadmin or are we missing something really easy here. Thanks. DBRICHARD wrote: Thanks! This looks to be the answer. We'll try it. If that works for you, be sure to mark this thread as answered. Thanks! DBRICHARD wrote: Our DBA has given me access to MSDB o ...Show All

• aliassce Install and Uninstall problem

  Mike, I am having the same issue, but a slightly different situation. I installed sql express...then thought I should uninstall and install sql express with advanced services...got the sa login error described in this thread but with error number 29521. the summary log says this...should I also send you the error log referenced in this log Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Fri Jan 05 09:59:01 2007 Machine : myname Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:\Program Files\Microsoft SQL Server\Setup Bootstr ...Show All

• PeteJM01 Cannot login using Integrated Authentication

  I can't seem to login using Integrated Authentication. I enter the user name / password and receive "You are not authorized". I messed with everything I can find and no solution. * I can browse a simple web page. * I cannot browse LocalStart.asp (get asked for User/Password) * I can set security on the reports folder to Anon and browse to Home.aspx * I have disabled the loopbackcheck. This is my dev box running Media Center 2005 w/SP2, IIS 5.1, SQL Server 2005 Any help would be appreciated. The only way that seems to work is if I change it in the Internet zone and not the Intranet zone. Changing the Intranet zone still fails. Doesn't this create a huge security hole becaus ...Show All

• Evan Mulawski Great Plains database replication

  Our company has a database server (Windows Server 2003 x64 EE w/ SQL Server 2005 x64 EE) that has Great Plains installed. We have a database for one of our companies that I would like to begin replicating to another server. The reason behind this is that we want to run the GP/CRM Connector which requires 32-bit ODBC connections. Anyways, what I need to do is enable replication to our 32-bit server. We have been successful in making this happen from 64-bit to 32-bit with a much smaller database. When I go to enable peer-to-peer in the properties of the publication (which I set up using all of the default settings), SQL Management Studio will hang and run for days while appearing to be working. However, when we end up killing Management S ...Show All

• akin_l Probleam with ReportViewer Jumping to Report

  Hi, We have an ASP.NET application using a ReportViewer to show reports. I have two reports (both with logo - image - in yours headers): - Report A: with action to jump to Report B. - Report B: with action to jump to Report A. This work fine into BID and into Report Manager , but into our application, when I click in first link into Report A, show me the Report B, but our logo isn't visible. If I try to return to Report B (clicking in action), show me this error: The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath) May I need to configure something into my web.config to work fine too Thanks. ...Show All

• Rtalan report viewer keep showing report is being generated

  hi all, i developed a web app with embedded report viewer to show the reports (server report). everything works alright. i created a setup file to install it at another machine. everything looks ok except that when i want to view the report, it will always show 'Report is being generated' for a very long time when it only takes a few seconds when i view it on report server. i found the following warning in event viewer (application): Process information: Process ID: 4976 Process name: aspnet_wp.exe Account name: DWPC1\ASPNET Exception information: Exception type: SoapException Exception message: System.Web.Services.Protocols.SoapException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found ---> Mic ...Show All

• boban-mk Change partition Source through XMLA

  Hi everyone, I've got a small problem that I hope that someone can help me with. I am quite new to datawarehousing, so when I started out I didn't take partitioning measuregroups into consideration. Now my problem is taht the actual processing of my cubes takes to much time. Therfore I decided to start creating partitions, but since I have quite a lot of measuregroups I wanted to create them in SSIS. This has worked out fine and the partitions are created, but since we are using standard edition of ssas 2005 I can't craete more than 3 partitions a measuregroup. Therfore I decided to alter my design a bit more and actually have one working partition and one history partition. My questions are: 1. Since my old partition is ba ...Show All

• cmaclo Question about performance

  I'm using a tableadapter for my update operations. The application i'm using typically creates 2500 dirty rows for a single table and then updates using the tableadapter.Update(). The tableadapter.update() method takes about 50 seconds to complete, which is way too long. This is the only query running agaist the sql server 2000 database ( as this is a test server only), so i'm not sure if it is a problem with sql server or a problem with the tableadapter. Can anyone recomment how to improve performance for updating with the tableadapter and sql 2000 Thanks in advance.   How big is each row Was the CPU fully utilized Is the client remote or local For performance related issue, if you can describe your configurat ...Show All

• robertje developing new task

  Hi Can i inherit a existing task to a new custom class to add functionality to custom class. for eg: Inherit lookup transfor which is already present in SSIS to add some funstionality into it. Thanks Vipul https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=796926&SiteID=1 ...Show All

• *A Database Snapshots Performance

  Hi, I'm developing a Data Mart and i'm experiencing a performance gap between my fact table and its snapshot. I create snapshot with the istruction: CREATE DATABASE DB_SNAP ON ( NAME = DB_SNAP_Data , FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ DB_SNAP_Data .ss' ) AS SNAPSHOT OF DB ; And it works. But executing queries on the snapshot result very "low". Can anyone tell me why Tanks. F. There is a section in Books Online titled "How Database Snapshots Work" which shows the extra level of redirection for snapshots. For a newly created snapshot, the data will not be in cache so it might take a little while to pull the data into the buffer pool. Once i ...Show All

• programmingisfun Integration services Globla variable and scheduling issue

  I have one main package from which i am executing 5 other packages.I want to use one single DB connection in all the packages which i am declaring in Main package and it should be available in all the child packages. How can i Do this Few Variables are common is all the packages so i want to keep it Globally so how can i access those variables How can i schedule package in sql server Thanks Priyank Gajera wrote: Hi, Thanks for the answer I am able to get other variables or values in child package using parent package variable but I don't know how to assign any variable to OLD DB connection manager or FTP Connection manager(I am using both type of connection manager as well as Flat file connection) So please guid ...Show All

• Francisco Tavares c# against ms sql express - multi user access

  I have developed two programs that operates against the same database. One of the program is just a display program that displayes the data put into the other administation program where you put in the data to be displayed (an administration program). Every time I access the db from the administration program, the display program stops and throws connection pool errors and other database errors. For me, it looks like it does’t do multi-access to a database. I have tried putting user instance to off in both programs, but this didn’t help. Connection string also points to same file database. Looks like you got things going, just wanted to check back to be sure things were working. Mike ...Show All

• incendy delete all sql database user objects

  Good afternoon, I have a little trouble with sql server 2005 express database: customer need install new web application to hosting, but at hosting is currently exist other web application and it's using DB what I must use. DB contains a big number of tables, views, functions, etc. I need delete all user objects from this DB, it must be as new created one. Is any query whitch can do this PS: I know, best way for this is delete DB and create new one, but i haven't permissions for these. Thank's for reply. so u want to drop all objects created by u...u can generate delete scripts(for all user objects in that DB) for all the objects using the management studio...select all the items u need ...Show All

• JoshKorn 7031A Class Setup

  Has anyone downloaded the DVD splits for the 7031A class yet After I downloaded all of the files I created the Instructor DVD to have the VMC/VHD files for the class setup but there were no Virtual Disk files in the "Drives" folder...only a text file called "placeholder". Any ideas on how to get the BCBase.exe, Upgrade.exe, InPlace.exe, SideBySide.exe and SQL7Upgrade.exe files -- David J. Culley EduCorp Training & Consulting Have you tried installing them on a seperate machine, you might refer to the download link location from where you have got this file. ...Show All

• crazyabtdotnet Installing SP2 directly over SQL Server 2005 without sp1

  Hello, 1. Can we directly install sp2 without SP1 - for sql server 2005. 2 . Iam basically dotnet developer. iam using sql server 2005 both developer and express editions. Do i need to stop sql server service before installing sp2. During sp1 installation, it seems some file are locked and when it prompt, i stopped service and continued installation. 3. Moreover Sql server 2005 express edition comes along with VS2005 didn't have management studio. I feel like having entire features installed in my system. I have downloaded express edition SQLEXPR_ADV.exe. Which is better choice for installation. thanks karthik I would suggest to wait until full release of SP2 in this case as it is under CTP now, o ...Show All