|
Posted by davidschultz45 on July 31, 2008, 6:01 pm
Please log in for more thread options
I am having the same problem on multiple machines as described in the first
post by Terrible Tom. I have tried setting the Port 1433 and checked the
permissions in the registry as suggested also, but neither had any effect on
sychronizing the offline database.
Any other suggestions would be much appreciated!
Thanks in advance!
David
"Marc" wrote:
> I had an issue getting backup database to sync and had to set a port 1433
> exception in the firewall to get it to work.
>
> Marc
>
>
> > Hi Terrible Tom,
> >
> > Did you ever find an answer to this problem. I have a site with the same
> > issue. Administrator connects to both the live and offline databases
> > fine.
> > I can alternate between the two and the POS runs fine.
> >
> > I get [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exists or
> > access denied.
> >
> > I'm using the standard 'sa' username and password.
> >
> > "Terrible Tom" wrote:
> >
> >> Both registers get the same error:
> >>
> >> ---------------
> >> Run-time error '-2147217900 (80040e14)':
> >>
> >> OLE DB provider "SQLNCLI" for linked server "(null)" returned message
> >> "Login
> >> timeout expired".
> >> ---------------
> >>
> >> I am able to successfully connect to the offline DB without issue from
> >> the
> >> Admin program. Obviously, both registers connect to my live DB without
> >> issue. What is going on?
> >>
> >> Thanks,
> >> Tom
> >> --
> >> Stop fishing for e-mail
>
>
>
|