Backup Fails when starting VSS

Try this one instead:  http://support.microsoft.com/kb/940349

Jeff
TechSoEasy

I tried that hot fix, but i get the same error. any other suggestions?? i also tried the 2 downloads previusly mentioned, but they are only applicable for SP1.

i juts noticed something else, the SBSMONITORING service is failing to start, i tried to start manually and it fails, i get the following error in event viewer:

SQLServerAgent could not be started (reason: Unable to connect to server 'NSSVR\SBSMONITORING'; SQLServerAgent cannot start).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

i am really new to SQL, so please understand if i am not following the correct troubleshooting steps, i try to login to SQL using the SQL server management studio express and i get this error (below), once again, i am not a SQL guru, but it seems like i am having a authentication problem, the only reason why i bring this up is because teh event viewer also has an entry for VSS that refers to a SQL error, please see the 2 errors:

***********************************************************************************************************************
SQL Server management studio error:

Cannot connect to NSSVR\SBSMONITORING.

===================================

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 1 - I/O Error detected in read/write operation) (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4&LinkId=20476

------------------------------
Server Name: NSSVR\SBSMONITORING
Error Number: 4
Severity: 20
State: 0


------------------------------
Program Location:

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

*****************************************************************************************************************************

VSS Event viewer entry:

Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 18
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.


For more information, see Help and Support Center at

One other thing that i forgot to mention was, that the administrator password was reset when i started to work on this project, i am not sure if this should cause an impact.

Thanks

You shouldn't manually mess with the SBSMonitoring SQL Database.  If it's not working right, just reinstall it through the SBS Integrated Setup.  http://support.microsoft.com/kb/555432

But I'm wondering if this server was properly upgraded to SP2.  Can you please post the results from running SYSTEMINFO at a command prompt?

Jeff
TechSoEasy

Host Name:                 NSSVR
OS Name:                   Microsoft(R) Windows(R) Server 2003 for Small Busines
s Server
OS Version:                5.2.3790 Service Pack 2 Build 3790
OS Manufacturer:           Microsoft Corporation
OS Configuration:          Primary Domain Controller
OS Build Type:             Multiprocessor Free
Registered Owner:          OWNER
Registered Organization:
Product ID:                74995-OEM-4213056-25821
Original Install Date:     10/5/2007, 8:40:45 PM
System Up Time:            1 Days, 5 Hours, 43 Minutes, 47 Seconds
System Manufacturer:       Gigabyte Technology Co., Ltd.
System Model:              965GM-S2
System Type:               X86-based PC
Processor(s):              2 Processor(s) Installed.
                           [01]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~
2010 Mhz
                           [02]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~
2010 Mhz
BIOS Version:              GBT    - 42302e31
Windows Directory:         C:\WINDOWS
System Directory:          C:\WINDOWS\system32
Boot Device:               \Device\HarddiskVolume1
System Locale:             en-us;English (United States)
Input Locale:              en-us;English (United States)
Time Zone:                 (GMT-05:00) Eastern Time (US & Canada)
Total Physical Memory:     4,087 MB
Available Physical Memory: 2,095 MB
Page File: Max Size:       8,007 MB
Page File: Available:      5,803 MB
Page File: In Use:         2,204 MB
Page File Location(s):     c:\pagefile.sys
Domain:                    NS.local
Logon Server:              \\NSSVR
Hotfix(s):                 72 Hotfix(s) Installed.
                           [01]: File 1
                           [02]: File 1
                           [03]: File 1
                           [04]: File 1
                           [05]: File 1
                           [06]: File 1
                           [07]: File 1
                           [08]: File 1
                           [09]: File 1
                           [10]: File 1
                           [11]: File 1
                           [12]: File 1
                           [13]: File 1
                           [14]: File 1
                           [15]: File 1
                           [16]: File 1
                           [17]: File 1
                           [18]: File 1
                           [19]: File 1
                           [20]: File 1
                           [21]: File 1
                           [22]: File 1
                           [23]: File 1
                           [24]: File 1
                           [25]: File 1
                           [26]: File 1
                           [27]: File 1
                           [28]: File 1
                           [29]: Q147222
                           [30]: KB933854 - QFE
                           [31]: SP1 - SP
                           [32]: KB911829 - Update
                           [33]: KB912442 - Update
                           [34]: KB916803 - Update
                           [35]: KB924334 - Update
                           [36]: KB926666 - Update
                           [37]: KB931832 - Update
                           [38]: KB928365 - Update
                           [39]: Q936181
                           [40]: IDNMitigationAPIs - Update
                           [41]: NLSDownlevelMapping - Update
                           [42]: KB925398_WMP64
                           [43]: KB938127-IE7 - Update
                           [44]: KB939653-IE7 - Update
                           [45]: KB914961 - Service Pack
                           [46]: KB926139
                           [47]: KB921503 - Update
                           [48]: KB924667-v2 - Update
                           [49]: KB925876 - Update
                           [50]: KB925902 - Update
                           [51]: KB926122 - Update
                           [52]: KB927891 - Update
                           [53]: KB929123 - Update
                           [54]: KB930178 - Update
                           [55]: KB931784 - Update
                           [56]: KB932168 - Update
                           [57]: KB933360 - Update
                           [58]: KB933729 - Update
                           [59]: KB933854 - Update
                           [60]: KB935839 - Update
                           [61]: KB935840 - Update
                           [62]: KB935966 - Update
                           [63]: KB936021 - Update
                           [64]: KB936357 - Update
                           [65]: KB936782 - Update
                           [66]: KB938127 - Update
                           [67]: KB939653 - Update
                           [68]: KB940349-v3 - Update
                           [69]: KB941202 - Update
                           [70]: KB941672 - Update
                           [71]: KB943460 - Update
                           [72]: XpsEPSC
Network Card(s):           3 NIC(s) Installed.
                           [01]: Marvell Yukon 88E8056 PCI-E Gigabit Ethernet Co
ntroller
                                 Connection Name: VPN
                                 DHCP Enabled:    No
                                 IP address(es)
                                 [01]: 10.30.5.6
                           [02]: Intel(R) PRO/1000 GT Desktop Adapter
                                 Connection Name: LAN
                                 DHCP Enabled:    No
                                 IP address(es)
                                 [01]: 10.30.5.2
                           [03]: 1394 Net Adapter
                                 Connection Name: 1394 Connection
                                 DHCP Enabled:    Yes
                                 DHCP Server:     N/A
                                 IP address(es)

OK, i will make those changes and will post an update, for right now, i will accept this as a solution, i seem to have more problems than just the VSS.

Thanks