Welcome, Guest
Username: Password: Remember me
Welcome to the ToolsJX forum!


TOPIC: Cannot get working with MS SQL Server Express 2005

Cannot get working with MS SQL Server Express 2005 4 years 1 week ago #731

  • rainman
  • rainman's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hi,

I read the other thread about this but I'm still confused. My MS SQL Server is on a Windows 2003 box and my Joomla/Table JX is on a Linux box. I receive an error that says "Unable to connect to the database:Could not connect to MSSQL server X.X.X.X,1433".

Where do I get ntwdblib.dll file and do I need to copy on Windows server or Linux server? The file that I saw seem to be for a Windows machine and the following info that was pointed out in the other discuss seems to be related to Windows.

http://si2.php.net/manual/en/mssql.requirements.php
www.helpspot.com/helpdesk/index.php?pg=kb.page&id=13

Please help.
The administrator has disabled public write access.

Re:Cannot get working with MS SQL Server Express 2005 4 years 1 week ago #732

  • viljem
  • viljem's Avatar
  • OFFLINE
  • Administrator
  • Posts: 178
  • Karma: 0
Hi,

maybe this step-by-step tutorial can help:
www.toolsjx.com/index.php?option=com_content&view=article&id=52

Best regards,
Viljem
The administrator has disabled public write access.

Re:Cannot get working with MS SQL Server Express 2005 4 years 1 week ago #735

  • rainman
  • rainman's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Okay thanks. MSSQL support is installed and active when I run phpinfo, but I still receive the following:

Unable to connect to the database:Could not connect to MSSQL server X.X.X.X,1433

It may be my SQL Server machine restricting access so I will also contact my hosting company, but any ideas on what else to try?

Thx
The administrator has disabled public write access.

Re:Cannot get working with MS SQL Server Express 2005 4 years 1 week ago #736

  • rainman
  • rainman's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hi,

I had my hosting company verify everything was set up properly on the SQL Server, but I am still unable to connect. Please advise.

Thx
The administrator has disabled public write access.

Re:Cannot get working with MS SQL Server Express 2005 4 years 1 week ago #737

  • rainman
  • rainman's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hi, I wasn't able to solve this but we decided to use MySQL instead.
Last Edit: 4 years 1 week ago by rainman.
The administrator has disabled public write access.

Re:Cannot get working with MS SQL Server Express 2005 4 years 1 week ago #739

  • dauidM
  • dauidM's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
In Database Host you need to set:
hostname:port
not like you set hostname, port.

Try this ;)
The administrator has disabled public write access.
Time to create page: 0.160 seconds