Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2006
    Posts
    64

    MSSQL server 2000 connectivity

    I am facing difficulty to connect sql server with Client utilities. When I tried to create new sql server registration it don't connect it prompting me an error " Connectio0{} not found or sql server not found " Please advise

    Regards

  2. #2
    have you register the instance in the Client Network Utilities ?

  3. #3
    connect to MS SQL Enterprise Manager

    Open the SQL Server Client Network Utililty (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)
    Click on the "Alias" tab
    Click "Add" and enter the following information:
    Server Alias - Servername
    Network Library - TCP/IP
    Computer Name - x.x.x.x(serverIP)
    Port Number - by default 1433(check it)
    Click OK
    Click OK - This will close out the Client Network Utility
    Open Enterprise Manager. Right Click "Microsoft SQL Servers" and select "New SQL Server Registration" This will open a wizard. Click Next.
    Select "Servername" from the list of available servers and "Add" it. Click Next.
    Choose to connect using SQL Server Authentication
    Enter your assigned username and password. Keep on clicking next until the wizard is completed.

    :-)

  4. #4
    Join Date
    Apr 2006
    Posts
    64
    Quote Originally Posted by besty
    connect to MS SQL Enterprise Manager

    Open the SQL Server Client Network Utililty (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)
    Click on the "Alias" tab
    Click "Add" and enter the following information:
    Server Alias - Servername
    Network Library - TCP/IP
    Computer Name - x.x.x.x(serverIP)
    Port Number - by default 1433(check it)
    Click OK
    Click OK - This will close out the Client Network Utility
    Open Enterprise Manager. Right Click "Microsoft SQL Servers" and select "New SQL Server Registration" This will open a wizard. Click Next.
    Select "Servername" from the list of available servers and "Add" it. Click Next.
    Choose to connect using SQL Server Authentication
    Enter your assigned username and password. Keep on clicking next until the wizard is completed.

    :-)
    Thank you best! This solution worked for me

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •