Database Connection Problem

[fred]

Hi,

I im trying to install an intranet onto a new build server and while it
works fine in the development environment i get this error on the new
test server:

DBI connect('Driver={SQL
Server};Server=172.16.99.1;Database=ffcommon;','sa',...) failed:
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
(SQL-08001)
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(CreateFile()). (SQL-01000)(DBD: db_login/SQLConnect err=-1) at
FF_Config.pm line 112


I dont want to use named pipes but cannot see where to change it. In
development it uses TCP IP so why on the new sever would it be trying
to use named pipes?

(I am a complete novice when it comes to perl!)

Thanks for any help

Fred

 

[fred]

Hi,

I im trying to install an intranet onto a new build server and while it
works fine in the development environment i get this error on the new
test server:

DBI connect('Driver={SQL
Server};Server=172.16.99.1;Database=ffcommon;','sa',...) failed:
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
(SQL-08001)
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(CreateFile()). (SQL-01000)(DBD: db_login/SQLConnect err=-1) at
FF_Config.pm line 112


I dont want to use named pipes but cannot see where to change it. In
development it uses TCP IP so why on the new sever would it be trying
to use named pipes?

(I am a complete novice when it comes to perl!)

Thanks for any help

Fred

No worries all sorted. Turns out it was just a corrupt install of the
DBD-ODBC package.