DK ACE V21 Testing Files

Quote:

Step 1: Clearing backup history Step 2: Dropping logins if exists Step 3: Deleting if databases if exists Step 4: Create [CHARACTER_01_DBF Step 5: Create [ACCOUNT_DBF Step 6: Create [RANKING_DBF] Step 7: Create [LOGGING_01_DBF] Step 8: Create logins Msg 15025, Level 16, State 1, Line 257 The server principal 'account' already exists. Msg 15025, Level 16, State 1, Line 261 The server principal 'eocrm' already exists. Msg 15025, Level 16, State 1, Line 265 The server principal 'log01' already exists. Msg 15025, Level 16, State 1, Line 269 The server principal 'character01' already exists. Step 9: Create users Step 10: Create connection servers Step 11: Configure [ACCOUNT_DBF] OLE DB provider "SQLNCLI11" for linked server "CHR01" returned message "Login timeout expired". OLE DB provider "SQLNCLI11" for linked server "CHR01" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". Msg 2, Level 16, State 1, Line 767 Named Pipes Provider: Could not open a connection to SQL Server [2]. Step 12: Configure [CHARACTER_01_DBF] (1 row(s) affected) (1 row(s) affected) OLE DB provider "SQLNCLI11" for linked server "RANKING" returned message "Login timeout expired". OLE DB provider "SQLNCLI11" for linked server "RANKING" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". Msg 2, Level 16, State 1, Line 7377 Named Pipes Provider: Could not open a connection to SQL Server [2]. Msg 208, Level 16, State 6, Procedure CHARACTER_STR, Line 9593 Invalid object name 'dbo.CHARACTER_STR'. Step 13: Configure [LOGGING_01_DBF] Step 14: Configure [RANKING_DBF] Msg 208, Level 16, State 1, Procedure view_last_3_month, Line 18756 Invalid object name 'LOGGING_01_DBF.dbo.VIEW_LOG_LOGIN_TBL'. Msg 208, Level 16, State 1, Procedure view_last_1_month, Line 18775 Invalid object name 'LOGGING_01_DBF.dbo.VIEW_LOG_LOGIN_TBL'. Step 15: Installation Systems Msg 154, Level 15, State 1, Procedure uspVendorNpcGet, Line 18955 a USE database statement is not allowed in a procedure, function or trigger. Msg 154, Level 15, State 1, Procedure uspVendorNpcUpdate, Line 19159 a USE database statement is not allowed in a procedure, function or trigger. Msg 154, Level 15, State 1, Procedure ConsignmentInsertItem, Line 19222 a USE database statement is not allowed in a procedure, function or trigger. Msg 5133, Level 16, State 1, Line 19296 Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\BACKEND_DBF.m df" failed with the operating system error 3(‏‏למערכת אין אפשרות לאתר את הנתיב שצוין.). Msg 1802, Level 16, State 1, Line 19296 CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Msg 5011, Level 14, State 5, Line 19310 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19310 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19313 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19313 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19316 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19316 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19319 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19319 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19322 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19322 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19325 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19325 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19328 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19328 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19331 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19331 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19334 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19334 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19337 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19337 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19340 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19340 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19343 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19343 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19346 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19346 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19349 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19349 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19352 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19352 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19355 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19355 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19358 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19358 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19361 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19361 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19364 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19364 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19367 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19367 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19370 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19370 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19373 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19373 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19376 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19376 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19379 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19379 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19382 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19382 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19385 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19385 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19388 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19388 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19391 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19391 ALTER DATABASE statement failed. Msg 5011, Level 14, State 5, Line 19394 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19394 ALTER DATABASE statement failed. Msg 102, Level 15, State 29, Line 19397 Incorrect syntax near 'QUERY_STORE'. Msg 5011, Level 14, State 5, Line 19400 User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks. Msg 5069, Level 16, State 1, Line 19400 ALTER DATABASE statement failed. Msg 1801, Level 16, State 3, Line 19472 Database 'WEBSITE_DBF' already exists. Choose a different database name. Msg 102, Level 15, State 29, Line 19573 Incorrect syntax near 'QUERY_STORE'. Msg 2714, Level 16, State 6, Line 19690 There is already an object named 'LOG_SENDITEM' in the database. Step 16: Installation AiO Database SQL 2017 complete ****************************************** * Thanks for using AiO Database SQL 2014 * * by Ace * ******************************************