Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Changing Windows server 2012 password not allowing SQL Management studio to connect database.

Posted on 2016-09-19
2
Medium Priority
?
37 Views
Last Modified: 2016-09-19
I have windows server 2012 and I have installed SQL 2008 r2. when  i change Windows server 2012 administrator password,
i could not connect SQL management studio.

I need to change Windows server 2012 password every 15 days. How can i solve this problem.

Thanks .
0
Comment
Question by:Nitin Shah
2 Comments
 
LVL 16

Accepted Solution

by:
Kamal Khaleefa earned 2000 total points
ID: 41804864
Check windows services and verify  which account does SQL server services use
If it use the local admin account
create a new local admin (domain user preferred)
And assign it to the service even in case its using local service
0
 

Author Closing Comment

by:Nitin Shah
ID: 41804978
Dear King202

Thanks for Quick answer.

This has help me to solve very easily.

Thanks .

Nitin Shah
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question