Managing SQL server instances registration through Studio GUI and Manual Steps

  Managing Registered SQL Server instances:             “%appdata%MicrosoftMicrosoft SQL Server100ToolsShellRegSrvr.xml" OR "C:Users<Username>AppDataRoamingMicrosoftMicrosoft SQL Server100ToolsShellRegSrvr.xml"   Sample content of a   <?xml version="1.0"?> <model xmlns="http://schemas.serviceml.org/smlif/2007/02">   <identity>     <name>urn:uuid:</name>     <baseURI>http://documentcollection/</baseURI>   </identity>   <xs:bufferSchema xmlns:xs="http://www.w3.org/2001/XMLSchema">     <definitions xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08">       <document>         <docinfo>           <aliases>             <alias>/system/schema/RegisteredServers</alias>           </aliases>           <sfc:version DomainVersion="1" />         </docinfo>         <data>           <xs:schema targetNamespace="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">             <xs:element name="RegisteredServer">               <xs:complexType>                 <xs:sequence>                   <xs:any namespace="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08" processContents="skip" minOccurs="0" maxOccurs="unbounded" />                 </xs:sequence>               </xs:complexType>             </xs:element>             <RegisteredServers:bufferData xmlns:RegisteredServers="http://schemas.microsoft.com/sqlserver/RegisteredServers/2007/08">               <instances xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08">                 <document>                   <docinfo>                     <aliases> […]

Read more

Packaging UK Mamut Business Software (MBS)

Pre-requisites: Install SQL Express R2 Advanced Features, instance named MAMUT Installing UK Mamut Business Software (MBS) : Launch Mamut 14.5 setup.exe In Installation Type Wizard: Install Single User with Advanced Options Specify Program Files path: C:Program Files (x86)Mamut Specify Database Files path: C:UsersPublicPublic MamutDatabasesMAMUT It uses locally installed Instance name automatically, Click Finish Configuring UK Mamut Business Software (MBS) : Launch Application Select Register License > Click Next > Specify Documents Directory: C:UsersPublicPublic MamutDemoDataMamutUKAppData It creates System Database Specify the values for user profile creation for System Administrator: Full name:  System Administrator User name: sa Password: test Register Program TestOrg/Test […]

Read more