yaniv Posted December 28, 2003 Posted December 28, 2003 my asp.net work great on my developing machine, but when i moved it to a check computer (my notebook), i allways get an error masseges "select statment deniyed for object..." i tryed to change permissions on the sql manager, but could make it work. do you have idea? Quote
Administrators PlausiblyDamp Posted December 28, 2003 Administrators Posted December 28, 2003 What type of database are you connecting to and what connection string are you using to connect to it? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
yaniv Posted December 28, 2003 Author Posted December 28, 2003 i connect to sql server. connection string: "Server=localhost;DataBase=cartisiyot;Integrated Security=SSPI" Quote
Administrators PlausiblyDamp Posted December 28, 2003 Administrators Posted December 28, 2003 Does the user you are logging on the local machine as have permissions to the database or if this is an ASP.NET application have you given permissions to the ASPNET account? What is the code for the select statement and it is a view or a table? Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
yaniv Posted December 29, 2003 Author Posted December 29, 2003 i use the ASPNET account. as much as i understand i did gave permissions. the select is very simple: "SELECT * from subject". subject is a table. Quote
iebidan Posted December 31, 2003 Posted December 31, 2003 Try changing the Server=localhost for Server=SERVERNAME where the SQL Server is located Quote Fat kids are harder to kidnap
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.