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 |
|
Charles Egan
Starting Member
21 Posts |
 Posted - 2013-06-03 : 17:13:57
|
| I know I can create more sysadmin accounts by clicking the "Add..." button in Database Engine Configuration.But how can I get back to Database Engine Configuration without rerunning SQLEXPRADV_x86_ENU.exe as Administrator?I tried:Start | All Programs | Microsoft SQL Server 2008 | Configuration Tools | SQL Server Installation Center (run as Administrator) | Installation | New SQL Server stand-alone or add features to an existing installtionbut before I ever got to the Database Engine Configuration step, I immediately got the "Browse for SQL Server 2008 Installtion Media" window. I wasn't able to deal with that when I encountered it before - I had to completely reinstall SQL Server by running SQLEXPRADV_x86_ENU.exe again.Won't it do the installation all over if I run SQLEXPRADV_x86_ENU.exe again? Or can I run it up to the Database Engine Configuration step without then going through the rest of the installation?Thanks for any help. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-03 : 17:48:15
|
quote:
Originally posted by Charles Egan
I know I can create more sysadmin accounts by clicking the "Add..." button in Database Engine Configuration.But how can I get back to Database Engine Configuration without rerunning SQLEXPRADV_x86_ENU.exe as Administrator?I tried:Start | All Programs | Microsoft SQL Server 2008 | Configuration Tools | SQL Server Installation Center (run as Administrator) | Installation | New SQL Server stand-alone or add features to an existing installtionbut before I ever got to the Database Engine Configuration step, I immediately got the "Browse for SQL Server 2008 Installtion Media" window. I wasn't able to deal with that when I encountered it before - I had to completely reinstall SQL Server by running SQLEXPRADV_x86_ENU.exe again.Won't it do the installation all over if I run SQLEXPRADV_x86_ENU.exe again? Or can I run it up to the Database Engine Configuration step without then going through the rest of the installation?Thanks for any help.
If you select add/remove features, it should not do a complete reinstall - it should only add or remove the features you requested.For adding a new login as sysadmin, you don't need to go through add/remove features. Instead, launch SQL Server Management Studio (which should have been installed as part of your initial install) and then connect to the server ( server name will be .\SQLExpress), and in the object explorer, under security -> login, add a new user and grant them sysadmin role.You should add someone as sysadmin on if absolutely required. Even if you have a login with sysadmin privileges, for normal day to day work, it is better to use a less privileged account. |
 |
|
|
Charles Egan
Starting Member
21 Posts |
Posted - 2013-06-03 : 18:39:43
|
| Thanks, James K -A simple, concise, correct answer that even a newbie such as myself could understand and implement! I can't thank you enough! |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-04 : 12:21:19
|
| You are very welcome - glad to help! |
|
|
|
|
|
|
|
|
How can I add administrators?