Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Access Denied or Sql Server doesnt exist.

Access Denied or Sql Server doesnt exist.

Scheduled Pinned Locked Moved ASP.NET
databasesql-serversysadminhelp
5 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    myousufq
    wrote on last edited by
    #1

    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

    K A 2 Replies Last reply
    0
    • M myousufq

      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

      K Offline
      K Offline
      Kodanda Pani
      wrote on last edited by
      #2

      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

      M 1 Reply Last reply
      0
      • M myousufq

        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

        A Offline
        A Offline
        Ali Iqbal Khan
        wrote on last edited by
        #3

        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.

        M 1 Reply Last reply
        0
        • K Kodanda Pani

          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

          M Offline
          M Offline
          myousufq
          wrote on last edited by
          #4

          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

          1 Reply Last reply
          0
          • A Ali Iqbal Khan

            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.

            M Offline
            M Offline
            myousufq
            wrote on last edited by
            #5

            Thanks for ur reply. connection string are workin fine with both windows application and web application, but dont know wats wrong with webservices. Error is occured with web service. thanks

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups