SQL Server 2012 Auditing
Posted on 2013-02-01
I am trying to see what is causing an application connection to switch databases once connected. The custom app I have is to write to any database that I type into it with the designated credentials. When I connect to the SQL Server instance, I have a db1 and a db1_dev. I want to write to the db1_dev when connecting with the app, and the app does successfully connect, but then it writes to table1. I tested the app by entering a database name that doesn't exist and then it doesn't connect....so that indicates to me that the app is initially passing in the database name value that I am giving it, however somewhere in SQLServer 2012, it is defaulting back to db1. What can be done to troubleshoot the SQL Server to see what is causing the issue?