SQL Server 2000 Connectivity

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • raaman rai
    New Member
    • Oct 2007
    • 114
    #1

    SQL Server 2000 Connectivity

    guys, i have recently created a server for my office wid windows server 2003. I installed sql server 2000 in the server n now i want to connect to sql server from the network clients. i tried to create the dsn for that but encountered the following problem :
    [HTML]connection failed:
    SQLState:'01000 '
    SQL Server error:265
    [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen( SECDoClientHand shake()),
    Connection failed:
    SQL State:'08001'
    SQL Server Error:18
    [Microsoft][ODBC SQL Server Driver][Named Pipes]SSL Security error[/HTML]

    Pls can s'body give me the detailed procedure as to how to go about? I have used Windows Authentication for the SQL Server.
    Tags: None
    • OuTCasT
      Contributor
      • Jan 2008
      • 374
      #2
      Originally posted by raaman rai
      guys, i have recently created a server for my office wid windows server 2003. I installed sql server 2000 in the server n now i want to connect to sql server from the network clients. i tried to create the dsn for that but encountered the following problem :
      [HTML]connection failed:
      SQLState:'01000 '
      SQL Server error:265
      [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen( SECDoClientHand shake()),
      Connection failed:
      SQL State:'08001'
      SQL Server Error:18
      [Microsoft][ODBC SQL Server Driver][Named Pipes]SSL Security error[/HTML]

      Pls can s'body give me the detailed procedure as to how to go about? I have used Windows Authentication for the SQL Server.
      How are u trying to connect, in your code or in SQL Manager

        Comment

        • raaman rai
          New Member
          • Oct 2007
          • 114
          #3
          Originally posted by OuTCasT
          How are u trying to connect, in your code or in SQL Manager
          I have tried creating a ODBC connection (dsn) to the sql server which i will use it in my code later on. If you have any idea pls help me. It wud b gr8 if u could also give me an idea on how to create user groups/users in win server 2003. I wanna use this account to access the sql server.

            Comment

            • amitpatel66
              Recognized Expert Top Contributor
              • Mar 2007
              • 2358
              #4
              Originally posted by raaman rai
              guys, i have recently created a server for my office wid windows server 2003. I installed sql server 2000 in the server n now i want to connect to sql server from the network clients. i tried to create the dsn for that but encountered the following problem :
              [HTML]connection failed:
              SQLState:'01000 '
              SQL Server error:265
              [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen( SECDoClientHand shake()),
              Connection failed:
              SQL State:'08001'
              SQL Server Error:18
              [Microsoft][ODBC SQL Server Driver][Named Pipes]SSL Security error[/HTML]

              Pls can s'body give me the detailed procedure as to how to go about? I have used Windows Authentication for the SQL Server.
              Since it says SSL Security error, is it because of any firewall setup that is blocking the connection?

                Comment

                • raaman rai
                  New Member
                  • Oct 2007
                  • 114
                  #5
                  Originally posted by amitpatel66
                  Since it says SSL Security error, is it because of any firewall setup that is blocking the connection?
                  Yes that cud b a reason but how sud i access the firewall.I couldnt find anything like a firewall thing in windows server 2003 like in XP. Infact the option to check the checkbox "Protect my computer and network by limiting....." is disabled for the Network Adapter of my server machine. Wat sud i do then?

                    Comment

                    Previous template Next
                    Working...