CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    47

    Login Failed for User : 'SqlExress/guest' !! ??

    hi guru's
    I am trying to connect the Instance of SQL Express 2005 from a client PC (running on Windows XP).
    While in the Object Explorer connection window, I can view the required SQL Express Instance installed in my server, but while i try to connect the instance, it says 'Login failed for the user 'MYSERVER/guest'

    The same error popups when i try to tun my client application (developed in VB6)..

    The server is set to run on Windows Autentication Mode and i've enabled the TCP/IP in the Local and Remote connections in Surface Area and the TCP/IP is enabled.

    How can i overcome this problem..

    any solutions pls..

  2. #2
    Join Date
    Apr 2002
    Location
    Egypt
    Posts
    2,210

    Re: Login Failed for User : 'SqlExress/guest' !! ??

    1. Do you use a domain controller So the server can recognize the client?
    2. If so, Did you add yourself as a valid login in the SQL server instance?
    3. Can you post the connection string you use in the vb6 application?
    Hesham A. Amin
    My blog , Articles


    <a rel=https://twitter.com/HeshamAmin" border="0" /> @HeshamAmin

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