Access Denied or Sql Server doesnt exist.
-
Hello there. I build a webservice which get the data from SQLSERVER 2000. When I retrive the data from Local system. it s workin but when I m trying to get data from remote server. it is nt workin and error occured like "Access denied or Sql Server doesnot exist". but when I used same connectionstring or code in windows application it s working for bhot local and remote server,but not workin in webservice when I try to connect a remote server. thanks
-
Hello there. I build a webservice which get the data from SQLSERVER 2000. When I retrive the data from Local system. it s workin but when I m trying to get data from remote server. it is nt workin and error occured like "Access denied or Sql Server doesnot exist". but when I used same connectionstring or code in windows application it s working for bhot local and remote server,but not workin in webservice when I try to connect a remote server. thanks
Hi myousuf, what are your connection string parameters. Are you using Integrated Security=SSPI; option. The account that the ASP.NET worker process runs under must have access to the database for integrated security to work unless impersonation is used in which case the impersonation account must have access to the database. Otherwise use SQL authentication by supplying a valid user name and password. Thanks and Regards SGS
-
Hello there. I build a webservice which get the data from SQLSERVER 2000. When I retrive the data from Local system. it s workin but when I m trying to get data from remote server. it is nt workin and error occured like "Access denied or Sql Server doesnot exist". but when I used same connectionstring or code in windows application it s working for bhot local and remote server,but not workin in webservice when I try to connect a remote server. thanks
This must be because security settings. Thats why you can access same system using Windows-based application but not from Web-based. There is vast difference between security settings, access permissions between these two sortof applications. So, first do check all security settings... like see how much permission do the account from which you are accessing the database have. I am sure this will resolve the issue.
-
Hi myousuf, what are your connection string parameters. Are you using Integrated Security=SSPI; option. The account that the ASP.NET worker process runs under must have access to the database for integrated security to work unless impersonation is used in which case the impersonation account must have access to the database. Otherwise use SQL authentication by supplying a valid user name and password. Thanks and Regards SGS
Thanks for ur reply. Dear sir. the connection string I m using for makin connection are below. Connection to Remote Server (Server Name=Umar): string strDSN= "Password=umar; Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=umar"; Connection String that I made by SERVER ExPLORER is (but it also nt working) string strDSN = "workstation id=YOUSUF;packet size=4096;user id=sa; Password=umar; data source=umar;persist security info=False;initial catalog=Northwind"; please remember all this connection string are working in all applications like C# windows application or C# WEb application but not in Web services, when I try to connect remote database. error occured "Access Denied or SQL Server doesnot exist." THanks
-
This must be because security settings. Thats why you can access same system using Windows-based application but not from Web-based. There is vast difference between security settings, access permissions between these two sortof applications. So, first do check all security settings... like see how much permission do the account from which you are accessing the database have. I am sure this will resolve the issue.