|
|
Rank: Newbie
Groups: Member
Joined: 9/20/2008
Posts: 3
Points: 9
|
I am testing this tool for a web hosting company and I keep getting this error:
Unabled to use the SysAdmin connection
When I try to connect to any database as any new user?? I am sure this is something simple but I cnat get it to work..
thanks for any help
|
|
Rank: Newbie
Groups: Member
Joined: 9/20/2008
Posts: 3
Points: 9
|
I am seeing this in the event logs:
Login failed for user ''. The user is not associated with a trusted SQL Server connection
I am using mixed mode auth with SQL logins. I can login as this account using sclcmd from anywhere and it works fine.
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
In your config.xml file, check that in your sqlserver definition the sysadminconnection property is well set to false
<sqlserver
address="ServerName\InstanceName"
name="my SQL Server"
sysadminconnection="false"
/>
|
|
Rank: Newbie
Groups: Member
Joined: 9/20/2008
Posts: 3
Points: 9
|
thank you very much, I knew this was something simple that I forgot!!
|
|
|
Guest |