Hopefully pretty straight forward.
Scenario: I am moving a SQL 2005 Express database to a new SBS 2008 server which has SQL 2008 standard installed. Backing up / restoring the database into SQL 2008 server isnt a problem. The problem is that an application that accesses the database has connection details hardcoded to connect and pull data from the database.
Problem: The sql2005 express instance is called 'xyz' (the same name as the server). When installing the new sql 2008 instance of the same name, the instance is of the format 'server name\instance name'. (ie xyz\xyz). This causes connection problems with the application. On the old server i can log in with Managment studio to 'xyz' but on the new server its always xyz\xyz.
Question: Is it possible and how do i install an SQL2008 instance that i can connect to as 'xyz' NOT xyz\xyz??
Thanks in advance!