Thursday, July 17, 2014

Infopath Publishing error "The following URL is not valid"

When trying to publish Form the following alert appear "The Following URL is not valid"

Solution: 

After Googling and trying lots of things, I remembered my proxy was turned on at University...

Check if it's active, if so deactivate the proxy server at IE

Internet Options - > Connections - Lan settings - > "Proxy server" - deactivate the check boxes here

Have a great Day ;)

Wednesday, May 7, 2014

The workbook cannot be opened - Excel File SharePoint

Whether you open a excel file in SharePoint the following message appear "The workbook cannot be opened"

You have to do these 2 steps:
  1. Run Powershell commands
    1. $w = Get-SPWebApplication -Identity http://portal
    2. $w.GrantAccessToProcessIdentity("domain\ServiceAccount")
  2. Restart IIS iisreset /noforce

The breapoint will not currently be hit. No symbols have been loaded for this document.

Hi Folks,

One day in the morning I keep getting this error: The breakpoint will not currently be hit. No symbols have been loaded for this document.

I asked for help on a Microsoft College and He simple did "nothing". After 30 minutes it started to work and the only different thing he done was this:
Solution:

  1. Go to Menu build -> Configuration Manager
  2. In the Active Solution Configuration, select Release (or Debug if you had Release). Close
  3. Do a Clean Solution then a Build Solution
  4. Switch back to to Debug (or Release if you had Debug).
  5. Now if you deploy the error will go away.

Hope it helps for you folks

Allow anonymous access to internal, external or other network

Best Practices for allowing anonymous access to an existing Web Application or Portal.

NOTE: If you go straight and allow anonymous access on your Web Application, all users will have to click Sign In.

In spite of allow anonymous access to your web application and site collection, you should extend your web application and create a new IIS site with new hostname and then allow anonymous access


That’s is the right way because if you do all at the same web application users within intranet will not automatically authenticate in your Portal.

Trade-off: The problem is when you separate the same Site in two or more hostnames. Forms can only be submitted to one URL, so you must choice which one. That's the trade-off.
If you have a solution for that, I really appreciate your share.

Thank you.

Tuesday, April 29, 2014

Build-in, simple, easy and free way to block / disable Print and Download a copy button on SharePoint documents

Hi Folks,

Do you want to know how to block / disable Print and Download a copy buttons of a document in SharePoint without Information Right Management (IRM) ?

I was looking for an answer and haven't found on Internet and also asked Microsoft about it. They said apparently there is none.

So i began to look around for a solution...

And yeah i found a easy way with a mix os Sharepoint configurations and permissions.
I will make a tutorial of how you can do that in my next post.

Do you really think it is useful ?

Friday, March 28, 2014

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)


Problem: After a while using some tasks like detaching, putting offline, shrinking on SQL Server Management Studio, I couldn't attach a database and the following error appear:

"Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)"

Refreshing and reconnecting won't work but don't give up...

Solution: Simply Restart SQL Server Management Studio!

Friday, March 14, 2014

Disable / Remove share button, follow button and synchronize button Sharepoint 2013

In spite of deploying code or jquery scripts, I wanted to know if there was a way of disabling buttons in SharePoint itself..
So I found out that you don't need any code/script to disable those buttons (share, follow and synchronize).

Here's how:
  • Disable "Share button" 
    1. Go to Site Permissions
    2. Select Access Request Settings
    3. Unmark Allow access request
Remember: You have to do for each Site and Button will still be visible for Admins

  • Disable "Follow button"
    1. Go to Site Features
    2. Deactivated Following Content Feature
Remember: You have to do for each Site

  • Disable "Synchronize button"
    1. Go to library settings
    2. Go to Advanced settings
    3. Say No to Offline Client Availability
Remember: You have to do for each Library

All done :)

Wednesday, March 12, 2014

The breakpoint will not currently be hit. No symbols have been loaded for this document

What i have done to resolve the issue:

  • I selected to start the right project - Source: stackoverflow
  • Attached the specific process - Someone's Blog
  • tested IE 8 and 9 - Someone's Blog

None of these worked.


Solution: I tested switching from debug mode, to release...deploy
Then back to debug ... deploy and unexpected breakpoints started to work!!

Have a happy day

Tuesday, February 11, 2014

Send email with powershell with(out) SharePoint

If you are schedule a Job, an alert or just want to mess around with your colleagues. You can use this powershell script

a)

Add-PSSnapin Microsoft.SharePoint.Powershell
Write-Host "Sending Email...pausing 30 seconds"
Start-sleep -s 30
Write-Host "Waited 30 seconds"

#SMTP Server Name
$smtpServer = "exchange.com"

$msg = new-object Net.Mail.MailMessage
$smtp = new-object Net.Mail.SmtpClient($smtpServer)

#Write FROM EMAIL
$from = "@something.com"
$msg.From = $from
$msg.ReplyTo = $from

#Write TO EMAIL
$msg.To.Add("@something.com")

#Your Subject
$msg.subject = "test subject"

#Your Email Body 
$msg.body = "test body"

#Sending email
$smtp.Send($msg)

1 - Write your smtp server
2 - Write email you want to be from
3 - Write email you want to send to

Or with SharePoint

b)
Add-PSSnapin Microsoft.SharePoint.Powershell

#Write EMAIL TO
$email = "@something.com"

#Write Subject
$subject = "Test subject"

#Write Body
$body = "Test body"

$web = Get-SPWeb "http://sharepointserver" #Email From have to be configured here
[Microsoft.SharePoint.Utilities.SPUtility]::SendEmail($web,0,0,$email,$subject,$body)

1 - Write your smtp server
2 - Write email you want to be from
3 - Write email you want to send to


c ) Copy and save it a ps1 file and run it.


Error The application is unable to continue and will now terminated

Problem:
---------------------------
SharePoint Manager Preflight check Error
---------------------------
The application is unable to continue and will now terminated.
---------------------------
OK  
---------------------------

Solution:
You have to be Farm Administrator or SQL SysAdmin

Enjoy!