CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2001
    Posts
    33

    Promlem: Connect to remote SQL server

    I have a big problem about connecting to a remote SQL server.
    I have do all the settings in the "Client Network Utility". In which I provide the path of the SQL server and then go back to
    "Enterprise Manager" ---> "SQL Server Group" ---> Start "New SQL Server Registration" --->..... and finally I got the message:
    "Werg --SQL Server does not exist or access denied.

    I have tried many times, but it still got that message. I'm sure that the path of that server is correct.

    Do anyone get any idea what is wrong in my connecting to that server ?

    Please help me !!!!!


  2. #2
    Join Date
    Jul 2000
    Location
    Milano, Italy
    Posts
    7,726

    Re: Promlem: Connect to remote SQL server

    Do your client has permission on server? I mean, is it a registered user in sqlserver? Do you leave the default "Use winnt login" for remote connection?
    Hope this helped.

    Special thanks to Lothar "the Great" Haensler. Come back soon, you Guru.
    ...at present time, using mainly Net 4.0, Vs 2010



    Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
    all the other wonderful people who made and make Codeguru a great place.
    Come back soon, you Gurus.

  3. #3
    Join Date
    Jul 2000
    Location
    Milano, Italy
    Posts
    7,726

    Re: Promlem: Connect to remote SQL server

    I had to register my client logon as administrator's member...

    Special thanks to Lothar "the Great" Haensler. Come back soon, you Guru.
    ...at present time, using mainly Net 4.0, Vs 2010



    Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
    all the other wonderful people who made and make Codeguru a great place.
    Come back soon, you Gurus.

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured