Lun

i have implemented the forms athentication security extension sample ssrs, noted here: http://msftrsprodsamples.codeplex.com/wikipage?title=ss2008%21security%20extension%20sample&referringtitle=home and here: (we using asp.net sql membership database) http://blogs.msdn.com/bimusings/archive/2005/12/05/using-sql-reporting-services-2005-and-forms-authentication-with-the-whidbey-2-0-sqlmembershipprovider.aspx i have working: sharing auth ticket between our asp.net site , ssrs server, allows user authenticated , authorized correctly when access report.  have authentication working for the ssrs web service, , have enabled ssrs web service use cookies. i plan use the ssrs web service list of available reports, since appears api fetch list of available reports, using current user's roles, etc. i changed our asp.net site logon page call logonuser() of ssrs web service.  works page, doesn't persist web service authentication on subsequen...

hi guys. i pulling out hair trying solve this. can not figure out syntax of dateadd function. i designed chart should have year + quarters on x-axis. e.g 2015-q1, 2015-q2 etc. i managed years via: =dateadd(dateinterval.quarter,-5, today()) min , =dateadd(dateinterval.quarter,5, today()) max. 2015-01-01, 2016-01-10 . how outout 2015,2016 etc years? next thing - how "sub" output quarter? final output like: 2015-q1, 2015-q2 etc? cheers you can use datepart(dateinterval.year,today()) year date part. can use datepart(dateinterval.quarter,today()) quarter. cstr(datepart(dateinterval.year,today()))+"-q"+cstr(datepart(dateinterval.quarter,today())) should year-qx format you're looking for. SQL Server  >  SQL Server Reporting Service...

hi, i wonder if 1 can improve query. select distinct a.source, a.returnid,b.indicator from apple left outer join boy b on a.returnid=b.returnid , id = '111' and a.returnid in (select returnid cat id ='111' , left(year,4) = '2006' , source <>'me' , dup = 'n' , flag ='y') what trying year column cat table select statment like select distinct a.source, a.returnid,b.indicator , year from apple left outer join boy b on a.returnid=b.returnid , id = '111' and a.returnid in (select returnid cat id ='111' , left(year,4) = '2006' , source <>'me' , dup = 'n' , flag ='y') simam you can join cat table based on returnid field, e.g. select distinct a.source, a.returnid, b.indicator, c.year from apple as left outer join boy as b on a.returnid=b.returnid and id = '111' inner join cat c on and a.returnid = c.returnid where c.id = '111' ...

hi all, i'm complete novice when comes tfs setup, thought i'd try out on home network.  current situation this: my desktop , laptop (both running windows 7) on same home network , able ping each other. i've installed visual studio 2013 professional on laptop , desktop. i've installed team foundation server 2013 on desktop, , can connect visual studio on desktop. my 8080 port open on windows firewall. when try connect tfs laptop, timeout errors, both visual studio , entering url in ie. i've restarted both machines few times measure. i searched online while, advice found make sure firewall allowing incoming 8080 traffic on tfs server, is.  i'm guessing it's obvious, since i'm bit out of depth.  appreciated.  thanks. hi eryk,    thanks post. first, please share detailed error message here. second, try turn off firewall on desktop , laptop machines temporary, try connect tfs server laptop check if firewall caused timeout issue. ...

i'm trying add dp user control.  i"m not getting build errors new property doesn't show in xaml intelisense.  have dps created in other projects , don't differnt this.   1 public shared readonly clientviewtypeproperty as dependencyproperty = dependencyproperty.register( "viewtype" , gettype (viewtypes), gettype (clientwindow), new propertymetadata( new propertychangedcallback( addressof onclientviewtypechanged))) 2 3 private shared sub onclientviewtypechanged( byval d as dependencyobject, byval args as dependencypropertychangedeventargs) 4 dim sender as clientwindow = ctype (d, clientwindow) 5 sender.type = ctype (args.newvalue, viewtypes) 6 end sub 7 8 private _type as viewtypes 9 public property type() as viewtypes 10 get 11 return _type 12 end 13 set ( byval value as viewtypes) 14 _type = value 15 ...

i have sql server 2005 database published using merge publication uses filter on host_name() along join filters send subset of data subscribers , uses web sync via rmo. filtering setup for accounts using replicationaccount table includes accountids subscribers have access , table filtered host_name(); account table linked replicationaccount table join filter , other account tables (like accountnote) linked account table further join filters. i want change publication's account article set 'copy user triggers' property false , requires reinitialization of subscriptions need make sure account changes made subscribers sent published db , reloaded subscriber db. make change i've done following: 1. change publication's automatic reinitialization policy upload first: exec sp_changemergepublication @publication = 'publication' , @property = n 'automatic_reinitialization_policy' , @value = n '1' 2. change article disable copy of user triggers (wh...

hi all, i used use tfssdk 2010 (http://archive.msdn.microsoft.com/tfssdk) while. have upgraded 2012. i'm interested use newer version of tfssdk too. can not find new version of it. discontinued? integrated tfs itself? we using activitypack update assemblyversion during each tfs build. regards, afshar mohebbi i believe comes part of team explorer anywhere since have sorts of stuff on machine may have come packaged visual studio well. try adding reference project , select assemblies -> extensions ->microsoft.teamfoundation..... v11.0 Archived Forums V  >  Team Foundation Server - General

i have installed sql 2012 enterprise x64 on windows 8. installed fine , have completed configuration of other tools. running data quality server installer elevated prompt, non-elevated prompt same menu link generates following error: ... [1/30/2013 9:59:55 am] registered assemblies. [1/30/2013 9:59:55 am] [1/30/2013 9:59:55 am] [1/30/2013 9:59:55 am] action 'register data quality assemblies , stored procedures' finished successfully. [1/30/2013 9:59:55 am] executing action: set product version property. [1/30/2013 9:59:55 am] action 'set product version property' finished successfully. [1/30/2013 9:59:55 am] executing action: create mds user (if mds login exists). [1/30/2013 9:59:55 am] action 'create mds user (if mds login exists)' finished successfully. [1/30/2013 9:59:56 am] executing action: load out of box data. [1/30/2013 9:59:56 am] starting installation rollback... [1/30/2013 9:59:56 am] installation rollback completed successfu...

upgraded expression encoder 2 expression e. 3. have on 210 videos working on our website using older silverlight 2. using new encoder 3 have found computers play video well, on two out of ten computers in our office complex new silverlight 3 not play (all older silverlight 2 videos play on 10 computers). webpage error details 1 of computers:   user agent: mozilla/4.0 (compatible; msie 8.0; windows nt 5.1; trident/4.0; .net clr 1.1.4322; infopath.1; .net clr 2.0.50727) timestamp: tue, 1 sep 2009 16:14:58 utc     message: unhandled error in silverlight application code: 4004     category: managedruntimeerror       message: system.exception: [arg_comexception] arguments: debugging resource strings unavailable. key , arguments provide sufficient information diagnose problem. see http://go.microsoft.com/fwlink/?linkid=106663&version=3.0.40723.0&file=mscorlib.dll&key=arg_comexception  ...

hi there i want understand how calculate 3d coordinates in hlsl (or in c# matter) let's say i have 3d positioned light source @ 200, 100, -500 (assuming -500 away camera , scene) let's have flat surface this: border{ width: 100, height: 100, rotationx: 45, rotationy: -45} located @ -100, -100, -200 basically have scene in 3d space surface "reflecting" som of light lightsource q1: how calculate different angles/positions in pixel shader ? q2: how calculate phong pixel shader lighting ? q3: how convert between world coordinates , object coordinates , screen coordinates ? - samples / algorithms find, require use of view_projection_matrix , having view_position - samples have uses normalise function, ? - dot product used ? - possible live without vertex shader ? (how manage to do stuff without ? - how convert vertex shader stuff silverlight stuff ?) i've had 3d imaging courses years ago, long gone in memory... so inputs / links , no...

          thank help. the errors can see in code gave in answer following , more or less same had previously   i tried code have encounter following problems.   1.       in line have declaration as server , as database in public function createdatabase(byval srv server, byval databasename string) database gives me problem type database not declared same type server not declared , not give me option.   2.       in addition as datasource, relationaldatasource, relationaldatasourceview, scalarminingstructurecolumn, datasourceviewbinding , gives me problem type not declared.   3.       finally in mc = new miningmodelcolumn("yearly income", utils.getsyntacticallyvalidid("yearly income", type.gettype(miningmodelcolumn))) not accesible in context because 'private'. i have more problems thing solving above referred solve rest.   thank way. best regards, manolis phd student ...

hi, i trying remove line between each item in listbox control. scott shows in blog how remove borders. can tell me how can remove line between each item?   to that, you'll need redefine entire template of listbox.  docs have example of how define listbox (including existing template) , changing should work.  that's did in sl2 example:   http://www.silverlightdata.com Silverlight  >  Designing with Silverlight

i'm trying turn on tracing on tfs 2013 instance. i'm modifying c:\program files\microsoft team foundation server 12.0\application tier\web services\web.config file this: <appsettings> <add key="tracewriter" value="true" /> <add key="tracedirectoryname" value="%temp%\\tflogfiles" /> </appsettings> <system.diagnostics> <assert assertuienabled="false" /> <trace autoflush="false" indentsize="4" /> <switches> <add name="api" value="4" /> <add name="authentication" value="4" /> <add name="authorization" value="4" /> <add name="database" value="4" /> <add name="general" value="4" /> <!-- workitem trace switches --> <add name="tracelevel...

my company soon be upgrading work pc xp windows 7 professional.  running sql server 2000 on pc , use load , analyze data large volumes of data.  need work 3gb 5gb of data, , have had databases reach 15gb in size.  best version of sql server install on pc after upgrade?  sql server express won't cut it.  need more 2gb of data , current version of dts functionality load , transform data. thanks. hi, its difficult best you. can install sql server 2012 standard edition because supported on windows 7 sp1, enterprise edition not supported. sql server 2012 express has database limitation of 10g not includes file stream size , log file size not provide ssis features. just have at features supported various editions of sql server in deciding better i inclination towards sql server 2012 because sp2 , more stable 2014( personal opinion) please mark reply answer if solved issue or vote helpful if helped other forum members can benefit my technet ...

hello i using scheduled task , windows synchronize manager pull subscription sql standard sql express. everything working correctly, except when log off windows. when left on windows log in screen, task still runs, error code windows synchronize manager process , sync not succeed:   task scheduler completed task "\microsoft\windows\synccenter\s-1-5-21-3039370102-1486009767-2709374209-1142\{bf5939ec-f097-4d5a-8e20-c7eb082a995f}\microsoft sql server 2008 sync schedule" , instance "{a4f4dc5a-b48b-4167-9656-a97c224ddb08}" , action "c:\windows\system32\mobsync.exe" return code 2147500058. after research, error 2147500058 means 'the server process not started because configured identity incorrect. check username , password.' what confuses me process works when logged windows, have set specific user to run task, , set task "run whether user logged on or not". windows user has full adiministrator rights on both publisher , subscriber...

the following function returns proprietry actions cube.  cube has 6 measure groups many-many relationships dimensions, fact relationships direct relationships (if has relevance).  code returns cell action exists long there no data in measure groups/fact tables have many-many dimension relationships...   so in summary, code correct , want do, when data exists behaves differently (incorrectly) , doens't return results.   has else had similar problems?  ideas , appreciated.    thanks james   public string getaction( ienumerable < member > celltuple) { string catalogname = this .command.connection.database; string schemaname = null ; string cubename = query.cube.name; string actionname = null ; int actiontype = 64; // proprietry string cell = "(" ;   foreach ( member member in celltuple) cell += member.uniquename + "," ; cell = cell.trimend( ',' ) + ")" ;   object [] restrictions = ...

hi, i trying load sql server management studio sql server 2005. giving me following errors. can !! package 'microsoft sql server management studio' package failed load i presume because have reloaded .net framework 2.0 beta 2 , require .net framework 2.0 uninstall completely. the current running version of .net framework on pc 2.0 beta 2 how can uninstall sql server 2005 completely, in order run setup again. please me out on !! regards ad you can uninstall using sqlbuw.exe  http://sqljunkies.com/forums/showpost.aspx?postid=6481 SQL Server  >  SQL Server Setup & Upgrade

hello, i need load files table. however, files extract , fmt. extract files have raw data no clumns. fmt files have column name such:   2       sqlchar       0          2    "\t"      2       id 3       sqlchar       0          6    "\t"      3       type 4       sqlchar       0          6    "\t"      4       subtype 5       sqlchar       0    ...

hi,   specs: i using ssas 2005, excel 2003 (office 2003 professional sp2)   i browse cube in ssas 2005 bi studio , export excel.  this excel file provides interactivity, meaning double-click on expandable cell , excel issues mdx query , retrieves values.    issues: 1. when save excel file, displays read-only version , still allows me save excel file in following formats: excel, web page (html , mhtml), xml file. displays checkbox "add interactivity". the saved web page (html or mhtml) or xml files not provide interractivity. reports not able expand cells or issue mdx queries. allow write on cells, no double click. how can provide this? i want save them web pages, , publish them web server.   2. excel olap report exported yesterday, (excel 2003 file). mentioned before , give interactivity. after checked same report after day. they displaying following error on double clicking or clicking on drop down: "xml analysis parser: xxxxxxx session i...

hi all, i want start silverlight 2, train little, i'm totally new silverlight ... i want make application can manipulate data : what available application : - mysql database - text files - xml files how can work theses kind of storage ? thanks in advance help,   best regards   hi, i'm starting silverlight , data access. things i've learned several days of being clueless on how make silverlight stop being island. mysql database: expose service , consume it. , god's sake, don't forget add proper client access policies server, or else you'll point you'll want throw pc off window. text files , xml files, if they're on same place app, download them using webclient. if they're on different site don't forget check cross-domain policies again. if i'm wrong in feel free correct me, if there's can ask.   Silverlight ...

all,   i trying understand perpose of putting logical keys on dsv, have read articles , book saying should use/set them, since don't create keys @ teh database level wondering how helps? aide various wizards???   regards, yes, various wizards. helps dimension wizard identify dimesion keys , cube wizard can use them identify roles (fact/dimension) particular tables playing. strictly speaking can away without using them , set relevant properties in dimensions , cubes yourself. these keys have no effect on performance. SQL Server  >  SQL Server Analysis Services

hi there,  i have been trying make work. out of idea. have created grid in xaml code following: <stackpanel x:name="spgrids" verticalalignment="top" horizontalalignment="stretch" margin="20,0,20,0">           <grid x:name="grdvalues1" verticalalignment="top" horizontalalignment="stretch">                   <grid.columndefinitions>                         <columndefinition width="20"></columndefinition>                         <columndefinition width="50"></columndefinition>  ...

  hi,   i wondering, can reson incredibly slow performance of team foundation server.   this includes basic operations in tfs.   anybody has idea, can reson this? idea on how improve speed?   all comments appreciable.   thank you   rahul hi rahul   could please give more info environment: is new tfs, problems since beginning how load create on tfs what hardware / performance have what deployment errors / warnings in event log did check tfsservermanager it might problem on db performance, everything.   regards nicolas Archived Forums V  >  Team Foundation Server - General

in existing project in sql2k/vs2003, have several .sql files in folder in vs solution.  entire database created/recreatable these queries.  solution under source control, , therefore of queries.  when opens query file, query analyzer launched.  there few annoyances (like fact separate instance of qa launched each time file opened), works well. so try doing similar in vs2005.  closest can create text file in app_data.  but, when open up, window overglorified text editor.  may asking much, expected docked windows (the object browser , templates) a la query analyzer appear, , text color-coded , that. i've tried opening 'query' window server explorer window.  joke.  thought in access.  more importantly, looked more suited dml ddl.  , couldn't figure out how save text of query solution anyway. so... missing something, or how is?  going have go old qa or find third-party tool?  excited when found out sql tools , ...

when calling method below, if use sql in red , pull method populates data correctly. but, if use sql in green, i errror message. have set breakpoints , un sql returned sql statement green, , returns records. gives? joins not allowed? public void getdiagnosislist() { // connection string sql server 2000 string rdaoledbconnectstring = "provider=sqloledb; data source=workpc;initial" + " catalog=database;user id=username;password=password"; // string sqlget = "select tblludiagnosis.strdiagnosiscode, tblludiagnosis.strdiagnosisdesc tblludiagnosis" + // " inner join tblpatientepisode on tblludiagnosis.strdiagnosiscode = tblpatientepisode.strprimarydiagnosis" + // " tblpatientepisode.inthospitalid =" + inthospitalid; string sqlget = "select top 15 tblludiagnosis.strdiagnosiscode, tblludiagnosis.strdiagnosisd...

hi, i want configure continuous integration of tfs 2010 builds. please post steps on same.   regards rajeshram right click build definition(build) in team explorer-->click edit build definition -->go trigger tab -->select the continuous integration - build each checkin radio button , save build definition.   Archived Forums V  >  Team Foundation Server - General

i tried upgrade our windows server 2008 r2 - sql 2008 sql 2008 r2.  upgrade process seemed have been successful, when done database engine services, sql server replication, full-text search, analysis services, reporting services still 2008.  management, client tools , other components upgraded 2008 r2. i ran repair , results same.  a couple errors came during initial upgrade process.  here text 1 of them title: microsoft sql server 2008 r2 setup ------------------------------ the following error has occurred: exception has been thrown target of invocation. click 'retry' retry failed action, or click 'cancel' cancel action , continue setup. for help, click: http://go.microsoft.com/fwlink?linkid=20476&prodname=microsoft+sql+server&evtsrc=setup.rll&evtid=50000&prodver=10.50.1600.1&evttype=0xa56d2304 the other 1 said reporting services group name 'sqlserverreportuser$nordic04$msrs10.mssqlserver' cannot found. i clicke...

good morning, i'm starting dip toes of of reports using guages, charts , indicators etc. my first guage works , displays average dataset pointer shows: =sum(fields!no_of_merges.value)/count(fields!no_of_merges.value) what want add if possible either guage or pointer shows recent day against average (above). i've attached sql below dataset based. here trick part. there no data weekend need display if report run on monday need display fridays no of merges  else display previous days  no of merges eg running today display yesterdays data. ---------------------------------------------------------- --by month -------------------------------------------------------- select datepart(year,m.mergedttm) [year], datepart(month,m.mergedttm) [month no], datename(month,m.mergedttm) [month name], datepart(week,m.mergedttm) [week], datepart(day,m.mergedttm) [dayno], datename(weekday,m.mergedttm) [day], count(m.oid) [no of merges] lzo...

what's new numa in sql server? is there way reading, sql server or perfmon or hardware vendor tools or vm tools, of how crossing numa boundaries, , costing? the "numa management" trick know setting maxdop @ or below number of cores on physical processor.  guess rest supposed automagic. is there else 1 can see or regarding numa? thanks, josh what's new numa in sql server? nothing know. numa was introduced scale-ability overcome limitations of smp system.the biggest shared memory bus requests use use same memory bus. introduction of numa system each numa nodes not have there own memory , possibly own i/o channels. is there way reading, sql server or perfmon or hardware vendor tools or vm tools, of how crossing numa boundaries, , costing? the readings should interest local , foreign memory readings. local memory memory of node process can access while memory allocated other nodes process wants access foreign memory. cost associated forei...

hi,   we've been using sql server 2005 time , we've found stable , pretty bug free, done! (as opposed oracle 10g, bug-ridden) i'm not sure if right forum post in, felt best place start. please move post if not correct.   in the last few weeks we've had serious problem; whenever try execute our upgrade scripts cpu usage spikes 100%. , every insert takes > 0.5 seconds. needless say, i'll anyway, huge problem. of our scripts have > 100 000 inserts, upgrade process takes "forever".   at point might useful talk briefly how use our sql server; have application configured via database (we support sql server , oracle) , use database lot more "dumb" datastore. massive amounts of insert/update every version of our application , add new tables quite often. have build system, using tfsbuild, nightly builds. build drop current database (example of name: monday, tuesday etc.) , restore again using image. upgrade new database current version o...

hi all, i have below query --constants used in condition of source query declare @uk_legal_matter_org_unit__potential_e_o_3 nvarchar ( 20 ) declare @uk_legal_matter_org_unit__potential_e_o_2 nvarchar ( 20 ) declare @uk_legal_matter_org_unit__potential_e_o_1 nvarchar ( 20 ) declare @uk_legal_matter_org_unit__us_retail_group nvarchar ( 50 )   set @uk_legal_matter_org_unit__potential_e_o_3 = 'ameriprise > e&o coverage - lancer' set @uk_legal_matter_org_unit__potential_e_o_2 = 'ameriprise > e&o coverage' set @uk_legal_matter_org_unit__potential_e_o_1 = 'ameriprise > potential e&o' set @uk_legal_matter_org_unit__us_retail_group = 'ameriprise > retail group > advisor group' --source query select text_legal_matter_source .* from text_legal_matter_source ...