![ms sql server connection string localhost ms sql server connection string localhost](https://3.bp.blogspot.com/-vFVKVgVYIm8/V_Oprqr8LeI/AAAAAAAAB6c/zOQgqTk4qi4j7SxUeaaOI43JbTG5txIBwCLcB/s1600/Download%2BSQL-Server-2012-Management-Studio-Express-Screenshots.jpg)
If your WSUS was a 2.0 upgrade from MSDE, or a WSUS 3.0 install existed previously on the install provided database option, there are two available options to fix the issues - one for SQL Express users (the database provided with SCE) and one for full SQL server reporting services users. I don't understand why SCE reports looking for DB "SUSDB" - the name is similar to WSUS. On this computer I also have another instance of SQL(MSDE) called Windows Internal Database (MICROSOFT#SSEE)which is run from : c:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Binn\sqlservr.exe -sMICROSOFT#SSEE The SQL instance of SCE ( c:\Program Files\System Center Essentials 2007\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sSCE) does have databases: Operationsmanager, OperationsmanagerDW, ReportServer#SCE, ReportServer#SCETempDB. I didn't find database "SUSDB" in SQL 2005 instance of SCE. : Cannot open database "SUSDB" requested by the login.
![ms sql server connection string localhost ms sql server connection string localhost](https://www.dundas.com/support/images/dbi/docs/install/sql/ServerAuth_TurnOnSQLServerAuthenticationMode.png)
(rsErrorOpeningConnection) -> : Cannot open database "SUSDB" requested by the login. : Cannot create a connection to data source 'WSUSDatabase'. End of inner exception stack trace -Īt .GetExecutionInfo()Īt .GetParameters()Īt .UI.(ServerReport serverReport)Īt .UI.(Object sender, ConsoleJobEventArgs args) (rsProcessingAborted) -> : Cannot create a connection to data source 'WSUSDatabase'. : An error has occurred during report processing. The information may appear cryptic but provides context for the error. Note: The following information was gathered when the operation was attempted. When I try to receive some report the following error happend: After the instllation WSUS work fine, SCE can discover and monitor agents, but reportingįeatures didn't work. This computer has a WSUS 2.0 on it before , and as a result of installation WSUS was upgraded to version 3. I installed all System Center Essentials components on Hp DL140 - 3Gb Ram and 3.4Ghz Xeon processor.