Q

When I move my app to the production server, how will my apps resolve the previous server name?

I am developing my first application with a SQL database. On my laptop I have a server and a SQL server name, and, of course, my connections to the database have those names. My question is: when I have to move the application to the production server with a different name, how will my applications resolve the previous server name? What are the recommendations for this type of situation?
The best way to deal with this issue is to use the SQL Server Client Network Utility and create a new alias for the database. This will point to different physical servers in your development and production machines, of course. Next, in your configuration files, as well as your code, in the connection string Data source attribute, use that alias. You can even point the alias to an specific SQL Server instance, if you have more than one in a single server.
This was first published in July 2003

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

SearchSOA

TheServerSide

SearchCloudApplications

Close