Hi.

I`m having problems connecting to my SQL desktop engine with ASP.NET and VB.NET. I can make the connection work fine within a windows application, but not through my web application. Any suggestions of what could be wrong?
Here is my connection string which was automatically generated by VS.NET:
data source=knut;initial catalog=felicitas;integrated security=SSPI;persist security info=False;workstation id=KNUT;packet size=409

Please help.

Regards,
Knut

Do you have the ASP.NET account added to your permissions list in the database? Whenever an ASP.NET application accesses your database, it connects with the <server name>\ASPNET account, when you log on with integrated security. To get around it, you can set up a SQL Server account, give that account the privileges a user would normally have, and add the User ID/password to the connection string.