Accessing SQL Server on Windows Server 2008 R2 from remote client

27. March 2013
Comments (0)

This is a nice Blog post for the solution to this problem :- http://stackoverflow.com/questions/5717310/accessing-sql-server-on-windows-server-2008-r2-from-remote-client

The solution which worked for me is :- 

Here is a summary of what worked for me to get remote connections working. I am not an expert in this so some of my steps may not be necessary. I took some of the steps from other answers to this question.

  • Open SQL Server Configuration Manager
  • Select SQL Server Network Configuration
  • Chose your instance of a SQL Server
  • Make sure that TCP/IP protocol is enabled
  • Right click TCP/IP protocol
  • Select properties
  • Click IP addresses tab
  • Scroll down to IP4. The IP address of the server should be here. Set active to yes and enabled to yes. Set TCP port to 1433 (don't know if this is necessary. Can some expert comment)
  • Scroll down to IPAll. Set TCP port to 1433
  • Make an inbound firewall rule for port 1433
  • open sql server management studio, right click server instance, properties->connections-> allow remote connections. Security-> SQL Server and Windows Authentication mode
  • restart sql server service
  • restart sql server browser

MSSQL 2008

How to Compare Schema or Data of two Database Created in MS SQL SERVER 2008 using Visual Studio 2010

30. November 2012
Comments (0)

During my work i encounter this problem of different versions of Database one on my local development machine and one on my web hosting server . Now to check whether they are same or not i searched a bit and found a way to do so . 

All you need is a Visual Studio 2010 ultimate / Premium - you can check here which version can do this thing http://msdn.microsoft.com/en-us/library/dd193250.aspx

Steps you have to go through - 

1. Open the VS 2010 and add both the databases in Server Explorer under Data Connections . 

2. Right click on the primary DB you want to compare to with the secondary one and click on Compare Schema/Compare Data which ever you want to do . 

3. Next a new popup window will open and it will ask you to set the primary database and secondary database . Click OK after selecting appropriately . 

4. A new Tab will open and your schema/data will be compared with all the description as in what is equal and what is not . 

 

MSSQL 2008