myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Unabled to use the SysAdmin connection Options · View
zappox22
Posted: Saturday, September 20, 2008 2:57:37 PM
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
zappox22
Posted: Saturday, September 20, 2008 3:15:43 PM
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.
elian
Posted: Saturday, September 20, 2008 3:52:24 PM

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"
/>
zappox22
Posted: Saturday, September 20, 2008 4:01:53 PM
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!!
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.