Login failed for User sa in Remoting.net and RMI
Posted on 2005-04-13
i have strange problem
1:i have been working on remoting project with sql server database on different server
authentication works well. now i have changed the server and export database to my local server.
i check the connection in a simple c# window project and it work fine retriving data.
but when i try the same connection in Remoting project it give me eexception "Login failed for user sa"
no sa problem and password problem koz it is working in simple window project.
same problem occurs in Java RMI
and same error generates
i use ODBC in RMI and ODBC works fine and tested successfully.
for RMI i uses the same database and tables.
it was also working fine it was on differnt server.
if it is sa or password problem or ip problem then why it is working fine in other Projects.
kindly guide me.