Re: data access strategy

Thanks Ekrem,

Correct, there is a domain which is why my app was originally setup to use windows authentication. I have now change the sql instance to use mixed mode and tested the login credentials locally. All works OK.

I am using a named instance (.\sqlexpress) and I have set that instance to listen on 8082. testing locally using
Data Source=192.168.1.1,8082

instead of the usual
Data Source=192.168.1.1\sqlexpress

Suggests to me that it's working.

I have asked the guys managing my firewall to open 8082 and forward it to my server but I can't make a connection to the database.

I've just discovered that the connection works via VPN when using 192.168.1.1\sqlexpress instead of servername\sqlexpress which is how I previously had it setup.

So temporary way is to use the VPN but I'd like to build a module of my app to run on a windows mobile device so I'll keep trying to get remote DB access working......unless this is a really bad idea.

Russ

.

Relevant Pages

  • Re: Building customized Setup.dll for installations
    ... In the C++ code of your setup DLL write some code that for example sends ... that is also registered by your app when it starts. ... I created a Visual C++ MFC DLL project to design the custom Setup.dll. ... >>> Everything works fine except on uninstall. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Easiest E-Mail server to setup and use?
    ... >>> windows then how hard could it be to setup a nice GUI to control the ... >>> be too hard from a GUI program surely? ... fetchmail to get the mail from the ... > wee GUI app that uses fetchmail to get the mail, ...
    (alt.os.linux.suse)
  • Re: Login failed for user sa. C#, SqlServer 2000
    ... > If you get the same problem then SQL Server isn't setup for SqlServer ... it's only setup for Windows authentication. ... >> to connect to a database on another computer. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Login failed for user sa. C#, SqlServer 2000
    ... If you're currently setup for SqlServer and Windows authentication then use ... Query Analyzer to login using sa and your password for sa. ... If you get the same problem then SQL Server isn't setup for SqlServer ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Check if a DLL exists...
    ... it was impressed upon me that any VBX files and DLL I ... used must be included in my setup because it could ... Would you really package a setup program with your EXE and not include ... checking for the existance of that file from within your app is ...
    (microsoft.public.vb.general.discussion)