cannot connect to server

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Role Playing dimensions Currency Conversion issue Hi, Having issues with Currency Conversion in SSAS when using role playing dimensions of Time. When the Dim Usage in the cube is set for the role playing dimensions, i.e. defining the relation between the Exchange rate fact and the role playing time dims. the base $ measures (no calculations) return a null value. The generated conversion script in Calculations has leaves(Time), not the leaves for each role playing dim. With leaves for each along with leaves(time), the base measures return null. Regards Tag: cannot connect to server
  - 2
    - deletescript for cleanup Hi twinsen We also have databases with more than 100 GB (one > 1 TB). Due to the size of your databases you should work in chunks. If you want to delete 1 mio records in one step you work into risk to get huge LOCKS on your database. My solution for cleanup scripts in our system was to work with two temp tables. First get a big chunk (e.g. 500.000) records which shuold be deleted into a temp table to avoid always to search from main tables by many criteria. After that you can delete in 10.000 record steps with a second temp table which gets its IDs from the main temp table. You should avoid big LOCKING problems and can work with transactions. Here a small pseudy example: Code Block WHILE EXISTS ( SELECT TOP 1 * FROM MainTable WHERE HasToBeDeleted = 1 ) BEGIN INSERT INTO #ManyToBeDeleted -- The value 500.000 is just an excample, you have to evaluate -- the highest value to avoid locks SELECT TOP 500000 priceid FROM MainTable WHERE HasToBeDeleted = 1 WHILE EXISTS ( SELECT TOP 1 * FROM #ManyToBeDeleted ) BEGIN BEGIN TRANSACTION -- 10.000 is just an example, evaluate your best chunk size INSERT INTO #ToBeDeletedChunk SELECT TOP 10000 priceid FROM #ManyToBeDeleted DELETE OT FROM OtherTables OT JOIN #ToBeDeletedChunk TBDC ON OT . priceid = TBDC . priceid DELETE MT FROM MainTable MT JOIN #ToBeDeletedChunk TBDC ON MT . priceid = TBDC . priceid DELETE MTBD FROM #ManyToBeDeleted MTBD JOIN #ToBeDeletedChunk TBDC ON MTBD . priceid = TBDC . priceid DELETE FROM #ToBeDeletedChunk COMMIT TRANSACTION END END You should also add indexes to the both temp tables. Regards Flo Tag: cannot connect to server
  - 3
    - extract distinct information and order the results The possible query, Assumption : The tran_nr are inserted in sequence. Suggestion, instead of using the id use the timestamp. Code Snippet Create Table #data ( [tran_nr] int , [ret_ref_no] int , [msg_type] int , [description] Varchar ( 100 ) ); Insert Into #data Values ( '5111' , '12345' , '420' , 'reversal' ); Insert Into #data Values ( '5112' , '12345' , '200' , 'auths' ); Insert Into #data Values ( '5113' , '15236' , '200' , 'auths' ); Insert Into #data Values ( '5114' , '46587' , '200' , 'auths' ); Insert Into #data Values ( '5115' , '46587' , '420' , 'reversal' ); select * from #data main where exists ( select l . ret_ref_no from #data l inner join #data r on l . ret_ref_no = r . ret_ref_no and l . tran_nr < r . tran_nr where l . msg_type = '420' and r . msg_type = '200' and main . ret_ref_no = l . ret_ref_no ) Tag: cannot connect to server
  - 4
    - How to use a dialog retry timer for doing a web service call Timers are per dialog. Why are messages A and B sent on the same dialog in the first place Is there some correlation between them you left out of the explanation HTH, ~ Remus Tag: cannot connect to server
  - 5
    - how to excluded the intersection of 2 dimensions ? Hi, I have the following simplified problem. I have a fact table and two dimension tables, colors and weekdays. I can make a query to select all except red and all except on monday but I like to make a query to select all except red mondays They query tool doesn't give you really the options. Any suggestions Constantijn Enders Tag: cannot connect to server
  - 6
    - Error while BAM deployment on SQl server express 2005 C:\Program Files\Microsoft BizTalk Server 2006\Tracking>bm.exe deploy-all -Defin itionFile:testtype.bam.xml Microsoft (R) Business Activity Monitoring Utility Version 3.5.1602.0 Copyright (C) 2006 Microsoft Corporation. All rights reserved. Using 'BAMPrimaryImport' BAM Primary Import database on server 'MOHSASLPT13719\S QLEXPRESS'... Deploying Activity... ERROR: The BAM deployment failed. The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 (Clien t unable to establish connection). The SQL statement issued has failed. The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 (Clien t unable to establish connection). The SQL statement issued has failed. Tag: cannot connect to server
  - 7
    - how to write this query? If you can create an inline table function to do the job the functon is a reasonable to make the code more readable; however, I would avoid a scalar function because scalar functions can put a lot of drag on a query. Something like this might work: create function dbo.discount ( @cLineDiscTag char(1), @cReceiptsMultiDivFlag char(1), @nTrnsQty integer, @nLineDisc1 integer, @nReceiptsCurrConRate numeric (9,2), @nUnitPrice numeric (9,2) ) returns table as return ( select CASE WHEN @cLineDiscTag = '2' THEN (CASE WHEN @cReceiptsMultiDivFlag = 'D' THEN (@nTrnsQty * @nLineDisc1) / @nReceiptsCurrConRate ELSE (@nTrnsQty * @nLineDisc1) * @nReceiptsCurrConRate END) ELSE (CASE WHEN @cReceiptsMultiDivFlag = 'D' THEN (@nTrnsQty * @nUnitPrice * @nLineDisc1 / 100) / @nReceiptsCurrConRate ELSE (@nTrnsQty * @nUnitPrice * @nLineDisc1 / 100) * @nReceiptsCurrConRate END) END as Discount1 ) Thanks for nudging me Arnie; I'm afraid I kind of fell asleep at the wheel. You have picked me up a couple of times today and I really appreciated it. I am just not fully together today; I don't know why, but I really appreciate you nudging me a couple of times today. :-) Kent Tag: cannot connect to server
  - 8
    - Out of Memory Error when running a Select Statement Hi all, In the object Explorer in SQL Server 2005 Management Studio, if I right click on the table I want to open and choose open, I eventually get an out of memory error with an error source: MSCORLIB. This table contains 40m records, but when it opens the table it goes past the 40m and wants to open 83m records, and then eventually comes up with an out of memory error. The properties of the table indicates that there are 40m records, but when you open the table, at the bottom, where it says retrieving data, it is counting of numbe rof records that surpass the 40m total. Is it because the database is too big, or is there a way to configure SQL Server 2005 to use X amount of memory Regards Tag: cannot connect to server
  - 9
    - Change filename for flat file connection manager at runtime Hi Rishi, I did something to fix it then, but I would't solve it the same way today. The following example gets data from a file with a date in it. The date is always the current date so the Connection string needs to be updated to be able to read from the file. I hope this gives you an idea of how to solve your problem! Regards, Sara ----------------------------------------------------------------------------------------- Script Task Connection Manager Name: L:\VPKBA\Laddning\EDBKjerne\konto_YYYYMMDD.txt File Name: L:\VPKBA\Laddning\EDBKjerne\konto.txt Imports System Imports System.IO Imports System.Data Imports Microsoft.SqlServer.Dts.Runtime Public Class ScriptMain Public Sub Main () Dim theDate As String Dim i As Integer strPath = "L:\vpkba\laddning\EDBkjerne\" theDate = Now.Year & IIf( CInt (Now.Month) < 10, "0" & Now.Month, Now.Month).ToString & IIf( CInt (Now.Day) < 10, "0" & Now.Day, Now.Day).ToString For i = 0 To Dts.Connections.Count - 1 If Dts.Connections(i).Name.Contains( "YYYYMMDD" ) Then Dts.Connections.Item(i).ConnectionString = Dts.Connections.Item(i).Name.Replace( "YYYYMMDD" , theDate) End If Next Dts.TaskResult = Dts.Results.Success End Sub End Class Tag: cannot connect to server
  - 10
    - Get previous sale for a customer's sale? Sorry, but I'm afraid I don't follow what you are trying to do here. Could you provide a little more detail and/or provide a table of expected results Thanks, Bryan Tag: cannot connect to server
  - 11
    - Trigger to insert multiple records into related table You might be able to get by with something like this: create trigger dbo.iTr_cat_control on dbo.Cat_Control for insert as begin create trigger dbo.iTr_cat_control on dbo.Cat_Control for insert as begin -- ------------------------------------------------------------ -- This trigger works by taking the cross product of each -- row inserted into the cat_control table with each of the -- 4 possible answers. This avoids a looping or 2-level -- level looping process. -- ------------------------------------------------------------ insert into dbo.det_control ( cat_control_id, cat_control_name, det_control_answer ) select i.cat_control_id, i.cat_control_name, a.answer from inserted i cross join ( -- replace the 'Case' with whatever it should be select 1 as caseId, 'First Answer' as answer union all select 2 as caseId, 'Second Answer' as answer union all select 3 as caseId, 'Third Answer' as answer union all select 4 as caseId, 'Fourth Answer' as answer ) a end go insert into cat_control values (1, 'This is a test.') select * from det_control where cat_control_id = 1 -- ----------- Sample Output: ------------ -- det_control_id cat_control_id cat_control_name det_control_answer -- -------------- -------------- ------------------------------ ------------------------------ -- 1 1 This is a test. First Answer -- 2 1 This is a test. Second Answer -- 3 1 This is a test. Third Answer -- 4 1 This is a test. Fourth Answer Tag: cannot connect to server
  - 12
    - Split - Comma seperaed values Try: Code Snippet create table dbo . t1 ( ID int not null unique , DepartmentNames varchar ( 128 ) ) go insert into dbo . t1 values ( 1 , 'IT,Finance' ) insert into dbo . t1 values ( 2 , 'Accounting, Finance, IT' ) go -- Idea from Itzik Ben-Gan to generate a table of numbers on the fly WITH L0 AS ( SELECT 1 AS c UNION ALL SELECT 1 ), L1 AS ( SELECT 1 AS c FROM L0 AS A , L0 AS B ), L2 AS ( SELECT 1 AS c FROM L1 AS A , L1 AS B ), L3 AS ( SELECT 1 AS c FROM L2 AS A , L2 AS B ), Nums AS ( SELECT ROW_NUMBER () OVER ( ORDER BY c ) AS n FROM L3 ) -- Idea from SQL Server MVP Anith Sen (using table of numbers to split the string) SELECT t . [ID] , row_number () over ( partition by [ID] order by n . n ) as position_in_list , ltrim ( rtrim ( substring ( t . DepartmentNames , n . n , charindex ( N ',' , t . DepartmentNames + N ',' , n . n ) - n . n ))) AS [Value] FROM Nums as n inner join dbo . t1 as t on n . n <= convert ( int , len ( t . DepartmentNames )) AND substring ( N ',' + t . DepartmentNames , n , 1 ) = N ',' order by t . [ID] go drop table dbo . t1 go Arrays and Lists in SQL Server 2005 http://www.sommarskog.se/arrays-in-sql-2005.html#tblnum AMB Tag: cannot connect to server
  - 13
    - Cannot Pull table with RDA Change your OLEDB connectionstring: Dim rdaOleDbConnectionString As String = "Provider=SQLOLEDB;Data Source=SKYWALKER;Initial_ Catalog=ristobar;User ID=MobileUser;Password=pippo;" or Dim rdaOleDbConnectionString As String = "Provider=SQLOLEDB;Data Source=192.168.0.199;Initial_ Catalog=ristobar;User ID=MobileUser;Password=pippo;" Tag: cannot connect to server
  - 14
    - How to connect to remote server Very few hosting providers will allow you to connect to their server using SSMS; rather they provide their own set of management tools accessable through their site. If you log into your account you will likely find a set of links that take you to the management console for your hosted database. From there you should be able to load the script file that you saved from the DPW and run it to create your objects in the hosted database. As others mention, contact your hosting provider if you have questions about managing your hosted database. Mike Tag: cannot connect to server
  - 15
    - SQL 2005 Standard on Vista RTM Samuel Lester - MSFT wrote: Can you read through this thread and see if it applies It suggests that there is a WMI configuration issue. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=124864&SiteID=1 Thanks, Sam Hi, Yes I went through the steps with the WMI batch etc yesterday without any difference to the outcome. Thanks. Tag: cannot connect to server
  - 16
    - Performance-Issue with variables If you are interested, here is a more 'indepth' exclication of what happens, and how to avoid 'parameter sniffing'. Stored Procedure �CParameter Sniffing http://blogs.msdn.com/queryoptteam/archive/2006/03/31/565991.aspx http://tinyurl.com/f9r2 http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/17/444.aspx Tag: cannot connect to server
- Next
  - 1
    - using encryption via an asp site. how is it done You can provide access to data via a view that automatically decrypts using decryptbykeyautocert, for example. You can then group your Admin users in a role and grant permissions to that role to use the key. Admin users would then be able to decrypt the data and see it; regular users would not be able to. Thanks Laurentiu Tag: cannot connect to server
  - 2
    - The '[CDbl]' function does not exist. I once had a weird situation on an IA64 machine where I could only get the VBA functions working by prefixing them with VBAMDX instead of VBA (VBAMDX is the name of the assembly on the server). I found that this worked on both IA64 and 32bit editions. Not sure why this is, as far as I understand the VBA prefix is meant to work on IA64, but I don't have any other IA64 servers that I can check this against. I'm not sure if IsNull() exists as a function or not, but you will find that the IsEmpty() function is equivalent. Tag: cannot connect to server
  - 3
    - How to acces report of other system from my system. Mahender, Your report server URL should be http://<ServerName>/ReportServer . In order to view your report, the user will need to be in the 'Browser' role. Hope this helps. Jarret Tag: cannot connect to server
  - 4
    - FTP Connection problem with "The Password was not allowed" error message I had set the PackageProtection to EncryptSensitiveWithPassword, but that didn't work either. As for an incorrect password, this can't be correct, because when I test the FTP connection it works fine Any other thoughts Thanks D Tag: cannot connect to server
  - 5
    - Problem with "Transfer SQL Server Objects Task" Oops, sorry for the chaos. The previous post was also made by me. I currently have two Passport identities. I'll try to not use the other one anymore... *edit* This is starting to become really weird. I've manually created a database (no tables, sps etc.) on the destination server. When I tell the "transfer... task" to copy the production database from the source server to this new database it gives me the following error: "Cannot find the object "dbo.tblTasks" because it does not exist or you do not have permissions." Of course the table doesn't exist. The package is supposed to create it. A lack of permissions can't be the problem as well since I'm sysadmin. I'm really stuck here. SQL 2005 has been out for quite a while now. I just can't believe that this is a bug. Tag: cannot connect to server
  - 6
    - Problem running SSIS from C# program. The specified package could not be loaded from the SQL Server Database /r/n I tried both this Package package = app.LoadFromSqlServer("trans_hist", Properties.Resources.dbServerName, Properties.Resources.userId, Properties.Resources.password, null); and this Package package = app.LoadFromSqlServer("\\MSDB\\Maintenance Plans\\trans_hist", "ppntt240", "id", "password", null); I also tries adding .dtsx to the SSIS name. Tag: cannot connect to server
  - 7
    - Schema use in SQL2005 Which schema is dnn_Forum_AA_StatisticsSiteUpdate defined in Which schema is dnn_Forum_Statistics_Site defined in The behavior of SQL Server 2005 is the same as SQL Server 2000 with respect to resolution. If you do not specific a schema, it will first look for the object in the default schema of the user. If it does not find the object in the default schema of the user, it will fall through and look in the dbo schema. If it is not found in the dbo schema, it will fail. It should be noted that not fully qualifying the name of an object in SQL Server is just as bad of a practice as not fully qualifying an object in any programming language. It leads to issues and the default resolution order is not guaranteed to be preserved from one version to another. Tag: cannot connect to server
  - 8
    - Granting UPDATE for only certain columns in a table Thanks for your support. Here is a small bit of code that is able to produce the problem. It seems to be associated with having a JOIN in the UPDATE statement. An UPDATE without the JOIN works just fine. Using a DB_OWNER account perform the following table creation, insert, and grant commands: create table trs.dbo.people ( name varchar(10) , sex varchar(10) , age smallint ) insert into people values ('tom', 'male', 10) insert into people values ('jane', 'female', 18) insert into people values ('sue', 'female', 22) create table trs.dbo.grads ( name varchar(10) , grad_yr varchar(4) ) insert into grads values ('jane', '2006') insert into grads values ('sue', '2002') grant update (age) on trs.dbo.people to calc Then, from the db_datareader account, calc, run the following UPDATE statements, one at a time. update p set age = 40 from trs.dbo.people p where (age is not null) ; update p set age = 35 from trs.dbo.people p inner join trs.dbo.grads g on p.name = g.name where (age is not null) ; The first one works. The second one fails with error message Msg 230, Level 14, State 1, Line 1 UPDATE permission denied on column 'name' of object 'people', database 'TRS', schema 'dbo'. Does this help Tag: cannot connect to server
  - 9
    - Event ID: 17055 I am running a WSUS and get this error in my event log. I am running Windows 2000 with SQL 2K SP4. 1827 CREAR/ALTER DATABASE failed because the resulting cumulative database size would exceed you licensed limit of 2048MB per database. Tag: cannot connect to server
  - 10
    - Trouble with Pivot Task (multiple problems) - Long All, I would not really call this a fix, but in case anyone has similar problems... I have used a for each loop to feed the data flow task one row to pivot at a time. All rows pivot and write to the destination table without any errors being reported. Why would pivot fail on multiple expected output rows when each is able to successfully process While It would be nice to get feedback regarding the original problems, since I found a work around this is successfully completing. Thanks. Tag: cannot connect to server
  - 11
    - @@Version still shows Service Pack 1 Yeah, the SP1 in this case refers to your Windows Version: Windows NT 5.2 (Build 3790: Service Pack 1) The Service Pack level apparently isn't listed in the @@VERSION as I thought it was. Build 3054 is definitely SP2, but you can also check Add/Remove Programs report or the setup regitry hives to confirm. Thanks, Sam Lester (MSFT) Tag: cannot connect to server
  - 12
    - Linked server SQL 2005 to 2000 I have something similar... On a SQL 2005 default instance on a box named 'machine1', I define a linked server which points to a SQL 2000 instance also located on 'machine1'. In SSMS, I right-click to use 'add linked server' to add 'machine1\sql2000' (taking the SQL Server radio button as the default). The definition works fine. I then try to use the linked server in a four-part name, e.g. 'select * from machine1\sql2000.dbname.dbo.foobar' and I get a syntax error complaining abou the backslash. No amount of quotes seems to help. What's the trick for defining a linked server in a SQL 2005 instance where the linked server is a named SQL 2000 instance on the same machine and then using that linked server of the SQL 2000 instance in a T-SQL query thx Tag: cannot connect to server
  - 13
    - SQL Questions Thanks but how would you identify and resolve these issue. What you mentioned I knew it could be one of those but how actually I come to know that this is the issue and fixing it. Regards Tag: cannot connect to server
  - 14
    - Line Chart Color for each value u need to select colors. u may have different values inside data in chart properties , for each case u need to follow the same path and choose different color.it worked for me. i hope it will work for u also Tag: cannot connect to server
  - 15
    - Im new to using views, and this program they have me working on is using them quite heavily..(cant read from a view) Not a problem. We ALL could write a book on the boneheaded things we've done -even when we knew better! Tag: cannot connect to server
  - 16
    - Insert Performance Hey, I'm writing an application where I have to perform a lot of inserts/updates on a SQL Server Compact Edt. 3.1 database (up to 50.000 or even 100.000 consecutive inserts). I'm using native C++ and OleDB. I set the command text only once for each table and I increased maximum buffer size (DBPROP_SSCE_MAXBUFFERSIZE). There are also no table indices or foreign keys. The performance is quite well, but not good enough. I took a closer look at the MS Merge Replication and I observed a really good insert performance. Maybe somebody can tell me some ''secrets'' how I can speed up my query performance! best regards Tom Tag: cannot connect to server

sally568223

i have installed SQL Server management studio
when i attempt to connect to report services server i get the following error

client found response content type text/html;expected text/xml

i cant find where i might have went wrong in installation or report server configuration
am new to reporting services so plz help me on this regard

thanks
sally

Re: cannot connect to server

Jens K. Suessmeyer

Are you sure SQL Server Reporting Services is running smootly at the connecting server To make sure that it is, connect to the server using http://Yourserver/Reportserver (or the non-default name you configured for it) I guess you are trying to connect, the IIS throws an error message (which is in HTML) and which is not readable for SSMS.

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Re: cannot connect to server

sally

Reporting Services Error

Re: cannot connect to server

Jens K. Suessmeyer

This is a security related problem of the Windows Server or the IIS Worker process, see more details here:

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

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---