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!
 
jentc001Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Om PrakashCommented:
See if this helps

How to change SQL Server Instance Name?
http://sqldbpool.wordpress.com/2008/09/03/how-to-change-sql-server-instance-name/
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>The problem is that an application that accesses the database has connection details hardcoded to connect and pull data from the database.
what the heck? are you 200% sure there is not config file anywhere?

>Question: Is it possible and how do i install an SQL2008 instance that i can connect to as 'xyz' NOT xyz\xyz??
you might try to configure a ALIAS on the client machine (where the application runs)
http://msdn.microsoft.com/en-us/library/ms190445.aspx
0
Paul MacDonaldDirector, Information SystemsCommented:
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).
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> 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..
0
jentc001Author Commented:
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?
0
cyberkiwiCommented:
Hi there,

You can always create a SQL server alias.
Start->Run->cliconfg  (click OK)
2nd tab "Alias"
Click Add
In Server alias (top) enter whatever the hard coded name\instance was
Change network libraries if required, normally I would set to TCP/IP
In Server Name, type the real name\instance
Click OK to save

Now name\instance will refer to the real name\instance.
0
cyberkiwiCommented:
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
0
jentc001Author Commented:
Thanks Angelll / CyberKiwi - Will try an alias tomorrow and see how if i can point xyz\xyz to just xyz
0
jentc001Author Commented:
Hi All,

Fixed this by uninstalling all named instances. Reinstalled an instance using the default option as oppsed to a named instance and renamed the default database name (which i didnt know you could do) to 'xyz'. This allows me to connect to 'xyz'.

Thanks for the quick responses.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.