Rename SQL Default instance in cluster

HI GROUP
I have my production sql server computer name "sql2k"
and of course the default sql instant name as "sql2k"
because they're running on same box aand stand alone
server.
I do have another active\active sql cluster in place
node1 name is sql1 node 2 name sql2 and virtual computer
name sqlcluster. My default sql instance name
is "sqlserver1"
and it running on Node1 with failed over using Node 2
My sql second instance name is "sql/server2" and it
running on Node 2 with failed over using Node1.
I would like to rename my "sqlserver1" sql instance name to
my production sql name is "sql2k, my plan is to uninstall
the sql default instant on node 1 and reinstall sql with
the my sql production name after shutdown my prodution sql
server. my question is do I need to rename the computer
virtual server name too or just sql instance name?
Do any one have any idea what will cause any problem to
rename sql instance in cluster and of course the cluster
will have diff ip address with sql production server
only the name will be transfer to my default cluster on
node 1. Please give me any opinion if you have with this
Thanks a lot
You can't rename a SQL Server instance in a cluster. The only way to
accomplish this is to uninstall SQL Server and reinstall it. There aren't
any issues to doing this that I'm aware of. Just keep the name under 13
chanracters.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||Thanks
But I would like to transfer production sql name to the
default sql cluster name is it possible?
I know I can not have 2 sql name in the same network
but what if I shutdown my production and during the
reinstall sql on defaukt cluster Can I use my production
sql name for it? I still not clear if sql name using any
dns or wins like computer name on network if that the case
then where do I need to look for do a clean up of that name
before using it for my cluster?
Thanks a lot

>--Original Message--
>You can't rename a SQL Server instance in a cluster. The
only way to
>accomplish this is to uninstall SQL Server and reinstall
it. There aren't
>any issues to doing this that I'm aware of. Just keep
the name under 13
>chanracters.
>--
>Mike
>Principal Mentor
>Solid Quality Learning
>"More than just Training"
>SQL Server MVP
>http://www.solidqualitylearning.com
>http://www.mssqlserver.com
>
>.
>
|||Yes, you can reuse that name as long as the original server is offline. The
names that you use for the machine, cluster, and SQL Server are DNS
resolvable.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

rename aspnetdb ?

Hello,

I have a shared hosting plan which already has aspnetdb.mdf on the server so of course I cannot use that db name for my site...

I have renamed the db and now I get an errorCould not find stored procedure 'dbo.aspnet_CheckSchemaVersion

My question is, how can I make this thing work? All help is greatly appreciated!

Hello my friend,

The aspnet.mdf database is intended for development and testing only, not for production due to performance reasons. When moving into production, you should change your site to use a real full heavyweight SQL Server database. Besides the aspnet tables existing in a different database, there is virtually no difference in terms of the application so you do not need to worry about changing your pages/code. I assume your different sites that you will be hosting will use different databases so this problem you are having will not occur when this has been sorted.

Kind regards

Scotty

|||

Scotty,

Ok, so let's say that what you say is true... how do you get all of the membership and users from aspnetdb into another db so that it can be used with my SQL Enterprise edition or any other for that matter

thanks!

|||

Hello again my friend,

I usually give the full answer to questions instead of referring to urls but I feel the following url demonstrates it better than I have time to explain: -

http://www.beansoftware.com/ASP.NET-Tutorials/Security-Features.aspx

You might find it useful to take advantage of the ApplicationName property if you wish the different sites that you are hosting to use the same database. Personally, I would always use a a separate database for each application.

Kind regards

Scotty

|||

Scotty,

So far so good... I haven't uploaded the new db yet but I have a feeling that this will work...

Question: where does the machine.config come into play on the hosting/production server?

Is that something that needs to be ftp'd over also?

KS

|||

Hello again my friend,

If you have installed .NET on the production server, the machine.config file should be there already. You should not need to change any settings in here. Besides, if you did, you override them using your web.config file in your website.

Machine.config is the top of the tree, its contents apply to all applications. When you create an application, you can overrule these settings by specifying settings in your web.config file. Further down, a web.config file in a subfolder of your application can overrule some settings in your web.config file in your application's root folder. This can go several subfolders deep. Finally, a web page in a folder can overrule some settings in the web.config file of that folder. One such setting is whether to use debugging or not.

Kind regards

Scotty

|||

Scotty,

Alright... sounds good... well, I have uploaded the site and db and now I am getting the error:

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

I am not sure what that means other than a connection was not made somewhere...

Maybe my connection string is wrong:

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="ConnectionString" connectionString="Server=(local);Database=mff;User ID=xxxx;Password=xxxx;" />
<add name="LocalSqlServer" connectionString="Server=(local);Database=mff;User ID=xxxx;Password=xxxx;" />

</connectionStrings>

I am just not sure... let me know what you think

|||

Hello again,

Have you tried logging on to the SQL Server Management Studio/Enterprise Manager directly with the same credentials that you are using in the web.config? Do this to test the connection, it could be a SQL Server issue; wrong username or password. When you get it working directly, then try it with the website. If you are ever unsure about connection strings, a good resource on this iswww.connectionstrings.com.

Kind regards

Scotty

|||

I can't figure out how to give the database a user and password... maybe that is some of the problem...

When I log into SQL Server I do not need any password or user it is set to windows authentication

thanks for all your help bro'

|||

Scotty,

Alright... I got into the db using the credentials and it appears that I can get in fine, BUT when I do... there are no tables... what is going on there? Any ideas?

Kevin

|||

Hi - I have the exact same problem, i.e. have been learning and designing a site using membershio, so default database (ASPNETDB.MDF) created.

All working fine on loical PC but just signed up with hosting company and tried to create database but told that ASPNETDB.MDF already in use, so I have to rename my membership database.

After reading the correspondence on this topic, I still don't understand what I need to do.

Are you saying that with the SQL Express 2005 edition I can't get it to use a different name for the default database?

Are you saying that with a different SQL version (which one - the Developer edition for $49?) that I can?

With whatever version I need, is it a complicated job (remember - I'm a beginner).

I'd really appreciate feedback on this.

Regards,

Garrett

|||

Garrett,

Are you uploading your db directly onto a server as an mdf file OR are you scripting this db to a hosting account? If you are scripting this db to a host, which I assume you are, this will be as simple as changing the name of the db via the script before scripting to the host...

let me know

|||

I understand all that now.

I posted the same question in a different part of the forum and got the response I needced.

http://forums.asp.net/p/1200251/2087698.aspx#2087698

Thanks to everyone for the help.

Garrett