appmlcase from w3school, connection to sql server

[ipez]

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

[bruce]

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 (http://www.DiscountASP.NET)