index > ClickOnce and Setup & Deployment Projects > Deploying with SQL back end.

Deploying with SQL back end.

I'm working on a VB.NET shareware program so naturally I will have no knowledge of local users or credentials. It uses SQL Server for data storage. In development, SQL Server 2005. I publish it with clickonce, including SQL Express as a prerequiste, which installs ok on the client machine. My problem is, after the install, I get the error: The failed. Login failed for user 'Mycomputer\testuser'.

How do I get around this?

Thank you!

pmkdatabase Saturday, August 29, 2009 8:23 AM

You are probably using a connection string with integrated security. You need to add an account to the database for your application to use, and specify that username and password in the connection string instead.

RobinDotNet

Click here to visit my ClickOnce blog!