Checking the Database Specifics - unsure if using main DB

Here’s my current situation, I have multiple servers with Ignition on it, a production server, a development server, and a testing server. On each server they have a connection to a database called Tab, which is the main database our production server uses. I want to be able to dive deeper and look at my dev/test server database connections to this ‘Tab’ database. and make sure that it is NOT the same as the actual live database we have customer files in. How can I view the specifics to make sure that is the case?

If you have the proper rights to the server you can query against it for the IP Address

SELECT CONNECTIONPROPERTY(‘local_net_address’) AS local_net_address

This is MS SQL.

1 Like