|
| | | Supreme Being
Group: Forum Members
Last Login: Saturday, February 12, 2011
Posts: 133, Visits: 427 |
| Hi,
The issue is with data base user. Please make sure the Data Base user configured during farm configuration (see attached image) has sysadmin rights to the server and also to this particular DataBase.
regards,
Moderator
|
| |
| | | Senior Member
Group: Forum Members
Last Login: Friday, March 14, 2008
Posts: 9, Visits: 26 |
| | Adding the Skelta impersonation user to the server/database I was trying to connect to solved the problem, thanks! |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: Wednesday, March 03, 2010
Posts: 2, Visits: 19 |
| Hi,
I have same problem. The database is run on other machine.
I found that when I disable windows firewall and click button "Test SQL Connection" again, Test connection was succeeded.
I think it is a firewall problem then witch port number to add to windows firewall exceptions.
When I turn-on windows firewall I already add exceptions for TCP Port 1433 |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Thursday, March 17, 2011
Posts: 66, Visits: 73 |
| | |
| | | Forum Newbie
Group: Forum Members
Last Login: Wednesday, March 03, 2010
Posts: 2, Visits: 19 |
| Hi
The problem is solved by add c:\windows\system32\msdtc.exe to windows firewall exceptions.
Thanks. |
| |
|
|