Posts

Showing posts from February, 2017

Bulk import Users into Active Directory from CSV

Image
In this video, the Active Directory management tool XIA Automation is used to bulk import users into AD from a CSV file. The CSV import feature is one of the many benefits of using XIA Automation to help manage your network.  It can be combined with automation tasks to enable you to mass provision user accounts in minutes. - Please visit the XIA Automation page form more information. - A free trial version is available.

Install XIA Links Server v3

Image
If you need help installing XIA Links v3, check out the tutorial video posted on the CENTREL Solutions YouTube channel . It covers how to install the prerequisites including IIS, .NET 3.5 and ASP.NET 3.5. XIA Links Server is then installed.  The .NET CLR version is changed to v2.0.  The XIA Links Client is then downloaded and installed from the Server homepage. Finally, the Server URL is configured in the Client and the licence file is applied. - Please visit the XIA Links page for more information. - A free trial version is available.

Install XIA Automation Server v3

Image
Fresh off the back of our XIA Configuration Server installation video , we've created a XIA Automation Server v3 installation video . It covers how to install all the prerequisites including IIS, .NET 3.5 and ASP.NET 3.5 and walks you through the installation steps. The purpose of the client and server is briefly mentioned at the end.  Note: This is covered in more detail in our getting started video . - Please visit the XIA Automation page for more information. - A free trial version is available.

Active Directory Management Tool

Image
In the latest of our series of tutorials , I demonstrate how to get started with the Active Directory Management Tool XIA Automation Server. The video starts by showing how to create automation profiles and tasks in the XIA Automation Client.  A sample configuration is downloaded from the CENTREL Solutions website and imported.  The tasks are then executed through the XIA Automation Server web interface via both the form input and CSV input. The video ends by mentioning a couple of other features commonly used in the software, Active Directory password resets and custom branding. - Please visit the XIA Automation page form more information. - A free trial version is available.

Install XIA Configuration Server v9.0

Image
We recently updated our XIA Configuration Server v9.0 installation video.  It now covers how to install all the prerequisites including Microsoft .NET 3.5, IIS and SQL on Windows Server 2008 R2, Windows Server 2012 R2 and Windows Server 2016. It also explains options such as the 'Preconfigure the client service' checkbox. You can watch it here: How to install the IT Documentation Tool XIA Configuration - Please visit the XIA Configuration page for more information - A free trial version is available

Cannot alter the role 'db_owner', because it does not exist or you do not have permission.

Image
This post describes how to fix the error "Cannot alter the role 'db_owner', because it does not exist or you do not have permission". This also applies to the role 'db_datareader'. Cause This can occur if your server collation is case sensitive and you're trying to alter a role in SQL using the sp_addrolemember stored procedure e.g. EXEC sp_addrolemember 'db_Owner', 'dbo'; To check your server collation: SELECT SERVERPROPERTY('COLLATION'); To check your database collation: SELECT DATABASEPROPERTYEX('%DATABASENAME%', 'Collation') SQLCollation; Note: You can get a description of each COLLATION using this query: SELECT * FROM fn_helpcollations(); Solution Change your server collation or ensure the role you want to alter matches exactly including case. EXEC sp_addrolemember 'db_ o wner', 'dbo'; Video Watch the video:  Cannot alter the role, because it does not exi