-
March 19th, 2007, 02:48 AM
#1
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..
-
March 19th, 2007, 01:18 PM
#2
Re: Login Failed for User : 'SqlExress/guest' !! ??
- 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?
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
|