|
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.
|
|
![](/yafnet/resource.ashx?u=2) 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 |