Changing sa SQL 2005

I have changed my sa password on the database SQL 2005. I have also changed the DOMAIN\Account account from our Active Directory.

Then I went into SQL Server Configuration Manager and changed the SQL Server Broswer to the new DOMAIN\Account and I also changed the SQL Server Agent (MSSQLSERVER) to the new DOMAIN\Account.

Now I think I got everything covered. But my jobs are failing. Even though the Owner of the Job is DOMAIN\Account i get a

".. Description: System.Runtime.InteropServices.COMException (0x80040E4D): Login failed for user 'sa'. ..."

thank you

Check the job to see if it is running as sa and if it is make sure that the password is the same as the password you selected for sa when you changed it.

HTH,

-Steven Gott

SDE/T

SQL Server

Changing sa SQL 2005

I have changed my sa password on the database SQL 2005. I have also changed the DOMAIN\Account account from our Active Directory.

Then I went into SQL Server Configuration Manager and changed the SQL Server Broswer to the new DOMAIN\Account and I also changed the SQL Server Agent (MSSQLSERVER) to the new DOMAIN\Account.

Now I think I got everything covered. But my jobs are failing. Even though the Owner of the Job is DOMAIN\Account i get a

".. Description: System.Runtime.InteropServices.COMException (0x80040E4D): Login failed for user 'sa'. ..."

thank you

Check the job to see if it is running as sa and if it is make sure that the password is the same as the password you selected for sa when you changed it.

HTH,

-Steven Gott

SDE/T

SQL Server

Changing package's owner

Dear All,
Previosly we were using NT 4.0 domain called Domain_A. Recently we imployed
Active Directory and moved all domain accounts to a new domain, Domain_B. We
are using SQL Server 2000 database installed on Win 2K box. Programers are
connecting to SQL Server with trusted connection. When User_A (programer's
account) created a package, the owner of the package appeared as User_A.
Now, the new account of the same user is User_B. I changed owner in the
"owner" field in table "sysdtspackages", from User_A to User_B, so the owner
of the same package appears as User_B. Now, the problem is that User_B can
not save its own package - where owner is User_B, but previously was User_A.
Pops up a message that only sysadmins and owners can make changes to the
package (allthow User_B appears to be an owner).
Did anyone encountered this kind of problem?
Thanks in advance.
BilBil
Try
sp_reassign_dtspackageowner [@.name =] 'name',
[@.id =] 'id',
[@.newloginname =] 'newloginname'
"Bil" <biljanat@.nbrm.gov.mk> wrote in message
news:%23BepIEK0EHA.1204@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Previosly we were using NT 4.0 domain called Domain_A. Recently we
imployed
> Active Directory and moved all domain accounts to a new domain, Domain_B.
We
> are using SQL Server 2000 database installed on Win 2K box. Programers are
> connecting to SQL Server with trusted connection. When User_A (programer's
> account) created a package, the owner of the package appeared as User_A.
> Now, the new account of the same user is User_B. I changed owner in the
> "owner" field in table "sysdtspackages", from User_A to User_B, so the
owner
> of the same package appears as User_B. Now, the problem is that User_B can
> not save its own package - where owner is User_B, but previously was
User_A.
> Pops up a message that only sysadmins and owners can make changes to the
> package (allthow User_B appears to be an owner).
> Did anyone encountered this kind of problem?
> Thanks in advance.
> Bil
>|||Uri,
Thank you very much. This resolved my problem. This is undocumented stored
procedure.
Thanks a lot.
Regards,
Bil
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23MHRBHK0EHA.3072@.TK2MSFTNGP11.phx.gbl...
> Bil
> Try
> sp_reassign_dtspackageowner [@.name =] 'name',
> [@.id =] 'id',
> [@.newloginname =] 'newloginname'
>
>
> "Bil" <biljanat@.nbrm.gov.mk> wrote in message
> news:%23BepIEK0EHA.1204@.TK2MSFTNGP10.phx.gbl...
> imployed
> We
> owner
> User_A.
>

Changing directory where database files are stored

Hi

After install the mdf and log files are stored in the Program Files directory tree.

How do I change the place were they are stored to a path of my own choice, so that new DBs get created there too?

I've looked though the docs, but I can't find this.

Thanks

John

You cna change this using Management Studio Express in the Server Properties dialog.

Mike

Changing default directory for stored procedures

I want to change the default directory for my stored procedures. It is extremely inconvenient for me that they are placed in \documents and settings\... I cannot find a place in the Tools where I can change it.

Thanks.

hi,

stored procedures are not "saved" to file in your \doc & settings\ folder...

stored procedures are saved in the database they have been created in..

only "queries" are saved by SQL Server Management Studio (Express as well) in that folder, and I quiet sure you can not modify that folder..

regards

|||

Thank you Andrea.

Then what can I do about this, I would say, serious problem?

I make a modification in my stored procedure, and try to save it. The only options I am given is to save a "Query1" (it may be Query23" or something) or "save as."

Let's say I saved it. Then I close the SQLEXPRESS and open it up again. Go to my stored procedure and cannot find my changes.

Now it does not seem to happen every time but so annoyingly often that I cannot see any pattern to change my behavior accordingly.

I have about a dozen queries now saved. I actually have only 3 stored procedures I am working with now, one per a database. When I open them up in notepad I can see my old stored procedures (in spite of what you just said) some of them with chaotic changes I made days ago when I did not know what I was doing.

I try to keep track of the disorder. I recall that working with one database I saved a procedure as "Query1." I go to another database where I need to remove a bug from a similar stored procedure, open it and it appears as "Query1" AGIAN. But inside it does not look like my previous Query1 which I just saved. So I am afraid to modify it because I may wipe out the change I made in my previous database a minute ago.

It is a madhouse. It is just a bunch of nonsense as I see it.

I need clarity.

Thanks.

|||

Alex,

Execute it to persist (drop existing first if any)

Save it for your reference and for executing later on demand. IOW you're saving code (like a prg in VFP).

|||Thank you, Cetin.

Changing data directory

How to change data directory for all databeses including system ones
(master, temdb etc.)
Can't do it by update sysfiles because (I can't figure why) this object
cannot be modified -
Regards
Piotr
Inidivisual database names can be changed via detaching and attaching,
chaging the path of the system databases needs a registry hack for that,
because the service will start them.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"piotr" <ksswd@.poczta.fm> schrieb im Newsbeitrag
news:eqXDppacFHA.2736@.TK2MSFTNGP12.phx.gbl...
> How to change data directory for all databeses including system ones
> (master, temdb etc.)
> Can't do it by update sysfiles because (I can't figure why) this object
> cannot be modified -
> Regards
> Piotr
>
|||In the registry I can only change master database path and I can't detach
model, tempdb nor msdb databases
Piotr
Uytkownik "Jens Smeyer"
<Jens@.Remove_this_For_Contacting.sqlserver2005.de> napisa w wiadomoci
news:%23YK9K2acFHA.2756@.tk2msftngp13.phx.gbl...
> Inidivisual database names can be changed via detaching and attaching,
> chaging the path of the system databases needs a registry hack for that,
> because the service will start them.
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "piotr" <ksswd@.poczta.fm> schrieb im Newsbeitrag
> news:eqXDppacFHA.2736@.TK2MSFTNGP12.phx.gbl...
>
|||hi Piotr,
piotr wrote:
> In the registry I can only change master database path and I can't
> detach model, tempdb nor msdb databases
>
please have a look at http://support.microsoft.com/kb/224071/EN-US/
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Finally made it, thanks a lot.
Uytkownik "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> napisa w
wiadomoci news:3has31Ffpu70U1@.individual.net...
> hi Piotr,
> piotr wrote:
> please have a look at http://support.microsoft.com/kb/224071/EN-US/
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>