CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. March 31st, 2009, 08:25 AM #16
    savesheep
    savesheep is offline Junior Member
    Join Date
    Mar 2009
    Posts
    9

    Re: i have NO IDEA what i'm doing

    Hey Nelo!

    I got it to work! There were three remaining steps to make the connection happen.

    1) Check the port in SQL Server Confugruation manager/Protocols for SBSMONITORING/ TCP/IP /IP Addresses /IPAll - add 1433 to TCP port
    2) Tell it to only allow remote connections using TCP/IP and not both Named Pipes.
    3) Allow MSSQL 2005 to accept connections in mixed mode not just windows authentication. More can be found here: http://www.codeproject.com/KB/databa...05_remote.aspx

    You guys are incredible! Thanks again!!
    Reply With Quote Reply With Quote
  2. March 31st, 2009, 05:09 PM #17
    nelo
    nelo is offline Senior Member
    Join Date
    Nov 2002
    Location
    .NET 3.5 VS2008
    Posts
    1,039

    Re: i have NO IDEA what i'm doing

    Quote Originally Posted by savesheep View Post
    Hey Nelo!

    I got it to work! There were three remaining steps to make the connection happen.

    1) Check the port in SQL Server Confugruation manager/Protocols for SBSMONITORING/ TCP/IP /IP Addresses /IPAll - add 1433 to TCP port
    2) Tell it to only allow remote connections using TCP/IP and not both Named Pipes.
    3) Allow MSSQL 2005 to accept connections in mixed mode not just windows authentication. More can be found here: http://www.codeproject.com/KB/databa...05_remote.aspx

    You guys are incredible! Thanks again!!
    Nah!!! You're the incredible one! From zero programming experience to working all that out is not easy. I don't know you if you would make a good programmer/developer but you sure are an excellent problem solver and researcher
    Join a Discussion on Multithreaded Programming
    Reply With Quote Reply With Quote
  3. March 31st, 2009, 06:58 PM #18
    JonnyPoet's Avatar
    JonnyPoet
    JonnyPoet is offline Elite Member Power Poster
    Join Date
    Mar 2005
    Location
    Vienna, Austria
    Posts
    4,538

    Re: i have NO IDEA what i'm doing

    Congratulations !
    Its always great when it is possible to help someone and the help in the end is acknowledged too.
    Jonny Poet

    To be Alive is depending on the willingsness to help others and also to permit others to help you. So lets be alive. !
    Using Code Tags makes the difference: Code is easier to read, so its easier to help. Do it like this: [CODE] Put Your Code here [/code]
    If anyone felt he has got help, show it in rating the post.
    Also dont forget to set a post which is fully answered to 'resolved'. For more details look to FAQ's about Forum Usage. BTW I'm using Framework 3.5 and you ?
    My latest articles :
    Creating a Dockable Panel-Controlmanager Using C#, Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Part 7
    Reply With Quote Reply With Quote
Page 2 of 2 FirstFirst 12
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured