I am trying to connect vendors data sets with SQL database but always get the message: "Failed login for user .... ".
The account I am trying with is SQL one and I think all the needed permissions are given. Already tried with most of the OLE DB providers but to no avail. I couldn't find any more sophisticated information in the offline or online help regarding the issue and connecting to SQL server itself. Only vague general suggestions.
Has anyone got through this?
コメント
3件のコメント
Are you using a SQL Account (SA) or Windows Authentication, Can you connect via a system DSN using ODBC, have you run sql server man studio as the account that you are trying to use? I'd check all of these plus tcp/ip and named pipes are turned on the sql instance and the sql ports tcp 1433 and udp 1434 are open. You should be able to connect directly using the native client to the sql database or via a system DSN without any issue.
Hi MartinP,
Thank for the suggestions. I tried them all before writing here but missed them in the initial post.
The account I am trying with is an SQL account.( If I use a domain account everything works as it should be. )
SQL Management Studio - I can log in without a problem. I can even list the databases from FC, also get the connection successful but when press the ok button to save the settings, the error occurs.
UPDATE:
Problem solved.
The solution: The little tick for "save password" when configuring an OLE DB provider MUST be checked.
サインインしてコメントを残してください。