Click to See Complete Forum and Search --> : Login Failed for User : 'SqlExress/guest' !! ??


hbkelkar
March 19th, 2007, 03:48 AM
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..

hspc
March 19th, 2007, 02:18 PM
Do you use a domain controller So the server can recognize the client?
If so, Did you add yourself as a valid login in the SQL server instance?
Can you post the connection string you use in the vb6 application?