Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pontifikas
Starting Member
32 Posts |
 Posted - 2004-09-13 : 11:50:07
|
Here is the situation:I wanted the Enterprise manager to login , not with the system account but, with another. I created a user which also is a user of the system.Right Click on the server, properties, start with user:myuser, passwd:mypass Ok?The Ent.Manager warned me that it should restart in order the changes to take effect.OK.After restart, I cannot connect to the DB Server. I cannot even push properties to change back to logging in with system account.I need to have access to the base or I'm screwed. Any help whould be appreciated.. |
|
|
n/a
deleted
35 Posts |
Posted - 2004-09-13 : 12:02:30
|
| I htink you changed the database startup account and not the EM log in account.If that is the case you can switch it back in the services.goto;Start>>settings>>control panel>>administrative tools>>servicesfind the following two services and stop them (if they are started).MSSQLSERVERSQLSERVERAGENTonce they are stopped right click on each on and goto propertiesgoto the log on tab and reset your username and password for starting the services.restart the services (Make sure they start).now, go back to EM and right click on the server and select EDIT SERVER REGISTRATION PROPERTIES (this is what controls the connection to the database, not properties). reset your connection and you should be set to goHTHPaul |
 |
|
|
pontifikas
Starting Member
32 Posts |
Posted - 2004-09-14 : 04:10:54
|
| The problem has been solved. Thanks A lot mate :) |
|
|
|
|
|
|
Urgent!User authentication