Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Problem on MS SQL Server

Background: I am about to install an application that asks already in the installation phase about MS SQL database to create its DB inside it. There are options of Windows Authentication and Server Authentication as methods to log on.

Question: My question is that what settings should I have on Sql Server Configuration Manager to be able to connect my installed program into it?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

Those options equal to:

  • windows authentication -> use a Windows (or domain) user account to connect to the database. Here you need to ensure that the user that runs the application (or the user that is configured to start the service) has access to the SQL Server (if you installed SQL Server and you're also installing the application, than most likely you already have access);

  • sql authentication -> create a SQL user that has access to the SQL Server and use it inside the application's connection strings. It is not dependent on the Windows/domain users, it's local only to that SQL installation.

If you're installing a new application that you're not familiar with, and it requests SQL Server access, then I suppose you should use Windows Authentication and check that the SQL Server service is started and accepts connections from that user. In SQL Server Configuration Manager you should check that the main SQL service is started and that it has enabled the main client protocols (TCP-IP and shared memory).

share|improve this answer
    
+1: This solved my issue. I actually found out these instruction by try and trial, but now I know why the things worked like I made them :) –  mico Jul 13 '11 at 11:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.