Be a Proud Pakistani. No compromise on dignity of Pakistan and Kashmir. Stand your ground and fight till glorious death.
Don't wanna be here? Send us removal request.
Statistics
We looked inside some of the posts by thinkpakistan and here's what we found interesting.
Average Info
Notes Per Post
62
Likes Per Post
35
Reblog Per Post
27
Reply Per Post
0
Time Between Posts
11 hours
Number of Posts By Type
Photo
12
Text
3
Last Seen Tumblr Blogs
Fun Fact
Tumblr was created by web developers David Karp and Marco Arment.
Text
Locked sa Account/Forgot admin password in SQL Server
Shit happens all the time in world of technology and one of them in world of SQL Server is admin account locked out/ forgotten password for admin account due to any stupid reason. Some of those reasons can be
All logins that are members of the sysadmin fixed server role have been removed by mistake.
All Windows Groups that are members of the sysadmin fixed server role have been removed by mistake.
The logins that are members of the sysadmin fixed server role are for individuals who have left the company or who are not available.
The sa account is disabled or no one knows the password.
No need to worry because we are going to guide you through step by step instructions to clear this mess. You ready? It is recommended that you take a cup of coffee :) ..just kidding. Lets start now.
First of all you do not need to re install any thing to handle such situation. You are already saved if you selected the option of Mix Mode Authentication while installing SQL Server i.e. you can use both SQL Authentication and Windows Authentication to login to server.
From the Start page, start SQL Server Management Studio. On the View menu, select Registered Servers. (If your server is not already registered, right-click Local Server Groups, point to Tasks, and then click Register Local Servers.)
In the Registered Servers area, right-click your server, and then click SQL Server Configuration Manager. This should ask for permission to run as administrator, and then open the Configuration Manager program.
Close Management Studio.
In SQL Server Configuration Manager, in the left pane, select SQL Server Services. In the right-pane, find your instance of SQL Server. (The default instance of SQL Server includes (MSSQLSERVER) after the computer name. Named instances appear in upper case with the same name that they have in Registered Servers.) Right-click the instance of SQL Server, and then click Properties.
On the Startup Parameters tab, in the Specify a startup parameter box, type -m and then click Add. (That's a dash then lower case letter m.)
Click OK, and after the message to restart, right-click your server name, and then click Restart. Wait..Please make sure that you have changed the start up type to Manual for SQL Server Agent. If this is set to automatic then before you login, SQL server agent will start by logging in and then late on you will get errors that only single user can be logged into the server. So do not forget this step. You can do this by typing services.msc in command window and then changing the start up type to Manual by editing the properties of SQL Server Agent.
After SQL Server has restarted your server will be in single-user mode.
Right-click the icon for Management Studio.Select Run as administrator. (This will pass your administrator credentials to SSMS.)
Connect with Object Explorer using Windows Authentication (which includes your Administrator credentials). Expand Security, expand Logins, and double-click your own login. On the Server Roles page, select sysadmin, and then click OK.
Now you have got sysadmin rights for your login. You can either reset the password for sa account or any other admin account.
The following steps now change SQL Server back to multi-user mode. Close SSMS.
In SQL Server Configuration Manager, in the left pane, select SQL Server Services. In the right-pane, right-click the instance of SQL Server, and then click Properties.
On the Startup Parameters tab, in the Existing parameters box, select -m and then click Remove.
Right-click your server name, and then click Restart.
Congratulations!!! Your problem is solved. Now enjoy using sysadmin rights on SQL Server.
Please do let me know if you face any problem. I hope this blog will clear your mess of sa locked account/sa forgotten password.
0 notes
Photo
Do not be afraid of making mistakes unless you make them for first time. Never lose a lesson when you make mistake and remember it will be a blunder if you repeat your mistake.
0 notes
Text
We are enemies of our brothers and sisters
In the name of entertainment Pakistanis rush towards cinemas to watch Bollywood movies. They listen to Indian music and now our radio channels are doing their business on basis of Indian Music. Our media has spread this message in Pakistan that music has no boundaries. Well to be honest this is the biggest crap you have ever listened. How many of you know that revenue that India generates from its movies in Pakistan is directly used on Indian army in Kashmir? In short we Pakistanis are funding Indian Army in Kashmir. India shows no mercy in Kashmir and also shows brutality on yearly basis by flooding Pakistan. We still rush towards cinemas for Indian movies. Wow what a nation we are. We are not a nation any more. We are just group of people living with no moral values. We are dead as a nation. In 1947 a nation won a country, but now our country needs a nation. If you feel that you are true Pakistani and you feel pain of Kashmiri brothers and sisters then spread this message otherwise just ignore and keep on funding Indian Army. I feel ashamed when I see posters of Indian movies on jumbo billboards on highway. I am sorry Muhammad Ali Jinnah, I am really sorry.
0 notes
Photo
Quality time with family....Thank you Allah for all you have given...I have no words to thank You for all your blessings..please keep me in Your path, the right path. I have no worries because I have You my Allah. Thank you sooooooooooooooooooooo much.
0 notes
Photo
Jumma Mubarik. Have a blessed day. Say thanks to Allah if you are still breathing and you still have a chance of Tauba. Do not waste this day.
0 notes
Text
Wake Up !!!!!
You are dead if you have forgotten your moral values. It is so embarrassing to see morning shows on Pakistani channels. On daily basis we are just acting like terminator of our moral values. Whenever I switch on the TV in the morning I will see nothing but bunch of vulgar shows on air. All these shows are promoting culture of those who have killed and who are killing our brothers and sisters not only in Kashmir but also in Pakistan. How can we be such fools to see these shows? Do you have any respect for Muhammad Ali Jinnah? Are you really thankful to Allah for opening your eyes on free land? Do you really remember the sacrifices of your forefathers? If yes then please stop watching this vulgarity imported from enemy in neighborhood. Realize that we are at war and this vulgarity is their most lethal weapon. Please wake up and raise your voice against this until this vulgarity gets banned on our channels. No one will come from outside to help you, you have to stand your ground and fight for your country which was made in the name of Allah and His Messenger (SAW).
0 notes