Category: MSSQL

Cannot Connect to WMI Provider. You do not have permissions of the server is unreachable

Sometime while connecting to MSSQL Server Configuration Manager it throws following Error Cannot Connect to WMI Provider. You do not have permissions of the server is unreachable. Note that you can only manage SQL Server 2005 servers with the SQL Server Configuration Manager. Invalid namespace[0x8004100e] I have searched on Google and found that it happens
Read More »

Error: SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name.

Sometime while setting up MSSQL Replication you will receive following error at the time of connecting Slave or Secondary Database Server.   Detailed Error: TITLE: Connect to Server —————————— Cannot connect to failover-db. —————————— ADDITIONAL INFORMATION: SQL Server replication requires the actual server name to make a connection to the server. Connections through a server
Read More »

Unattended MSSQL 2005 Installation – Command Line Installation of MSSQL

Microsoft SQL Server is a relational model database server produced by Microsoft and it’s Installation is quite Easy using GUI where a user has to selects the options which he/she needs with the database server and install it. We can automate the installation procedure and make it so simple that MSSQL can be installed using
Read More »

Guide to MS SQL 2008 Transactional Replication (Create Publisher) Part-III

After you configure the Distributor Server (Guide to MS SQL 2008 Transactional Replication (Configure Distributor) Part-II) now I will explain how you can create & configure the Publisher. Create & Configure Publisher 1) Select the Transactional Databases: Login to MSSQL Management Studio and go to  Server >> Replication (right Click) >> Publisher Properties >> Publication
Read More »