November 4, 2005 at 1:05 pm
Installed SQL Server developer edition on Win XP Pro laptop - using mixed mode authentication -
When I try and connect in Enterprise Manager I get the following error:
A Connection Could Not be Established to (LOCAL)
Reason: Login failed for user SA...
Please verify SQL server is running and check your SQL Server Registration Properties
The SQL Service Manager is running under the name of my server -
Appreciate any help anyone can give...
THANKS
November 5, 2005 at 6:44 am
Login failed for user SA is sql authentication.
Sure you haven't changed the password for SA?
Can you login using windows authentication?
November 5, 2005 at 7:25 am
Hi - i decided to uninstall and try setting SQL up with Win Authentication instead of Mixed Mode - Now I am getting the error:
A connection could not be establised to LOCAL
Reason: login failed for user sa Reason: not associated wiht a trusted SQL server connection
Thanks for the help
November 5, 2005 at 8:16 am
hmm
normally a fresh install of sql server allows buildin administrators (local administrators of a pc) to login via windows authentication.
November 5, 2005 at 8:19 am
I know that is what is so confusing...the server manager is running under my server name also...
January 2, 2008 at 6:34 pm
This problem appeared today out of the blue; does anyone have any idea what is going on here? I tried reinstalling MS SQL Server 2000 SP3 to no avail. Any help would be greatly appreciated.
November 1, 2008 at 11:03 am
Hi there,
I have a similar problem.
I can connect from a client to my sql server. But when I try to register it on the server with the enterprise manager. I receve an error message like
"invalid option/identifier "
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply