Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Server stopped after changing startup parameters for mirroring. Expand / Collapse
Author
Message
Posted Tuesday, May 26, 2009 3:27 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:27 AM
Points: 4,432, Visits: 4,155
RTM is the first version which gets released without any patches. Could you post the results from this, just to be sure that SP2 is installed correctly:
SELECT @@VERSION


Markus Bohse
Post #723117
Posted Tuesday, May 26, 2009 3:44 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 9:50 AM
Points: 1,458, Visits: 2,435
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.1
(Build 2600: Service Pack 2)
Post #723125
Posted Tuesday, May 26, 2009 3:50 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:27 AM
Points: 4,432, Visits: 4,155
San (5/26/2009)
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.1
(Build 2600: Service Pack 2)

That's just what I thought.
Your SQL Server version is RTM (no Service Pack). You can recognize it from the build version 9.00.1399.
The Service Pack information you see is for the Windows operating system. So install the SQL Server Service Pack and your problem should be solved.


Markus Bohse
Post #723127
Posted Tuesday, May 26, 2009 4:33 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 9:50 AM
Points: 1,458, Visits: 2,435
I ran SP2 and am geting the version as below

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

wel, I had removed ";-T1400" from startup params (before running SP2) and I could confgiure sucessfully as well.Now the problem is while clicking on "Start Mirroring button." Kindly see the thread below.


http://www.sqlservercentral.com/Forums/Topic723067-360-1.aspx


Thanks.




Post #723156
Posted Tuesday, May 26, 2009 4:54 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:27 AM
Points: 4,432, Visits: 4,155
Since you started that second thread already two hours before installing SP2, it's probably a good idea to start the whole process from scratch again.

Markus Bohse
Post #723163
Posted Tuesday, June 02, 2009 1:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 12, 2009 2:31 AM
Points: 2, Visits: 2
add the startup params and try to stop the service and start again ,now check it works
Post #727192
Posted Tuesday, June 02, 2009 1:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 12, 2009 2:31 AM
Points: 2, Visits: 2
add the startup params and try to stop the service and start again ,now check it works
Post #727194
Posted Thursday, January 03, 2013 1:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 11, 2014 4:10 AM
Points: 102, Visits: 406
Remove 1400 from startup parameters.Check the mirror endpoint port number is opened.provide the error what u r getting

Post #1402227
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse