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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

SQL Server 2005 connectivity issue

After configuring the Microsoft Server 2003 R2 as an additional domain controller. The SQL server 2005 cannot connect an the database are gone. I've tried some troubleshooting tips but still unable to connect the server. Please help its urgent! Thanks in advance.
0
codba
Asked:
codba
  • 2
  • 2
2 Solutions
 
Jim P.Commented:
Do you have the Named Pipes protocol turned on? If so turn off protocol and restart the SQL Services.

Named Pipes depends on a unique token that is provided by a single domain controller. If that DC goes off line (even a reboot) the token is no longer valid. Use TCP onl for remote access.
0
 
codbaAuthor Commented:
Actually got it to work.  The logon defaulted to NT AUTHORITY. I changed the log on as : to This account by entering the administrator of the domain  and password <servername\administrator> then restart services.

Thanks. But will definitely keep your suggestion in mind in case an issue occur when rebooted. So far rebooted this  server it's working.
0
 
Jim P.Commented:
It is a giant security hole to use the Domain Admin account as the SQL Server logon account. That would allow anyone who has to the SQL Server to get to anything on the domain.

The best practices suggest building a specific account that only has permissions to the specific folders that are needed.

My lazy way of doing it is to build a domain account that is a local admin on the server but a regular user on the domain.
0
 
codbaAuthor Commented:
Issue was resolve before suggested solution from experts.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now