2. ASPRunner.NET General questions
  3. [SOLVED]  Can't connect to SQL Server on localhost
This topic is locked
[SOLVED]

 Can't connect to SQL Server on localhost

 		3/5/2020 8:36:49 AM
ASPRunner.NET General questions
Pete K author

I have always developed my apps using a remote SQL Server instance. But I now need to work on my local machine. I installed SQL Server Developer Edition and was able to successfully connect in SQL Server Management Studio using localhost with integrated authentication. However, when I attempt to connect within ASPR.net, I get a database error. (See screenshot.)
Has anyone else encountered this? Ideas?
jadachDevClub member 3/5/2020

I use .\sqlexpress as server and it always work.
Pete K author 3/5/2020



I use .\sqlexpress as server and it always work.



Thanks for the suggestion, Jerry. Unfortunately, that didn't work either. It makes no sense to me that SSMS connects but not ASPR.
admin 3/5/2020

Try enabling SQL Server authentication, it might be easier to configure.
Pete K author 3/6/2020

Figured it out. Seems the TCP/IP protocol is disabled by default with the Developer Edition of SQL Server. I enabled it and it's working now.