Q
Problem solve Get help with specific problems with your technologies, process and projects.

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

Daniel Cazzulino
Clarius Consulting
Follow:
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 last published in July 2003

Dig Deeper on .NET Workflow

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.

Meet all of our Microsoft .Net Development experts

View all Microsoft .Net Development questions and answers

Start the conversation

Send me notifications when other members comment.

Register

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

TheServerSide.com

SearchCloudApplications

Close