Changing computer name

Can anyone advise how to change the computer name of a PC
which is running sql client with msde.
I find if I change the computer name sql server will not
start.
Any advise would be appreciated. Thanks
The following works for the default instance:
DECLARE @.old_server_name SYSNAME
DECLARE @.new_server_name SYSNAME
SET @.old_server_name = @.@.SERVERNAME
SET @.new_server_name = <your new computer name>
EXEC sp_dropserver @.server = @.old_server_name
EXEC sp_addserver @.server = @.new_server_name , @.local = 'LOCAL'
UPDATE msdb..sysjobs
SET originating_server = @.new_server_name
WHERE originating_server = @.old_server_name
You have to restart SQL Server (MSDE), and then change the computername, for
it to take effect though.
Jacco Schalkwijk
SQL Server MVP
"Elayne" <pstjw@.hotmail.com> wrote in message
news:c37501c47a33$c0d79090$a401280a@.phx.gbl...
> Can anyone advise how to change the computer name of a PC
> which is running sql client with msde.
> I find if I change the computer name sql server will not
> start.
> Any advise would be appreciated. Thanks
|||I've never experienced the SQL Server service failing to start after the
computer name was changed. What is the error you get when starting the
service from the command line (net start mssqlserver)? Are you able to
start SQL Server as console app by running "sqlservr.exe -c" from the
command line?
Regards,
Farooq Mahmud [MS SQL Support]
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Changing column size in existing databese?

I must increase column (filed) size in existing datebase but without using
Enterprise manager...(Becouse we use MSDE on our clients PCs)
The Filed is part of primary and foreign key constraints...
And every constraint has diferent index number in each database...
for example (PK_something_9e382hjl8), and I don't know how to pick this
value before "drop constraint" command....

Thank you very much...[posted and mailed, please reply in news]

Poted (dario1975@.post.hnet.hr) writes:
> I must increase column (filed) size in existing datebase but without
> using Enterprise manager...(Becouse we use MSDE on our clients PCs) The
> Filed is part of primary and foreign key constraints... And every
> constraint has diferent index number in each database... for example
> (PK_something_9e382hjl8), and I don't know how to pick this value before
> "drop constraint" command....

Moral: name your constraint explicitly according to some standardized
scheme, so you easily can find the names.

This query gives you the name of the PK for a table:

select name from sysobjects
where xtype = 'PK'
and parent_obj = object_id('tablename')

This query lists all referencing foreign key for a table:

select object_name(constid), object_name(fkeyid), col_name(fkeyid, fkey)
from sysforeignkeys
where rkeyid = object_id('depots')
order by constid, fkey

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

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

Change the location of the database files

Hi,
I would like to move my base from drive C: to drive D: .How can I do this
with MSDE (I don't have the MMC installed on the computer where I want to do
this)
Refer to following url
http://support.microsoft.com/default...en-us%3B224071
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
"Gal" <W32.virus@.wanadoo.fr> wrote in message
news:uM8J5PqMEHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> I would like to move my base from drive C: to drive D: .How can I do this
> with MSDE (I don't have the MMC installed on the computer where I want to
do
> this)
>
|||hi Gal,
"Gal" <W32.virus@.wanadoo.fr> ha scritto nel messaggio
news:uM8J5PqMEHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> I would like to move my base from drive C: to drive D: .How can I do this
> with MSDE (I don't have the MMC installed on the computer where I want to
do
> this)
you can do it detaching the desired database, moving the database files to
the new desired position a,d reattacchin the database...
log into oSql.exe..
1>EXEC sp_detach_db db_name
2>GO
move the file(s) to new location
1>EXEC sp_attach_db @.dbname = 'db_name' ,
2>@.filename1 = 'd:\:fulldatapath_of_DataFile.Mdf' ,
3>@.filename2 = 'd:\:fulldatapath_of_LogFile.Ldf'
4>GO
for your convenienence, you can have a look at a free prj of mine, available
at the link following my sign., which provide a user interface similar to
Enterprise Manager for full MSDE administration...
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Change the location of the base

Hi,
I would like to move my base from drive C: to drive D: .How can I do this
with MSDE (I don't have the MMC installed on the computer where I want to do
this)
Try this article:
http://support.microsoft.com/default...b;en-us;224071
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Gal" <W32.virus@.wanadoo.fr> wrote in message
news:ecXhZPqMEHA.2704@.TK2MSFTNGP10.phx.gbl...
Hi,
I would like to move my base from drive C: to drive D: .How can I do this
with MSDE (I don't have the MMC installed on the computer where I want to do
this)

Change sa Password in MSDE

This is a newbie question but how can I change the sa password in MSDE?
You don't have the graphical tools with MSDE that come with full blown SQL
Server versions, but you have a command line tool that is called osql. You
can run this and then change the sa password with the following SQL
statement (assuming you are logged in as sa):
EXEC sp_password '<old password>', '<new password>'
Jacco Schalkwijk
SQL Server MVP
"JohnK" <JohnK@.discussions.microsoft.com> wrote in message
news:EC4A5773-DA53-4B46-9B3B-6EDD58409012@.microsoft.com...
> This is a newbie question but how can I change the sa password in MSDE?
|||Hi John,
We've also got a tool (MSDE Manager) that's free for personal use. Details
are on our web site. It can do things like this easily.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"JohnK" <JohnK@.discussions.microsoft.com> wrote in message
news:EC4A5773-DA53-4B46-9B3B-6EDD58409012@.microsoft.com...
> This is a newbie question but how can I change the sa password in MSDE?

Change sa password error

Hi all,
I have a customer who is trying to change their sa password
in MSDE 2000 using the sp_password procedure.
When they attempt this, they are returned the following error:
Msg 552, Level 16, State 1, Server abcdef\inst, Procedure
sp_password, Line 63
CryptoAPI function 'CryptAcquireContext' failed. Error
0x80090006: Invalid
Signature.
Can anyone provide any insight into this?
From my own research it seems like there might be a problem
with their crypto library, but I am unsure of how to fix this.
Thanks
Jay
That's not exact, but close to an issue I had trying to run MSDE 2000 on NT
4.0 server. If you run MSDE 2000 on NT 4.0 with >512 MB of RAM, then
CryptoAPI functions have problems. Check out KB321459 on Microsoft.
"Jay" <anonymous@.discussions.microsoft.com> wrote in message
news:2b3d01c4a796$3f625b40$a601280a@.phx.gbl...
> Hi all,
> I have a customer who is trying to change their sa password
> in MSDE 2000 using the sp_password procedure.
> When they attempt this, they are returned the following error:
> Msg 552, Level 16, State 1, Server abcdef\inst, Procedure
> sp_password, Line 63
> CryptoAPI function 'CryptAcquireContext' failed. Error
> 0x80090006: Invalid
> Signature.
> Can anyone provide any insight into this?
> From my own research it seems like there might be a problem
> with their crypto library, but I am unsure of how to fix this.
> Thanks
> Jay
|||Yes I had already seen that KB.
I forgot to add in my original post that this is on a Win2K
server (SP4) with all latest patches.

>--Original Message--
>That's not exact, but close to an issue I had trying to
run MSDE 2000 on NT
>4.0 server. If you run MSDE 2000 on NT 4.0 with >512 MB
of RAM, then
>CryptoAPI functions have problems. Check out KB321459 on
Microsoft.
|||For the benefit of those who encounter this problem later.
Microsoft advised me to re-install IE to repair the mismatched DLL's.
I am waiting on the client to do this so I can't vouch for it's success, but
thought I would post this as it may help others in the future.
Jay
"Jay" wrote:

> Hi all,
> I have a customer who is trying to change their sa password
> in MSDE 2000 using the sp_password procedure.
>

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 ***

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.codecomments.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.codecomments.com ***

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.codecomments.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.codecomments.com ***