Viewing 12 posts - 61 through 72 (of 72 total)
Ok guys, the solution was:
1. Create a new user in windows with admin rights and log into that account.
2. Start SQLServer in single connection mode. Link
3. Connect to Managment Studio...
November 14, 2011 at 6:08 am
Sweet! That seems to be the way to go, gonna try it out later when the traffic gets lower and i can shutdown the server.
I'll update and tell how how...
November 14, 2011 at 5:02 am
And this is my question... If you have rights to Disable it, it means you have to rights to Enable it back. Just UNDO your step.
OR
Do you have any other...
November 14, 2011 at 4:09 am
Basically i had all the standard install accounts like sa, nt authority and the like enabled.
I accidently disabled login for my windows account named "Administrator".
And i dont remember the password...
November 14, 2011 at 3:52 am
Is it not enabled? Or you are not SA?
I dont remember the password for sa, but i am dba, running the server on local machine.
November 14, 2011 at 3:37 am
Then enable it (yourself ot with help of IT Support).
I dont have access to sysadmin account... except maybe NT AUTHORITY\SYSTEM.
IS it possible to log into Managment Studio with NT AUTHORITY\SYSTEM...
November 14, 2011 at 3:34 am
Is there a way?
I would need to access NT AUTHORITY\SYSTEM to enable admin again...
November 14, 2011 at 3:29 am
Why do you want to do that?
I accidently disabled admin acc, and dont have access to sa...
November 14, 2011 at 3:26 am
@suresh Ty, you were right once again.
I found it useful to use: set @Subject_tets = 'some text' + @variable + 'some text', instead of having it in the...
October 24, 2011 at 6:53 am
New day, new challenges...
Here's how the script looks like, as it is now i create a temp table and populate it with data (id,email, firstname), then it loops through every...
October 24, 2011 at 2:49 am
That did the trick, thank you!
Now it works to send emails to several recepients, however it doesnt seem very scalable... next step, figure out how to create a...
October 20, 2011 at 5:34 am
Thats pretty much the options i got, either write a ASP VBScript app or use Database Mail together with SSA Jobs... Trying to figure out wich one...
October 20, 2011 at 4:16 am
Viewing 12 posts - 61 through 72 (of 72 total)