c# - SQL Server Reporting Services LocalDB doesn't exist error -


i've been trying view deployed reports in ssrs using visual studio 2015 , sql server 2014, error message i've been receiving:

a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: sql network interfaces, error: 50 - local database runtime error occurred. specified localdb instance not exist. )

this connection string looks like:

data source=(localdb)\viraj-pc;initial catalog=adventureworks2012

i've done numerous things troubleshoot problem including editing firewall settings open ports 1433 , 1434 need accessed, made sure mssqlserver service running, configured local server allow incoming connections, have turned on tcp/ip , named pipes protocols through configuration manager, , have checked see if localdb instance running through sqllocaldb.exe in command line (it running).

if matters @ all, i'm using sql server management studio 2016. don't want have uninstall i've done 2 or 3 times because of previous errors , have gone through lot of configuration if there's way fix without having reinstall, appreciate it.


Comments