Monday, March 26, 2012

Named Instances Problem (I Think)

I'm struggling a little with this. I hope someone can help.

Ho do i install SQL Server 2005 Express so i can connect to it with "localhost", not "<MACHINE_NAME>/SQLEXPRESS". I cant seem to find any obvious setting in setup.

Could anyone shed any light on this?

Regards,

Anthony

I think you want to connect only to default instance in that case just specify the instance name as default while installing sql express refer, http://msdn2.microsoft.com/en-us/library/ms143722.aspx

|||

You can use an alias configured on the clients to connect to the name only. See the BOL for more information about configuring aliases. You will have to use the SQL Server configuration manager.

Jens K. Suessmeyer

http://www.sqlserver2005.de

No comments:

Post a Comment