system DSN connection

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kaib
    New Member
    • Nov 2006
    • 23

    system DSN connection

    i've installed SQL Express 2005 in windows 2003 server; purpose was to store the email accounts for the mail server running on this; i want to connect from another windows 2003 server while creating system DSN on the machine; but sql doesn't allow me to connect.

    both machines are workgroup machines; i've installed sql with NT authentication and enabled thru surface area management remote connection (TCP) ; what could be the reason not allowing me to connect
    help appreciated
  • jagged
    New Member
    • Feb 2008
    • 23

    #2
    Originally posted by kaib
    i've installed SQL Express 2005 in windows 2003 server; purpose was to store the email accounts for the mail server running on this; i want to connect from another windows 2003 server while creating system DSN on the machine; but sql doesn't allow me to connect.

    both machines are workgroup machines; i've installed sql with NT authentication and enabled thru surface area management remote connection (TCP) ; what could be the reason not allowing me to connect
    help appreciated

    Whats the connection string?
    Do you have a firewall?

    From the other Windows 2003 server, can you telnet to port 1433 of the SQL Express server?

    Comment

    • kaib
      New Member
      • Nov 2006
      • 23

      #3
      Originally posted by jagged
      Whats the connection string?
      Do you have a firewall?

      From the other Windows 2003 server, can you telnet to port 1433 of the SQL Express server?
      no firewall; i'ven't tried telnet to i'll;

      Comment

      • kaib
        New Member
        • Nov 2006
        • 23

        #4
        i tried to telnet on to 1433 but fails; when i connect from other machine i get an error which says like NT-AUTHORITY ANONYMOUS USER LOGIN and fails; can SQL express be used to connect to other machine; help

        Comment

        Working...