We have sucessfully used cassini (CassiniDev4-console.exe) from both Windows XP and Windows 2003 to test/develop aspx pages.
Setup as follow:
We test/develop on a local PC within our local domain (localDoamin)
In web.config we point out our customers MS SQL as follows
<add name="CustDB" connectionString="data source=test01.customerDomain.com;Network Library=DBMSSOCN;Initial Catalog=lis;Trusted_Connection=yes;"/>
In "stored usernames and passwords" we set up the login (customerDomain\user & pwd) for test01.customerDomain.com
We need to use integrated login since the security in the system is built on that the procedures check who you are with sqlfunction suser_sname()
From Windows 2003 & XP this works like a charm, when connecting to MS SQL our local uid/pwd is replaced with customerDomain\user & pwd and we get into the database.
I can see that in the evenlogs on our Customers Server,
BUT doing exactly the same on Windows 7 doesn't work..... Cassini is sending local username and password NOT using that we entered in "stored usernames and passwords)
If we test for ex. dir \\customerServer\c$ it works both on windows 2003 and windows 7 without asking for username
Any help is appreciated