I have a stored procedure on a SQLServer 2008. I want to run this procedure from a web page. When i try to run the stored procedure i get this error
but if i run the SQL query straight from the web page it works. I am currently using asp, but the code will be converted to JSP when i am done.
The stored procedure works fine on the SQL Server.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not connect to server 'HPFDATA' because 'bay_portal' is not defined as a remote login at the server.