It is very easy
1. Create a simple txt file and change the extention to .udl
2. Double-click on the file and up pops a SQL connectivity window to allow testing of remote SQL connections
Archive for SCSM
How to test a remote connection to SQL Instance
Category: Azure Pack, COSN, SCCM - Installation, SCOM - Installation, SCSM - Installation, SQL, WAP Installation |
FORBEDRE DIN ITSM OPERATIONS, OG OPNÅ MERE TILFREDSHED
Praktisering af ITSM Operations har til formål at skabe størst mulig værdi for forretningen og IT afdelingen, igennem konstant fokus på organisationens IT leverancer. Det sikres med en effektivitet og kvalitets styret drift af de services og ydelser som IT afdelingen leverer. Og ITSM Operations må betragtes som en kritisk disciplin, der stiller krav til hvordan man løbende vedligeholder og forbedrer stabiliteten i driften af services og ydelser – det er et område der kræver en dedikeret styring, med fokus på både reaktiv og proaktiv tiltag. Read more
Service Manager – Report – View Persmission
Service Manager supports a Delegation Model for different User Roles. However, if you want non-Administrators to see and use specific Reports, this is not possible using one of the default roles.
I have create this short guide that use the build-in role-base access model i Reporting Service.
Category: SCSM - Reporting |
Tags: Reporting Persmission
SQL – Full-Text Search – Danish – Service Manager 2012 sp1
I am from Denmark and therefor I like to try out Service Manager 2012 sp1 in Danish.
My Setup info
Windows Server 2008 R2
SQL Server 2008 R2
Sharepoint Foundation 2010 SP2 with Danish langauge pack
So I installed it and got Service Manager to talk danish :-). Then I got to the Self Service Portal. I installed the language pack and got the setup right. So now the service portal also speak danish. So fare all fine.
Service Manager – Issue with Registration of Data Warehouse – A Management Group with same Name
Very nice that life give your some new challenges. In may lap I some how ran into below error.
Error Message: A Management group with the same name is already registered to the data warehouse mangement group.
Service Manager installation issue with the MP part
Finally I had a issue with installation of the Service Manager system for POC system.
Error: An error occurred with executing a customer action:_CreateMOMRegKey
Category: SCSM - Installation |
SQL Server guide for System Center 2012
I found this nice blog from Paul Keely,MVP.
This is a guide to help you make design decisions and maintenance plans for SQL Server 2008 R2 to support System Center 2012. In the guide you will learn to make server and instance specific changes to support SQL server for the different workloads that System Center requires. We will look at the install requirements per product, what we need to move the data bases and how we should back them up.
Link: http://gallery.technet.microsoft.com/SQL-Server-guide-for-8584c403
SCSM – Portal Service Catalog Empty for End Users
I have just setup the Self Service Portal, and it look fine. But it was empty. Then I found Justin Cook has wrote a nice blog about it.
I will recommend you to have look.
http://systemcentertech.com/2012/06/28/scsm-2012-portal-service-catalog-empty-for-end-users/
And another greate blog from Sandeep Chadda
http://schadda.blogspot.com/2012/08/how-to-fix-system-center-portal-if-it.html
One more to check out
If you take a look on both blog’s, then you have very good idea solve this issue.
Category: SCSM, SCSM - Installation |
SCSM – “the data warehouse registration failed”
Yesterday I got below error when I tried to register my Data Warehouse.
Error Message
I have look through the white papers from Microsoft (Link). I saw that section with Powershell. And when I change Execution Policy to RemoteSigned, and run the GUI agaoin. The works
How to
Run Powerhell with admin right and run below command. And press Y(as default)
Set-ExecutionPolicy RemoteSigned
Category: SCSM - Installation |
