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?

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.

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.