April 30, 2008 at 12:55 am
I am using dynamics GP 10. for customization am using VBA, in that when i try to connect remote server[sql 2005]
am getting this "Login failed for user 'sa' " Even this is happening for other user also.
I am using ADODB.Connection method. And i set mixed mode for 'sa' also.
what would be the solution for this?
May 1, 2008 at 8:59 pm
Any errors in your SQL Server ERRORLOG? Here's a list of possible login failure states and their causes:
Error State Error Description
1 SQL Server in single user mode - only one admin can login
2 and 5 Invalid userid
6 Attempt to use a Windows login name with SQL Authentication
7 Login disabled and password mismatch
8 Password mismatch
9 Invalid password
10 Known issue with using domain password policy on SQL Authenticated logins
11 and 12 Valid login but server access failure
12 SQL Server service paused
16 No permission in target database (could be default or specific db)
18 Change password required
27 Could not determine initial database for session
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply