about autherization
-
hi all, I am using following autherization in the web config file using following tags this works fine. But due to this , i am facing following problem... when i try to connect to a remote SQL server, where login id and pwd of user is given in the connection string , then i am not allow to connect to the SQL server, with exception "either sql server doesn't exist or access is denied". But when i remove the deny tag from above tags then the authentication works fine. Can some body tell me what's the problem there and how can i overcome this problem. The connection string i am using is following server=myserver;uid=testuser;pwd=12345;database=mytestdatabase;Integrated security=false it is to mention that, this user "testuser" has administrators rights on the sql server .