Rename SQL Server 2005 Virtual Server

Hi everybody,
I'm having a big problem when I want to rename my Failover Clustered SQL
Server 2005 Virtual Server. I've followed the indications given in this
how-to: http://msdn2.microsoft.com/en-us/library/ms178083.aspx but when I
try to bring my SQL Server online (after changing the network name, of
course...) I get this error:
[sqsrvres] GetRegKeyAccessMask: Could not get registry access mask for
registry key Software\Microsoft\Microsoft SQL Server\MSSQL.3\Cluster (status
0))
If I return back to the Virtual Server's old name I can bring SQL Server
online allright...
I've found no information about this error. Can anybody help me?
Thanks in advance,
Petrus
Create the following regkey:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsof t SQL Server\MSSQL.3\Cluster]
"ClusterName"="<NewVirtualServerName>"
I had the same problem, and MSSQL.3 referred to Reporting Services. I'm guessing that since Reporting Services isn't cluster aware, the parameters aren't updated (or even created). But when SQL starts all its instances up, it gets confused that the parameter isn't there to change.
However, this still didn't have the desired result for me. The database engine and the OLAP services were MSSQL.4 and .5 respectively. The cooresponding Cluster keys as above continually renamed themselves back to the old name.
-Tom Kretzmer
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
|||Sorry to post an update so soon. Just update MSSQL.4 and .5 on both nodes of the cluster and restart resources. For some reason "select @.@.servername" still comes up as the old instance name, but everything else works as it should.
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Rename a Database

Hi everybody
I have a question
Could you tell me How can i do to renae a database?
thanks for all
best regardsYou can use the ALTER DATABASE command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:4F639024-6CBE-448C-A765-95E00BA33034@.microsoft.com...
> Hi everybody
> I have a question
> Could you tell me How can i do to renae a database?
> thanks for all
> best regards|||Thanks Tibor, but Could you send me a example please,
best regards
"Tibor Karaszi" escribió:
> You can use the ALTER DATABASE command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ivan" <Ivan@.discussions.microsoft.com> wrote in message
> news:4F639024-6CBE-448C-A765-95E00BA33034@.microsoft.com...
> > Hi everybody
> > I have a question
> > Could you tell me How can i do to renae a database?
> >
> > thanks for all
> >
> > best regards
>
>|||I would use the sp_rename stored procedure:
EXEC sp_rename 'old_name', 'new_name', 'DATABASE'
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:F510612C-A655-44C8-9F96-3B1E93739CC0@.microsoft.com...
> Thanks Tibor, but Could you send me a example please,
> best regards
> "Tibor Karaszi" escribió:
> > You can use the ALTER DATABASE command.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Ivan" <Ivan@.discussions.microsoft.com> wrote in message
> > news:4F639024-6CBE-448C-A765-95E00BA33034@.microsoft.com...
> > > Hi everybody
> > > I have a question
> > > Could you tell me How can i do to renae a database?
> > >
> > > thanks for all
> > >
> > > best regards
> >
> >
> >|||I suggest you get familiar with checking up syntax in Books Online:
ALTER DATABASE dbname MODIFY name = newdbname
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:F510612C-A655-44C8-9F96-3B1E93739CC0@.microsoft.com...
> Thanks Tibor, but Could you send me a example please,
> best regards
> "Tibor Karaszi" escribió:
>> You can use the ALTER DATABASE command.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Ivan" <Ivan@.discussions.microsoft.com> wrote in message
>> news:4F639024-6CBE-448C-A765-95E00BA33034@.microsoft.com...
>> > Hi everybody
>> > I have a question
>> > Could you tell me How can i do to renae a database?
>> >
>> > thanks for all
>> >
>> > best regards
>>|||Sp_rename is for objects. You are probably thinking of sp_renamedb. As of SQL Server 2000, MS
recommend us using ALTER DATABASE instead of sp_renamedb.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
news:%230HkU83PFHA.3156@.TK2MSFTNGP15.phx.gbl...
>I would use the sp_rename stored procedure:
> EXEC sp_rename 'old_name', 'new_name', 'DATABASE'
> "Ivan" <Ivan@.discussions.microsoft.com> wrote in message
> news:F510612C-A655-44C8-9F96-3B1E93739CC0@.microsoft.com...
>> Thanks Tibor, but Could you send me a example please,
>> best regards
>> "Tibor Karaszi" escribió:
>> > You can use the ALTER DATABASE command.
>> >
>> > --
>> > Tibor Karaszi, SQL Server MVP
>> > http://www.karaszi.com/sqlserver/default.asp
>> > http://www.solidqualitylearning.com/
>> >
>> >
>> > "Ivan" <Ivan@.discussions.microsoft.com> wrote in message
>> > news:4F639024-6CBE-448C-A765-95E00BA33034@.microsoft.com...
>> > > Hi everybody
>> > > I have a question
>> > > Could you tell me How can i do to renae a database?
>> > >
>> > > thanks for all
>> > >
>> > > best regards
>> >
>> >
>> >
>|||Thanks very much Ron I appreciate your help
best regards
"Ron Hinds" escribió:
> I would use the sp_rename stored procedure:
> EXEC sp_rename 'old_name', 'new_name', 'DATABASE'
> "Ivan" <Ivan@.discussions.microsoft.com> wrote in message
> news:F510612C-A655-44C8-9F96-3B1E93739CC0@.microsoft.com...
> > Thanks Tibor, but Could you send me a example please,
> >
> > best regards
> >
> > "Tibor Karaszi" escribió:
> >
> > > You can use the ALTER DATABASE command.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "Ivan" <Ivan@.discussions.microsoft.com> wrote in message
> > > news:4F639024-6CBE-448C-A765-95E00BA33034@.microsoft.com...
> > > > Hi everybody
> > > > I have a question
> > > > Could you tell me How can i do to renae a database?
> > > >
> > > > thanks for all
> > > >
> > > > best regards
> > >
> > >
> > >
>
>

Removing User Right Assignments form SQL-Server Account

Hello everybody,
I'm currently securing a w2k box according to some recommendations
made by a company that audited our server.
Now among their recommendations is to remove the following rights from
the sql-server account. (The SQL Server runs under its own 'user
account' and in mixed mode)
According to them I should remove these permissions:
- Act as part of the Operating System
- Replace a process level token
- Increase quotas
- Log on as batch job
- Log on as service
I've browsed the web and found some documents, however none could
really answer which SQL-Features depend on these services.
Maybe someone in this forum has some experience or helpful urls.
Thanks very much.
the document:
SQL Server 2000 C2 Administrator's and User's Security Guide
at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/security/sqlc2.asp
somehow mentions that these four services are necessary, but not why.
* Act as part of the operating system.
* Increase quotas.
* Replace a process-level token.
* Log on as a service.Hallo Beat(e) M=FCller,
at first you must NOT REMOVE the right
- Log on as service (The sql-Server does not start anymore!)
second the others you may try but I do not suggest it. Please look at
http://www.microsoft.com/sql/techinfo/administration/2000/s
ecurity/securingsqlserver.asp
there are useful tipps to securing the sql-Server
- Log on as a batch job (removable depends on your Envoirement - !CHECK! does your sqlserver service use a start batch?)
- the others will be used for internal tuning and interaction - I you REALLY must to remove them try it on your on risk!
CU Ralf