About Piyush Bajaj

I am very passionate about SQL Server. I also did certification on MCSA – SQL Server 2012, Querying and Administering; MCTS – SQL Server 2008, Database Development; and MCTS – SQL Server 2005, Implementation & Maintenance, which helped me to get more knowledge and interest on this field.Please feel free to drop me any question online or offline, I will try to give you the best possible answer from my side.Right now I am working as a SQL Server developer in TCS. I have an experience of just 2.6 years, well I can only say that “If you have an interest and passion, experience might become a very small thing”.

View all posts by Piyush Bajaj →

9 Comments on “SQL Server – Why the Domain User Account is being preferred?”

  1. Hence we require Domain User Account (or Domain Admin Account as per the requirement) when we want to setup Log Shipping, Replication, Database Mirroring, Remote backup plan etc. where there is a requirement to access the external resources.

    Nice one Piyush…

  2. can you please post a topic on how to install sql server 2008 (or R2), on windows 7 and differences between stand alone mode, sharepoint integration mode, including user accounts we need to assign please for ssrs, ssis, ssas and sql server also.

    thank you.

  3. Hi piyush

    This is kranthi,i have a one doubt 1)100% cpu utilization is thier? what is the steps i followed??

    2)can you change instance name? is it possible or not?

    Thanks&Regards,

    kranthi M

    SQL DBA

  4. Hi,

    I tried to install SQL server 2008 through local account , it got successfully installed. But after that i faced an issue while connecting to instance. It was giving the error.

    Error

    ##############################

    TITLE: Connect to Server

    ——————————

    Cannot connect to MSSQLSERVER.

    ——————————

    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

    ——————————

    BUTTONS:

    OK

    ——————————

    #######################################

    can you please help me on this…

    1. All the services were enabled.

    2. instance name was correct.

    3.windows firewall port 1433was configured.

    Ihope it was not due to local account.

  5. Hi,

    I just want to ask you that is there any difference if we run our software( sql server 2008 as back end) with only 1 domain user instead of making more domain user 1 for each user..

  6. Hi there, thanks in advance

    I have a problem similar to that. If I have 2 servers, one for SQL Server database and other for AD (Domain Controller). I want to restrict the access to my SQL Server database through getting access from Domain accounts only. i.e. if any one doe not login through through a Domain account, he will not able to access my database. How can I configure this?

  7. Hello Piyush,

    I have one query: Can we use the Windows Domain account to login SQL Server and access the Databases.

Leave a Reply

Your email address will not be published.