changing admin passwd

There is something seems strange to me that when i change the administrator password of the machine, sql server is not starting due to the problems of network.Anf forcing me to use the password that i give at the setup of win2000.Why does it occur and what do I have to do?By going to Control Pannel--->Adminsitrative Tool-->Services-->MSSQL SERVER..Double click on that and enter the new password.It should work then.

Changing "Connection String" in SSIS package ?

Hi!

I create a SSIS Package for ETL on my own machine. During development database was also on my machine. For access to this database an OLE DB connection was defined within a package in BI Development Studio. Everything worked well both in debug mode and testing package itself.

Finally I need to load data to a database on a different machine using this package.

I used several scenaries:

1) simply copied the package-file to estination machine, open it for execution, in section "Connection Managers" I edited connection string manually - changed server name and Initial Catalog. And try to execute.

2) on the destination machine I manually created an OLE DB connection (using Microsoft Data Link) to a different database (test succeded), Changed the extention of the connection file 'udl' for ' txt ' and copied its connection string to the field connection string in section "Connection Managers" (pointed in variant 1) ).

3) use Package Configurations, copied the deployment to destination machine, installed the package the way like written here - http://msdn2.microsoft.com/en-us/library/ms365338.aspx. Changed exported properties - Server name, Initial Catalog and also the whole Connection String. Also try to execute.

In all cases I recieved the same error execution message :

"Errors in the metadata manager. Either the database with ID of " OLD_DATABASE_NAME " does not exist in the server with ID of " NEW_SERVER_NAME " or the user does not have permissions to access the object."

As for access (username/pass) settings they are the same for both of them, I have the same administrative rights on both machines. And more with the same rights the ole db connection made was made manually in variant 2 - succeded!!! So I don't think the problem is here.

As for Error message - I think somewhere the OLD name of database (Initial Catalog) is saved, though I tried to change it. Though the NEW value for the server name is substituted.

Please, help me. I don't know what else can I try. And it is not a single case for my practice. So I think - something wrong in my actions.

Don't store the ConnectionString property AND all of the other properties as configurations. Store EITHER the ConnectionString property OR all of the other properties (my advice would be to store only the ConnectionString property)

-Jamie

|||

Jamie Thomson - why to store only the ConnectionString?

Then config-file will overwrite only Connection String value itself, written in the package. But other properties would not be changed, but they will also been included into the package (the content of the package is independent with what properties I decided to include into configurations. Am I right? ).

Will you explain me? Thanks.

|||

The reply, posted before Jamie Thomson's one, was very helpfull to me. I marked it as it was helpful, but suddenly your post disapeared ? Sorry, I am new to this forum, but anywhere you help me.

I tried to watch the package file in text editor, and find the property to which the old database name value was saved, then include this property to configurations to make it changable at run time.

Thanks, it works!!!!

|||

Was this the post that disappeared?

sachin.rao wrote:

Hi Iris

The only place it could be persisting this information is in the package itself. Is the catalog name being stored in the dtsx file? Open it up in your favourite text editor and check it out.

Sachin

|||

Rafael Salas - yes, it is! Thanks.

Please, tell me what I did wrong and how can I mark a post if it was helpful and/or was a reply/solution to my question.

|||For some reason that post was deleted...only the author or a moderator can do that...I don't know who did it. You should have a buton 'Mark as anserwer'...|||

IrisFresco wrote:

Jamie Thomson - why to store only the ConnectionString?

Then config-file will overwrite only Connection String value itself, written in the package. But other properties would not be changed, but they will also been included into the package (the content of the package is independent with what properties I decided to include into configurations. Am I right? ).

Will you explain me? Thanks.

Because the ConnectionString is made up of allthose individual properties (e.g. CatalogName, Username, password, ServerName etc...). Changing ConnectionString automatically changes allthe other properties. With ConnectionString you only need to maintain one thing however and I see that as an adavantage.

-Jamie

Changed machine name after SSRS installation

Hi,
I changed my machine name after installation of SSRS 2005. After the name
change, nothing seems working. To make the reports work, what and where do I
need to make the changes?
Whenever I starts reconfiguration, it says Invalid Namespace error.
Appreciate your help.
Thanks
AtulHave you checked whether the server is getting accessed from "Reporting
Services configuration" from configuration menu.
Amarnath
"Atul Shukla" wrote:
> Hi,
> I changed my machine name after installation of SSRS 2005. After the name
> change, nothing seems working. To make the reports work, what and where do I
> need to make the changes?
> Whenever I starts reconfiguration, it says Invalid Namespace error.
> Appreciate your help.
> Thanks
> Atul
>
>|||If nothing is so imp in your server then reinstall it. One more thing just try
typing http://localhost/reports this is the check recommended by MS to see
whether RS installed properly if you dont get the home page then it is not
installed properly.
Amarnath
"Atul Shukla" wrote:
> No. Whenever I try to access the reporting service configuration, I get the
> error (file attached).
> It seems that I need to re-install SQL Server.
>
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:D6758B6E-17D1-4336-85F0-CF76470D6873@.microsoft.com...
> > Have you checked whether the server is getting accessed from "Reporting
> > Services configuration" from configuration menu.
> >
> > Amarnath
> >
> > "Atul Shukla" wrote:
> >
> >> Hi,
> >>
> >> I changed my machine name after installation of SSRS 2005. After the name
> >> change, nothing seems working. To make the reports work, what and where
> >> do I
> >> need to make the changes?
> >> Whenever I starts reconfiguration, it says Invalid Namespace error.
> >>
> >> Appreciate your help.
> >> Thanks
> >> Atul
> >>
> >>
> >>
>
>

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 SSIS File System Connection

Hi,

i've been asked to move our ssis project to another machine
and i've a lot of file system connection whice i must rename them to the new path in the other machine.
there is away to rename the file system connection dynamic or i must go and rename one by one ?
thanks.You'll have to edit them one by one, but the good news is that when you are editing each one, you can use expressions to dynamically create the file path. You can also use package configurations to allow you to set the "base path" via an environment variable, XML file, etc...

You may also be able to open the .dtsx file, though, and use Search/Replace to alter the file paths.|||

Ok thanks i will use Search/Replace to alter the file paths but after it i will have to enter each package and test connection so it will work.

there is away to bypass it?

thanks.

|||Why do you have to test it so that it will work? If the file format is the same, changing the directory shouldn't have any impact.|||

what i meant was that if i move my project to another machine i have to enter each package and there enter to each connection to sql server or odbc edit them,test connection and save the package.

there is any way to skip those levels?

|||

Best solution is to take your own time and make use of config files so that you dont have to bang your head on this in future.

Also i dont think you need to change the settings for ODBC and SQL connections unless and until you plan to execute the package on a different server.

Change SQL Server registration?

I am trying to set up my machine for replication and have recieved the
following message

"SQL Server replication does not support nicknames, such as "." or
"(local)" as server names.

Delete the SQL Server registration for this server and register it
using the actual server name"

Well, I am not sure how to do that, I can't seem to find any info on
it. Can anyone help out?

Thanks.Gala Grant (gala@.sonic.net) writes:
> I am trying to set up my machine for replication and have recieved the
> following message
> "SQL Server replication does not support nicknames, such as "." or
> "(local)" as server names.
> Delete the SQL Server registration for this server and register it
> using the actual server name"
> Well, I am not sure how to do that, I can't seem to find any info on
> it. Can anyone help out?

In Enterprise Manager, right-click the server and choose Delete SQL
Server Registration. (Delete button may also work.) Then right-click the
group and then choose New SQL Server Registration. This time enter the
actual server name.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Change report server database

I install reporting service on 2 machines. Each RS has it's own report
server database. e.g. A_ReportServer for machine A and B_ReportServer for
machine B. Can I dynamically change the report server database ? i.e.
Machine A point to B_ReportServer database. If yes, how can I do this ?You can redirect A_ReportServer to point to Database B by running the
rsconfig.exe utility. Please refer to the following link for more
information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_7oft.asp
If your looking for load balancing or failover support as in load balancing
of the web servers or Sql Server failover that is available with the
enterprise edition. Check the BOL for more info about how to configure.
"May Liu" wrote:
> I install reporting service on 2 machines. Each RS has it's own report
> server database. e.g. A_ReportServer for machine A and B_ReportServer for
> machine B. Can I dynamically change the report server database ? i.e.
> Machine A point to B_ReportServer database. If yes, how can I do this ?

change pwd disconnects remote server

Hello,
I have sql personal server installed on my xp machine and have registered a
remote server called pccm-nt. I have login permissions to the server and I'm
a database user for all of the databases.
I connect to the remote sql server with my windows domain account username a
nd password. When I change my pwd I can no longer connect to the remote serv
er, pccm-nt, I usually have to remove the server and re-register it. Would s
omeone be able to tell me w
hy changing my domain password is causing this conflict?
Thanks,
ChiekoYour security token is now invalid. Logout of the domain and log back in ag
ain.|||Okay,
I'll try that but I think that I did log off and log on again.
Thanks for the help,
Chieko

change MSDE to SQL security

We have an installation that already has MSDE (SQL 2000) loaded on their
machine, so there is no enterprise manager or QA.
I need to change this to use SQL security and I need to set the sa
password.
How can I do those from the osql prompt?
Darin
*** Sent via Developersdex http://www.developersdex.com ***Darin <darin_nospam@.nospamever> wrote in news:eSrnUNgfHHA.3508
@.TK2MSFTNGP03.phx.gbl:
> We have an installation that already has MSDE (SQL 2000) loaded on their
> machine, so there is no enterprise manager or QA.
> I need to change this to use SQL security and I need to set the sa
> password.
> How can I do those from the osql prompt?
To set the password, use sp_password (described in BOL).
There is no straightforward way of using T-SQL to change the authentication
mode. It can however be done by:
- SQLDMO
- hacking the registry (e.g. see http://www.microforge.net/kb/41)
as well as using Enterprise Manager or a clone.
The non-straightforward way using T_SQL is to use the sp_OA_Create, etc
series of SPs to instantiate and manipulate an SQLDMO COM object, but I've
never tried doing this that way.|||If you mean to enable mixed security mode (i.e allowing both Windows
security and SQL Security), you can modify corresponding Windows registry
key:
1. Start "regedt32.exe"
2. Go this key:
HKEY_LOCAL_MACHINE->Software->Microsoft->MSSQLServer->MSSQLServer->LoginMode
3. Double click it to edit its value: change the "value Data" from 0 to 2
4. Click "OK" and close Registry Editor.
Now the SQL Server's mixed security mode is enabled. Disclaimer: at your own
risk to edit registry.
"Darin" <darin_nospam@.nospamever> wrote in message
news:eSrnUNgfHHA.3508@.TK2MSFTNGP03.phx.gbl...
> We have an installation that already has MSDE (SQL 2000) loaded on their
> machine, so there is no enterprise manager or QA.
> I need to change this to use SQL security and I need to set the sa
> password.
> How can I do those from the osql prompt?
>
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***