Lun

i'm trying install team foundation use on internet, assumption clients not members of team foundation server's domain.  in order reduce server's attack surface, goal expose server ip address only, , require clients to connect server using ssl, client certificates, , arbitrary port.  example, server path might like:     https://1.2.3.4:5/ my infrastructure consists of offline root ca, domain controller, , single-deployment team foundation server.  imported root ca certificate domain controller, , issued server certificates domain controller , server.  built standalone client, installed team explorer, , issued user certificate client's login account.  basic infrastructure functions correctly: https client's internet explorer test ssl site on server work, login non-ssl team explorer server. however, when attempt ssl login team explorer, keep getting authentication errors. can provide insight problem? many thanks.  david quick qu...

i'm having trouble following xmla script: < batch xmlns = " http://schemas.microsoft.com/analysisservices/2003/engine " >< errorconfiguration xmlns:xsd = " http://www.w3.org/2001/xmlschema " xmlns:xsi = " http://www.w3.org/2001/xmlschema-instance " xmlns:ddl2 = " http://schemas.microsoft.com/analysisservices/2003/engine/2 " xmlns:ddl2_2 = " http://schemas.microsoft.com/analysisservices/2003/engine/2/2 " xsi:type = " errorconfiguration " > < keyerrorlogfile > \\dfspath\logfile.log </ keyerrorlogfile > < keyerrorlimitaction > stoplogging </ keyerrorlimitaction > < nullkeynotallowed > ignoreerror </ nullkeynotallowed > </ errorconfiguration > < process > < type > processfull </ type > < object > < databaseid > myssascatalog </ databaseid > < dimensionid > mydimension </ dimensionid > </ object > </ process ...

i work consulting firm. customers reporting being annoyed popup "help make microsoft sql server 2005 better". customers don't want bothered once. there way keep popup ever appearing? the customers intelligent. understand why popup appears , purpose is. point address customers have paid sql server, they annoyed feature , want way suppress it. want give customers want. when customers tells me nuisance, it's not place tell them wrong. there's not supported way this. said, if fuss around customerfeedback key in registry @ location: hkey_local_machine\software\microsoft\microsoft sql server\90 you might able figure out. perhaps pre-populating appropriate value work. or perhaps cause setup fail; don't know. good luck... edited amend: there straightforward way supported: command-line install, , on command line specify whichever value choose 2 parameters, sqmreporting , errorreporting. refer template.ini in servers folder of install media details. ...

i want insert :   <column>     <column_name>feedbackloop</column_name>     <column_type>int</column_type>   </column> at end of existing xml. perhaps easier if proved schema , existing xml: code snippet create xml schema collection email_column_xml_schema as '<xsd:schema xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns:t="grs" targetnamespace="grs" elementformdefault="qualified">   <xsd:element name="object">     <xsd:complextype>       <xsd:complexcontent>         <xsd:restriction base="xsd:anytype">           <xsd:sequence>             <xsd:element name="type" type="xsd:string"/>             <xsd:element name="name" type="xsd:string"/>             <xsd:element name="remote" type="xsd:integer"/>             <xsd:element name="provider" type="xsd...

i have sql server 2012 ssis. create connection manager ole db. selected user sql server authentication. i add user name , password. can succesfully test connection. can run succesfully then select package configurion , add configuration xml file. edit configure correctly, password not stored xml file. when run package now, error because of missing password establish connection ole db. it feature? i'm not able run package xml configuration file visual studio if use sql user password? kenny_i check below seems similar issue, if helps http://social.msdn.microsoft.com/forums/sqlserver/en-us/a1f455fb-c75b-4470-a862-d5d89e9a4da6/ssis-package-does-not-remember-password-ole-db-connection-adonet-connection?forum=sqlintegrationservices please click mark answer button , vote helpful if reply solves problem SQL Server  >  ...

hello, how can convert text string varbinary?   thanks :) the insert statement works pretty fine; see test script below. sure field in same order in select statement , that's varbinary field? create table #test   ( field1 int , field2 int , field3 varbinary ( 100 )) go   insert into #test      select 1 , 2 , convert ( varbinary , 'abcdefg' ) go   drop table #test   olaf helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich http://olafhelper.over-blog.de SQL Server  >  Getting started with SQL Server

this isn't anywhere else, hope isn't atleast. have searched support area 2 hours , have not found solution. ask here. i need create server sql 2008 r2 express, downloaded , started going through installation process. came problem. got page has terms , conditions, accepted them , clicked next. started processing support files. but, after completed installing these support files, application closes , nothing happens - no matter how long wait for. used approximately year ago on same computer, , worked perfectly. have not done computer since then. please me experts! i run on windows xp service pack 2. please me. in advanced -fria hello, prompt response. unfortunately, upgraded , patched xp service pack 3, , still same thing. have more suggestions? machine having orphan entries in registry various sql realted msi. since setup "crashing" after "licence terms" page, know installs setup support files. first action item remove setup support fi...

i had created query in tfs 2012 showed me pbis hadn't changed in last 90 days.  i used changed date determine aging. since migrated tfs 2013, nothing shows on query , in fact, items in backlog have dozens of history entries automatically generated system recording change revision # (rev) , nothing else.  this in turn updates changed date , renders query useless. hi, melissa i did test issue, , found changed date of migrated work items became time of migration. checked database , couldn’t find other fields filter out work items. found state changed date wasn’t updated, wish may benefit you. Archived Forums V  >  Team Foundation Server - Project Management & Work Item

hello folks "olapquerylog" table not created in database. i changed server properties of "create query log table" --> "true". even table not created. please me regards sunny hi sunny, what’s order of steps, did specify olapquerylog before specifying connection string? if so, try this: 1)     check connection string, ensure can access database , type of database sql server. 2)     set olapquerylog false. 3)     change olapquerylog false. 4)     refresh database check olapquerylog table created. http://technet.microsoft.com/en-us/library/cc917676.aspx   hope helps. raymond SQL Server  >  SQL Server Analysis Services ...

hi all, i using url ssrs report export in csv format. the problem is exporting correctly first time,but when selecting different parameters , after pressing view report , exporting,it giving me same result.can tell me how refersh it. i using belowurl http:myserver/pages/reportviewer.aspx?%2freport+test%2freport_name&rs:command=render&rs:format=csv while result coming fine in sub report. thanks in advance regards, msbilearbning hi, add &rs:clearsession=true at end of url. regards! hope helps! k r o o t z SQL Server  >  SQL Server Reporting Services, Power View

looking way add robustness here. i'm issuing queries sql server instance (2008 r2 or 2012) , forcefully rollback transaction - typically in response application error occurred. once rollback begun, i've noticed subsequent queries on database fail due timeout - presumably due rollback either keeping server busy, or holding locks new query tries acquire. my question - there way determine when rollback complete?  i've seen columns in system views such sys.dm_os_tasks , sys.dm_exec_sessions promising, no complete recipe on how information. kill {spid} statusonly gets rollback progress information, exists somewhere (and admittedly, might somewhere inaccessible through system dynamic management views). so, suggestions? -cd mark best replies answers! hi daniel: i use below script know status of rollback command , when completes. select command,percent_complete,'elapsed'=total_elapsed_time/60000.0,'to complete' = estimated_completion_time /600...

hi i have used sql server 2008 msbi.  don't have knowledge on "sql server 2012". i have installed sql server 2012 in pc 2 days back. after installing have tried create "report model project" unable find template in "sql server data tolls". please tell me why facing problem. because of not proper installation or sql server  (or) sql server didn't provide template in sql server 2012 version. and please let me know template have use creating "analysis project" has create cubes. thanks in advance!... moderators, please move thread sql server data tools forum. for every expert, there equal , opposite expert. - becker's law my blog my technet articles SQL Server  >  SQL Server Data Access ...

hi, i'm trying use executesql in new policy conditions fail if use facet variables. even simple example this, fails : executesql('numeric','select @@name') already tried sample database facet , login facet. the error message same : must declare variable @@name. seems doesn't reconize @@name facet variable. so, question : how can use facet variable executesql in policy conditions ? thank ! dennes - se resolveu, classifique mensagem, por favor - [http://www.bufaloinfo.com.br] novo dvd segurança no asp.net : http://www.bufaloinfo.com.br/learingseriessegurancaaspnet2.asp hi, i found solution! it seems executsql not understand facet variables, can concatenate strings achieve result.  here small sample (not real query pbm, example) : executesql('string', concatenate(concatenate('select ''', @name), '''')) cheers, dennes - se resolveu, classifique mensagem, por favor - [http://www.bufaloinfo.co...

  hi all,   i trying restore msde 2000 database sql 20005 ee , got stuck with following error:   system.data.sqlclient.sqlerror: restore detected error on page (xxxx:xxxxxx) in database 'testdb' as read backup set.   do think pages corrupt db or backup set?   has come across this? ideas to resolve error?   thanks, siva. i not sure if might ! try verify if backup file corrupted or not ! code block restore verifyonly disk='path\backupfilename.bak' may file might have been corrupted ! - deepak SQL Server  >  SQL Server Setup & Upgrade

hi there, i'm trying dynamically create select statements in package. i'm using expressions in way you'd expect i.e. expression on vaiable set this: "select synchdel,synchrec,pcode,pavailable,pprice,pdcode,pocode " +@[template::dbname]+".property pcode=''fak080032''" which means value on variable evaluates as: select synchdel,synchrec,pcode,pavailable,pprice,pdcode,pocode abnrps.property pcode=''fak080032'' or alternatively, want run "select synchdel,synchrec,pcode,pavailable,pprice,pdcode,pocode " +@[template::dbname]+".property synchrec >  date_add(now(),interval -1 hour)" which evalutes as select synchdel,synchrec,pcode,pavailable,pprice,pdcode,pocode abnrps.property synchrec >  2010-01-19 12:05 point being, want able choose query run during package execution now want store expressions in in database table, , read them package @ run time. idea doing run simple execute sql task returns express...

hi, i importing files using ssis notice attributes empty imported 0 lentgh character instead of null. is there option can choose maintaining nulls instead of char() type? though default setting dts. many thanks, nicolas sample file pipe delimiter: |some data|another data||previous no data| sorry "retain null values source nullvalues in dataflow"   SQL Server  >  SQL Server Integration Services

hi all i need restore tfs database backup in new tfs server, , new database server test keeping existing tfs 2010 live. if can give me steps me archive this. thanks, omantha system support engineer i-context content convergence (pvt) ltd hi omantha, for questions, can refer "restore databases" section in 2 links detail steps: restore data different server or instance move team foundation server 1 hardware configuration another best regards, we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Archived Forums V  >  Team Foundation Server – Migration and Integration ...

i curious, adapting ssas 2005 bi, , ssrs 2005 report we use sharepoint 2003 now, great presenting ssrs what's best way present ssas though? i know can report in ssrs ssas, using cube data source but if users want slice-and-dice , change filter criterias? i wouldn't want create ssrs report what-if conditions and great if ssrs' "report builder" feature works on cube, it? other ways can think of - give users permission ssas server, , install 2005 mgmt studio on desktop can browse cube? (definitely not installing visual studio 2005) - build every report every request? - build general one, , let them drill-down extent? thanks you have quite few options; use excel pivottables connect analysis services directly. excel 2007 beta shows great inprovements in as-related functionality. recently aquired proclarity not part of microsoft product line. 1 of advanced clients on market. you cannot install ssms on client machines, used administrative purposes only. edward....

at company have many qa people create temporary schemes on few database servers. use schema while, or around day or so. due our product can not re-use same schema name , have install valid testing.  i have been trying find way can find old schema's not used anymore , delete them. should given task, , have no prior experience database management. for reason, doesn't the  schema_id >4. when comment out, works. helps lot. SQL Server  >  SQL Server Manageability

originally had installed sql server 2008 express, didn't have management studio included.  after research, found should uninstall sql 2008, install sql server 2008 express w/tools instead.  however, when first installation step 'new sql server standalone', error popup: sadly, error doesn't exist anywhere online.  having hard time figuring out how resolve this. this blog sreekar m has step step instructions remove sql express. sure backup registry before making changes. unfortunately, sql uninstall not job of removing sql machine. http://blogs.msdn.com/b/sreekarm/archive/2010/03/15/sql-express-is-not-installed-properly-steps-to-be-taken-before-reinstall-again.aspx   SQL Server  >  SQL Server Setup & Upgrade ...

i added custom work item types , modified them using gui tool imaginets export , import.  when found out couldn't delete work item or rename one, ended deleting team project. i created new 1 same name, menu work items displays "error loading menu: index outside bounds of array." i deleted team project , created new 1 different name, , working ok. i believe problem used list maintained ui in registry. trying old workitem name in registry , failing. to fix it, close vs client , go path in registry: hkey_current_user\software\microsoft\visualstudio\8.0\workitemtracking\teammenu\addworkitemmru\<your_tfs_server>\<your_project> and delete old wit name list. can delete entire <your_project> key , let recreated again. hope helps. thanks, amit dev, team foundation server Archived Forums V  >  ...

i have new setup sql server, , sql server agent wont start. when try starting it starts, stopps immediately. i have tried running service network service, domain account , local account, of have sysadmin right on sql instance in ssms says sql server agent (agent xps disabled) the agent working before, , fail during maintenance task, changed logon account service, , have no been able working again i have instance had same issue. ran command, , made sure permissions same. when choose account in sscm sql server agent service popup saying "the proccess terminated unexpectedly"   hi hansondodge, please check sqlagent.out file located @ c:\program files\microsoft sql server\instance_name\mssql\log detailed error message , reasons. , please refer below blog how troubleshooting issue: http://blogs.msdn.com/b/sqlserverfaq/archive/2009/06/12/unable-to-start-sql-server-agent.aspx   thanks, weilin qiao please remember mark replies answers if , u...

as sl 1.0 released , sl 1.1 not, think of implementing site javascript until 1.1 released. happens, switch on c# , replace javascript code c# code. know software design pattern should follow simplify code replacement? thought of mvc (model view controller) or mvp (model view presenter). both think need replace model , controller/presenter while keeping xaml view. not such big deal. have better idea? hello. well, guess can build application porting easy. however, version 1.1 has features can't use 1.0. instance, i'm thinking controls. in 1.1 surelly have several controls encapsulate several portions of ui , think best can in js "encapsulate" xaml element js object. yes,  you can in c#, but  think building reusable components have , feel , behavior way go when using silverlight 1.1. guess i'm trying here there isn't pattern can use definitly make write code when porting 1.0 1.1 (again, can since c# supports features have in 1.0, similar...

sql server 2005 service pack 3 (sp3) available public testing; final release version available in future. sp3 ctp version addresses issues reported through sql server community , quick fixes enhance sql server 2005. no new product features included in sp3.  public ctp bits can downloaded here .  please provide feedback , improve sql server 2005 submitting bugs connect feedback center .   SQL Server  >  SQL Server Database Engine

my application getting error below in logs.  but, there no errors in event viewer, etc. on sql server side.  can tell me of way assist me in diagnosing error?  performance counter related logins can track?  being error message client side, trying figure out way find root cause, , have not been succesful in attempts. system.data.sqlclient.sqlexception: timeout expired. timeout period elapsed prior completion of operation or server not responding. peace the error message saying that  sqlcommand.commandtimeout property has expired; default value timeout 30 seconds. see more at: ".net framework class library -> sqlcommand.commandtimeout property" http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx this not sql server issue. client application issue, client app executing query or stored proc timing out (taking more 30 seconds). run sql profiler or server side trace (using application name filter). rpc completed , sql batchcompl...

hello, i have team foundatin server 2010 in test lab enviorment. our developers using visual studio 2010 connection. however, want let our technical writers acesss team foundation server , load files that going import visual source safe test. however, unsure of version of visual studio load on pc. don't want give them access installing premium edition. also, not intend use web access @ time. @ same time affraid professional may little functionality. any recommendations apprecaiated.       hi tommy, have @ feature matrix here: http://www.microsoft.com/visualstudio/en-us/products/2010-editions/product-comparison for things think pro enough unless have special requirements force premium.  description, can't think of push there. ryan hanisco mcse, mcts:sql 2005, project+ techsterity.wordpress.com Archived Forums V ...

hi, i'm using sql server 2005 replication monitor monitor number of publications. one publication node, not expand however, when clicked it's label changes expanding , never completes in order provide details of publications @ publisher. means cannot highlight specific publication @ publisher further investigation , instead have review subscriptions in subscription watch list, cumbersome. i have tried removing publication , adding replication monitor without success, issue persists. have tried creating sql server login sysdba rights in order connect remote distributor in order rule out a permissions issue. has else come across issue before or can perhaps provide further suggestions in order troubleshoot? john sansom | sql server database administrator john did run sql profiler , @ object 'expanding' locking? how many publications have? if have plenty, server working hard respond , have wait little longe usual, perhaps 5 - 6 minutes in cases. l...

i pretty new mssql (not dba), , trying understand basics of filegrowth settings. none of databases have max size set, presumably keep growing long free disk space. noticed there file growth column in sys.database_files can set percent. how can tell when growth going trigger? example 10gb database 10% file growth, going grow 11gb? how can predict when growth kicks in when there nothing 10% file growth kick in when db reaches xyz size? please have @ these links: considerations "autogrow" , "autoshrink" settings in sql server sql server database growth , autogrowth settings t-sql articles t-sql e-book technet wiki community t-sql blog SQL Server  >  Getting started with SQL Server ...

 i still have problem timer doesn't stop. program has timer counts backward 5 secs should stop. keeps going. when timer reaches 0 fires clockend sub.          dim sb new storyboard  ..         myclock = new classclock(canvas3, canvas4)         myclock.start_clock(0, 5)         sb.begin()         addhandler myclock.clockend, addressof clock_end           addhandler sb.completed, addressof me.sb_complete     end sub       private sub clock_end()         myclock.start_clock(0, 5)         sb.stop() ''wont stop resets sub          end sub     private sub sb_comp...

we receive different results follow 2 mdx expressions.  difference second parameter in clause uses separate dimension called asset class in first query,  whereas in first uses attribute hierarchy dimension  on asset dimension.   the first provides expected results top 10 equity assets, whereas second returns 3 equity assets belong top 10 assets overall.   can explain this?  using cross join in topcount function works, unfortunately proclarity using not deal properly.    query 1   select non empty { [measures].[value base] } on columns ,   non empty { topcount( { [asset].[asset].[all].children }, 10, ( [measures].[value base] ) ) } on rows     from [miqb daily]   where ( [period].[month].&[2005-11-01t00:00:00], [asset class].[asset class category].&[equity])      query 2   select non empty { [measures].[value base] } on columns ,   non empty { topcount( { [asset].[asset].[all].children }, 10, ( [measures].[value base] ) ) } on rows    ...

  i have 2 tables between there one-to-many relationship. simplified structure follows:   code snippet master   id   keywordid   url   isactive   detail   detailid     masterid   capturedatetime     i want slice according datetime, , produce resultset mdx incorporating count of detail rows each master row child rows' capturedatetime fall within specified datetime range.   in addition, should have fields such detailidstart , detailidend (the min , max detailid columns given masterid in date range) , startdatetime , enddatetime (the min , max capturedatetime given masterid in date range):   code snippet masterid   keywordid   url   count   detailidstart  detailidend    startdatetime     enddatetime   isactive     previously in usage of analysis services, have had measures based on fact tables, sliced these according dimensions. how fields such masterid, keywordid , url returned? these been dimensions opposed measures, sinc...

hi, can body tell me how draw generates ssrs report on runtime of asp.net c# (need generates report in column number not fixed)  hello akhil, what want do; showing existing reports in asp.net page? use reportviewer webform control; see using webforms reportviewer control olaf helper blog xing SQL Server  >  SQL Server Reporting Services, Power View

hi - need in solving below secnario calculated measure: consider following case have 4 claim suffixes following revisions in fact table:    claim-suffix   dq compveh 12345-01 orig 1 0 r1 0 1 r1 0 0 23456-02 orig 0 0 r1 1 0 34567-03 orig 0 0 r1 0 0 45678-04 orig 0 0 r1 0 0 r2 1 0 r3 0 0 as shown above, have 12 rows in fact table and  each claim_suffix contain multiple reviousin in fact table.             in above example when roll revisions claim level, get claim-suffix dq report comp veh report 12345-01 1 1 23456-02 1 0 ...

i have ssis job outputs query csv file. each time file generated has filename structure output_<date>.csv if job ran multiple times in 1 dat csv file gets overwritten. my problem if user happens have file opened in excel , tries run job fail file in use. is there way prevent this? the easiest way write file write file location that users shouldn't accessing.  copy/move file location can access.  process fail on copy/move part of process, if want latest file after such failure, can copy hand. russel loski, mcse data platform/business intelligence twitter: @sqlmovers; blog: www.sqlmovers.com SQL Server  >  SQL Server Integration Services

  hi all,   i have small problem connect sql native odbc client mirrored database. the connection goes without problem when connect primary database, when give connect string an odbc client ""server=partner_a; failover partner=partner_b; database=xxx; network=dbmssocn"", connect fail. there no firewalls , other things on network. i able connect mirror database during failover, i'm not able set both servers on odbc connection.   kind regards, gruna     hi, before connecting secondary need failover mirroring, mirrored database become online. or have moved logins principal server mirror server same sid. if not need move existing logins (or particular login used connection) in primary secondary server, can use ssis package same or can use sp_helrevlogin proc. or if logins exists in secondary server different sid, in case need fix orphan id's in database, can check link  how fix orphaned sql server users  for same. ...