Now I always use SQL server logons rather than Integrated Security so I don't have a database set-up that way that I can use as an example. However I seem to remember that when I did have it set up that way that I had to give ASPNET access to the database.
my memory is fizzy.
Can you set your SQL server to use "Mixed Mode" so you can use a connection like in my example?
adefwebserve...
Contributor
5912 Points
1207 Posts
MVP
Re: why is this so difficult?
Dec 29, 2005 04:03 PM|LINK
Now I always use SQL server logons rather than Integrated Security so I don't have a database set-up that way that I can use as an example. However I seem to remember that when I did have it set up that way that I had to give ASPNET access to the database. my memory is fizzy.
Can you set your SQL server to use "Mixed Mode" so you can use a connection like in my example?
Open Light Group
LightSwitchHelpWebsite.com | ADefWebserver.com