| Author |
Topic |
|
sqlmember2000
Starting Member
9 Posts |
 Posted - 2011-04-08 : 23:38:15
|
Hello - hoping someone can help with this perplexing issue. I'm not a DBA or anything, so apologies if I sound like an amateur!  I currently have Enterprise Manager 2000 installed on my C:\drive, with the server running on my local computer (i.e. the SQL Server Group shows up as (local)(Windows NT)). I also have admin rights which allows me to access the server so I can run my pkgs, etc.The problem: I am going to have my admin rights removed. For example, when admin rights was removed, I got the following error:"A connection could not be established to (local). Reason: Login failed user user XXX.. Please verify SQL Server is running and check your SQL Server registration properties...."In light of this, what can I do to be able to access/use Enterprise Manager w/o dependency on having admin rights? What specific settings needs to be changed, if any?Note: having to connect to an actual database server is not an option at this moment. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlmember2000
Starting Member
9 Posts |
Posted - 2011-04-10 : 17:38:24
|
Thanks so much tkizer for replying to my post. If not too much trouble, would you be able to outline the steps in going about adding my account as sysadmin or use of sa account? I'm not exactly sure where to start. Btw - in being able to set the above, I can do this even while I do not have admin rights, correct?I do hope your suggestion works, because I was beginning to lose hope!Thanks in advance! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlmember2000
Starting Member
9 Posts |
Posted - 2011-04-11 : 10:52:41
|
| Hi tkizer - I have admin rights re-instated. I went into the server's Properties within Enterprise Manager. In the authentication box is selected as "Windows only". In the Startup Service Account box, it is currently set as "System account". Is your suggestion to change the Startup Service Account box to be "This account"? Is this any random username and password I can enter? Or should I be entering the user/pwd details that I typically use to log into my computer every day?Thanks for guiding me through this! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-04-11 : 12:57:21
|
| No, not the service account.You have two options:1. Grant your account sysadmin: In SSMS, go to Security, then logins. Add your account and in the server roles page, check the sysadmin box.2. Use sa account: Need to verify authentication mode first: In SSMS, right click on server, go to properties and then security. If it is using windows auth only, then switch it to windows and sql auth. You'll need to restart your service at this point. Then set a password for the sa account that you will remember and use each time you connect. You can do that in SSMS, security, logins.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
sqlmember2000
Starting Member
9 Posts |
Posted - 2011-04-11 : 14:26:01
|
| I actually don't have SSMS available (I'm running with SQL Server 2000, isn't SSMS something for later versions?). It's not part of the drop-down I have. Are there any other alternative?I also found this link while searching today. I'm not sure how to go about the first 4 steps. Though, do you think this would be something that will work?https://helpdesk.handynetworks.com/supportsuite/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=142&nav=0,6 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlmember2000
Starting Member
9 Posts |
Posted - 2011-04-15 : 16:50:24
|
Hi tkizer -Just wanted to get back to you on your solution and so far, it worked! "THANK YOU!"  I have to give it some more checks to make sure all the functionalities are working (which I'm guessing it should), but it looks good so far!Thank you for your brillant mind! Yes, you are truly Almighty SQL Goddess!! I bow to thee!All the best! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Enterprise Manager without admin rights