Install on Small Business Server MSSQL Server
Keywords: SBS, Network Layer, Error 13059
Dear SBS owner (sucker).
I have had an awful time getting BDE links to work with SBS MSSQL
Server. I have succeeded finally. Here is:
The problem is they (MickeySoft) have disabled
the SQL Client install in SBS and they DID NOT TELL US ANYWHERE IN THE
DOCUMENTATION. You must get the client installed before SQL Links will
work.
The good news is that all the files you need are there on the server.
The
trick is knowing which ones to load where. I suggest you download the
trial SQL server, install a workstation client, and see what happened.
This changes all the registry entries so all the OLE stuff works. Also,
you get the books on line stuff with the trial. I don't know what will
happen in 120 days.
--- OR ----
Alternately, modify and use the following batch commands below where g:
is
your server: The registries won't be changed for OLE.
Make the local directory (in this case SQLClient\Binn) first.
Also, very extremely important: Set your path (remember paths) to
include
the new directory you are installing into. The network communications
then will be found by other drivers. Also there is a reg file, run
that
so it gets merged with the registry.
Reboot after installation. Run the windbver to set the client. I
suggest
using TCP/IP. Make sure your server is set for TCP/IP and not just
Named
Pipes Change it by running SETUP on the server and changing Network
connections. TCP/IP is the fastest connection.
This should work - verify with Database explorer - worked for me.
Best regards,
Jim Cubbage
----BATCH COMMANDS START -----
copy g:\mssql\binn\NTWDBLIB.DLL c:\sqlclient\binn
copy g:\mssql\binn\NTWDBLIB.DLL c:\windows\system
copy g:\mssql\binn\ADME.DLL c:\sqlclient\binn
copy g:\mssql\binn\BCP.EXE c:\sqlclient\binn
copy g:\mssql\binn\DAC.EXE c:\sqlclient\binn
copy g:\mssql\binn\DACDLL.DLL c:\sqlclient\binn
copy g:\mssql\binn\DBMSADSN.DLL c:\sqlclient\binn
copy g:\mssql\binn\DBMSDECN.DLL c:\sqlclient\binn
copy g:\mssql\binn\DBMSRPCN.DLL c:\sqlclient\binn
copy g:\mssql\binn\DBMSSOCN.DLL c:\sqlclient\binn
copy g:\mssql\binn\DBMSSPXN.DLL c:\sqlclient\binn
copy g:\mssql\binn\DBMSVINN.DLL c:\sqlclient\binn
copy g:\mssql\binn\DBNMPNTW.DLL c:\sqlclient\binn
copy g:\mssql\binn\DTCCM.DLL c:\sqlclient\binn
copy g:\mssql\binn\DTCTRACE.DLL c:\sqlclient\binn
copy g:\mssql\binn\DTCTRACE.EXE c:\sqlclient\binn
copy g:\mssql\binn\DTCUIC.DLL c:\sqlclient\binn
copy g:\mssql\binn\DTCUTIL.DLL c:\sqlclient\binn
copy g:\mssql\binn\ENUDTC.DLL c:\sqlclient\binn
copy g:\mssql\binn\filelist.txt c:\sqlclient\binn
copy g:\mssql\binn\HELP.HLP c:\sqlclient\binn
copy g:\mssql\binn\HELPSQL.HLP c:\sqlclient\binn
copy g:\mssql\binn\INFOVIEW.EXE c:\sqlclient\binn
copy g:\mssql\binn\ISQL.EXE c:\sqlclient\binn
copy g:\mssql\binn\ISQLW.EXE c:\sqlclient\binn
copy g:\mssql\binn\ISQLW.HLP c:\sqlclient\binn
copy g:\mssql\binn\MAKEPIPE.EXE c:\sqlclient\binn
copy g:\mssql\binn\MFC40.DLL c:\sqlclient\binn
copy g:\mssql\binn\MSDTC.REG c:\sqlclient\binn
copy g:\mssql\binn\MSDTCPRX.DLL c:\sqlclient\binn
copy g:\mssql\binn\MSVCRT20.DLL c:\sqlclient\binn
copy g:\mssql\binn\MSVCRT40.DLL c:\sqlclient\binn
copy g:\mssql\binn\NTWDBLIB.DLL c:\sqlclient\binn
copy g:\mssql\binn\READPIPE.EXE c:\sqlclient\binn
copy g:\mssql\binn\REGFONT.EXE c:\sqlclient\binn
copy g:\mssql\binn\REGSVR32.EXE c:\sqlclient\binn
copy g:\mssql\binn\SQEWEXEC.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQEWNT.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQEWOBJ.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQEWREPL.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQEWSTAT.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQEWSYS.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQEWTIPS.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQEWWIZ.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQLBOOKS.flt c:\sqlclient\binn
copy g:\mssql\binn\SQLBOOKS.hst c:\sqlclient\binn
copy g:\mssql\binn\SQLEW.EXE c:\sqlclient\binn
copy g:\mssql\binn\SQLEW.HLP c:\sqlclient\binn
copy g:\mssql\binn\SQLGUI32.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQLOLE.HLP c:\sqlclient\binn
copy g:\mssql\binn\SQLOLE65.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQLOLE65.TLB c:\sqlclient\binn
copy g:\mssql\binn\SQLQRY32.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQLSVC32.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQLTL32.DLL c:\sqlclient\binn
copy g:\mssql\binn\SQLTRACE.EXE c:\sqlclient\binn
copy g:\mssql\binn\SQLTRACE.HLP c:\sqlclient\binn
copy g:\mssql\binn\SQLTRACE.MAP c:\sqlclient\binn
copy g:\mssql\binn\SQSECMGR.EXE c:\sqlclient\binn
copy g:\mssql\binn\SQSECMGR.HLP c:\sqlclient\binn
copy g:\mssql\binn\STARCMON.DLL c:\sqlclient\binn
copy g:\mssql\binn\SVCSRVL.DLL c:\sqlclient\binn
copy g:\mssql\binn\WEBWIZ.EXE c:\sqlclient\binn
copy g:\mssql\binn\WINDBVER.EXE c:\sqlclient\binn
copy g:\mssql\binn\XOLEHLP.DLL c:\sqlclient\binn
copy g:\mssql\binn\XPSTAR.DLL c:\sqlclient\binn
