I have Sql Server 2005 Standard Edition installed on a little development server on my small network. I develop ASP.NET applications on my workstation and want to try out the new data caching features available with SQL Server 2K5 Broker Service and ASP.NET 2.0.
I have created a database on the server with ENABLE_BROKER set. I have granted the permissions to the user as specified here (although I have only created one user for both the subscriber at starter):
For some reason I still cannot my application to work - my application throws the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
It points to the following line in my application:
Now before you tell me to enable remote connections in SQL Server Management Studio, I have already done so. In fact I can happily read data from the database with the same login if I do not use data caching (SQLDependency).
The funny thing is that there is absolutely no traffic between my workstation and the database (at least not in sql query analyzer) when I try to use SQLDependency (Data caching). Is there anything else that I need to do?
I've also created an endpoint for servicebroker using windows authentication.
I'm really out of my depth here. I'm a part-time asp.net developer and work with SQL Server 2K and 2K5 from a development perspective. I have no DBA experience.
500 points for a working solution!