ok braintrust, I am at my wit's end. I am trying to connect to my locally running MS SQL server database. Integrated security is on, database is running, ports have been greenlit in the firewall, but I keep getting the error messages as posted below. I have scoured half the internet in the meantime, no other related forum posts helped me fix this problem, and I can't get it to work. Anyone any idea?
asked
Femke Hoogstad
1 answers
3
I ended up fixing it myself. Adding this answer for documentation purposes. Turns out there is a separate SQL studio Manager Configurator (automatically installed with SQL server, but not easy to find: C://Windows/SysWOW64/SQLServerManagerXX.msc), in which you can check the TCP/IP protocols and the ports for your SQL server. Apparently, not only was my TCP/IP disabled, there was also no port set. Having fixed that, the database ran just fine!