Stop using SQL Server path’s work with a SQL Alias

A lot of times i run into customers how started out with one SQL server and run in to problems when these servers have to be upgrade or the databases needs to be migrated to different SQL servers of clusters because of expansion or recourses. Let’s say you have an application that has a specified database connection that I either can’t or don’t want to change. However, I need to move the database to a new server. How can I do this easily without breaking other things that maybe using this connection and/or database?

By using an alias! We can keep the application configuration the same, but tell the operating system to look somewhere else for the database. Another plus is that once an alias is created, it is set at the operating system level. That means if we have two applications which connect to MySQLServer on that computer, once the alias is created, both will be re-pointed based on the alias. You can create an alias using one of two utilities:

  1. SQL Server Configuration Manager
  2. SQL Server Client Network Utility

SQL Server Configuration Manager

Let’s start by looking at how to do it using SQL Server Configuration Manager. In the left pane of SQL Server Configuration Manager, if you expand the SQL Native Client Configuration folder, there is a subfolder called Aliases (see Figure 1). If we click on this subfolder, we’ll see any aliases that have been defined for the system shown in the right pane. In most cases, there won’t be any defined. To create a new alias, right-click on Aliases and choose New Alias… from the pop-up menu.

Figure 1:


A dialog window comes up (Figure 2) which allows us to specify our new alias. In the Alias Name property, you specify the name the application uses. For instance, if it connects to a SQL Server called MyOldServer, that’s what you enter in here. You can also enter an alias that appears to point to a named instance, such as MyOldServer\MyInstance. You can then specify the server where the database really is, to include configuring the protocol, the server name, and the port. Clicking the OK button will create the alias. In the case of Figure 2, I’m creating an alias called MyOldServer which points to my local server’s default instance.

Figure 2:


You should now see the new alias listed in the right pane (Figure 3).

Figure 3:



The next step is to test the connection. You can do so quickly by either creating and testing a Data Source Name (DSN), or if you have the SQL Server client tools installed, by using SQL Server Management Studio (SSMS). I’ll do so using SSMS. Figure 4 shows the dialog window to open a new connection to a database engine. For Server name:, enter in the alias you specified. In the example we called the alias OldServerName, so that’s what we’ll use here.

Figure 4:


If the alias is pointed correctly to the new location, a successful connection should be established. In SSMS, I was opening a new connection for Object Explorer. Figure 5 shows that the connection was successfully made using the alias. Note that as far as SSMS is concerned, the server name is the alias.

Figure 5:


SQL Server Client Network Utility

If you haven’t installed the SQL Server 2005/2008 client tools, you can still create an alias using the SQL Server Client Network Utility. This has come installed automatically on every operating system from Windows 2000 on. To bring up the utility, click on Start, then Run, and run cliconfg.exe. To view or create aliases, click on the Alias tab (Figure 6). As you can see from Figure 6, aliases created by SQL Server Configuration Manager can be seen by the SQL Server Client Network Utility. The reverse is also true.

Figure 6:



To create a new alias, click on the Add… button. This will bring up a new dialog window where you can specify your alias (Figure 7). Just as with SQL Server Configuration Manager, the Server alias is what the application will attempt to connect to. You can specify where that alias points to by specifying the network library, the real server name, and any additional configuration parameters. In Figure 7 I’m creating a new alias called MyOldServer2 that also points to the default instance of my local server.

Figure 7:



Click the OK button to create the new Alias. In order for the alias to actually be created, however, you must click the OK button for the SQL Server Client Network Utility, which will create the alias as it closes.


Now that you know how to create an alias to a SQL Server instance look at this option instead of having hard SQL connections to server and run into problems when you want to reinstall or rename your servers. Also some application do not give you the ability to connect to a named instance, so this is another way of connecting without having to use the a default instance.

Try Exchange, Sharepoint and Lync 2013 preview releases.

Be one of the first to find out what’s coming next by exploring preview versions of these powerful business products.

SharePoint 2013

The newest SharePoint is designed to help everyone in your organization share content and ideas, organize teams and projects, and discover connections to get work done.

  • Share documents easily from SharePoint or any Office application, and track the people you’ve shared them with.
  • Follow sites, documents, and people with updates delivered to your activity feed.
  • Share ideas and tap into the knowledge of specialists from across your organization.
  • Search for documents, people, discussions, and #tags from anywhere in SharePoint.
  • Discover and trial third party apps in the marketplace to customize your SharePoint sites.

How to try

With Office 365 Small Business Premium Preview
Try it | Learn more

With Office 365 Enterprise Preview
Try it | Learn more

For IT Pros, try the SharePoint Server 2013 Preview

Exchange 2013

The newest Exchange enables you to increase user productivity and keep your organization safe, while maintaining the control you need.

  • Move to the cloud on your terms with flexible migration options.
  • Help your users do more on any device, manage increasing volumes of email, and work together more effectively as teams.
  • Protect business communications and sensitive information as you meet internal and regulatory compliance requirements.

How to try

With Office 365 Small Business Premium Preview
Try it | Learn more

With Office 365 Enterprise Preview
Try it | Learn more

For IT Pros, try Exchange Server 2013 Preview

Lync 2013

The newest Lync is an enterprise-ready, unified communications platform that connects people everywhere on Windows 8 and other devices.

  • Use a single, unified client for real-time communications, including voice and video calls, Lync meetings, presence, instant messaging, and persistent chat.
  • Get HD video conferencing across a range of devices. The Lync video gallery allows Lync meeting attendees to simultaneously view up to 5 different participants, identify the active speaker, and associate names with faces.

How to try

With Office 365 Small Business Premium Preview
Try it | Learn more

With Office 365 Enterprise Preview
Try it | Learn more

For IT Pros, try the Lync Server 2013 Preview

Office Web Apps Server 2013

With Office Web Apps Server, your users get browser-based productivity from nearly any device on your terms and within your own private network.

  • Keep your users productive and working together, no matter where they are or what device or software they have, using browser-based versions of Word, Excel, PowerPoint and OneNote.
  • Manage updates to Web Apps Server independent of other products with standalone server deployment and configuration.
  • Get simple, seamless integration with your existing servers including Exchange, SharePoint, Lync, line-of-business applications and file shares.

Project 2013

The new Project offers flexible service or on-premises solutions for project portfolio management (PPM) and everyday work. Try it in these three versions:

  • Project Online Preview is our online solution that gives you flexible options for achieving strategic priorities while helping your team deliver efficiently from virtually anywhere.
  • Try Project Server 2013 Preview, our on-premises solution to set clear strategic priorities and help your team execute effectively against them.
  • With Project Professional 2013 Preview you can call or instant message right from your project with Lync*—just two new ways to improve collaboration while keeping your team productive and on track. (* Requires Lync Online or Lync 2013, which are sold separately.)

Visio 2013

The new Visio lets you easily create professional, versatile diagrams that help you organize and make sense of complex information.

  • Create diagrams more intuitively—including new and updated shapes and stencils, improved effects, and themes.
  • Make your diagrams more dynamic by linking shapes to real-time data, and then share them with others via Visio Services in SharePoint—even if they don’t have Visio installed.
  • Simplify teamwork with new coauthoring features.

Office Professional Plus 2013

For IT pros, you can also try the Office Professional Plus 2013 MSI-based installation, which includes Word, PowerPoint, Excel, Outlook, OneNote, Access, Publisher, and Lync. Note that this is not the Click-to-Run installation used by Office 365 ProPlus and does not support fast streaming installation or side-by-side operation with older versions of Office. In addition, you must uninstall the existing version of Office on your PC to try Office Professional Plus 2013.

Internet Explorer 9 is here!

Microsoft has launched the much anticipated IE9.

To start experiencing a more beautiful web with IE9 and to visit a small set of the top 250 web-sites globally that have created a more beautiful experiences for all of us with IE9, go to

Internet Explorer 9 has now been downloaded 2.35 million times in the first 24 hours since its Monday night release. That is over 27 downloads every second, or over 240 downloads every 9 seconds. Wow!.

They want to thank everyone around the world for downloading IE9 and the enthusiastic reception. 2.3 million downloads in 24 hours is over double the 1 million downloads we saw of the IE9 Beta and four times that of the IE9 RC over the same time period.

In case you missed it, check out the collection of videos from the SxSW launch event. Ze Frank’s demo of Star.ME is one not to be missed!

You can see all of the demos and the complete launch event by clicking play below. And to download Internet Explorer 9 for yourself, visit

Ze Frank’s demo of Star.ME is one not to be missed!

You can see all of the demos and the complete launch event by clicking play below. And to download Internet Explorer 9 for yourself, visit


Announcing App-V 4.6 RC and integration with Office 2010 Beta!


First of all, we are excited to announce the availability of App-V 4.6 RC! In August we announced the App-V 4.6 Beta. Since then we have taken in lots of customer feedback and continue to refine the App-V 4.6 release so that we can deliver a great product!  We invite you to check out the RC release by registering and downloading the App-V 4.6 RC release via Microsoft Connect, where you can also submit feedback directly to the team.

We’re not done though, in addition we’d like to share some great news and also announce our integration with Office 2010 Beta:

Microsoft Office 2010 Beta, Ready to be Sequenced With the Microsoft Office 2010 Beta Deployment Kit for App-V

As you know the Office team just completed a major milestone Microsoft Office 2010 Beta, congrats to the team!  Throughout the process of building Office 2010 the App-V and Office teams have been working very closely to make sequencing Office 2010 Beta possible with App-V 4.6 RC!  We have taken the feedback and requests from post-Office 2007 and App-V 4.5 releases, and have been hard at work implementing a solid integration experience for Office when App-V 4.6 releases in H1 2010.

So what’s Different when using Microsoft Office 2010 Beta and App-V 4.6 RC together?

Office 2010 has introduced a new piracy protection initiative, the Software Protection Platform (SPP) service.  This service uses a machine’s hardware characteristics and product key to activate the installation, which is performed during the first Office application launch.

Since the Office 2010 product activation is linked to the hardware on which Office is originally installed, customers who wish to deploy Office 2010 using App-V must physically install the SPP service on the sequencer machine before beginning the sequencing process – and on any client machines that will stream and run Office 2010.

Our engineering teams have collaborated to address the top customer issues that people were running into when virtualizing past versions of Office.   As a result, Office 2010 has a much more integrated user experience.  The Office 2010 integration delivers key productivity enhancements and a seamless user experience by enabling the following::

· Microsoft SharePoint Integration – You can open, edit, and save Microsoft Office documents using Microsoft SharePoint.

· Microsoft Outlook Fast Search – You can use Microsoft Windows Desktop Search to find specific messages in your inbox.

· MAPI Proxy – You can connect to your inbox using Microsoft Outlook Send To functionality.

· Microsoft Office Document Indexing – You can index your documents so that you can use Microsoft Windows Search to locate files.

· Virtual Mail Control Panel icon – You can use the Email icon in Control Panel to perform advance mail configuration.

· URL protocol handler – You can configure links in the browser and specify the appropriate associated Microsoft Office application.

· Send to Microsoft OneNote Printer driver – You can print documents to Microsoft OneNote.

To help customers facilitate this process, we have created the Microsoft Office 2010 Deployment Kit for App-V (Beta). The Deployment Kit contains both the required SPP licensing component and Office 2010 integration features.

And what’s even more exciting, you can get your hands on it now.

How Do I Sequence Microsoft Office 2010 Beta for App-V 4.6 RC?

1. Download Office 2010 Beta here

2. Download the Microsoft Office 2010 Deployment Kit for App-V (Beta)

3. Download App-V 4.6 RC on Microsoft Connect

4. Read the App-V recipe for sequencing Office 2010 Beta on Microsoft Connect.

For detailed information on whether your environment meets the requirements of Office 2010 and App-V 4.6 RC, please refer to the App-V recipe.

Please note: We are providing a recipe to support the sequencing and testing of these pre-release products on Microsoft Connect.  Please provide feedback via Microsoft Connect, by choosing FEEDBACK once logged into the App-V 4.6 Program.

We look forward to hearing about your App-V 4.6 RC and Office 2010 experience!

Office 2010 Downloads

Office 2010 Pro:

64-bit Client Installation of Office 2010

Describes and illustrates the 64-bit client installation of Office 2010.

Microsoft Office Web Apps (Beta)

Microsoft Office Web Apps are new web-based tools that extend the Microsoft Office 2010 experience to your browser. Office Web Apps enable you to view, do light editing, and share your Office documents from virtually anywhere. With these online companions to Word, Excel, PowerPoint, and OneNote you’ll always have the tools you need, wherever you are.

Project 2010 Reference: Software Development Kit

The Microsoft Project 2010 (Beta) SDK contains documentation, code samples, “How to” articles, and programming references to help customize and integrate the Project 2010 clients and Project Server 2010 with other applications for enterprise project management.

Download details FAST Search Server 2010 for SharePoint Beta

For organizations looking to help users find information and expertise quickly and easily through a search capability able to address their most challenging needs – includes all the search features and integration capabilities of SharePoint Server 2010, plus a more engaging and conversational search experience, use of context to provide specific search experiences for different needs (such as departments or geographies), advanced content processing capabilities that create metadata and add structure to unstructured content, and deep platform flexibility, scalability, and extensibility. For use with SharePoint Server 2010 Enterprise Edition.

Download details FAST Search Server 2010 for SharePoint Internet Sites Beta

For customers looking to offer engaging and conversational search experiences on websites using SharePoint Server 2010 for Internet Sites – this product also adds powerful content processing that enhances the meaning and structure of your information, along with deep platform flexibility and search scalability. For use with SharePoint Server 2010 for Internet Sites, Enterprise Edition.

Download details SharePoint Foundation 2010

This download contains an installable version of Windows SharePoint Services 2010 Beta, that can be used to assess and test the new functionality in this release.

Download details Access Database Engine 2010

This download will install a set of components that can be used by non-Microsoft Office applications to read data from and write data to 2010 Office system files such as Microsoft Access 2010 (mdb and accdb) files and Microsoft Excel 2010 (xls, xlsx, and xlsb) files. Connectivity to text files is also supported.
ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.

Download details Visio 2010 (Beta) Viewer

The Visio 2010 (Beta) Viewer allows anyone to view Visio drawings and diagrams (created with Visio 5.0, 2000, 2002, 2003, 2007, or 2010) inside their Microsoft Internet Explorer version 5.0 or later Web browser.

Download details Visio 2010 (Beta) Software Development Kit

The Microsoft Office Visio 2010 (Beta) Software Development Kit (SDK) contains the latest documentation, samples, header files, libraries and tools that you need to develop custom solutions for Microsoft Office Visio 2010 (Beta).

Download details Microsoft Project Professional 2010 Beta x64

Microsoft Project Professional 2010 Beta gives you powerful, visually enhanced ways to successfully manage and deliver a wide range of projects. Easier and more intuitive, Project Professional 2010 Beta provides flexible choices to simplify planning, collaboration and resource management.

Download details Microsoft Project Professional 2010 Beta 32 bit

Download details Business Contact Manager for Outlook 2010 Beta

Business Contact Manager for Outlook 2010 provides contact management, sales, marketing and project management for the small business or small team.

Download details Office 2010 (Beta) Administrative Templates and OCT

This download includes updated Group Policy Administrative Template and Office Customization Tool OPA files; an updated Office Customization Tool; and ADMX and ADML versions of the Administrative Template files.

Office 2010 KMS Host License Pack

Volume editions of Microsoft Office 2010 client products require activation. Key Management Service (KMS) is a local volume activation method. To activate your Office 2010 client installations with KMS, you will need to set up a KMS host.

SharePoint 2010 Products Beta MP

A System Center Management Pack for Microsoft SharePoint 2010 Products Beta (the product are: SharePoint Server 2010, Project Server 2010, Search Server 2010).

SharePoint Foundation 2010 (Beta) MP

A System Center Management Pack for Microsoft SharePoint Foundation 2010 Beta.

Business Contact Manager for Outlook 2010 Beta

Beta release of Business Contact Manager for Outlook 2010

Microsoft Office 2010 (Beta) Filter Packs

Microsoft Office 2010 (Beta) Filter Packs

Access 2010 Beta Download: Access Runtime

The Microsoft Office Access 2010 Runtime enables you to distribute Access 2010 applications to users who do not have the full version of Access 2010 installed on their computers.

Microsoft Visio 2010 Beta

This download contains the Microsoft Visio 2010 Beta release.

SharePoint Server for Internet Sites Enterprise 2010 Beta

This is a Beta version of SharePoint Server 2010 for Internet Sites, Enterprise that enables extranet and internet sites using the full power of SharePoint Server 2010, the business collaboration platform for the Enterprise and the Web.

Microsoft Visio 2010 Beta

This download contains the Microsoft Visio 2010 Beta release.

SharePoint Server for Internet Sites Enterprise 2010 Beta

This is a Beta version of SharePoint Server 2010 for Internet Sites, Enterprise that enables extranet and internet sites using the full power of SharePoint Server 2010, the business collaboration platform for the Enterprise and the Web.

SharePoint Server 2010 Beta

This is a Beta version of SharePoint Server 2010, the business collaboration platform for the Enterprise and the Web.

SharePoint Server 2010 Beta

This is a Beta version of SharePoint Server 2010, the business collaboration platform for the Enterprise and the Web.

Search Server 2010 Express Beta

This is a Beta version of Search Server 2010 Express.

SharePoint Designer 2010 Beta

This is a Beta version of SharePoint Designer 2010, the tool of choice for the rapid development of SharePoint applications.

SharePoint Designer 2010 Beta

This is a Beta version of SharePoint Designer 2010, the tool of choice for the rapid development of SharePoint applications.

Microsoft Project Server 2010 Beta

Project Server 2010 Beta ensures organizations select and deliver the right projects, while gaining greater visibility and control of resources leading to improved productivity and better business performance.

Beta Office 2010 & Sharepoint 2010 on MSDN & Technet Plus!

Microsoft has release the beta versions of Office & Sharepoint 2010 on technet and MSDN

Microsoft Office 2010 will become available in a x86 and x64 version. Sharepoint 2010 will only be available in x64 version only.

Microsoft is planning to release the  Microsoft Office 2010 products in Q1 next year (2010).

More information about the Office 2010 products on

Pre-register for SharePoint 2010 Beta

Pre-register today and get notified when SharePoint 2010 Beta becomes available in November.

Find out how this integrated suite of server capabilities can help your organization by providing comprehensive content management and enterprise search, accelerating shared business processes, and facilitating information-sharing across boundaries for better business insight.

Please review the preliminary system requirements to prepare for the beta release. For a comprehensive list of readiness resources and the right steps to take today, check out SharePoint 2010 Get Ready.

Register link :

Source :

SharePoint 2010 Keynote

Source :

Steve Ballmer Microsoft SharePoint Conference 2009 Transcript
PowerPoint Presentation Microsoft SharePoint Conference 2009 (2.1MB)
Steve Ballmer Keynote Video


Jeff Teper Keynote
Jeff Teper Q&A
SharePoint Workflow – Content

Office Integration

Office Integration

Easily connect Microsoft Office to the SharePoint sites you work in

Compliance Everywhere

Compliance Everywhere

Quickly identify, collect and preserve content throughout SharePoint for legal discovery

SharePoint Workflow – Composites

Business Connectivity Services

Business Connectivity Services

Users can easily connect to and interact with external enterprise data

Human Workflows

Human Workflows

SharePoint Designer lets you create sophisticated workflows without code

SharePoint Workflow – Insights

Rich Analytics and Visualizations

Rich Analytics and Visualizations

Create interactive and contextual dashboards aggregating data and content seamlessly

Increased Fidelity With Excel

Increased Fidelity With Excel

Distribute Excel Workbooks with the same fidelity as the client, maintaining one version of the truth

SharePoint Workflow – Communities

Add Colleagues

Add Colleagues

Adding Colleagues to my network is easy, and includes grouping and privacy options

Enterprise Wikis

Enterprise Wikis

Enterprise wikis help consolidate companywide information into a centralized, easy-to-manage repository

SharePoint Workflow – IT Pros

Streamlined Central Administration

Streamlined Central Administration

Streamlined Central Administration and Ribbon UI improve management experience

Visual Upgrade

Visual Upgrade

Switch between two versions of looks of SharePoint after upgrade

SharePoint Workflow – Developers

Install on Windows 7

Install on Windows 7

SharePoint 2010 running on Windows 7

Developer Dashboard

Developer Dashboard

The Developer Dashboard appears below the page when enabled