If you create a new database and table, you're going to have to configure it with CRS in the AppAdmin pages. You'll have to have set up an ODBC connection for it to use, and define the user name and password for access.
once this is done, you can tackle your script. You have to have the DB Resource successfully able to poll for the database schema before it's going to work at all. once you can get this, you should then make sure your query will run on the test tab.
If it runs in enterprise manager, but not in CRS, you have a config problem. From what you're describing, you need to verify your setup and make sure you've gotten the prerequisite work done for this to work.
That's a really good question. The answer is that it depends on what you're doing.
If you have a high availability solution, then you've purchased a full blown SQL server install as part of the solution anyway. The danger in loading another database on the CRS server is that if you load down the server doing non CRS stuff, it may negatively impact server processing.
However, if it is a simple read or simple write (i.e. no complex SQL involved, and the tables are small and/or static), it shouldn't be a problem. But if you are dealing with large tables or tables that are going to grow continuously, I'd strongly suggest moving them to an external server.
Just remember that the CRS server's primary function is running your call center. As long as you aren't bogging down that functionality, you can do pretty much whatever you want. Cisco recommends that you not do this, but if you're storing things like open/close times or VIP pin numbers for the support desk, I've not had issues with it.
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...
If you have 2 ISR routers, one acting as Failover, do we need to have both the same number of SRST licenses on the 2 routers?
No. You will only need the SRST licenses on the primary router. Because this feature...