Changing collation when installing SQL2000

Hi,
I'm installing SQL2000 on a new cluster server.
I selected a 'custom installation' and was presented with a
'Collation settings' screen.
I need it to be SQL_Latin1_General_CP1_CI_AS collation
as I will be restoring databases with this collation.
What should I choose from the 'Collation designator' and 'SQL
Collations' box.
Is it 'Dictionary order, case-insensitive, for use with 1252
characters'?

What will be the default? Will it be the same default as for the
'typical' installation?
Thanks(polinaskulski@.aol.com) writes:
> I'm installing SQL2000 on a new cluster server.
> I selected a 'custom installation' and was presented with a
> 'Collation settings' screen.
> I need it to be SQL_Latin1_General_CP1_CI_AS collation
> as I will be restoring databases with this collation.
> What should I choose from the 'Collation designator' and 'SQL
> Collations' box.
> Is it 'Dictionary order, case-insensitive, for use with 1252
> characters'?

I would guess that is be the one, although the description also fits into
SQL_Latin1_General_CP1_CI_AI.

When you install Window collations, there are check-boxes for the
sensitivity stuff, but there might not be for SQL collations. (I
never install these.)

> What will be the default? Will it be the same default as for the
> 'typical' installation?

I believe that SQL_Latin1_General_CP1_CI_AS is the default is your
regional settings is English (USA).

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

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

Changes to SQL 2000 Server Properties Don't "Stick"

Hello,
I have a new installation of SQL 2000 (via SBS 2003). When it was originally
setup, "Windows Only" security was configured. Using the "Server Properties
" dialog in Enterprise Manager, I tried changing it to "Windows and SQL", bu
t the changes don't "stick"
after clicking OK. I tried some other general changes (for example: min/max
memory) and none of the changes I make are stored after clicking OK.
Has anyone run across this before?
ThanksHi,
I have not encountered this sort of sitiuations before,
For changing the Memory and other parameters please try executing
SP_CONFIGURE procedure (Look books online for info).
For changing the Authentication mode you have to change the registry entry
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\Microsoft SQL
Server\HARISQL\MSSQLServer]
Change the value for "LoginMode" to 2 for SQL server and Windows , AFter
this restart SQL server sevice and verify the status.
Thanks
Hari
MCDBA
"FJOHN" <anonymous@.discussions.microsoft.com> wrote in message
news:A9887B4F-FFD3-4E7A-B465-210476166479@.microsoft.com...
> Hello,
> I have a new installation of SQL 2000 (via SBS 2003). When it was
originally setup, "Windows Only" security was configured. Using the "Server
Properties" dialog in Enterprise Manager, I tried changing it to "Windows
and SQL", but the changes don't "stick" after clicking OK. I tried some
other general changes (for example: min/max memory) and none of the changes
I make are stored after clicking OK.
> Has anyone run across this before?
> Thanks|||It sounds like the login that SQL Server is running under may NOT have
permissions to alter the registry keys for SQL Server...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"FJOHN" <anonymous@.discussions.microsoft.com> wrote in message
news:A9887B4F-FFD3-4E7A-B465-210476166479@.microsoft.com...
> Hello,
> I have a new installation of SQL 2000 (via SBS 2003). When it was
originally setup, "Windows Only" security was configured. Using the "Server
Properties" dialog in Enterprise Manager, I tried changing it to "Windows
and SQL", but the changes don't "stick" after clicking OK. I tried some
other general changes (for example: min/max memory) and none of the changes
I make are stored after clicking OK.
> Has anyone run across this before?
> Thankssql

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 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 SQL Server 2000 Ent to Standard

How do I change a SQL Server 2000 Enterprise Edition
installation to a SQL Server 2000 Standard Edition
installation?Hi,
You need to remove sql enterprise edition and install sql standard edition.
You could do the below steps:-
1. Backup and databases (can be used if attach fails)
2. detach all the databases from sql enterrise edition
3. Remove sql enterprise edition and install sql standard with same
directory structure
4. Apply the same service pack level
5. Attach the MDF and LDF files back in standard edition.
If attach fails you could restore the database using the backup files
performed in step-1
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
> How do I change a SQL Server 2000 Enterprise Edition
> installation to a SQL Server 2000 Standard Edition
> installation?|||Thanks Hari. I was hoping for some sort of "upgrade"
functionality, but if that is the only way....
>--Original Message--
>Hi,
>You need to remove sql enterprise edition and install sql
standard edition.
>You could do the below steps:-
>1. Backup and databases (can be used if attach fails)
>2. detach all the databases from sql enterrise edition
>3. Remove sql enterprise edition and install sql standard
with same
>directory structure
>4. Apply the same service pack level
>5. Attach the MDF and LDF files back in standard edition.
>If attach fails you could restore the database using the
backup files
>performed in step-1
>
>Thanks
>Hari
>MCDBA
>"Pooh" <anonymous@.discussions.microsoft.com> wrote in
message
>news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
>> How do I change a SQL Server 2000 Enterprise Edition
>> installation to a SQL Server 2000 Standard Edition
>> installation?
>
>.
>|||Hi Pooh,
You should also look at this...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;268361
Peter
>--Original Message--
>Thanks Hari. I was hoping for some sort of "upgrade"
>functionality, but if that is the only way....
>>--Original Message--
>>Hi,
>>You need to remove sql enterprise edition and install
sql
>standard edition.
>>You could do the below steps:-
>>1. Backup and databases (can be used if attach fails)
>>2. detach all the databases from sql enterrise edition
>>3. Remove sql enterprise edition and install sql
standard
>with same
>>directory structure
>>4. Apply the same service pack level
>>5. Attach the MDF and LDF files back in standard edition.
>>If attach fails you could restore the database using the
>backup files
>>performed in step-1
>>
>>Thanks
>>Hari
>>MCDBA
>>"Pooh" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
>> How do I change a SQL Server 2000 Enterprise Edition
>> installation to a SQL Server 2000 Standard Edition
>> installation?
>>
>>.
>.
>|||Hi Pooh,
You have to perform the manual steps (My previous post) to downgrade from
SQL Enterprise edition to SQL Standard Edition.
But the upgrade from Standard to Enterprise edition can be done directly
using the SQL server Enterprise edition CD.
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:436a01c47fab$18ec6fe0$a401280a@.phx.gbl...
> Thanks Hari. I was hoping for some sort of "upgrade"
> functionality, but if that is the only way....
> >--Original Message--
> >Hi,
> >
> >You need to remove sql enterprise edition and install sql
> standard edition.
> >
> >You could do the below steps:-
> >
> >1. Backup and databases (can be used if attach fails)
> >2. detach all the databases from sql enterrise edition
> >3. Remove sql enterprise edition and install sql standard
> with same
> >directory structure
> >4. Apply the same service pack level
> >5. Attach the MDF and LDF files back in standard edition.
> >
> >If attach fails you could restore the database using the
> backup files
> >performed in step-1
> >
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >"Pooh" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
> >> How do I change a SQL Server 2000 Enterprise Edition
> >> installation to a SQL Server 2000 Standard Edition
> >> installation?
> >
> >
> >.
> >

Change SMTP server AFTER installation

How do I change SMTP server info AFTER installation? ThanksLook in the RSReportServer.config file for the SMTPServer element.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"VNN" <VNN@.hotmail.com> wrote in message
news:el2iio8BFHA.3376@.TK2MSFTNGP12.phx.gbl...
> How do I change SMTP server info AFTER installation? Thanks
>

Change product key of SQL Server 2005

Is there any way to change product key after installation of SQL Server 2005 or must be SQL Server reinstalled. We have used wrong one for our customer because carelessness. Any problem if customer use product with old product key, but have a legal licence for product?

Hi,

see if you can change that:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\ProductID

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hello,

thanks for answer but it seem be that ProductID is other value like Product Key. Also other format. I found in

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\CurrentVersion a value SerialNumber. But for now is emtpy. Not know if this right place to do this.

Any other suggestion ?

thanks

Anton Kalcik

|||Is the Product Key that's installed with the product from the same distribution channel as the real key (i.e. both are retail products or both are volume licenses)?|||

No it was not. Installation was from MSDN, but customer licence was from reseller. But we have reinstalled SQL Server 2005, so that meet licence agreement. But thanks for help.

Anton Kalcik

Change of default path while creating New DB

Hi,
while creating new database and setting the Data and Log file by
default it shows the default path (based on SQL Server Installation) .
If we want to change the path we will be able to change. But while creating
Data and Log file i want the the default path it shows to some other default
path.
Please give me the solution as early as possible
Thanks,
HerbertHi
Enterprise Manager
Click on the Server
Right click
Select properties
Database Settings Tab
Change the values 2/3 of the way down the page "new database default
location".
From that point onwards, new databases created use those paths.
Regards
Mike
"Herbert" wrote:
> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while creating
> Data and Log file i want the the default path it shows to some other default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert|||server propeties->database settings->def. data&log dir?
I think this settings stored somewhere in the registry.
"Herbert" wrote:
> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while creating
> Data and Log file i want the the default path it shows to some other default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert|||Hi,
CHange the value for the below registry keys.
For a SQL 2000 default instance, the default folders are stored in the
registry under:
HKEY_LOCAL_MACHINE\SOFTWARE\Mi­crosoft\MSSQLServer\MSSQLServer\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\Mi­crosoft\MSSQLServer\MSSQLServer\DefaultLog
For named Instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Mi­crosoft\Microsoft SQL Server\[Instance
Name]\MSSQLServer\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\Mi­crosoft\Microsoft SQL Server\[Instance
Name]\MSSQLServer\DefaultLog
Enterprise Manager:-
These can be viewed/changed with Enterprise Manager (server properties -->
database settings). This will also update the registry.
Thanks
Hari
SQL Server MVP
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:95A73C48-62BB-4264-B121-2D3FB8D4E4D7@.microsoft.com...
> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while
> creating
> Data and Log file i want the the default path it shows to some other
> default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert

Change of default path while creating New DB

Hi,
while creating new database and setting the Data and Log file by
default it shows the default path (based on SQL Server Installation) .
If we want to change the path we will be able to change. But while creating
Data and Log file i want the the default path it shows to some other default
path.
Please give me the solution as early as possible
Thanks,
Herbert
Hi
Enterprise Manager
Click on the Server
Right click
Select properties
Database Settings Tab
Change the values 2/3 of the way down the page "new database default
location".
From that point onwards, new databases created use those paths.
Regards
Mike
"Herbert" wrote:

> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while creating
> Data and Log file i want the the default path it shows to some other default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert
|||server propeties->database settings->def. data&log dir?
I think this settings stored somewhere in the registry.
"Herbert" wrote:

> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while creating
> Data and Log file i want the the default path it shows to some other default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert
|||Hi,
CHange the value for the below registry keys.
For a SQL 2000 default instance, the default folders are stored in the
registry under:
HKEY_LOCAL_MACHINE\SOFTWARE\MiXcrosoft\MSSQLServer \MSSQLServer\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\MiXcrosoft\MSSQLServer \MSSQLServer\DefaultLog
For named Instance:
HKEY_LOCAL_MACHINE\SOFTWARE\MiXcrosoft\Microsoft SQL Server\[Instance
Name]\MSSQLServer\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\MiXcrosoft\Microsoft SQL Server\[Instance
Name]\MSSQLServer\DefaultLog
Enterprise Manager:-
These can be viewed/changed with Enterprise Manager (server properties -->
database settings). This will also update the registry.
Thanks
Hari
SQL Server MVP
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:95A73C48-62BB-4264-B121-2D3FB8D4E4D7@.microsoft.com...
> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while
> creating
> Data and Log file i want the the default path it shows to some other
> default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert

Change of default path while creating New DB

Hi,
while creating new database and setting the Data and Log file by
default it shows the default path (based on SQL Server Installation) .
If we want to change the path we will be able to change. But while creating
Data and Log file i want the the default path it shows to some other defaul
t
path.
Please give me the solution as early as possible
Thanks,
HerbertHi
Enterprise Manager
Click on the Server
Right click
Select properties
Database Settings Tab
Change the values 2/3 of the way down the page "new database default
location".
From that point onwards, new databases created use those paths.
Regards
Mike
"Herbert" wrote:

> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while creatin
g
> Data and Log file i want the the default path it shows to some other defa
ult
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert|||server propeties->database settings->def. data&log dir?
I think this settings stored somewhere in the registry.
"Herbert" wrote:

> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while creatin
g
> Data and Log file i want the the default path it shows to some other defa
ult
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert|||Hi,
CHange the value for the below registry keys.
For a SQL 2000 default instance, the default folders are stored in the
registry under:
HKEY_LOCAL_MACHINE\SOFTWARE\Mi_crosoft\M
SSQLServer\MSSQLServer\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\Mi_crosoft\M
SSQLServer\MSSQLServer\DefaultLog
For named Instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Mi_crosoft\M
icrosoft SQL Server\[Instance
Name]\MSSQLServer\DefaultData
HKEY_LOCAL_MACHINE\SOFTWARE\Mi_crosoft\M
icrosoft SQL Server\[Instance
Name]\MSSQLServer\DefaultLog
Enterprise Manager:-
These can be viewed/changed with Enterprise Manager (server properties -->
database settings). This will also update the registry.
Thanks
Hari
SQL Server MVP
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:95A73C48-62BB-4264-B121-2D3FB8D4E4D7@.microsoft.com...
> Hi,
> while creating new database and setting the Data and Log file by
> default it shows the default path (based on SQL Server Installation) .
> If we want to change the path we will be able to change. But while
> creating
> Data and Log file i want the the default path it shows to some other
> default
> path.
> Please give me the solution as early as possible
> Thanks,
> Herbert

Change Named to Default Instance

We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
installation. The SQL 2K install is running under the default instance and
therefore to install the SQL 2005 we will need to run it under a named
instance. After the SQL 2005 has been configured and we are confident the DB
is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
default instance. Can anyone describe the steps need to do this. We want to
avoid having to re-write a lot of connetion strings in client applications
which would require is to re-deploy those apps.
Thanks in advance.
RTYou cannot change instance name, nor from a default to a named instance (or other way around). One
option is to install 2005 again, as a named instance (after removing 2000). Then copy the databases
(backup/restore, detach/attach, for instance). But there are extra steps handling the data inside
the system databases, though...
Or, handle this on the client machines:
Either change the connection string.
Or, create an alias for the named instance, with only the machine name as the alias name.
(Basically, rename it seen from the client's perspective.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005 the
> default instance. Can anyone describe the steps need to do this. We want to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT|||Hi,
To add on to Tibor; you could use the automated upgrade of sql 2000 to sql
2005. steps
1. Take a complete backup of sql 2000 (including system databases)
2. Run the SQL 2005 setup program
3. This will automatically upgrades the existing SQL 2000 to SQL 2005
4. After the completion of the upgrade the existing SQL 2000 will be
upgraded to SQL 2005 with the same server name
5. After this there will not be any connecting string chnages
The only this incase of issues; you may need to install SQL 2000 and restore
all the databases backed up...
Take a look into:-
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
Thanks
Hari
"RT" <RT@.discussions.microsoft.com> wrote in message
news:2BD744AB-1A64-4F49-8FE5-9A388A52B72D@.microsoft.com...
> We are looking to install SQL 2005 Standard next to a SQL 2000 Enterprise
> installation. The SQL 2K install is running under the default instance and
> therefore to install the SQL 2005 we will need to run it under a named
> instance. After the SQL 2005 has been configured and we are confident the
> DB
> is how we want it we want to uninstall the SQL 2K and make the SQL 2005
> the
> default instance. Can anyone describe the steps need to do this. We want
> to
> avoid having to re-write a lot of connetion strings in client applications
> which would require is to re-deploy those apps.
> Thanks in advance.
> RT|||Sorry to use an existing post but when I try to start a new thread, nothing
happends.
I just reinstalled SQL Server 2000. During the install. I used the default
Server name of GATEWAY_COMPUTE. Now when I try to start SQL Server, the
Server name comes up as GATEWAY_COMPUTE, services is SQL Server. When I
click start I receive error message ' The service did not start due to a
login failure'.
Can someone tell me how to correct this?

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