Does Anyone Have A Solution/Help/Info?

~~[Owner]Mr.Kester~~ · 12/20/2011, 05:53

For My Problem Here Below?
2011-12-20 01:21:00 PS_DBAGENT__system log start (DBAgent01)
2011-12-20 01:21:06 connect game, Name=
2011-12-20 01:21:06 connect game, Name=
2011-12-20 01:42:17 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:42:17 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:42:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:42:52 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:43:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:43:18 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:44:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:44:38 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:48:10 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:48:10 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:48:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:48:30 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:48:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:48:54 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:49:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:49:30 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:52:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:52:08 ::LoadBillingItem 17 qerr=-1, EXEC usp_Read_Char_Product_Item_E 17
2011-12-20 01:52:09 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:52:09 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:52:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:52:54 ::LoadBillingItem 13 qerr=-1, EXEC usp_Read_Char_Product_Item_E 13
2011-12-20 01:53:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:53:02 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 01:53:34 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:53:34 ::LoadBillingItem 17 qerr=-1, EXEC usp_Read_Char_Product_Item_E 17
2011-12-20 01:56:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 01:56:44 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 02:00:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:00:24 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 02:01:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:01:31 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 02:01:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:01:38 ::LoadBillingItem 17 qerr=-1, EXEC usp_Read_Char_Product_Item_E 17
2011-12-20 02:01:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:01:50 ::LoadBillingItem 14 qerr=-1, EXEC usp_Read_Char_Product_Item_E 14
2011-12-20 02:01:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:01:54 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 02:02:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:02:18 ::LoadBillingItem 14 qerr=-1, EXEC usp_Read_Char_Product_Item_E 14
2011-12-20 02:04:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:04:43 ::LoadBillingItem 14 qerr=-1, EXEC usp_Read_Char_Product_Item_E 14
2011-12-20 02:08:22 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:08:22 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 02:13:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:13:24 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 02:36:59 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 02:36:59 ::LoadBillingItem 16 qerr=-1, EXEC usp_Read_Char_Product_Item_E 16
2011-12-20 03:05:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-20 03:05:07 ::LoadBillingItem 17 qerr=-1, EXEC usp_Read_Char_Product_Item_E 17
2011-12-19 06:35:47 PS_DBAGENT__system log start (DBAgent01)
2011-12-19 06:35:52 connect game, Name=
2011-12-19 06:35:52 connect game, Name=
2011-12-19 06:41:23 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)
2011-12-19 06:41:23 ::LoadBillingItem 13 qerr=-1, EXEC usp_Read_Char_Product_Item_E 13

JohnHeatz · 12/20/2011, 05:59

As you can read on every single log you are missing PS_USERDB01; also, remember what is needed to do with the Linked Servers

#Moved to the right section

ShaiyaOmega · 12/20/2011, 06:03

That means your linked servers are not installed correctly.
Look

for the solution. easiest way is to re run the EP4_SQL_config.sql file again to add the linked servers.