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..
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..