Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

SQL connectivity??

  • 12-02-2008 12:13pm
    #1
    Kaldorn
    Closed Accounts Posts: 299 ✭✭


    I was wondering if you could help me..basically I am having an issue connecting to a sql server from an engine.
    I cannot telnet the ip over 1433 but I can ping it and it resolves fine.there doesn’t seem to be logging enabled on the engine so I cannot tell is its listening correctly.if I do a netstat -na it doesn’t have any reference to 1433 port listening so my question is how do I get the engine to listen on the particular port to test the connectivity between the database and the engine?

    You help would be appreciated.


Comments

  • #2
    Khannie
    Registered Users, Registered Users 2 Posts: 37,485 ✭✭✭✭Khannie


    which database are you using? on which platform?


  • #3
    seamus
    Registered Users, Registered Users 2 Posts: 68,317 ✭✭✭✭seamus


    If you're after installing SQL Server Express edition, it's configured by default to only listen on internal IP subnets (i.e. 127.0.0.0) and not on any others. It's a security thing.

    You can change this behaviour:

    http://support.microsoft.com/kb/914277


  • #4
    Ginger
    Registered Users, Registered Users 2 Posts: 2,931 ✭✭✭Ginger


    Also if its SQL Server 2000 on Windows 2003, update the engine to SP4 as listening port will not be active


  • #5
    Kaldorn
    Closed Accounts Posts: 299 ✭✭Kaldorn


    its on windows 2003 and its sql 2000 if that helps..it only stopped working when we updated the web portal which should have anything to do with sql communication


  • #6
    Kaldorn
    Closed Accounts Posts: 299 ✭✭Kaldorn


    Mssql


  • Advertisement
  • #7
    Ginger
    Registered Users, Registered Users 2 Posts: 2,931 ✭✭✭Ginger


    What service pack is installed for SQL Server 2000 and what version is it... Standard or Enterprise or is it MSDE


Advertisement