SQL Server Performance Forum – Threads Archive

sql Server 2005 security problem

hi, 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
http://www.byramix.com
http://byramix.blogspot.com

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. here is my connection string : 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;" remmember, i log in with asp script! if i should change the authentication, so how i do it ?? software and programming issues http://www.byramix.com</a> http://byramix.blogspot.com</a>

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
http://www.SQL-Server-Performance.Com
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
http://www.byramix.com
http://byramix.blogspot.com

Hi,
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
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com

]]>