Archive

Archive for the ‘Cluster’ Category

HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 2

December 23, 2013 1 comment

Hi ALL,

for setting up TEST env for Server 2012 and above refer to my First post for initial details and videos from 1 to 6

remaining Videos are as below :: –>

once again CREDITS goes to metamanager  (Check out the Channel and Subscribe to the same)

Video number 7 

Video number 8 

 Video number 9

Video number 10

 

CREDITS goes to metamanager 

Thanks a lot for checking out the page .. do comment and share !!!

Enjoy

 

Advertisements

HOW TO Set up TEST Environment for SQL SERVER 2014 CTP2 or SQL SERVER 2012 PART 1

December 23, 2013 2 comments

Hey ALL,

if you are looking forward to set-up a test server for playing around with SQL server 2014 CTP2 release or have some

concepts cleared on always ON on SQL SERVER 2012 .. Follow on ..

Below is the flow of this post ..

1> links for pre-requisite for Setting up SQL server 2014 CTP2 or SQL Server 2012 Environment

2> Video Links for Setting up SQL Server 2012 (Same concepts and set-up is applicable to SQL Server

       2014 CTP2) 

Video links are taken from metamanager  (Check out the Channel and Subscribe to the same)

Credits for Videos goes to metamanager .. Thanks a lot for sharing them … Great for the SQL communities 

Host machine specs

–>  windows 7 ,8 GB RAM,core i5 ,around 150+ GB HD (so anything close to this or higher will be great )

download below ISO Files for

windows SERVER 2012 ,

SQL server 2012

or

SQL server 2014 CTP2

i have preferred to download ISO file (you may use CAB if you prefer , ALL links are for Evaluation Editions only )

1> Windows Server 2012 –> 

http://technet.microsoft.com/en-in/evalcenter/dn205286.aspx

 

download_ISO_file

2>  SQL Server 2012 –> 

http://www.microsoft.com/en-us/download/details.aspx?id=29066

OR

3> SQL Server 2014 CTP2 –>

 http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx

 4>  VMWARE workstation or Hyper-V is required to set-up the Virtual environment

  https://my.vmware.com/web/vmware/info/slug/desktop_end_user_computing/vmware_workstation/10_0

                                                                                               OR

 –> if you are interested in trying out Hyper-V then check out This links  (it is also  present as a feature in Server 2012)

         Once you are done with downloading the OS,SQL Server and VMware (or Hyper-V)

              Follow below Videos to Set-up your Env ..

                                                                             1> 

 

                                                                            2> 

 

                                                                           3> 

 

 

                                                                         4>

 

 

                                                                        5>

 

 

                                                                     6>

 

 

REST of the Videos .. i will share in second post ..

once again CREDITS goes to metamanager  (Check out the Channel and Subscribe to the same)

Enjoy 🙂

Error executing sp_vupgrade_replication SQL server or Login failed for user ‘domain\username’. Reason: Server is in script upgrade mode

October 18, 2012 Leave a comment

if you happen to failover a SQL server cluster .. you may have to wait before the SQL comes online .. and you will get below messages

1> SQL error log or while connecting thro SSMS

Login failed for user ‘domain\username’. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: ] 2012-10-18 05:20:16.370 Logon Error: 18401, Severity: 14, State: 1.

2> The SQL error log may also have below errors  (if the Database are involved in replication )

2012-10-18 05:20:29.800 spid9s Executing sp_vupgrade_replication.

2012-10-18 05:20:29.800 spid9s Executing sp_vupgrade_replication.
Database ‘master’ is upgrading script ‘repl_upgrade.sql’ from level 167776160 to level 167777660
Upgrading publication settings and system objects in database [DB1].
Upgrading publication settings and system objects in database [DB2].

Error executing sp_vupgrade_replication.

2012-10-18 05:21:05.090 spid9s Cannot perform this operation while SQLServerAgent is starting. Try again later.2012-10-18 2012-10-18 05:21:05.090 spid9s Saving upgrade script status to ‘SOFTWARE\Microsoft\MSSQLServer\Replication\Setup’

2012-10-18 05:21:05.090 spid9s Saving upgrade script status to ‘SOFTWARE\Microsoft\MSSQLServer\Replication\Setup’.

2012-10-18 05:21:05.090 spid9s Saved upgrade script status successfully.

Cause : This happens because the Databases have never been failed over this cluster node (the current active node) after the successful upgrade of service pack (e.g SQL 2008 SP2 or SP3 ) or are failed over for the First time after upgrade

**** some of the Database do not upgrade if the SQL agent is running **** so you need to let the upgrade run with SQL agent been STOPPED ..

To resolve this issue, follow these steps:

  1. In the cluster administrative tools, bring both SQL Server Agent and the SQL Server service offline. 
  2. Bring the SQL Server service back online while SQL Server Agent is still offline. 
  3. After the startup process has begun, review the error logs to see whether the following entries appear there:If you do not find these entries, the replication upgrade has completed successfully. To verify this, check whether the value of the Upgrade registry key at the following registry entry is updated to 1. (This indicates a successful upgrade.)
    • spid7s Upgrading publication settings and system objects in database [DBName].
    • spid7s Cannot perform this operation while SQLServerAgent is starting. Try again later.
    • spid7s Error executing sp_vupgrade_replication.
    • spid7s Saving upgrade script status to ‘SOFTWARE\Microsoft\MSSQLServer\Replication\Setup’.
    • spid7s Saved upgrade script status successfully.

  4. HKLM\SOFTWARE\Microsoft\MSSQLServer\Replication\Setup
     

  5. Run the following command, and then look for a transaction that is named “tran_sp_MScreate_peer_tables.” If you do not see an entry sthat has this name, you have additional verification that the replication upgrade completed on its own. use [DBName] 
    select * from sys.dm_tran_active_transactions where name = ‘tran_sp_MScreate_peer_tables’
  6. Stop the instance of SQL Server, bring both SQL Server Agent and the SQL Server service online on Node1, fail the instance of SQL Server over to the other node, and fail the instance back to the original node. 

If the instance of SQL Server is a stand-alone instance, you can resolve the issue by stopping both SQL Server and the SQL Server Agent service, disabling the SQL Server Agent service, and then restarting just the SQL Server service. This lets the upgrade process complete in the database. After this process is complete, you can restart the SQL Server Agent service.

Reference –> http://support.microsoft.com/kb/2509302

note the 6th point : you may have to failover cluster few times .. if you upgrade does not work clean initially ..

Thanks for reading 🙂

GS

Categories: Cluster