You are viewing limited content. For full access, please sign in.

Question

Question

I can't link LF Forms to SQL Server

asked on September 12, 2014

Hello,

 

I try to link LF Forms with SQL Server but it doesn't works. I get this message "Login failed for user 'user'. ".

I've tried to create a new user on SQL Server with 'public' and 'sysadmin' ServerRoles. For this user, I've set 'User Mapping' on database 'master' and 'CmdJu' (the one that I want to use with my form) with user 'user' and default schema 'dbo'. I've restarted the 'Laserfiche Forms Routing Service', logoff and logon LF Forms and then try again to link but it still doesn't works.

I guess this is come from SQL Server bad settings but I can't find how to figure it out.

0 0

Replies

replied on September 12, 2014

Are you creating a SQL User or trying to use Windows Authentication? If you are using a SQL User, do have that authentication type enabled on your SQL server?

1 0
replied on September 12, 2014

I use Windows authentification to connect on SQL Server, but I was trying to create a SQL user to link forms to SQL Server.

I saw another computer working like that so I was trying to do the same.

0 0
replied on September 15, 2014

Hey Moana,

 

If you're using Windows Authentication as your method of authentication to SQL, you'll need to make sure that the windows account that you're using has access to log into SQL.  You can test this by opening SQL Server Management Studio and using WIndows Authentication.  If you can't login there, then won't be able to login either.

 

You shouldn't need a separate user to link SQL to Forms, unless of course, that's the user that you'll be using to authenticate.

0 0
replied on January 27, 2015

I have had similar issues. When programming the user name, use the domain format. For example if you are in the domain "ABC" and user name is "lfuser" use

abc\lfuser as the user name and see if that works

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.