create a 3rd windows admin and hope sql server will authenticate

godaddy windows server 2008 rdp with no control pannel

I am creating another administrator user in case current server crashes and I can not log in

SqlServer 2005 seems to work with 2 logins.
I think it uses windows authentication.

What changes should I make to ensure that sql server works with 3rd (newly created) login
LVL 1
rgb192Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
It won't since SQL Server has its own login security area. You shouldn't guess as to what the login type is you should KNOW one way is using the Sql Server Management Studio and looking at the server
0
rgb192Author Commented:
It won't since SQL Server has its own login security area. You shouldn't guess as to what the login type is you should KNOW one way is using the Sql Server Management Studio and looking at the server

sql server login
in management studio login user 'j3' is listed

so if user 'j3' is deleted or disabled, will sqlserver not work?
0
David Johnson, CD, MVPOwnerCommented:
the server will work but you won't be able to login to the server.. The websites that use SQL Server may be using a local username to login and execute. The settings will normally be in the sites web.config.  if you look in the services you will see what account the sql server uses to start.  

Why are you not using your own system to recreate what you have done and see the effects?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

rgb192Author Commented:
Could I create another sql login
0
David Johnson, CD, MVPOwnerCommented:
quit f*king around with customers hardware/software.. set up your own test environment and play around there. Do you not own a computer? If not you can go to a rent-to-own place and get one delivered the same day (they're expensive in the long run but have low payments that seem to take almost forever)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rgb192Author Commented:
I will follow expert advice and
I will try
180 day trial versions of Windows Server
and then post back
0
rgb192Author Commented:
I will try
180 day trial versions of Windows Server
and then write another question. My expertise is too low to finish this question. Thanks for guidance.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.