Sql-server – SQL Services are off but can access and query from other server on the same domain. Why?

sql serversql-server-2008-r2sql-server-2019ssms

Using configuration manager, I disabled the SQL Server Services for a SQL Server 2008 R2 instance. Yet, I can still connect to the instance from its replacement server, a SQL 2019 box, and query the data! Also, the jobs which I disabled are enabled and appear to have been running. Locally, I cannot connect. I'd like to understand why this is occurring.

Follow-up: There was an alias named after the old 2008 instance. When you connected using that alias on the new machine, it would connect you to the new sql instance. Hence the confusion.

Best Answer

There are two options:

a) The service isn't stopped.

b) You access some other SQL server instance from your 2019 machine.

It is literally impossible to access a SQL server which isn't running, so we can rule that out.

My guess is that you have a client alias on the 2019 machine with the name of the old 2008 machine (and possibly instance), which points back to the 2019 machine (and possibly instance). You find these in SQL Server Configuration Manager under "SQL Native Client xx Configuration". Make sure you check out both the 64 and 32 bit entries!