Answer Questions

• Rick Phillips440754 Unable to run a report after deployed in a remote server

  Hi All, I encountered the following error after I deployed a report to a remote server. The deployment process was successful, however, when I try to run the reports from the remote report server, It gives me an error message saying: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'SessionOLAP'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors On the other hand, I deployed this report on the local machine and it is running perfect. Do you have any idea how to deal with this problem Thanks! Try stor ...Show All

• Ajay Suri AS2005 Projects best practice?

  Hi, I'm currently looking for the best practice to set-up my AS2005 projects. Any help would be appreciated. We currently need to build a lot of cubes with AS2005 and we have a lot of AS2005 developers working on this... Here are some points to keep in mind: Cubes will share dimensions Some cubes will have their exclusive dimension multiple developers working at the same time on the projects Here are my options: Create one big project to hold all my cubes and dimensions This is easy to set-up and manage Might have some problems having multiple developers working at the same time What if a dimension is used in multiple cubes but we need to define distinct hierarchies for every cube Create on projec ...Show All

• Soup01 database mail isn't working in the SQL Agent job notification

  Hi, Starting a few weeks ago I stopped receiving notifications when SQL Server Agent Jobs failed. The only error I see from the Error logs is the following: "[ 264] An attempt was made to send an email when no email session has been established " I've followed all of the postings about stoping and restarting the Agent service, confirming that the database mail can send out test emails and making sure that database mail account name matches the actual SMTP account. From my testing, I can successfully send out a test email by right-clicking on "Database Mail" - "Send Test E-Mail." Here's my setup: Active/Passive SQL Server 2005 Cluster. 32 bit SS2005 SP1 installed Database Mail worked for around ...Show All

• Mavericko sql connecting error via tcp/ip

  hello , can anybody help me iam getting the same error " target machine will activly refused to connect". while iam connecting to the sql server 2000. i didn't find the sql server listens on 1433 .how to know server is listenning on port 1433. Investigating the event log, you will see that there is an entry upon service start which shows which port the SQL Server instance is using. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• GraemeP Can't restart mirroring. Error 1416 and 1443.

  After stop mirroring, can't restart mirroring. Tried following two things, still can't restart mirroring. 1. Made a full DB backup and a log backup on principle, copied backup files to mirror and restored DB and log with NORECOVERY. Mirror DB is in "Restoring" status. 2. Delete DB on both principle and mirror, recreate DB on the principle, restore DB and log on the mirror with NORECOVERY. Mirror DB is in "Restoring" status. In both cases, after clicked "Start Mirroring", got error 1416. In sql server log file, got error 1443 ("Database mirroring has been terminated..."). Please help. Never mind. Problem solved. ...Show All

• sysawc Sorting Values in Colum Matrix in a logical order in RS2005?

  Hello, I am curios if someonse has accountered issue when you have to sort values in a column matrix in a logical order as opposed to alphabetical order. In my case I would like to have a matrix column sort like in th example below as opposed to 'Graduate', 'Law', 'Total','Undergraduate'. I have a column called OrderKey which forces the sort I want in T-SQL but this sort seems to be ignored by a RS Any ideas how I can fix it Thanks Undergraduate Graduate Law Total Score 230 560 880 1670 You can add a sort expression that evaluates the value and returns an integer based on the logical order. In this case, it would be something like =Switch(Fields!FieldName ...Show All

• Tigers21 MDX Expression For Sum of Days Between Dates

  Hi guys, We have this small problem that we cannot figure out how to do. In a nutshell, we want to write a calculated member that will calculate the difference in days between dates in a table and then it sum all the differences. Our knowledge of MDX is somehow limited :) Thanks Robert J Hello. Like Dave have told you, this is possible to solve with the TSQL DateDiff - function in the datasource view(if you use SSAS2005) or in a view or table expression in SQL Server 2000. HTH Thomas Ivarsson Can you be a little clearer Firstly, MSAS is cubes, dimensions, and measures. Secondly, what do you mean by "sum all of the differences". Between dateA and date ...Show All

• twilightown Error 1011 Remote serve Name

  I was trying to setup a transaction Replication and I get the error "The specified remote server name might not correspond to the network name of the remote server or the remote server was unreachable due to network Problem" I could Add the remote server on my local client and also view the data. Please help ...Show All

• jschroeder Applying SQL 2005 SP1 to a local copy of Workstation Components

  I have installed the Workstation components on my local PC, which also contains VS 2005 and SQL Express. I installed the WS components so that I could run the full blown version of SQL Management Studio from my PC, to remove SQL 2005 servers. I tried to update the Workstation components to SP1, but the SP1 package stops at the Setup Support Files, step and terminates claiming the package does not support SQL Express. I realize the package is not intended for Express, I simply need to update Management studio. I tried running the Post SP1 Tools hotfix and it complains that it will not update SP0 of the tools. I have successfully updated Express to SP1 and applied the Post hotfixes as well. Is there any way to patch just Management studio on ...Show All

• N B De-install and re-install problems SQL server 2005

  I never installed previous beta versions on my computer before. But now I have some serious problem after an incomplete de-install and a re-install of SQL server 2005 express advanced. I hope anybody can help me to solve this. Because the first installation eas not succesfull I had to do an de-install. I have tried to unstall through start/control panel/ add-remove programms and even there not all programs were removed. And that caused the problem. After that I wanted to re-install again but an msi file was missing. So I did a de-install agian. Tried to re-install again but with a lot of errors. After looking at the library I found a program: Windows Install CleanUp. I installed it and that even gives an error for all programs installed ...Show All

• LauraCapatina using sql bulk load and nested complex type

  I am using the SQL bulk load 4 but am new to xsd and sql schemas. Here is my problem. I get a bulk load error stating I need a sql:relationship for any of my nested complex types but the elements in my nested complex type is not going to another table but to the same table as my first complex type. How do I create nested complex types that bulk load the elements to the same table In the example below how do I represent the "Phone" as a complex type in the xsd and have the bulk upload load the elements to the same table as my root complex type Ex. <Root> <ContactInfo> <FirstName></FirstName> <LastName></LastName> <Phone> <Home></Home> <Cell></Ce ...Show All

• MircoS OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• geo2000 Deadlock at trigger

  a trigger need to insert or update record at the other table in high traffic environments however, the deadlock happens; ie, a trigger running twice at the same time want to need to insert record at the table. i trid to change isolation as SERIALIZABLE or REPEATABLE , but i cannot solve the problem. i guess the "while loop" affects the result because i try to cancel the loop and execute smoothly. How to solve the deadlock Thx ----------------------------- i used the following commands to change isolation level: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE begin transaction commit transaction ----------------------------- the code are as follows: declare setskuCursor cursor local static for select item, qua ...Show All

• Dennis van.der Stelt Error when file is saved to PDF

  I am calling a procedure that will save a file to PDF. It runs successfully. When I go to look at the PDF, I get a message, "Acrobat reader could not open 'Doc.pdf' because it is either not a support file or because the file has been damaged." This is how I'm calling the procedure: SaveFile(Dts.Variables( "varSSRS_URL" ).Value.ToString() + " /TestReports/MyReport&rs:Command=Render&rs:Format=PDF" , "C:\" + "MyReport.pdf" ) Unless you're having issues with the variables, this looks like it's an SSRS issue.... I think the thread already going in the SSRS forum would be more beneficial. http://forums.microsoft.com/MSDN/ShowPost.aspx Po ...Show All

• Avi Gershon Merge Join or Union All

  Hi, I am trying to normalize data using the unpivot transform. I have to unpivot using more than one key so I have a multicast feeding into two unpivot transforms then into a sort transform. This is where my problem starts - I have tried using a Merge Join (inner Join) transform but dont get the expected result. My original data looks like this: Pk_ID Choice1 Choice2 Feedback1 Feedback2 10 a b x y After the mulitcast - unpivot - Merge Join, the expected result is: (pk_newID is an identity) Pk_newID fk_ID Choice Feedback 563 10 a x 564 10 b y ...Show All