Yet another SQL Express setting to note…

    On some configurations, you will need to reach another Server for offload of Automated Processers requiring  SQL Express. Sometimes in trying to connect to the remote server, you may get a “SQL server does not exist or access denied” message.

     A fix for this may be to … Go to SQL Configuration Manager via  All Programs >Microsoft SQL Server 2008 > Configuration Tools > SQL Configuration Manager > Highlight SQL Server Services in left pane > In right pane, right click on SQL Server Properties > Properties on SQL Server Browser > On log in Account tab, Select Built in Local Services radial button or "This Account" and populate > On Advance tab > Select the Active field and drop down menu > Choose Yes for value > Restart the service from the prompt  This enables "Browsing" for SQL Express

Anonymous