I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?In EM, right-click on the server and then Edit Registration Properties.
Have it use Windows authentication.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eet8EBKhGHA.1612@.TK2MSFTNGP04.phx.gbl...
I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment