how to change SS name ?

i set the name of my ss to default on install, and now i want to use 'AttachDbFilename' to attach my dbfile in my asp.net app, but i cannot connect to the server. i fond in the adv. options, that the DataSource is set to '.\SQLEXPRESS' which is not the name of my SS, but i can't change it, so i want to ask if i can change the name of my SS withou reinstall.

thx for helping!

No you can not change Instance name... u have to reinstall it... BTW why u can not change the connection string...

Madhu

|||

it's not the connection string, i have not get yet, because i can not pass the test.

when i select the file, i click the test button, and got a fail message. i click the advence button, and i found that the DataSource is set the .\SQLEXPRESS, it's a dropdown list, in which you can choose DataSources, but you can't type in...

|||

\SQLEXPRESS is the default server name for an instance of SQL Server 2005 Express.

Are you sure that is not your server name?

Please post the complete error messages.

|||

well, i have reinstall SQL, and i can't remember the original error message, i can show you a step-by-step about how i get this problem

in vs.net(i use web dev), open the 'database explorer'-->'add connection'-->click 'change' atop of the dialog box-->select 'microsoft sql server database file'-->click 'advance' on the bottom of the dialog box-->in 'source' section, find 'datasource', you will see it's a drop-down list, so you can select the SS you want to use, but you can't type in. so if you install SS, and set the modal to 'default', rather than 'named instance', you cant find you'r SS here