Avatar of Richardsoet
Richardsoet

asked on 

How to rebuild master database on SQL 2005 to change collation settings

Error when trying to rebuild master database on SQl 2005 on active passive node.The install screen pop and then error user installation cacellation error.

Before getting that error , I have set the database into single user mode before runing the below script

start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=lekan SQLCOLLATION=Latin1_General_CI_AS

please help
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
James Murrell
Avatar of Richardsoet
Richardsoet

ASKER

Any idea,

Error:
User installation cancellation
ASKER CERTIFIED SOLUTION
Avatar of Richardsoet
Richardsoet

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of James Murrell
Microsoft SQL Server 2005
Microsoft SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo