SQL Server Performance Forum – Threads Archive
sql Server 2005 security problemhi, i’m tring to run a simple query on a data base that i created in sql server 2005, i’m running an asp script that simply select a record from the table, i should say that the same script run successfully with sql server 2000.
the error that i get is : Microsoft OLE DB Provider for SQL Server error ‘80040e09’
SELECT permission denied on object ‘_tblName’, database ‘dbName’, schema ‘dbo’. i guess it’s a permissions problem.
i checked all the permissions in the database, i created schemas and gave it the permission to select records, the same i did to the users and roles! but still getting the same error!
what do i miss??
Does the connect string used in the ASP script include login + password? Does it say to use integrated security (=Windows authentication)?
yes sure, it loggs in successfully!
i think that i don’t use windows auth. that why i need to insert the username and password! no ? ———————————————————————————
software and programming issues
Huh? You said it didn’t! Could you post the connection string? Replace the sensitive bits of information with some generic stuff. –edit to make you notice I replied before you edited your last post–
well, the authentication method (of the specific user) is SQL Server Authentication. <br />here is my connection string : <br />conn_str = "Provider=SQLOLEDB<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />assword=******<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ersist Security Info=True;User ID=UserID;Initial Catalog=dbName;Data Source=SRVNAMESQLEXPRESS;"<br /><br />remmember, i log in with asp script! <br />if i should change the authentication, so how i do it ??<br /><br />software and programming issues<br /<a target="_blank" href=http://www.byramix.com>http://www.byramix.com</a><br /<a target="_blank" href=http://byramix.blogspot.com>http://byramix.blogspot.com</a><br />
If you are using a local DSN then make sure the remote server is mentioned on that DSN. Alternatively, look at www.connectionstrings.com for alternative connection strings…. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.
i’m using the localhost as the sql server. isn’t it mentioned in the connection string as the "…Source=SRVNAMESQLEXPRESS;"?? software and programming issues
if i am not forgeting it would "Persist Security info = false" in connection string if using SQL Authentication Mode,referhttp://www.connectionstrings.com/ also. Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami