sql server

The issue is as above, however I can definitely confirm that the driver is installed. Currently running 5.00.9132.1023 (version 2409 with all hotfixes) As part of troubleshooting, I've uninstalled, rebooted, and then re-installed the driver, then rebooted again. Upgraded the SQL server version...

Hello guys, Can someone list all of the accounts for a fresh deployment of MECM, please include accounts needed like for SQL Server 2022 Administration, Client push-installation, Application deployment... etc Can you also elaborate on best practices choosing the account type for each...

Hi Guys! I am administering a CAS recovery after a HA SQL cluster failure. The Cluster was dismantled, rebuilt and synced by an DB Admin, but obviously, this broke SCCM. The CAS would not connect pointing to a site recovery to reconnect the CAS to the new HA cluster Listener. Towards the end, I...

Currently, we are using Microsoft Configuration Manager (MEMCM) version 2309 on a Windows Server 2019 server. The associated SQL Server, hosted on another Windows Server 2019 server, is version 15.0.2095.3 (SQL 2019). In order to improve performance and maintain system security, we want to...

Hi, SMS Site Cannot Access Sql server (2017) Any ideas...

Hi, In my humble opinion, and based on the fact you have numerous hard disks/disk arrays for partitioning, the best partitioning scheme for MS-SQL is the following: One partition for OS (C) One partition for the SYS_DB (D) One partition for the DB files (E) One partition for the DB_LOG files...

Hai Prajwal, I have followed your SCCM installation procedure,but during SQL installation in server accounts you have done a local account with domain administrators permissions, but I have given directly domain account itself.As i don't know how to create a new one and append domain...

Hi Prajwal, Thank you for the post which are related to SCCM, I found this is very helpful for the beginners, (you need to create a dedicate domain account to be used for the SQL Server Service. help link - http://www.randomtechtips.com/change-logon-account-for-sql-server-service/) I found...

hi guys Anyone have any luck with deploying SQL Server development 2014 ? I'm not sure which is the best way Use a ini file or command line

Hi, i installed SQL server 2016 just now. When i search SQL server management studio, I am unable to get it. How to get it ?.

i face this problem when installing SCCM ,i tried to change the TCP Port of my SQL Server and Run check again and it's also fail there is other solution @Prajwal Desai

I have the error below i have sql server 2008r2 and sql s2012 intsall i have 2012 sp3 installed and server 2012r2 sql server 11.0.6579 instance:-flagsccm sqlexpress 10.50.2811 epofresh 10.50.2811

Hi, I need suggestion for Database, My company is going to implement a new ERP System, we have a existing database for use of a big Application , would you please suggest me which is the best way to use a Database, should i use existing database or make new SQL Server for new Database Thanks...

Hello I had to reinstall SCCM 2012 R2 cause of a PXE issue and now I can not even open up the console. The logs point some type of SQL error however I don't know how to read them I am new to SCCM and hesitate troubleshooting as it could lead to further issue. Any help would be greatly...

So cam this morning and noticed that ccmservice on the server was stopped. I went ahead and looked and the windows logs and I have multiple errors. Once I start the service, everything "seems" to go back to normal but I still have issues installing the sccm client on new computer. Thanks...

Hello Prajwal, I am configuring SCCM 2012 on our domain where we already have SCCM 2007 on a different server.. We have a SQL server already in place that is the database for our SCCM 2007 server. How do I point SCCM 2012 to our existing SCCM server. I just finished installing SQL 2008 on the...

Hi Mr. Prajwal, Thanks for your tutorial for System Center Configuration Manager Installation guide, I came up with an failed message on the prerequisite check page SQL server service running account Failed SQLSERVER.Test.com The logon account...