Help me please!! i cant install Microsoft SQL Server CLR Types, R2 Object Managements and SQL Express Service Pack 1 x86

help me please... i need it badly... i cant install Microsoft SQL Server System CLR Types, Microsoft SQL Server 2008 R2 Management Objects and Microsoft SQL Server 2008 Express Service Pack 1 x86... i dont know why...

Here is the Error Log:

[09/26/15,13:18:34] Microsoft SQL Server System CLR Types: [2] WARNING! Setup Failed for optional component Microsoft SQL Server System CLR Types. MSI returned error code 1603
[09/26/15,13:18:37] Microsoft SQL Server 2008 R2 Management Objects: [2] WARNING! Setup Failed for optional component Microsoft SQL Server 2008 R2 Management Objects. MSI returned error code 1603
[09/26/15,13:21:25] Microsoft SQL Server 2008 Express Service Pack 1 (x86): [2] Error code -2068643839 for this component is not recognized.
[09/26/15,13:21:26] Microsoft SQL Server 2008 Express Service Pack 1 (x86): [2] Component Microsoft SQL Server 2008 Express Service Pack 1 (x86) returned an unexpected value.
***EndOfSession***

i dont know what to do. please help me.

Reply:

Hello,

The error code 1603 is a general error code. Please us the following article to find the cause of the error.

http://blogs.msdn.com/b/astebner/archive/2005/08/01/446328.aspx

Try installing the CLR Types MSI in verbose mode. You can download it SQL Server Feature Pack.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

------------------------------------

Office365 user connecting to RDS and can't view docs

I have users with Office 365 accounts logging into my RDS Server to run an app. This app stores attachments (word/excel files). Yet they can't access these documents because the apps are not on the RDS Server. I understand why, but is there a way to have the attachments open with the users Office account? Even via the web app version and even if it is just read-only. They have a "licence" but can't seem to use it in this scenario. Thanks.

Changed type Amy Wang_ Friday, October 9, 2015 2:21 AM

Reply:

Might try them over here.

https://community.office365.com/en-us/f/172

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

------------------------------------

Query NTP server VBscript

Hi,

I have written a Vbscript to query NTP server, but this is not giving the output.

Can anyone please help me to correct this ?

strComputer = line
Set StdOut = WScript.StdOut
Set oReg=GetObject( _
"winmgmts:{impersonationLevel=impersonate}!\\" &_
strComputer & "\root\default:StdRegProv")
strKeyPath = "SYSTEM\CurrentControlSet\Services\W32Time\Parameters"
strValueName = "NtpServer"
oReg.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,StringValue
WScript.Echo "SYSTEM\CurrentControlSet\Services\W32Time\Parameters" _
& "CrashControl\NtpServer" _
& " = " & StringValue

NtpServer = StringValue

Microsoft is Growing Rapidly

From XP to Vista to 7 to 8 and 8.1 and now finally Windows 10. I have seen Microsoft tweak their OS's every day and not all MS operating systems are great. In fact I found myself in a mess with Vista, but that's to the past now and we move forward in life to our newer operating systems which are more fast, efficient and friendlier. Hence the day our old beloved PC's die and we have to move on to newer computers that will most probably won't support older operating systems. Say for example that the Toshiba Satellite L50D-B that comes pre-loaded with Windows 8.1 OEM will not let you install Windows 7. I have tried testing methods like disabling secure boot and setting boot to CSM only to find that after the installation it'll freeze at the boot logo. Even after setting it to UEFI there was no avail, also I was very lucky to have 8.1 on a Pen Drive so I re-install it and restored the computer to a clean functioning state.

Now on to Windows 8 and 8.1 I kind of liked this operating system in fact it's not half bad. I found myself navigating much faster than I was with Windows 7 and the load times on applications was much faster, but not that much, yet still it made me a whole lot happier. I will be happy at least for now...

At last it comes to this Windows 10 which I call the best operating system ever! All of it is polished and detailed to perfection. I think I should thank Satya Nadella for the wonderful work he has done to this operating system. I'm currently sitting on 10547 at the moment and waiting for 10550 to drop this week. I hope.

R.I.P XP we will miss you forever! I'll have you down in my history book and so will Windows 10 too!

Changed type Dave PatrickMVP Saturday, September 26, 2015 3:18 PM no question

Team Foundation Server 2013 - Advance Configuration wizard installation Error

I'm trying to install TFS2013 And gives the following error:

TF255323:The installation parameters specify the use of an existing database.A database was found but is not empty. An empty database is required.The database name is Tfs_configuration The server hosting the database is mini\sqlExpress.

TF400656:The collection database cannot be created because a database with the same name already exists.The database name is:Tfs_defaultcollection.The server hosting the database is:mini\sqlExpress

thanks

Moved by Danny van DamMVP Thursday, July 10, 2014 5:59 PM not related to training and certification
Changed type AnnaWY Friday, July 11, 2014 5:51 AM other topic

Reply:

Hi White.s,

For the TFS issue, I would recommend you can post in Team Foundation Server forum for more effective support:

http://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=tfsgeneral

Thanks for your understanding.

------------------------------------
Reply:

You must run the "Application-Tier Only Wizard" to reconfiguration TFS Application Tier to existing Database

------------------------------------
Reply:

You must run the "Application-Tier Only Wizard" to reconfiguration TFS Application Tier to existing Database. If you still want to use "Advance Configuration wizard" you need to delete existing TFS configuration database.

------------------------------------

8.1 update is preventing from booting computer

Looking for some advice here, going to keep it nice and simple.

I am trying to fix a friends Windows 8.1 install, she updated it 3 weeks ago and ever since it has failed to boot.

It loads the Windows Start Up Recovery screen or goes in a loop of trying to diagnose the issue and then boot up, is fails to do it.

We have tried using all the options in the recovery screen they are not working as it will not accept any of the passwords that she was likely to have used on the computer.I have also tried to bot it into Safe Mode and use the advance options to see if it give us any idea to what the problem is.

Is there anyway this can be fixed?

Reply:

Unfortunately if the possible recovery options fail then you could go for a Clean installation. But that will erase all the important documents. I shall suggest you to back up all your data and proceed. If there is another HD then you can make this as a slave and back up data to the Master HD.

How to refresh, reset, or restore your PC

S.Sengupta, Windows Experience MVP

------------------------------------

Send email

I need to send email with sharepoint list items and attachment from document library in jquery. Can anybody please help how to achieve that as i guess using SP.Utilities.EmailProperties does not send attachments. Please suggest.

Reply:

Hi,

There is no out of box way of sending email with sharepoint list item as attachments.

as you have mentioned SP Utility doesnt have attachments property, you could try either one of the below 2 options.

1. Send the link to the document instead of adding attachment.

2. You should try with the System.Net.Mail namespace to send emails.

Below URL might help you to crack this, but still not a good approach to solve your problem

http://edwin.vriethoff.net/2007/10/02/how-to-send-an-e-mail-with-attachment-from-sharepoint/

Sivabalan

------------------------------------
Reply:

As siva told, there is no out of the box and Client scripting to send emails with attachements.

http://sharepoint.stackexchange.com/questions/148226/send-e-mail-from-javascript-using-rest-api

https://plumsail.com/blog/2015/05/send-emails-with-attachments-from-sharepoint-2013-and-office-365-workflow/

Please remember to click 'Mark as Answer' on the answer if it helps you

------------------------------------

Exchange Powershell Scripting for enabling Archive with reporting issue.

I have a script that works just fine for enabling Online Archiving and then assign retention policy (Script 1).

But when I add a line to export a report to a text, it only does it for the last person in the text file list.

If I was to run a script separately (Script 2) and assign the text file of the list of users it works great (see example of this script bellow), but when I try to integrate this script to the script that uses arguments to identify which users to enable Online Archiving, assign Retention Policy and then create a report text file it only spits out the results for the last user in the list.

Script 1

If ($Args.Count -eq 0) {
write-host "You need to specify a file with a list of users as a parameter at the command line!!!"
Exit
}
$users = get-content $args[0]
foreach ($u in $users) {
$MailboxDatabase= (Get-Mailbox $U).Database
$ArchiveDatabase= "Archive01"
$RetentionPolicy= "Retention Policy"
Enable-Mailbox $U -Archive -ArchiveDatabase $ArchiveDatabase
set-mailbox $U -retentionpolicy $RetentionPolicy
write-host "Done processing $u…"

Script 2

Get-Content "C:\scripts\Exchange\Online Archive Enable Script\Group4_List1_Arch_Enable.txt" | Get-Mailbox | FT Name,WindowsEmailAddress,Archivedatabase >"C:\scripts\Exchange\Online Archive Enable Script\Group4_List1_Arch_Enable_Report.txt"

Script 3 This is what I want to work

(Get-Mailbox $u) | FT Name,WindowsEmailAddress,Archivedatabase >"c:\data\TEST.txt"
}

Please have a look and help.

Thanks a bunch in advance.

Reply:

Note that you script is incomplete and has smart quotes which can cause issues:

If ($Args.Count -eq 0) {   write-host "You need to specify a file with a list of users as a parameter at the command line!!!"   Exit  }  $users = get-content $args[0]  foreach ($u in $users) {   $MailboxDatabase= (Get-Mailbox $U).Database   $ArchiveDatabase='Archive01'   $RetentionPolicy='Retention Policy'   Enable-Mailbox $U -Archive -ArchiveDatabase $ArchiveDatabase   set-mailbox $U -retentionpolicy $RetentionPolicy   write-host "Done processing $u…"

Use single quotes when expansion not required and do not use smart quotes.

\_(ツ)_/

------------------------------------
Reply:

You are just throwing a bunch of pieces on the screen and saying "make this work". This forum is not a repair site for scripts you have found oon the Internet (smart quotes tell us that).

Please post a script that you are using and ask a specific question.

\_(ツ)_/

------------------------------------
Reply:

This is the script that someone had suggested I use for this task. I am not a scripter, nor do I claim to be. I am just trying to make my work easier by using a script to handle multiple tasks simultaneously.

I have used this script successfully with the exception of the report being created at the end. I am looking for a solution for giving a report of the successful mailboxes getting Archive turned on with retention policy.

------------------------------------
Reply:

And what is the error you are getting. THe mailboxes changed are listed in the file you are outputting to. Change > to >> to see all outputs.

\_(ツ)_/

------------------------------------

Deploying a model from DEV to PROD did not create the users, their rights and notifications!

Hi,

Pretty disappointed here...

I deploy my first MDS model and all the security is lost as well as the notifications setup in the rules!!!

After some research I found that the users are not created and the security maintained (very bad design decision Microsoft...) but why the notifications are lost too????

How to correctly deploy stuff if the deployment tool dont do a good job?

is there any utility or sample already doing this? (I dont want to code this if possible)

Changed type Vincent Chen (X) Friday, September 25, 2015 6:52 PM

Reply:

I think there is no way to move the security setting from one environment to the other. The original thought, I guess, is Prod and Dev/Test will definitely have different user settings and security settings.

------------------------------------

Ghorepani poon hill trekking

Himalayan Recreation operate Ghorepani Poon hill trek in Annapurna region of Nepal, it is known as short & easy trekking which offers you breathtaking views of mountain scenery & sunrise from Poonhill.

Finding things...

Have given this to Redmond, @ their request & to the Microsoft Store, here in Calgary. I have used it for years, not only w/ Windows 10 & give it to all my friends, colleagues & clients; all like it a lot! It is very likely anyone would like it. It saves open Start & going through the All Applications there. It, also, shows ALL items w/out having anything inside folders. It gives a window that 'lives' on the Taskbar and its 'display' can be User selected for View & Sort.

Using this line %windir%\explorer.exe shell:::{4234d49b-0245-4df3-b780-3893943456e1}

Rt Clk Desktop > New > Shortcut. Put the line in Location, hit Next. Change (name) explorer.exe to Applications, hit Finish. Now, click on the resultant icon, get rid of the Nav Tree, select the desired View & Sort and MINIMISE, do not close (X). If closed, have to redo it. Has to be redone, via the Desktop icon, after a Restart.

-------------------------------------------

Also, remember, in Windows 10, one can search by just hitting the Win key & beginning to type what one seeks.

Cheers,
Drew

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Edited by Drew1903 Thursday, September 24, 2015 5:14 PM
Changed type Zen the Ocelot Friday, September 25, 2015 5:24 AM Not a question

Reply:

Thanks for sharing. We really appreciate your time and efforts. Hope your experience will help other community members facing similar practice.

Regards,

D. Wu

Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

------------------------------------
Reply:

You're welcome. My pleasure. Please, mark as "Helpful".

Cheers,
Drew

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

------------------------------------

cannot connect to sql server developer 64 bit

Hi.

Cannot connect to sql server developer 64 bit.

Cannot repair, because windows 10 does not like long file names for sql media.

How to fix.

Will paste below.

The error message.

Any help.

Thanks.

TITLE: Connect to Server

------------------------------

Cannot connect to MARVIN-PC.

------------------------------

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------

The system cannot find the file specified

------------------------------

Hi.

Cannot connect to sql server developer 64 bit.

Cannot repair, because windows 10 does not like long file names for sql media.

How to fix.

Will paste below.

The error message.

Any help.

Thanks.

TITLE: Connect to Server

------------------------------

Cannot connect to MARVIN-PC.

------------------------------

ADDITIONAL INFORMATION:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------

The system cannot find the file specified

------------------------------

BUTTONS:

------------------------------ Connect to Server

BUTTONS:

------------------------------ Connect to Server

http://startrekcafe.stevesdomain.net http://groups.yahoo.com/groups/JawsOz

Reply:

Marvin,

Read below

Troubleshooting Connecting to SQL Server DB engine

This is general error message saying your connection cannot find SQL Server, there can be many reaosn like SQL Server is stopped, blocked by firewall, incorrect connection details provided etc.

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Wiki Article
MVP

------------------------------------
Reply:

Hello,

Please share with us the Summary.txt log file created by the repair procedure you executed on the SQL Server instance. The following article will help you locate the file on disk

https://msdn.microsoft.com/en-us/library/ms143702(v=sql.120).aspx

Thank you in advance.

Regards,

Alberto Morillo
SQLCoffee.com

------------------------------------

SCCM 2012 R2 SP1 | Internet Based Client Management (IBCM) and Baselines

Will a client pull down new baselines assigned while off network with internet only connection over the IBCM MP? It seems like it does not work. After countless Machine Policy Retrievals our test system does not pull down new baselines into the configuration tab.

Does anyone know if this is supported?

Edited by Eric Weintraub Friday, September 25, 2015 12:58 PM Corrected Name

Reply:

One terminology correct, it's Internet Based Client Management (IBCM).

Yes, baselines are supported for Internet managed clients. They are part of the normal machine policy. Are you sure you have them deployed to the Internet systems?

Jason | http://blog.configmgrftw.com | @jasonsandys

------------------------------------
Reply:

Can you deploy other things such as applications or packages? What do the client logs show?

------------------------------------
Reply:

Jason thanks for the correction I updated the post.

I "think" it's deployed to the internet system. Is there anything different for a Internet Management Client? I can confirm the device is in the collection that has the Baseline deployment.

------------------------------------
Reply:

Will I will try to deploy a test package, which logs should I be looking at looking at for Baseline?

------------------------------------

First Release of Devart SSIS Data Flow Components

Devart announced the first release of Devart SSIS Data Flow Components — a set of components for SQL Server Integration Services (SSIS) packages that allow loading data from and to various sources in SSIS Data Flows. For now SSIS Data Flow Components supports 14 data sources.

Included Components

For each of the supported sources, Devart SSIS Data Flow Components include Source, Lookup, and Destination components along with the corresponding Connection Manager. Devart Source components provide convenient editors which allow you to quickly create a query to the data source. Source component for cloud data sources also provide advanced support for SQL SELECT statements, even for sources that do not support SQL natively. Devart Destination and Lookup components implement a number of optimizations that provide high performance data matching and loading.

The list of supported data sources includes:

Databases: Oracle, MySQL, PostgreSQL, DB2

Cloud CRMs: Salesforce, Microsoft Dynamics CRM, Zoho CRM, SugarCRM

Cloud Marketing Applications: MailChimp, ExactTarget

Ecommerce Applications: Bigcommerce, Magento

Cloud Accounting Applications: QuickBooks, FreshBooks

Learn more about the new product line of Devart SSIS Data Flow Components at https://www.devart.com/ssis/

Edited by Devart Software Friday, September 25, 2015 10:49 AM

week numbers in calendar web part

Greetings and salutations all :D

I am struggling with getting week numbers to show in the calendar web part (month view) in sharepoint online (office 365). I have looked around the net and found basically two ways to do it, and I cannot get any of them to work...

First one:
https://social.technet.microsoft.com/Forums/office/en-US/ba00628b-04b6-4bd2-9739-4138aa3797e6/week-numbers-in-calendar?forum=sharepointgeneralprevious

Second one:
http://blog.scoreman.net/2014/09/week-numbers-in-calendar-view-revisited-for-sharepoint-online/#comment-38431

The first one gives me errors saying unable to get property $4a (and also $4b).
The second one just gives an unexpected error...

So, my question is: Has anyone got a good solution to show week numbers in the calendar web part in sharepoint online?

Edited by luddiluddludde Friday, September 25, 2015 8:22 AM

Reporting Service Integration Mode with SharePoint

Hi,

I am looking for the solution to change the parameter panel position from right to the left part of the website.

Is it possible to change the order, so first of all in the left we will have Parameter Panel and in the right main body of the report?

Best regards

Edited by CaMeL023 Thursday, September 24, 2015 11:41 AM

Reply:

HI,As I understand you want to connect to reporting services with share point as share point integrated mode.Please check the link below that explains more in details about the RS and the integration with share point.

http://expertsharepoint.blogspot.my/2014/03/sql-reporting-services-installation.html

Anil Avula[Partner,MCP,MCSE,MCSA,MCTS,MCITP,MCSM] See Me At: http://expertsharepoint.blogspot.de/

------------------------------------
Reply:

Hi,

I managed to integrate sharepoint with SSRS and I can display report on sharepoint site using RSViewWebPart but I would like to change Parameter Container position from right side of the screen to left.

Is it possible to configure this webpart in this way?

------------------------------------

Trouble in debugging my SharePoint solution 2013 in visual studio 2012

I am having trouble in debugging my SharePoint solution in visual studio, the scenario is
When I deploy the solution in SharePoint 2013 from Visual studio 2012 it gets deployed and works well but when I deploy the solution in debug mode(F5) in Visual Studio it gives an error...

Any help will be appreciated

Cannot receive attachments due to this error "mx google com rejected your message to the following email addresses:"

Hi,

Our company email address suddenly have this error that we cannot receive attachments from our clients.

mx.google.com rejected your message to the following email addresses:

*** Email address is removed for privacy ***

Your message wasn't delivered because the recipient's email provider rejected it.
mx.google.com gave this error:
This message was blocked because its content presents a potential security issue.

SP2010 Attach content db

Hi Everyone

SP 2010 Web application STOPPED working after database attach(SQL SERVER 2008 R2)

During db attached, there was no single error triggered. Any steps to perform post attach method.

Regards

Prashanth

Reply:

Did What do you mean by "STOPPED"? Can you share screenshot or error message from SharePoint log when browsing the website?

Thuan Soldier
A 23-year-old man loving Microsoft technologies and making crazy ideas on business journey.
SharePoint Vietnam | Blog | Twitter

------------------------------------

ERR3:7438 No NTUser.DAT file for User was found

ERR3:7438 No NTUser.DAT file for User was found in \\server\profiles$\User. The roaming profile cannot be migrated.

Notes for myself or anyone else who runs into this specific issue:

I was running an interforest migration using ADMT 3.2. The user account migration failed with the above error, while trying to translate roaming profiles. I double checked the settings, googled and binged, but couldn’t find anything to resolve the issue. After starring at the error message, it hit me. ADMT isn’t using the FQDM to find the server that’s hosting the roaming profile. It’s using \\server instead of \\server.sorucedomain.local. I added Server to the hosts file on the ADMT machine, and the error disappeared. I believe this is a bug.

Changed type JoeNYC Friday, July 15, 2011 6:37 PM

Reply:

Hi,

Thank you for your question.

I am trying to involve someone to further look at this issue. There might be some time delay. Appreciate your patience.

Thank you for your understanding and support.

Brent
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact tnmff@microsoft.com

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

------------------------------------
Reply:

Looks like you answered your own question. Are you looking for any further assistance on the issue?

From my side i will check if this is a known issue.

Sumesh P - Microsoft Online Community Support

------------------------------------
Reply:

I just checked with an expert and It is likely that the short server name was used in profilePath property on the user account. It is posible that ADMT is just querying this property. So if the DNS client cannot resolve the short name, then it must be configured to do so (additional DNS suffix, hosts file entry, etc.).

Sumesh P - Microsoft Online Community Support

------------------------------------
Reply:

Hi JoeNYC,

Any update?

------------------------------------
Reply:

I wanted to add to this thread since it shows up in search results when looking for this error. In our environment what we discovered was that if the roaming profile path in the AD user object is a DFS path, then ADMT is unable to access it. However, if this DFS path is changed to a non-DFS path, then it works. I confirmed this from 2 separate source domains.

According to the logs, what appears to be happening is that ADMT attempts to translate the Roaming Profile path to a path that uses the admin share. So while it has a problem doing this when using a DFS path, it takes a non DFS path like \\server.com\share\user\Profile and converts it to \\server.com\d$\share\user\profile.

Our ADMT version is v3.2 (6.1.7600.17478) and the DFS path was a FQDN path.

Hope this helps someone!

Edited by Aakash Shah Friday, September 25, 2015 3:52 AM

------------------------------------

Ms Support forum

Sunday, January 30, 2022