Changing a Connection in DTS Local packages

Many of our Local packages in Data Transformation Services has the job of
copying data from one database on one server to another database on another
server. The package typically has 2 Connections defined.
Now we want to move the "destination" database to a new server. Is there any
way this can be done without editing each package in the "Design Package"
GUI
Thanks in advance
Henrik.You can use UDL files for the connection; you can change the properties
programmatically; you can use the Dynamic Properties task to change settings
at runtime.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Henrik Hjøllund Hansen" <hh@.dlf.dk> wrote in message
news:bicqd4$2hmp$1@.news.cybercity.dk...
> Many of our Local packages in Data Transformation Services has the job of
> copying data from one database on one server to another database on
another
> server. The package typically has 2 Connections defined.
> Now we want to move the "destination" database to a new server. Is there
any
> way this can be done without editing each package in the "Design Package"
> GUI
>
> Thanks in advance
>
> Henrik.
>
>

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 the domain setting for the MS SQL 2000 Server

Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
James
To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>
|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan

>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights[vbcol=seagreen]
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in
>
>.
>
|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in

Change the domain setting for the MS SQL 2000 Server

Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesHello,
If you bring up "Services" on your Server machine and have
a look for the SQL Server service, you can change the
account though there.
Remember to stop and start it after you have finished.
Peter
"Choose a job you love, and you will never have to work a
day in your life. "
Confucius
>--Original Message--
>Hallo,
>During the installation I have to choose the proper
service accounts. On a
>form that appears, I can set the service setting to use
local system account
>or to use a domain user account.
>I would like to use the domain user account to allow
other apllication to
>query the SQL server. But latter on I would like to
change the domain.
>Where to change the domain setting before put the the SQL
srver machine in
>another domain?
>Thanks in advance
>James
>.
>|||To add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan
>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
>> Hallo,
>> During the installation I have to choose the proper
service accounts. On a
>> form that appears, I can set the service setting to use
local system
>account
>> or to use a domain user account.
>> I would like to use the domain user account to allow
other apllication to
>> query the SQL server. But latter on I would like to
change the domain.
>> Where to change the domain setting before put the the
SQL srver machine in
>> another domain?
>> Thanks in advance
>> James
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> >--Original Message--
> >To add to Peter's response, you can also change the
> service account using
> >Enterprise Manager. This will assign the account the
> advanced user rights
> >needed.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"James" <James@.discussions.microsoft.com> wrote in message
> >news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> >> Hallo,
> >>
> >> During the installation I have to choose the proper
> service accounts. On a
> >> form that appears, I can set the service setting to use
> local system
> >account
> >> or to use a domain user account.
> >> I would like to use the domain user account to allow
> other apllication to
> >> query the SQL server. But latter on I would like to
> change the domain.
> >> Where to change the domain setting before put the the
> SQL srver machine in
> >> another domain?
> >>
> >> Thanks in advance
> >>
> >> James
> >>
> >
> >
> >.
> >

Change the domain setting for the MS SQL 2000 Server

Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesTo add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan

>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in[vbcol=seagreen]
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in

change SQLSERVERAGENT account

are there any issues to be aware of when changing the SQLSERVERAGENT
service's account to LOCAL SYSTEM or to a domain account with local "Log on
as a service" privilege ?
in other words, at time of install of SQL Server 2000, the SQLSERVERAGENT
account was specified to be the domain account for a specific user, and now
I'd like to change it ...
Domain accounts are often used if the Service need permissions in the
network. Perhpas you installed a SQMail on the Server ? That runs with the
associated MAPI account of the user which is configured on the SQL Server.
Perhpas you are pulling ot some data from a torage which has NTFS file
security ? You will need these sort of accounts then too. So first you have
to make sure that there are not issues around when you change the account to
a local system or a service account
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"John Grandy" <johnagrandy-at-yahoo-dot-com> schrieb im Newsbeitrag
news:OHWCD0fSFHA.3188@.TK2MSFTNGP09.phx.gbl...
> are there any issues to be aware of when changing the SQLSERVERAGENT
> service's account to LOCAL SYSTEM or to a domain account with local "Log
> on as a service" privilege ?
> in other words, at time of install of SQL Server 2000, the SQLSERVERAGENT
> account was specified to be the domain account for a specific user, and
> now I'd like to change it ...
>
|||"John Grandy" wrote:

> are there any issues to be aware of when changing the SQLSERVERAGENT
> service's account to LOCAL SYSTEM or to a domain account with local "Log on
> as a service" privilege ?
>
Hello, I'm in a similar situation - I want to use SQL Mail on my sql server,
and according to do so, it appears I need to change the account associated
with MSSQLSERVER, so that it has an email address, and I'm hesitant to do so
before I can be sure I won't spill anything, as this server runs our
accounting system, and integrates via biztalk to our CRM system.
Are there any things I should be aware of that any of you know about? The
only complexity I can think of is the Biztalk thing.

change SQLSERVERAGENT account

are there any issues to be aware of when changing the SQLSERVERAGENT
service's account to LOCAL SYSTEM or to a domain account with local "Log on
as a service" privilege ?
in other words, at time of install of SQL Server 2000, the SQLSERVERAGENT
account was specified to be the domain account for a specific user, and now
I'd like to change it ...Domain accounts are often used if the Service need permissions in the
network. Perhpas you installed a SQMail on the Server ? That runs with the
associated MAPI account of the user which is configured on the SQL Server.
Perhpas you are pulling ot some data from a torage which has NTFS file
security ? You will need these sort of accounts then too. So first you have
to make sure that there are not issues around when you change the account to
a local system or a service account
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"John Grandy" <johnagrandy-at-yahoo-dot-com> schrieb im Newsbeitrag
news:OHWCD0fSFHA.3188@.TK2MSFTNGP09.phx.gbl...
> are there any issues to be aware of when changing the SQLSERVERAGENT
> service's account to LOCAL SYSTEM or to a domain account with local "Log
> on as a service" privilege ?
> in other words, at time of install of SQL Server 2000, the SQLSERVERAGENT
> account was specified to be the domain account for a specific user, and
> now I'd like to change it ...
>|||"John Grandy" wrote:
> are there any issues to be aware of when changing the SQLSERVERAGENT
> service's account to LOCAL SYSTEM or to a domain account with local "Log on
> as a service" privilege ?
>
Hello, I'm in a similar situation - I want to use SQL Mail on my sql server,
and according to do so, it appears I need to change the account associated
with MSSQLSERVER, so that it has an email address, and I'm hesitant to do so
before I can be sure I won't spill anything, as this server runs our
accounting system, and integrates via biztalk to our CRM system.
Are there any things I should be aware of that any of you know about? The
only complexity I can think of is the Biztalk thing.

Change SQL Instance name to default(local) instrance

I found some information, but, it didn't work.
Now, i open the enterprise manager, and My SQL Server name is
DENNIS\DENNISDB(windows NT), but i want to change this name to default
name(local), when i installed sql, i changed the instance name, i want
default name.
I used this method.
EXEC sp_dropserver 'DENNISDB'
go
EXEC sp_addserver 'DENNIS', 'local'
go
and i restart SQL Server Service and,
SELECT CONVERT(char(20), SERVERPROPERTY('servername'))
result : DENNIS\DENNIDB
select @.@.SERVERNAME
result : DENNIS
But, stil Instance name On My Enterprize Manager is DENNIS\DENNISDB, I want
"(local)" instance
Help me plase..Hi
As far as I know you cannot change/switch a default instance with a named
one. Re-install SQL Server only.
"DennisLee" <ddongdog@.haja.or.kr.korea> wrote in message
news:ONofqOsMGHA.2320@.TK2MSFTNGP11.phx.gbl...
>I found some information, but, it didn't work.
> Now, i open the enterprise manager, and My SQL Server name is
> DENNIS\DENNISDB(windows NT), but i want to change this name to default
> name(local), when i installed sql, i changed the instance name, i want
> default name.
> I used this method.
>
> EXEC sp_dropserver 'DENNISDB'
> go
> EXEC sp_addserver 'DENNIS', 'local'
> go
> and i restart SQL Server Service and,
> SELECT CONVERT(char(20), SERVERPROPERTY('servername'))
> result : DENNIS\DENNIDB
> select @.@.SERVERNAME
> result : DENNIS
> But, stil Instance name On My Enterprize Manager is DENNIS\DENNISDB, I
> want
> "(local)" instance
> Help me plase..
>
>

Change ReportServer database

We have installed Reporting Services on a new server using the local
database. Now we want to point to a ReportServer database on another
database server.
How can we change the server used for the ReportServer database to point to
a different server?
Thanks
--
RickIn SQL 2005:
Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
Tools/Reporting Services Configuration
This will open the Reporting Services Configuration Manager. Choose
"Database Setup" from the left column and set the server and database name.
In SQL 2000 run the following (see
http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
-p<password>
<ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
authentication of the service account SQLRS will use to connect to the
ReportServer database <UserName> & <Password> is the name/password of the
service account mentioned above.
Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
rsconfig can be found in the C:\Program Files\Microsoft SQL
Server\80\Tools\Binn folder.
This assumes that the report services db is a restore of the original. If
it's different then it get's a little more complicated as encryption keys and
versions need to match.
"Rick" wrote:
> We have installed Reporting Services on a new server using the local
> database. Now we want to point to a ReportServer database on another
> database server.
> How can we change the server used for the ReportServer database to point to
> a different server?
> Thanks
> --
> Rick|||Thanks.
--
Rick
"Limey" wrote:
> In SQL 2005:
> Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
> Tools/Reporting Services Configuration
> This will open the Reporting Services Configuration Manager. Choose
> "Database Setup" from the left column and set the server and database name.
> In SQL 2000 run the following (see
> http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
> rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
> -p<password>
> <ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
> authentication of the service account SQLRS will use to connect to the
> ReportServer database <UserName> & <Password> is the name/password of the
> service account mentioned above.
> Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
> rsconfig can be found in the C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn folder.
> This assumes that the report services db is a restore of the original. If
> it's different then it get's a little more complicated as encryption keys and
> versions need to match.
>
>
> "Rick" wrote:
> > We have installed Reporting Services on a new server using the local
> > database. Now we want to point to a ReportServer database on another
> > database server.
> >
> > How can we change the server used for the ReportServer database to point to
> > a different server?
> >
> > Thanks
> > --
> > Rick

Change of NT password user affect to service

Dear all,
Whenever that I change my password on domain NT, then MSSQLSERVER
service failed (local sql server of course). So that I've got to enter in
that service
and update the password manually on LOG ON flap.
At the same time when I open my enterprise manager not appears all those
Network Sql Serverthat before I had. '?
I would like to have automatically this change.
Any help will be welcomed,
Thanks in advance,Enric,
That means that the service is using your account and every time you change
your password, you have to update the service.
Why you do not create an account just for the service?
See "Setting up Windows Services Accounts" in BOL.
AMB
"Enric" wrote:

> Dear all,
> Whenever that I change my password on domain NT, then MSSQLSERVER
> service failed (local sql server of course). So that I've got to enter in
> that service
> and update the password manually on LOG ON flap.
> At the same time when I open my enterprise manager not appears all those
> Network Sql Serverthat before I had. '?
> I would like to have automatically this change.
> Any help will be welcomed,
> Thanks in advance,|||It is better to create a special service account rather than using your own
for SQL Server services.
Hope this helps.
Dan Guzman
SQL Server MVP
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:DEF51AED-F720-46A1-9512-EBEE6E6DBFA2@.microsoft.com...
> Dear all,
> Whenever that I change my password on domain NT, then MSSQLSERVER
> service failed (local sql server of course). So that I've got to enter in
> that service
> and update the password manually on LOG ON flap.
> At the same time when I open my enterprise manager not appears all those
> Network Sql Serverthat before I had. '
> I would like to have automatically this change.
> Any help will be welcomed,
> Thanks in advance,|||Local System Account?
take care,
"Dan Guzman" wrote:

> It is better to create a special service account rather than using your ow
n
> for SQL Server services.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:DEF51AED-F720-46A1-9512-EBEE6E6DBFA2@.microsoft.com...
>
>|||Enric,
He meant a "domain user account".
AMB
"Enric" wrote:
> Local System Account?
> take care,
> "Dan Guzman" wrote:
>|||You could use the build-in Local System account if access to network
resources isn't needed (e.g. backup to UNC). As Alejandro suggested, I was
thinking of a domain account since this is apparently what you are currently
using.
Hope this helps.
Dan Guzman
SQL Server MVP
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:E2E61BAB-6C00-4B9A-AC44-FCD759E22E6E@.microsoft.com...
> Local System Account?
> take care,
> "Dan Guzman" wrote:
>