Link to home
Start Free TrialLog in
Avatar of codba
codba

asked on

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.
SOLUTION
Avatar of Jim P.
Jim P.
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of codba
codba

ASKER

Issue was resolve before suggested solution from experts.