Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    9

    Unanswered: Login failed problem in SQLExpress

    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
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by hbkelkar
    'Login failed for the user 'MYSERVER/guest'
    ...
    The server is set to run on Windows Autentication Mode
    This would suggest that your clients windows logon is unknown - hence the first line.
    When connecting, change to SQL Server authentication and use an account you have already set up on the server (your own perhaps?) - this might help narrow down the issue.
    George
    Home | Blog

Posting Permissions

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