jentc001
asked on
SQL2008 standard instance name
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!
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!
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Connecting via server name (rather than server\instance) should be the default behavior.
It's not clear if the machine hosting the 2005 Express product is called xyz or if the instance of Express is called xyz. In either case, you're probably better off naming the new 2008 server something different (or renaming the old server).
It's not clear if the machine hosting the 2005 Express product is called xyz or if the instance of Express is called xyz. In either case, you're probably better off naming the new 2008 server something different (or renaming the old server).
>> Question: Is it possible and how do i install an SQL2008 instance that i can connect to as 'xyz' NOT xyz\xyz??
No, if it is a Default instance at both locations, then you can change the hostname of both servers and use the script mentioned by om_prakash.
But since it varies between Default and Named instance, you have to connect it as xyz\xyz only..
No, if it is a Default instance at both locations, then you can change the hostname of both servers and use the script mentioned by om_prakash.
But since it varies between Default and Named instance, you have to connect it as xyz\xyz only..
ASKER
om_prakash.. i will look into the link more closely tomorrow. However the instance name is what i need it to be 'xyz'. However I can only connect to 'xyz\xyz'. 'xyz' is listed in management studio. However cant connect with details i specified when creating the instance (or any default / windows authenticaton methods). Perhaps the question should be how do it 'hack' into the xyz sql server account?
300% sure Angellll. The code is old and written in VB6. Connection details all reside in there and although the connection code can be rewritten.. i thought this would be an easier option.
Paulmacd: Both server and instance name are the same (ie.. xyz)
rrjegan17 - If im reading you correctly a named instance can only be connected to via xyz\xyz? Cant I make 'xyz' the default instance?
300% sure Angellll. The code is old and written in VB6. Connection details all reside in there and although the connection code can be rewritten.. i thought this would be an easier option.
Paulmacd: Both server and instance name are the same (ie.. xyz)
rrjegan17 - If im reading you correctly a named instance can only be connected to via xyz\xyz? Cant I make 'xyz' the default instance?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi there,
Just pointing out that Angelll has already pointed out a link which basically says what I typed out! Didn't see that before
Just pointing out that Angelll has already pointed out a link which basically says what I typed out! Didn't see that before
ASKER
Thanks Angelll / CyberKiwi - Will try an alias tomorrow and see how if i can point xyz\xyz to just xyz
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How to change SQL Server Instance Name?
http://sqldbpool.wordpress.com/2008/09/03/how-to-change-sql-server-instance-name/