Having an issue connecting SQL Express 2008 R2(Version 10.50.4033) with SQL Server 2008 R2 (Version 10.50.1600). Am I able to make a connection to Express from SQL Server ? I am able to back up and restore to Server but cannot make a connection between from Server to Express but can go Express to Server. Any body any ideas thanks
Assuming you are using linked server for you connection make sure the bits are the same on both editions. For example, if Express is 32bit and other instance is 64bit that Link Server connections won't play nice. Here is a good thread on this.