I've spent a couple of days on this now and have tried everything I can find on the web to fix this issue. I can add Access data sources to VS 2010 Express, but can't find how to add SQL Server 2008 Express data sources. I keep getting the "40" and "26"
I am running both VS2010 and SQLServer on a local machine, no network connection involved. I have granted corrected permissions in SQLServer.
I have opened the correct ports, set the correct protocols, ensured my SQLServer is open for remote connections and changed my windows firewall settings.
My question relates to the "Advanced" window in the data source wizard - it refers to .\SQLEXPRESS. I have noticed that this service is not running in my SQL Server Configuration manager and cannot even be started. I also do not have an Express SQL
Server Browser at all! (I had one yesterday before I reinstalled SQL Server for the 3rd time!).
Could this be the source of the problem? (the .\SQLEXPRESS) ?
Thanks in advance for any help,
View Complete Post