title: connecting to Microsoft SQL Server using sqlalchemy '1.4.22', python 3.9
body: <p>I have an extremely simple setup. Microsoft SQL Server 64b (version 15), installed on Windows 10. TP Port on TCP/IP properties is blank (Don't understand why is it so tough to figure out what port is it running on).</p>
  <p>I am able to connect to my database using SQL Management Studio with:</p>
  <blockquote>
  <p>Server name: DEVSERVER\MSSQLDEV2019</p>
  </blockquote>
  <p>and both &quot;Windows Authentication&quot; as well as &quot;SQL Server Authentication&quot;.</p>
  <p>However, when I try using sqlalchemy or MySQLdb, I cant seem to connect, generally getting two types of error:</p>
  <pre><code>DATABASECONFIG = {
      'DEV': {
          'server': 'MSSQLDEV2019',
          'database': 'family',
          'username': 'famrwuser',
          'password': 'password'
      }
  }
  
  class SQLDBConnection(object):
  
      def __init__(self, configname):
          config = DATABASECONFIG[configname]
          self.server = config['server']
          self.database = config['database']
          self.username = config['username']
          self.password = config['password']
      def _connstring(self):
          connstring = 'mysql://%s:%s@%s/%s'%(
              self.username, self.password,  self.server, self.database)
          return connstring
      def engine(self):
          engine = create_engine(self._connstring(), echo=True)
          return engine
  
      def getrawresultset(self, sql):
          with self.engine().connect() as connection:
              results = connection.execute(sql)
          return results
  
  x = SQLDBConnection('DEV')
  x.engine()
  print(x.getrawresultset('select % from dbo.members'))
  </code></pre>
  <p>with 'server': 'DEVSERVER\MSSQLDEV2019' also, I get the error</p>
  <pre><code>&quot;Unknown MySQL server host 'MSSQLDEV2019'
  </code></pre>
  <p>I also tried 'server': 'localhost', I get the error</p>
  <pre><code>&quot;Can't connect to MySQL server on 'localhost'
  </code></pre>
  <p>I did try using MySQLdb, with all versions of host, without any success</p>
  <pre><code>import MySQLdb
  Con = MySQLdb.Connect(host=&quot;DEVSERVER\MSSQLDEV2019&quot;, user=&quot;famrwuser&quot;, passwd=&quot;password&quot;, db=&quot;family&quot;)
  Cursor = Con.cursor()
  sql = &quot;SELECT * FROM dbo.members&quot;
  Cursor.execute(sql)
  </code></pre>