FIX:- Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection

Published: May 17th, 2012 Category: Microsoft Windows, MSSQL

Sometime while connecting MSSQL 2005 Remotely OR locally using MSSQL Management Studio (using user as SA) it throw following Error

Read the rest of this entry »

How to Convert/Migrate/Move/Copy MSSQL Database to MySQL Database?

Published: May 9th, 2012 Category: MSSQL, MySQL

Scenario

Read the rest of this entry »

Find Table Count and Tables without Primary Key in MS SQL

Published: May 2nd, 2012 Category: Microsoft Windows, MSSQL, Tutorials

Few days ago while working on MS SQL 2008 Transactional Replication I have faced following two issue
1) To find out the total number of tables to verify that Primary Server and Secondary server have same table count.
2) Tables without Primary key: After replication setup I have found that some tables were not replication. When I checked the logs it showed following error

Read the rest of this entry »

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

Published: Apr 28th, 2012 Category: 2008 Server, Microsoft Windows, MSSQL

Sometime while setting up MSSQL Replication you will receive following error at the time of connecting Slave or Secondary Database Server.

Read the rest of this entry »

Guide to MS SQL 2008 Transactional Replication (Create Subscriber) Part-IV

Published: Apr 13th, 2012 Category: Microsoft Windows, MSSQL, Tutorials

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

Published: Apr 10th, 2012 Category: Microsoft Windows, MSSQL, Plesk For Windows

Sometime while connecting to MSSQL Server Configuration Manager it throws following Error

Read the rest of this entry »

Guide to MS SQL 2008 Transactional Replication (Configure Distributor) Part-II

Published: Mar 19th, 2012 Category: MSSQL, Tutorials

In previous article (Step by Step Guide to MS SQL 2008 Transactional Replication over Internet Part – I) I have explained replication and how transactional replication work. Now I am going to explain some pre-configuration settings which need to be done before setting up MSSQL replication over Internet and also I will tell how to configure a Distribution Agent.

Read the rest of this entry »

Subscribe to eITWebguru

© 2012 eITWebguru. All Rights Reserved.