question

DFlatProgrammer-8376 avatar image
0 Votes"
DFlatProgrammer-8376 asked ·

UWP App deploys correctly from Remote Tools but fails when sideloaded

This app connects to a local SQLExpress Database. When deployed using remote tools it runs flawlessly but I am unable to get it to work when sideloaded. I think that a description of how the two install processes differ will point me towards a solution. I have tried creating a loopback exception but the app continues to fail at the first attempt to reach SQLEXPRESS.

windows-uwpwindows-uwp-runtime
· 10
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@DFlatProgrammer-8376 I have to say that it is difficult to deal with this issue based on the above information. I suggest you could use try..catch{} statement to get more exception messages, then you could provide these to us.

0 Votes 0 ·

Thanks for the response (and the sensible starting point) - The error message is "A network related or instance specific error occurred while establishing a connection to to SQL Server." Since the connection works with a deployment via Remote Debugger I'm puzzled at why it doesn't work when Sideloaded. This is a LOB app and I'm trying to establish whether I can fix the problem with Sideloading or whether there is a different deployment type that is closer to the Remote Debugger deployment.

0 Votes 0 ·
AryaDing-MSFT avatar image AryaDing-MSFT DFlatProgrammer-8376 ·

@DFlatProgrammer-8376 For connecting your database, the common reason is that the user doesn’t enable TCP/IP and SQL Server Browser service for SQL server. You could read the document about Trouble connecting to your database to check your configuration.


0 Votes 0 ·

Yes - I have the steps in Computer Management (configuring TCP-IP and enabling Browser) as part of my set up process - I'm checking your link to see if there is anything else in you rink that could be relevant - Again, I'm puzzled that the IDE Deployed version works, yet the Sideloaded does not..

0 Votes 0 ·
Show more comments

Thanks for the response (and the sensible starting point) - The error message is "A network related or instance specific error occurred while establishing a connection to to SQL Server." Since the connection works with a deployment via Remote Debugger I'm puzzled at why it doesn't work when Sideloaded. This is a LOB app and I'm trying to establish whether I can fix the problem with Sideloading or whether there is a different deployment type that is closer to the Remote Debugger deployment.

0 Votes 0 ·

@DFlatProgrammer-8376

We need a little more information here, so please check the following questions.

For remote deployment via debugger, is this from Visual Studio? Does this mean you are deploying to a separate device? For instance a Tablet or another machine? For sideloading, again, different machine then the deployment machine?

What is the URL you are tring to connect to? Are you using a LocalHost? If you are deploying to a remote machine, such as a Tablet, are you still trying to use LocalHost? If you are, is the SQL database on that service?

If possible, you could provide a sample, which will help a lot as well.

0 Votes 0 ·

0 Answers