Hi all if anyone has any ideas can u please help,
I have been stuck on ths issue for over a week. Here goes I have created a website using ASP and SQLServer. Users are all able to execute STored procedures on the site but as soon as they try to execute SQL from a ASP page they get the following error:
HTTP 500.100 - Internal Server Error - ASP error
-----------------------------------------------
Microsoft OLE DB Provider for SQL Server (0x80040E09) SELECT permission denied on object 'tblPlatform', database 'Server_management', owner 'dbo'.
/serrver_management/searchKell.asp, line 571
I do not get this error, every other user does! ALthough I do not have a seperate SQLServer login I use the domain LSL-UK\Domain Users.)eg I am LSL-UK\SmithC, everyone else is LSL-UK\username
I have tried the following conn strings and get the same problem:
1)
strConnection = "Provider=sqloledb;User ID=sa;Password=dbo;"
strConnection = strConnection & "Initial Catalog=Server_management;Data Source=cpmspodb5w;trusted_Connection=yes;"
2)
strConnection = "Provider=SQLOLEDB;Integrated Security=SSPI;"
strConnection = strConnection & "Initial Catalog=Server_management;Data Source=cpmspodb5w;Connect Timeout=600"
I have a feeling it is something to do with IIS. Could it be because I am an IIS administrator and no one else is?
Any Help would be greatly appreciated.
Thanks
I have been stuck on ths issue for over a week. Here goes I have created a website using ASP and SQLServer. Users are all able to execute STored procedures on the site but as soon as they try to execute SQL from a ASP page they get the following error:
HTTP 500.100 - Internal Server Error - ASP error
-----------------------------------------------
Microsoft OLE DB Provider for SQL Server (0x80040E09) SELECT permission denied on object 'tblPlatform', database 'Server_management', owner 'dbo'.
/serrver_management/searchKell.asp, line 571
I do not get this error, every other user does! ALthough I do not have a seperate SQLServer login I use the domain LSL-UK\Domain Users.)eg I am LSL-UK\SmithC, everyone else is LSL-UK\username
I have tried the following conn strings and get the same problem:
1)
strConnection = "Provider=sqloledb;User ID=sa;Password=dbo;"
strConnection = strConnection & "Initial Catalog=Server_management;Data Source=cpmspodb5w;trusted_Connection=yes;"
2)
strConnection = "Provider=SQLOLEDB;Integrated Security=SSPI;"
strConnection = strConnection & "Initial Catalog=Server_management;Data Source=cpmspodb5w;Connect Timeout=600"
I have a feeling it is something to do with IIS. Could it be because I am an IIS administrator and no one else is?
Any Help would be greatly appreciated.
Thanks