Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 8 / 9 / 2013 / 2014 / 2015 (Premium Edition) » Workstation SQL Server Connection Error
Post new topic  Reply to topic View previous topic :: View next topic 
Workstation SQL Server Connection Error
PostPosted: Mon Feb 13, 2017 9:08 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




Years ago, an old client had GMPE 2013.1.0.298 installed in SQL Server 2008 R2 on a Windows 7 Pro SP1, 64-bit then had his wife on a separate Windows 7 Pro workstation successfully access his GM across the Internet after I finally got the Windows Firewall under proper control.

He lost is original computer and got a new Windows 7 Pro SP1, 64-bit and I installed his same GMPE on his new computer.

When trying to connect his wife to his new computer, her workstation appears to be properly accessing the GMPE on the new computer but I keep getting the following error when trying to log into GM from her workstation:

[DBNETLIB] [ConnectionOpen (Connect0).]SQL Server does not exist or access is denied.
Native Code 17
Source Microsoft OLE DB Provider for SQL Server


I turned the Windows Firewall off on both computers and still got this error. I then turned them on and added Port 1433 and 1434 but still got the same error.

Could you possibly suggest another way to enable her connection?

Many Thanks,

Bob Gannett

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Tue Feb 14, 2017 8:50 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




across the internet or intranet? Is this a LAN or WAN situation? the former can be much more complicated to accomplish with port forwarding and whatnot.

If it's simply a LAN, you may have to enable/configure the TCP/IP and/or named pipes listeners on the SQL server. By default, SQL Express tends to only enable the shared memory protocol.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Tue Feb 21, 2017 7:23 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




I just want to thank you for your great response and very helpful information.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

Workstation SQL Server Connection Error
  ContactReview Forum Index » GoldMine 8 / 9 / 2013 / 2014 / 2015 (Premium Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin