appmlcase from w3school, connection to sql server

Discussion in 'ASP.NET WebServices' started by ipez, Aug 2, 2007.

  1. I downloaded appmlcase from
    http://www.w3schools.com/appml/case_download.asp

    it's a XML language for describing Internet applications, using the Internet standards HTML, CSS, and XML.
    Youcan create Internet applications without programming.
    I copied the files to my pc and the examples with northwinddatabase (access)work just fine.
    Now I am trying to connect to a sql server database on the intranet, using windows integrated connection.
    I configured the file local.config as suggested:
    <database name="PUBS"">
    <provider>SQLOLEDB</provider>
    <database>PUBS</database>
    <datasource>SQLSERVER</datasource>
    <userid>USER</userid>
    <password>PASSWORD</password>
    </database>
    the fact is that it's set for an access through username and password, while I have to use windows integrated authentication, passing
    <datasource>Data source=servername ;initial catalog=databasename;Integrated Security=SSPI</datasource>
    replacing this line in the local.config I get the error: Server SQLdoes not existor access denied
    any ideas?
    Thanks,
    Ipez
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    You cannot use integrated security. You need to change the connection to use SQL authentication.

    You should be able to find the connection string in the SQL manager in the control panel.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     

Share This Page