Thursday, July 23, 2009

How to change SQL server name ?

A very common issue, when you make a p2v ( convert in vmare language ) to a physical Server and change the name of the server.

The whole idea is that the database still thinks it's on the pervious database and it damages his functionalty.

Those are the steps to check if you have this issue, and how to fix that.

 
//check the hosting server of the SQL service
sp_helpserver
select @@servername

//if the server name that appears is of the pervious server
// Make sure to run it from the server itself, NO remote execution
sp_dropserver 'old_name'
go
sp_addserver 'new_name','local'
go
// Now restart the SQL service and check the first step again to make sure.


Good luck

Thursday, July 2, 2009

Archive for Sharepoint ? Symantec Enterprise Vault... Round# 2

Well, a while ago I talked about the Enterprise vault product for archiving Sharepoint platform.
Since then, The Moss 2007 is common in every single customre I have. So , now they have new version. I checked. And now I declare.

What did they fix that makes it better than their last version ?

1. It supports Kerberos authentication.

What still makes it not ready ?

1. Doesn't support fedrated shearch AKA you still cant crawl it with your Moss search engine.
2. When you want to edit an item, it's being retrieved back from the repository, but it opens the document in your temporray internet files and NOT in your web site AKA your changes wont be saved/updated ( Cause you didn't save them on your website ).
3. Permission issue. When you copy an item ( the stub ) to anoter new list with diffrent ACL - you wont be able to reach the file if you dont have an access to the source list ( read at least ).

There are more issues, but those are the most critical and I count only till three.

Sorry, But it still not ready. I better submit my customer an email.