Post reply

how to connect to SQL SEVER 2k running in win2k server machine

  • October 30, 2007 at 12:27 am

    #119149

    hello everybody

    i am pretty new to sql server and msde2000 our server has sql server 2k and the client system which i am working has msde2000 installed in it. its working fine when i am able to work with localhost sql server instance , but when i tried to connect with my server it returns "The specified service dosenot exists as an installed service" i also tried to connect it from osql using the following command

    osql -E -S \\server\MSSQLSERVER

    it returns sql server dosenot exists or access denied if i remove the "\\" it returns invalid connection. what should i do to connect with the server, any help will be greatly appriciated.:)

    Thanks and regards

    s.an

  • October 30, 2007 at 6:07 pm

    #746893

    You can connect as follows

    1.) osql -E -Sservername

    or

    2.) osql -E -Sservername,portnumber (eg. osql -E -Ssystem,1433)

    Where -E = windows authentication

    -S = Servername

    Regards..Vidhya Sagar
    SQL-Articles

  • October 31, 2007 at 8:05 am

    #747089

    If you have instance then you should execute the following command:

    osql -E -S server_name\instance_name

    Assuming your server name is SERVER01 and instance name is INSTANCE01, then you should execute:

    osql -E -S SERVER01\INSTANCE01

  • November 1, 2007 at 12:50 am

    #747323

    dear members

    osql -E -S \\server\MSSQLSERVER

    it returns sql server dosenot exists or access denied if i remove the "\\" i.e.osql -E -S server\MSSQLSERVER it returns invalid connection. what should i do to connect with the server, any help will be greatly appreciated

    my server name is server and the instance is MSSQLSERVER which is a default instance created while installing.

    Thanks in advance

    s.an

  • November 1, 2007 at 4:34 am

    #747371

    Through which authentication mode you are connecting to the server.

    If you are using windows authentication mode

    1.) osql -E -Sservername

    If you are using sql authentication mode

    2.) 1.) osql -Sservername -Uusername - Ppassword

    Regards..Vidhya Sagar
    SQL-Articles

  • November 2, 2007 at 12:45 am

    #747638

    hello mr.vidya sagar

    i am using sql authentication mode

    when i supplied user name and password it waits for certain minutes and a

    "Timeout Expired" appears

    any inputs

    best regards

    s.an

  • November 2, 2007 at 12:47 am

    #747639

    forget to add something

    i pinged my server and it returned properly and i am able to access the sharedfolders in my server from the client in which i am trying the osql.

    thanks and regards

    s.an

  • November 2, 2007 at 12:53 am

    #747643

    Are you using MSDE if so have you changed your authentication mode from windows to mixed in SQL Server. Because by default its windows in MSDE 2000. Also if tis has been done then you need to check the protocols nad the ports.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • November 5, 2007 at 6:27 am

    #748205

    Yes mr.sugesh i am using msde2000 and i also suspect it is a problem of protocol , if it so then how should i found and repair it request your expert advice ,

    Thanks and regards

    S.An

    p.s. i like the quote in the bottom.:cool:

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply