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 |
|
daniel5455
Starting Member
2 Posts |
 Posted - 2003-03-26 : 11:31:29
|
| I have a server with MSDE installed and i have enterprise manager installed on my workstation. I am trying to test a restore of a database, When i try to restore the db i get a error message that says "You must be logged on as 'sa' or a member of sysadmin or a member of dbcreator to perform this operation." I dont uderstand how i log in as sa under MSDE. I tried to create a user using Enterprise manager but i cant cause im not logged on as 'sa'. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-26 : 11:42:47
|
| Log on as an admin on the machine, and connect with windows auth.-Chad |
 |
|
|
daniel5455
Starting Member
2 Posts |
Posted - 2003-03-26 : 11:50:36
|
| Do you want me to log on to my WS as admin or the server that has MSDE? I am logged on my WS with my account which has domain admin rights. |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-03-26 : 12:21:03
|
| You should be able to log in EM as sa. Try a blank password, if no go then you set a sa password during the MSDE install that you need to use.If your sa password is blank you should add an sa password immediately. There are hack robots looking for sql servers with blank sa passwords.======Doug G====== |
|
|
|
|
|
|
Error Trying to restore a MSDE database