EXECUTE permission denied on object 'getUniqueCities', database 'd

[Guest]

I am using MS ASP.NET course matrial in Model 16.
I have the above problem.
I have setup user machin\ASPNET as Reeder and Writer for doctors database
More informatin are in following
System.Data.SqlClient.SqlException: EXECUTE permission denied on object
'getUniqueCities', database 'doctors', owner 'dbo'

Source Error:


Line 255: SqlConnection1.Open()
Line 256: Dim drCities As SqlDataReader
Line 257: drCities = cmdCities.ExecuteReader()
Line 258: lstCities.DataSource = drCities
Line 259: lstCities.DataTextField = "City"

 

[Jason Bentley]

David, your error is your answer. Whatever context the connection is
executing in does not have execution permission on getUniqueCities.
Give us some details about your SqlConnection object and your os, etc.

Jason Bentley
http://geekswithblogs.net/jbentley