Change what machine name (local) points to

I imaged my machine and moved that image to a new machine with a different
machine name. Now I try to create a database in Local and receive the
following error:
"Could not obtain exclusive lock on database 'MODEL'. Retry operation
later. CREATE Database failed. Some file names could not be created. Check
previous errors."
I'm useing SQL Server 2000 on an XP machine.
Has anyone seen a problem like this before?
Nevermind, had to re-register the local server then restart the service. I
missed the service part...
It's fixed.
"nate axtell" <naxtell at progeny dot net> wrote in message
news:Ob6COEl$EHA.2700@.TK2MSFTNGP14.phx.gbl...
>I imaged my machine and moved that image to a new machine with a different
>machine name. Now I try to create a database in Local and receive the
>following error:
> "Could not obtain exclusive lock on database 'MODEL'. Retry operation
> later. CREATE Database failed. Some file names could not be created.
> Check previous errors."
> I'm useing SQL Server 2000 on an XP machine.
> Has anyone seen a problem like this before?
>

Change what machine name (local) points to

I imaged my machine and moved that image to a new machine with a different
machine name. Now I try to create a database in Local and receive the
following error:
"Could not obtain exclusive lock on database 'MODEL'. Retry operation
later. CREATE Database failed. Some file names could not be created. Check
previous errors."
I'm useing SQL Server 2000 on an XP machine.
Has anyone seen a problem like this before?Nevermind, had to re-register the local server then restart the service. I
missed the service part...
It's fixed.
"nate axtell" <naxtell at progeny dot net> wrote in message
news:Ob6COEl$EHA.2700@.TK2MSFTNGP14.phx.gbl...
>I imaged my machine and moved that image to a new machine with a different
>machine name. Now I try to create a database in Local and receive the
>following error:
> "Could not obtain exclusive lock on database 'MODEL'. Retry operation
> later. CREATE Database failed. Some file names could not be created.
> Check previous errors."
> I'm useing SQL Server 2000 on an XP machine.
> Has anyone seen a problem like this before?
>

Change what machine name (local) points to

I imaged my machine and moved that image to a new machine with a different
machine name. Now I try to create a database in Local and receive the
following error:
"Could not obtain exclusive lock on database 'MODEL'. Retry operation
later. CREATE Database failed. Some file names could not be created. Check
previous errors."
I'm useing SQL Server 2000 on an XP machine.
Has anyone seen a problem like this before?Nevermind, had to re-register the local server then restart the service. I
missed the service part...
It's fixed.
"nate axtell" <naxtell at progeny dot net> wrote in message
news:Ob6COEl$EHA.2700@.TK2MSFTNGP14.phx.gbl...
>I imaged my machine and moved that image to a new machine with a different
>machine name. Now I try to create a database in Local and receive the
>following error:
> "Could not obtain exclusive lock on database 'MODEL'. Retry operation
> later. CREATE Database failed. Some file names could not be created.
> Check previous errors."
> I'm useing SQL Server 2000 on an XP machine.
> Has anyone seen a problem like this before?
>

Change Table Ownership.

I have a DB that I moved to another server recently and in the process we
created a new user/pass combination.
All the tables for the main app are listed as "system" and the main app runs
great.
There is a secondary app using 12 tables in the DB and although we changed
the user/pass in the app and it connects fine the app won't run saying
"Invalid object name 'tablename'."
The table is there. The only thing I notice that seems odd is the tables are
listed as "user" and not "system" and the user assigned is the old user.
How can I either,
A. change what user owns the table? or,
B. Change it from a "user" table to a "system" table?
Thanks for any replies.
Check out sp_changeobjectowner in BOL.
"Jim" <Jim@.abc.com> wrote in message
news:OX%234ZddPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I have a DB that I moved to another server recently and in the process we
> created a new user/pass combination.
> All the tables for the main app are listed as "system" and the main app
runs
> great.
> There is a secondary app using 12 tables in the DB and although we changed
> the user/pass in the app and it connects fine the app won't run saying
> "Invalid object name 'tablename'."
> The table is there. The only thing I notice that seems odd is the tables
are
> listed as "user" and not "system" and the user assigned is the old user.
> How can I either,
> A. change what user owns the table? or,
> B. Change it from a "user" table to a "system" table?
>
> Thanks for any replies.
>
>
>
|||System tables are there for SQL to run properly. User tables are what you
put information into. You don't need to or want to change a user table to a
system table.
You probably do need to change the owner of the tables. Look up
sp_changeobjectowner on BOL (Books On-Line) for exact instructions on how to
do this.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jim" <Jim@.abc.com> wrote in message
news:OX%234ZddPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I have a DB that I moved to another server recently and in the process we
> created a new user/pass combination.
> All the tables for the main app are listed as "system" and the main app
runs
> great.
> There is a secondary app using 12 tables in the DB and although we changed
> the user/pass in the app and it connects fine the app won't run saying
> "Invalid object name 'tablename'."
> The table is there. The only thing I notice that seems odd is the tables
are
> listed as "user" and not "system" and the user assigned is the old user.
> How can I either,
> A. change what user owns the table? or,
> B. Change it from a "user" table to a "system" table?
>
> Thanks for any replies.
>
>
>
|||> "Invalid object name 'tablename'."
Have you tried explicitly naming the object? e.g. dbo.tablename?
Also see http://www.aspfaq.com/2284
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
|||Thanks for the replies guys.
What I did was ran into the lazy GUI method.

>EM>Design Table>relationships icon from the top>Table tab> Change
ownership.
All set, app is behaving again.
Thanks.
"Jim" <Jim@.abc.com> wrote in message
news:OX%234ZddPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I have a DB that I moved to another server recently and in the process we
> created a new user/pass combination.
> All the tables for the main app are listed as "system" and the main app
runs
> great.
> There is a secondary app using 12 tables in the DB and although we changed
> the user/pass in the app and it connects fine the app won't run saying
> "Invalid object name 'tablename'."
> The table is there. The only thing I notice that seems odd is the tables
are
> listed as "user" and not "system" and the user assigned is the old user.
> How can I either,
> A. change what user owns the table? or,
> B. Change it from a "user" table to a "system" table?
>
> Thanks for any replies.
>
>
>

Change Table Ownership.

I have a DB that I moved to another server recently and in the process we
created a new user/pass combination.
All the tables for the main app are listed as "system" and the main app runs
great.
There is a secondary app using 12 tables in the DB and although we changed
the user/pass in the app and it connects fine the app won't run saying
"Invalid object name 'tablename'."
The table is there. The only thing I notice that seems odd is the tables are
listed as "user" and not "system" and the user assigned is the old user.
How can I either,
A. change what user owns the table? or,
B. Change it from a "user" table to a "system" table?
Thanks for any replies.Check out sp_changeobjectowner in BOL.
"Jim" <Jim@.abc.com> wrote in message
news:OX%234ZddPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I have a DB that I moved to another server recently and in the process we
> created a new user/pass combination.
> All the tables for the main app are listed as "system" and the main app
runs
> great.
> There is a secondary app using 12 tables in the DB and although we changed
> the user/pass in the app and it connects fine the app won't run saying
> "Invalid object name 'tablename'."
> The table is there. The only thing I notice that seems odd is the tables
are
> listed as "user" and not "system" and the user assigned is the old user.
> How can I either,
> A. change what user owns the table? or,
> B. Change it from a "user" table to a "system" table?
>
> Thanks for any replies.
>
>
>|||System tables are there for SQL to run properly. User tables are what you
put information into. You don't need to or want to change a user table to a
system table.
You probably do need to change the owner of the tables. Look up
sp_changeobjectowner on BOL (Books On-Line) for exact instructions on how to
do this.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jim" <Jim@.abc.com> wrote in message
news:OX%234ZddPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I have a DB that I moved to another server recently and in the process we
> created a new user/pass combination.
> All the tables for the main app are listed as "system" and the main app
runs
> great.
> There is a secondary app using 12 tables in the DB and although we changed
> the user/pass in the app and it connects fine the app won't run saying
> "Invalid object name 'tablename'."
> The table is there. The only thing I notice that seems odd is the tables
are
> listed as "user" and not "system" and the user assigned is the old user.
> How can I either,
> A. change what user owns the table? or,
> B. Change it from a "user" table to a "system" table?
>
> Thanks for any replies.
>
>
>|||> "Invalid object name 'tablename'."
Have you tried explicitly naming the object? e.g. dbo.tablename?
Also see http://www.aspfaq.com/2284
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Thanks for the replies guys.
What I did was ran into the lazy GUI method.
>EM>Design Table>relationships icon from the top>Table tab> Change
ownership.
All set, app is behaving again.
Thanks.
"Jim" <Jim@.abc.com> wrote in message
news:OX%234ZddPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I have a DB that I moved to another server recently and in the process we
> created a new user/pass combination.
> All the tables for the main app are listed as "system" and the main app
runs
> great.
> There is a secondary app using 12 tables in the DB and although we changed
> the user/pass in the app and it connects fine the app won't run saying
> "Invalid object name 'tablename'."
> The table is there. The only thing I notice that seems odd is the tables
are
> listed as "user" and not "system" and the user assigned is the old user.
> How can I either,
> A. change what user owns the table? or,
> B. Change it from a "user" table to a "system" table?
>
> Thanks for any replies.
>
>
>

Change Table Ownership.

I have a DB that I moved to another server recently and in the process we
created a new user/pass combination.
All the tables for the main app are listed as "system" and the main app runs
great.
There is a secondary app using 12 tables in the DB and although we changed
the user/pass in the app and it connects fine the app won't run saying
"Invalid object name 'tablename'."
The table is there. The only thing I notice that seems odd is the tables are
listed as "user" and not "system" and the user assigned is the old user.
How can I either,
A. change what user owns the table? or,
B. Change it from a "user" table to a "system" table?
Thanks for any replies.Check out sp_changeobjectowner in BOL.
"Jim" <Jim@.abc.com> wrote in message
news:OX%234ZddPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I have a DB that I moved to another server recently and in the process we
> created a new user/pass combination.
> All the tables for the main app are listed as "system" and the main app
runs
> great.
> There is a secondary app using 12 tables in the DB and although we changed
> the user/pass in the app and it connects fine the app won't run saying
> "Invalid object name 'tablename'."
> The table is there. The only thing I notice that seems odd is the tables
are
> listed as "user" and not "system" and the user assigned is the old user.
> How can I either,
> A. change what user owns the table? or,
> B. Change it from a "user" table to a "system" table?
>
> Thanks for any replies.
>
>
>|||System tables are there for SQL to run properly. User tables are what you
put information into. You don't need to or want to change a user table to a
system table.
You probably do need to change the owner of the tables. Look up
sp_changeobjectowner on BOL (Books On-Line) for exact instructions on how to
do this.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jim" <Jim@.abc.com> wrote in message
news:OX%234ZddPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I have a DB that I moved to another server recently and in the process we
> created a new user/pass combination.
> All the tables for the main app are listed as "system" and the main app
runs
> great.
> There is a secondary app using 12 tables in the DB and although we changed
> the user/pass in the app and it connects fine the app won't run saying
> "Invalid object name 'tablename'."
> The table is there. The only thing I notice that seems odd is the tables
are
> listed as "user" and not "system" and the user assigned is the old user.
> How can I either,
> A. change what user owns the table? or,
> B. Change it from a "user" table to a "system" table?
>
> Thanks for any replies.
>
>
>|||> "Invalid object name 'tablename'."
Have you tried explicitly naming the object? e.g. dbo.tablename?
Also see http://www.aspfaq.com/2284
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Thanks for the replies guys.
What I did was ran into the lazy GUI method.

>EM>Design Table>relationships icon from the top>Table tab> Change
ownership.
All set, app is behaving again.
Thanks.
"Jim" <Jim@.abc.com> wrote in message
news:OX%234ZddPEHA.3300@.TK2MSFTNGP09.phx.gbl...
> I have a DB that I moved to another server recently and in the process we
> created a new user/pass combination.
> All the tables for the main app are listed as "system" and the main app
runs
> great.
> There is a secondary app using 12 tables in the DB and although we changed
> the user/pass in the app and it connects fine the app won't run saying
> "Invalid object name 'tablename'."
> The table is there. The only thing I notice that seems odd is the tables
are
> listed as "user" and not "system" and the user assigned is the old user.
> How can I either,
> A. change what user owns the table? or,
> B. Change it from a "user" table to a "system" table?
>
> Thanks for any replies.
>
>
>

Change servername

Hi,
I moved jobs from a server to a new one with dts. However I cannot delete,
edit, enable, ... these jobs. If I try so I get the following error:
14274 Cannot add, update, or delete a job (or its steps or schedules) that
originated from an MSX server.
We changed the name of the server after it was installed from 'EDIFRAME-' to
'EDIFRAME'.
If I do SELECT @.@.SERVERNAME the result is 'EDIFRAME-' (This is the old
temporary name)
How can I change the servername because I think this is the problem?
Thanks in advance for any help.
Jo Segers.http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jo Segers" <segers_jo@.hotmail.com> wrote in message news:e$AuIrvpEHA.1712@.tk2msftngp13.phx.gbl...
> Hi,
> I moved jobs from a server to a new one with dts. However I cannot delete,
> edit, enable, ... these jobs. If I try so I get the following error:
> 14274 Cannot add, update, or delete a job (or its steps or schedules) that
> originated from an MSX server.
> We changed the name of the server after it was installed from 'EDIFRAME-' to
> 'EDIFRAME'.
> If I do SELECT @.@.SERVERNAME the result is 'EDIFRAME-' (This is the old
> temporary name)
> How can I change the servername because I think this is the problem?
> Thanks in advance for any help.
> Jo Segers.
>|||Thanks for the information, this solved my problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:eT7K37vpEHA.2900@.TK2MSFTNGP12.phx.gbl...
> http://www.karaszi.com/SQLServer/info_change_server_name.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Jo Segers" <segers_jo@.hotmail.com> wrote in message
news:e$AuIrvpEHA.1712@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I moved jobs from a server to a new one with dts. However I cannot
delete,
> > edit, enable, ... these jobs. If I try so I get the following error:
> >
> > 14274 Cannot add, update, or delete a job (or its steps or schedules)
that
> > originated from an MSX server.
> >
> > We changed the name of the server after it was installed from
'EDIFRAME-' to
> > 'EDIFRAME'.
> >
> > If I do SELECT @.@.SERVERNAME the result is 'EDIFRAME-' (This is the old
> > temporary name)
> >
> > How can I change the servername because I think this is the problem?
> >
> > Thanks in advance for any help.
> >
> > Jo Segers.
> >
> >
>

Change servername

Hi,
I moved jobs from a server to a new one with dts. However I cannot delete,
edit, enable, ... these jobs. If I try so I get the following error:
14274 Cannot add, update, or delete a job (or its steps or schedules) that
originated from an MSX server.
We changed the name of the server after it was installed from 'EDIFRAME-' to
'EDIFRAME'.
If I do SELECT @.@.SERVERNAME the result is 'EDIFRAME-' (This is the old
temporary name)
How can I change the servername because I think this is the problem?
Thanks in advance for any help.
Jo Segers.
http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jo Segers" <segers_jo@.hotmail.com> wrote in message news:e$AuIrvpEHA.1712@.tk2msftngp13.phx.gbl...
> Hi,
> I moved jobs from a server to a new one with dts. However I cannot delete,
> edit, enable, ... these jobs. If I try so I get the following error:
> 14274 Cannot add, update, or delete a job (or its steps or schedules) that
> originated from an MSX server.
> We changed the name of the server after it was installed from 'EDIFRAME-' to
> 'EDIFRAME'.
> If I do SELECT @.@.SERVERNAME the result is 'EDIFRAME-' (This is the old
> temporary name)
> How can I change the servername because I think this is the problem?
> Thanks in advance for any help.
> Jo Segers.
>
|||Thanks for the information, this solved my problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:eT7K37vpEHA.2900@.TK2MSFTNGP12.phx.gbl...
> http://www.karaszi.com/SQLServer/inf...erver_name.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Jo Segers" <segers_jo@.hotmail.com> wrote in message
news:e$AuIrvpEHA.1712@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
delete,[vbcol=seagreen]
that[vbcol=seagreen]
'EDIFRAME-' to
>

change reporting services location (2000)

hi,
our reporting services DB moved and I need to tell the report manager where to find it
isn't it in a config file somewhere, i can't find it?
do i have to reinstall?RSConfig -c -s Server name -d Reporting Services database name -a Sql|Windows -u User name -p User password

nevermind guys|||hrmm it still wont work, says it cant find the db

ugh...|||ok im talking to myself...

now a different microsoft sites says i cannot specify a named instance with this utility... but it let me install it like that (go figure)

now what, i guess i have to reinstall|||hrmm it still wont work, says it cant find the db

ugh...
See the Report Server database can be installed on only one instance of SQL Server per physical database sever computer. The database need not reside on the local Report Server computer but the server must be a member of the Windows domain or a server trusted by the domain.So somebody has moved it and if your reportings were okay so you can easily understand its on the member or a trusted domain.If your reports are not working its better to install it again.|||the ip address of the server changed, so really i shouldnt have to do anything - BUT, they did not open the port that allows dynamic ports to be found (UDP 1434). so i have to redo it and specify the port number i.e. Server\Instance, Port.

the ms website says rsconfig does not support named instances, but the installation GUI did, so that does not make sense

i do not want to reinstall it, it will be a pain, the rsconfig utility should support named instances otherwise what is the point