Changing the MSSQLServer service account causes SQL Agent could not start

Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
running either a domain account or local system account, i.e.
MSSQLServer service is under a domain account, SQL Agent is under
local system.
For a reason, we need to switch the domain account to the other domain
account, the MSSQLServer service is started up with no problem but the
SQL Agent is not able to start up neither in local system or new
domain account, the error message is: "The SQL Server Agent
(MSSQLSERVER) service on Local Computer started and then stop
automatically if they have no work to do, for example, the Performance
Logs and Alerts service. "
Switch back to original domain account is fine, let the MSSQLServer
running on local system account is fine too for both MSSQLServer and
SQL Agent.
P.S. Both old/new domain accounts are in the server's local admin and
domain administrator groups and as well as SQL sa.
What is needed to use a domain account as the SQL service account?
Thanks,
Yvette.
Hi Yvette
"yvette.ye@.gmail.com" wrote:

> Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
> running either a domain account or local system account, i.e.
> MSSQLServer service is under a domain account, SQL Agent is under
> local system.
> For a reason, we need to switch the domain account to the other domain
> account, the MSSQLServer service is started up with no problem but the
> SQL Agent is not able to start up neither in local system or new
> domain account, the error message is: "The SQL Server Agent
> (MSSQLSERVER) service on Local Computer started and then stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts service. "
> Switch back to original domain account is fine, let the MSSQLServer
> running on local system account is fine too for both MSSQLServer and
> SQL Agent.
> P.S. Both old/new domain accounts are in the server's local admin and
> domain administrator groups and as well as SQL sa.
> What is needed to use a domain account as the SQL service account?
> Thanks,
> Yvette.
>
For the account types that can be used see
http://support.microsoft.com/kb/907557
and http://support.microsoft.com/kb/283811 describes the requirements for
the accounts if you don't use EM or SCM to change the account.
John
|||"John Bell" wrote:

> Hi Yvette
> For the account types that can be used see
> http://support.microsoft.com/kb/907557
> and http://support.microsoft.com/kb/283811 describes the requirements for
> the accounts if you don't use EM or SCM to change the account.
> John
Also try http://msdn2.microsoft.com/en-us/library/ms143504.aspx
John

Changing the MSSQLServer service account causes SQL Agent could not start

Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
running either a domain account or local system account, i.e.
MSSQLServer service is under a domain account, SQL Agent is under
local system.
For a reason, we need to switch the domain account to the other domain
account, the MSSQLServer service is started up with no problem but the
SQL Agent is not able to start up neither in local system or new
domain account, the error message is: "The SQL Server Agent
(MSSQLSERVER) service on Local Computer started and then stop
automatically if they have no work to do, for example, the Performance
Logs and Alerts service. "
Switch back to original domain account is fine, let the MSSQLServer
running on local system account is fine too for both MSSQLServer and
SQL Agent.
P.S. Both old/new domain accounts are in the server's local admin and
domain administrator groups and as well as SQL sa.
What is needed to use a domain account as the SQL service account?
Thanks,
Yvette.Hi Yvette
"yvette.ye@.gmail.com" wrote:
> Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
> running either a domain account or local system account, i.e.
> MSSQLServer service is under a domain account, SQL Agent is under
> local system.
> For a reason, we need to switch the domain account to the other domain
> account, the MSSQLServer service is started up with no problem but the
> SQL Agent is not able to start up neither in local system or new
> domain account, the error message is: "The SQL Server Agent
> (MSSQLSERVER) service on Local Computer started and then stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts service. "
> Switch back to original domain account is fine, let the MSSQLServer
> running on local system account is fine too for both MSSQLServer and
> SQL Agent.
> P.S. Both old/new domain accounts are in the server's local admin and
> domain administrator groups and as well as SQL sa.
> What is needed to use a domain account as the SQL service account?
> Thanks,
> Yvette.
>
For the account types that can be used see
http://support.microsoft.com/kb/907557
and http://support.microsoft.com/kb/283811 describes the requirements for
the accounts if you don't use EM or SCM to change the account.
John|||"John Bell" wrote:
> Hi Yvette
> For the account types that can be used see
> http://support.microsoft.com/kb/907557
> and http://support.microsoft.com/kb/283811 describes the requirements for
> the accounts if you don't use EM or SCM to change the account.
> John
Also try http://msdn2.microsoft.com/en-us/library/ms143504.aspx
John

Changing the logical name of a DB

Hi,
I recently restored one DB over another different one in order to import a
template of data into a new DB. I did this in Enterprise Manager. The gui
allowed me to change the physical file path & name to match the destination
file, but didn't allow me to change the logical name.
How can I now change the logical file names of the data & log files?
Many thanks for any help
You should do your best to learn the DDL equivalents of pointing and
clicking in the GUI, for two reasons: (a) you can easily store your scripts
in source control, and (b) you will have access to parts of the
functionality that didn't make it into the interface. Try this in Query
Analyzer:
ALTER DATABASE Database_Name
MODIFY FILE
(
NAME = Logical_Name,
NEWNAME = NEW_Logical_Name
);
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help
|||> How can I now change the logical file names of the data & log files?
You can use ALTER DATABASE...MODIFY FILE. For example:
ALTER DATABASE AdventureWorks
MODIFY FILE (
NAME='AdventureWorks_Data',
NEWNAME='AdventureWorks_Data_New')
See ALTER DATABASE in the Books Online for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help
|||Hello Dan,
Thank you very much for your help here.
Cheers
Ant
"Dan Guzman" wrote:

> You can use ALTER DATABASE...MODIFY FILE. For example:
> ALTER DATABASE AdventureWorks
> MODIFY FILE (
> NAME='AdventureWorks_Data',
> NEWNAME='AdventureWorks_Data_New')
> See ALTER DATABASE in the Books Online for details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>
|||What version are you running?
In SQL 2000 you cannot change the logical file names.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help
|||Hi Kalen,
Thanks for the reply but in fact it appears you can. I am using SQL 2000 &
have successfully changed the logical name simply by using the Alter table
modify file statement I was given above. It worked fine!
Thank you any way for your input on this though.
Cheer
Ant
"Kalen Delaney" wrote:

> What version are you running?
> In SQL 2000 you cannot change the logical file names.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>
>
|||Hi, Kalen.

> What version are you running?
> In SQL 2000 you cannot change the logical file names.
Perhaps you are thinking of SQL 7. IIRC, the ability to change the logical
names was introduced in SQL 2000.
Hope this helps.
Dan Guzman
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23dlcDj1UIHA.5980@.TK2MSFTNGP04.phx.gbl...
> What version are you running?
> In SQL 2000 you cannot change the logical file names.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>
|||You're right... as Dan indicated it was actually SQL 7, when the new files
structures and ALTER DATABASE command were first introduced, that there was
no way to change the logical name.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:B2DD5503-5FC5-4B16-8B3B-C38655367FDF@.microsoft.com...[vbcol=seagreen]
> Hi Kalen,
> Thanks for the reply but in fact it appears you can. I am using SQL 2000 &
> have successfully changed the logical name simply by using the Alter table
> modify file statement I was given above. It worked fine!
> Thank you any way for your input on this though.
> Cheer
> Ant
> "Kalen Delaney" wrote:
|||Thanks, Dan.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:C6D04793-D874-4B42-A440-ED117325CE42@.microsoft.com...
> Hi, Kalen.
>
> Perhaps you are thinking of SQL 7. IIRC, the ability to change the
> logical names was introduced in SQL 2000.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:%23dlcDj1UIHA.5980@.TK2MSFTNGP04.phx.gbl...
>

Changing the logical name of a DB

Hi,
I recently restored one DB over another different one in order to import a
template of data into a new DB. I did this in Enterprise Manager. The gui
allowed me to change the physical file path & name to match the destination
file, but didn't allow me to change the logical name.
How can I now change the logical file names of the data & log files?
Many thanks for any helpYou should do your best to learn the DDL equivalents of pointing and
clicking in the GUI, for two reasons: (a) you can easily store your scripts
in source control, and (b) you will have access to parts of the
functionality that didn't make it into the interface. Try this in Query
Analyzer:
ALTER DATABASE Database_Name
MODIFY FILE
(
NAME = Logical_Name,
NEWNAME = NEW_Logical_Name
);
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help|||> How can I now change the logical file names of the data & log files?
You can use ALTER DATABASE...MODIFY FILE. For example:
ALTER DATABASE AdventureWorks
MODIFY FILE (
NAME='AdventureWorks_Data',
NEWNAME='AdventureWorks_Data_New')
See ALTER DATABASE in the Books Online for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help|||Hello Dan,
Thank you very much for your help here.
Cheers
Ant
"Dan Guzman" wrote:
> > How can I now change the logical file names of the data & log files?
> You can use ALTER DATABASE...MODIFY FILE. For example:
> ALTER DATABASE AdventureWorks
> MODIFY FILE (
> NAME='AdventureWorks_Data',
> NEWNAME='AdventureWorks_Data_New')
> See ALTER DATABASE in the Books Online for details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> > Hi,
> > I recently restored one DB over another different one in order to import a
> > template of data into a new DB. I did this in Enterprise Manager. The gui
> > allowed me to change the physical file path & name to match the
> > destination
> > file, but didn't allow me to change the logical name.
> >
> > How can I now change the logical file names of the data & log files?
> >
> > Many thanks for any help
>|||What version are you running?
In SQL 2000 you cannot change the logical file names.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help|||Hi Kalen,
Thanks for the reply but in fact it appears you can. I am using SQL 2000 &
have successfully changed the logical name simply by using the Alter table
modify file statement I was given above. It worked fine!
Thank you any way for your input on this though.
Cheer
Ant
"Kalen Delaney" wrote:
> What version are you running?
> In SQL 2000 you cannot change the logical file names.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> > Hi,
> > I recently restored one DB over another different one in order to import a
> > template of data into a new DB. I did this in Enterprise Manager. The gui
> > allowed me to change the physical file path & name to match the
> > destination
> > file, but didn't allow me to change the logical name.
> >
> > How can I now change the logical file names of the data & log files?
> >
> > Many thanks for any help
>
>|||Hi, Kalen.
> What version are you running?
> In SQL 2000 you cannot change the logical file names.
Perhaps you are thinking of SQL 7. IIRC, the ability to change the logical
names was introduced in SQL 2000.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23dlcDj1UIHA.5980@.TK2MSFTNGP04.phx.gbl...
> What version are you running?
> In SQL 2000 you cannot change the logical file names.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>> Hi,
>> I recently restored one DB over another different one in order to import
>> a
>> template of data into a new DB. I did this in Enterprise Manager. The gui
>> allowed me to change the physical file path & name to match the
>> destination
>> file, but didn't allow me to change the logical name.
>> How can I now change the logical file names of the data & log files?
>> Many thanks for any help
>|||You're right... as Dan indicated it was actually SQL 7, when the new files
structures and ALTER DATABASE command were first introduced, that there was
no way to change the logical name.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:B2DD5503-5FC5-4B16-8B3B-C38655367FDF@.microsoft.com...
> Hi Kalen,
> Thanks for the reply but in fact it appears you can. I am using SQL 2000 &
> have successfully changed the logical name simply by using the Alter table
> modify file statement I was given above. It worked fine!
> Thank you any way for your input on this though.
> Cheer
> Ant
> "Kalen Delaney" wrote:
>> What version are you running?
>> In SQL 2000 you cannot change the logical file names.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://blog.kalendelaney.com
>>
>> "Ant" <Ant@.discussions.microsoft.com> wrote in message
>> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>> > Hi,
>> > I recently restored one DB over another different one in order to
>> > import a
>> > template of data into a new DB. I did this in Enterprise Manager. The
>> > gui
>> > allowed me to change the physical file path & name to match the
>> > destination
>> > file, but didn't allow me to change the logical name.
>> >
>> > How can I now change the logical file names of the data & log files?
>> >
>> > Many thanks for any help
>>|||Thanks, Dan.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:C6D04793-D874-4B42-A440-ED117325CE42@.microsoft.com...
> Hi, Kalen.
>> What version are you running?
>> In SQL 2000 you cannot change the logical file names.
> Perhaps you are thinking of SQL 7. IIRC, the ability to change the
> logical names was introduced in SQL 2000.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:%23dlcDj1UIHA.5980@.TK2MSFTNGP04.phx.gbl...
>> What version are you running?
>> In SQL 2000 you cannot change the logical file names.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://blog.kalendelaney.com
>>
>> "Ant" <Ant@.discussions.microsoft.com> wrote in message
>> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>> Hi,
>> I recently restored one DB over another different one in order to import
>> a
>> template of data into a new DB. I did this in Enterprise Manager. The
>> gui
>> allowed me to change the physical file path & name to match the
>> destination
>> file, but didn't allow me to change the logical name.
>> How can I now change the logical file names of the data & log files?
>> Many thanks for any help
>>
>

Changing the default port number and still connecting

Hello,
I have SQL Server 2000 Enterprise Edition, and I'd like to change the
default port to something else (we'll use 2033 for this example). I've
tried to connect from another computer on the same subnet using
"ServerName:2033" as the server, but it doesn't connect. It will connect if
I change the Server to use the default port and change the server to connect
to on the client to "ServerName", but either I"m not referencing the new
port number properly or ?
Any help you could provide would be great.
Thanks In Advance!
Rick
Hi,
Stop all applications and Third party software services in the server.
After the applications and services are stopped, change the port and start
SQL Server
service. This should enable SQL Server to take control of new port. Open the
sql server error log and see if the new port is used.
See additional details from old post.
http://groups.google.co.in/groups?q=...ft.com&rnum=10
Thanks
Hari
SQL Server MVP
"RWC" <rcollens_SPAMONATOR_@.hemmingway.com> wrote in message
news:kUAde.1198452$8l.948157@.pd7tw1no...
> Hello,
> I have SQL Server 2000 Enterprise Edition, and I'd like to change the
> default port to something else (we'll use 2033 for this example). I've
> tried to connect from another computer on the same subnet using
> "ServerName:2033" as the server, but it doesn't connect. It will connect
if
> I change the Server to use the default port and change the server to
connect
> to on the client to "ServerName", but either I"m not referencing the new
> port number properly or ?
> Any help you could provide would be great.
> Thanks In Advance!
> Rick
>
|||Hi
"ServerName, 2033" is the correct format.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"RWC" wrote:

> Hello,
> I have SQL Server 2000 Enterprise Edition, and I'd like to change the
> default port to something else (we'll use 2033 for this example). I've
> tried to connect from another computer on the same subnet using
> "ServerName:2033" as the server, but it doesn't connect. It will connect if
> I change the Server to use the default port and change the server to connect
> to on the client to "ServerName", but either I"m not referencing the new
> port number properly or ?
> Any help you could provide would be great.
> Thanks In Advance!
> Rick
>
>
|||You're a GENIUS man! ;)
Thanks Mike, that worked like a charm. (I figured it would be the
connection syntax).
Thanks again!
Rick
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:C7FAFA8A-7B27-4E48-88CB-90E00FF63573@.microsoft.com...[vbcol=seagreen]
> Hi
> "ServerName, 2033" is the correct format.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "RWC" wrote:

Changing the default port number and still connecting

Hello,
I have SQL Server 2000 Enterprise Edition, and I'd like to change the
default port to something else (we'll use 2033 for this example). I've
tried to connect from another computer on the same subnet using
"ServerName:2033" as the server, but it doesn't connect. It will connect if
I change the Server to use the default port and change the server to connect
to on the client to "ServerName", but either I"m not referencing the new
port number properly or '
Any help you could provide would be great.
Thanks In Advance!
RickHi,
Stop all applications and Third party software services in the server.
After the applications and services are stopped, change the port and start
SQL Server
service. This should enable SQL Server to take control of new port. Open the
sql server error log and see if the new port is used.
See additional details from old post.
gVBHA.237%40cppssbbsa01.microsoft.com&rnum=10" target="_blank">http://groups.google.co.in/groups?q...oft.com&rnum=10
Thanks
Hari
SQL Server MVP
"RWC" <rcollens_SPAMONATOR_@.hemmingway.com> wrote in message
news:kUAde.1198452$8l.948157@.pd7tw1no...
> Hello,
> I have SQL Server 2000 Enterprise Edition, and I'd like to change the
> default port to something else (we'll use 2033 for this example). I've
> tried to connect from another computer on the same subnet using
> "ServerName:2033" as the server, but it doesn't connect. It will connect
if
> I change the Server to use the default port and change the server to
connect
> to on the client to "ServerName", but either I"m not referencing the new
> port number properly or '
> Any help you could provide would be great.
> Thanks In Advance!
> Rick
>|||Hi
"ServerName, 2033" is the correct format.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"RWC" wrote:

> Hello,
> I have SQL Server 2000 Enterprise Edition, and I'd like to change the
> default port to something else (we'll use 2033 for this example). I've
> tried to connect from another computer on the same subnet using
> "ServerName:2033" as the server, but it doesn't connect. It will connect
if
> I change the Server to use the default port and change the server to conne
ct
> to on the client to "ServerName", but either I"m not referencing the new
> port number properly or '
> Any help you could provide would be great.
> Thanks In Advance!
> Rick
>
>|||You're a GENIUS man! ;)
Thanks Mike, that worked like a charm. (I figured it would be the
connection syntax).
Thanks again!
Rick
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:C7FAFA8A-7B27-4E48-88CB-90E00FF63573@.microsoft.com...[vbcol=seagreen]
> Hi
> "ServerName, 2033" is the correct format.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "RWC" wrote:
>

Changing the default port number and still connecting

Hello,

I have SQL Server 2000 Enterprise Edition, and I'd like to change the
default port to something else (we'll use 2033 for this example). I've
tried to connect from another computer on the same subnet using
"ServerName:2033" as the server, but it doesn't connect. It will connect if
I change the Server to use the default port and change the server to connect
to on the client to "ServerName", but either I"m not referencing the new
port number properly or ??

Any help you could provide would be great.

Thanks In Advance!
RickHi,

Stop all applications and Third party software services in the server.
After the applications and services are stopped, change the port and start
SQL Server
service. This should enable SQL Server to take control of new port. Open the
sql server error log and see if the new port is used.

See additional details from old post.

http://groups.google.co.in/groups?q...oft.com&rnum=10

Thanks
Hari
SQL Server MVP

"RWC" <rcollens_SPAMONATOR_@.hemmingway.com> wrote in message
news:kUAde.1198452$8l.948157@.pd7tw1no...
> Hello,
> I have SQL Server 2000 Enterprise Edition, and I'd like to change the
> default port to something else (we'll use 2033 for this example). I've
> tried to connect from another computer on the same subnet using
> "ServerName:2033" as the server, but it doesn't connect. It will connect
if
> I change the Server to use the default port and change the server to
connect
> to on the client to "ServerName", but either I"m not referencing the new
> port number properly or ??
> Any help you could provide would be great.
> Thanks In Advance!
> Ricksql

changing sql server account using sem ...

when trying to change the sql server and sql server agent accounts using the
sql enterprise manager what is the syntax for a domain account that should be
used ( i.e. domainname/username, just username, domainname\username, etc... )
? when attempting to add an existing domain account an error message keeps
poping-up that says 'the account (local computername)/accountname is not a
valid windows account' ( for some reason it thinks its a local system account
instead of a domain account ) even though sql server is installed on the pdc.
tia ...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using the
> sql enterprise manager what is the syntax for a domain account that should be
> used ( i.e. domainname/username, just username, domainname\username, etc... )
> ? when attempting to add an existing domain account an error message keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system account
> instead of a domain account ) even though sql server is installed on the pdc.
> tia ...
|||Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.
http://support.microsoft.com/default...b;en-us;283811
Sincerely,
Anthony Thomas

"mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ? when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
> tia ...
|||Thanks Anthony.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"Anthony Thomas" wrote:

> Yes, but the recommended approach is to do it through EM. This way all of
> the necessary permissions and user rights assingments will be given
> appropriately. However, using the services msc is an alternative as long as
> you follow the KB article that describes manually setting all of the other
> requirements.
> http://support.microsoft.com/default...b;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
> news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
> Hello E-Double.
> I find it easiest to change the account using the services console (type
> services.msc in Start>Run), that way you can browse the network and or check
> the name that you enter so it will be prefixed correctly with the domain. I
> just find I don't have to think about it this way.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "E-Double" wrote:
> the
> be
> etc... )
> keeps
> account
> pdc.
>
>

changing sql server account using sem ...

when trying to change the sql server and sql server agent accounts using the
sql enterprise manager what is the syntax for a domain account that should be
used ( i.e. domainname/username, just username, domainname\username, etc... )
? when attempting to add an existing domain account an error message keeps
poping-up that says 'the account (local computername)/accountname is not a
valid windows account' ( for some reason it thinks its a local system account
instead of a domain account ) even though sql server is installed on the pdc.
tia ...Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:
> when trying to change the sql server and sql server agent accounts using the
> sql enterprise manager what is the syntax for a domain account that should be
> used ( i.e. domainname/username, just username, domainname\username, etc... )
> ? when attempting to add an existing domain account an error message keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system account
> instead of a domain account ) even though sql server is installed on the pdc.
> tia ...|||Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.
http://support.microsoft.com/default.aspx?scid=kb;en-us;283811
Sincerely,
Anthony Thomas
"mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:
> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ? when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
> tia ...|||Thanks Anthony.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"Anthony Thomas" wrote:
> Yes, but the recommended approach is to do it through EM. This way all of
> the necessary permissions and user rights assingments will be given
> appropriately. However, using the services msc is an alternative as long as
> you follow the KB article that describes manually setting all of the other
> requirements.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
> news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
> Hello E-Double.
> I find it easiest to change the account using the services console (type
> services.msc in Start>Run), that way you can browse the network and or check
> the name that you enter so it will be prefixed correctly with the domain. I
> just find I don't have to think about it this way.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "E-Double" wrote:
> > when trying to change the sql server and sql server agent accounts using
> the
> > sql enterprise manager what is the syntax for a domain account that should
> be
> > used ( i.e. domainname/username, just username, domainname\username,
> etc... )
> > ? when attempting to add an existing domain account an error message
> keeps
> > poping-up that says 'the account (local computername)/accountname is not a
> > valid windows account' ( for some reason it thinks its a local system
> account
> > instead of a domain account ) even though sql server is installed on the
> pdc.
> > tia ...
>
>

changing sql server account using sem ...

when trying to change the sql server and sql server agent accounts using the
sql enterprise manager what is the syntax for a domain account that should b
e
used ( i.e. domainname/username, just username, domainname\username, etc...
)
? when attempting to add an existing domain account an error message keeps
poping-up that says 'the account (local computername)/accountname is not a
valid windows account' ( for some reason it thinks its a local system accoun
t
instead of a domain account ) even though sql server is installed on the pdc
.
tia ...Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using t
he
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username, etc..
. )
> ? when attempting to add an existing domain account an error message keep
s
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system acco
unt
> instead of a domain account ) even though sql server is installed on the p
dc.
> tia ...|||Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.
http://support.microsoft.com/defaul...kb;en-us;283811
Sincerely,
Anthony Thomas
"mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ? when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
> tia ...|||Thanks Anthony.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"Anthony Thomas" wrote:

> Yes, but the recommended approach is to do it through EM. This way all of
> the necessary permissions and user rights assingments will be given
> appropriately. However, using the services msc is an alternative as long
as
> you follow the KB article that describes manually setting all of the other
> requirements.
> http://support.microsoft.com/defaul...kb;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
> news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
> Hello E-Double.
> I find it easiest to change the account using the services console (type
> services.msc in Start>Run), that way you can browse the network and or che
ck
> the name that you enter so it will be prefixed correctly with the domain.
I
> just find I don't have to think about it this way.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "E-Double" wrote:
>
> the
> be
> etc... )
> keeps
> account
> pdc.
>
>

Changing sql enterprise to sql standard edition.

Hi, now we have a server that is running in sql server2000 enterprise
edition. For licenses problems we need to desinstall this edition and
install the standard edition.
Do somebody know if there is a problem in attach the databases that were
created in the enterprise edition on the new standard edition server'
What do you recommend to me to do this migration?
Thanks a lot for your help!!!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!You can attach databases from EE to SE (in fact, you can attach across all editions).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"MariaGuzman" <marisa@.devdex.com> wrote in message news:uet9BdaHFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Hi, now we have a server that is running in sql server2000 enterprise
> edition. For licenses problems we need to desinstall this edition and
> install the standard edition.
> Do somebody know if there is a problem in attach the databases that were
> created in the enterprise edition on the new standard edition server'
> What do you recommend to me to do this migration?
> Thanks a lot for your help!!!
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||> You can attach databases from EE to SE (in fact, you can attach across all
editions).
Well, except a > 2GB database to MSDE... :-)|||Good point, Aaron. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ejmYeIbHFHA.2456@.TK2MSFTNGP09.phx.gbl...
>> You can attach databases from EE to SE (in fact, you can attach across all
> editions).
> Well, except a > 2GB database to MSDE... :-)
>|||Functionaly, the database should be equivalent. Unless you were doing
esoteric Distributed Partitioned Views or some such, you should run into any
problems.
Take a look at the product features of both editions to see if any of these
match thing you've been doing.
Also consider that if you had purchased Developer Edition to build your
systems, you would have been using Enterprise Edition and it would have been
likely that many users have deployed such systems to production level
Standard Edition. The only difference between DE and EE is the EULA.
Sincerely,
Anthony Thomas
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uet9BdaHFHA.3376@.TK2MSFTNGP14.phx.gbl...
Hi, now we have a server that is running in sql server2000 enterprise
edition. For licenses problems we need to desinstall this edition and
install the standard edition.
Do somebody know if there is a problem in attach the databases that were
created in the enterprise edition on the new standard edition server'
What do you recommend to me to do this migration?
Thanks a lot for your help!!!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Changing sql enterprise to sql standard edition.

Hi, now we have a server that is running in sql server2000 enterprise
edition. For licenses problems we need to desinstall this edition and
install the standard edition.
Do somebody know if there is a problem in attach the databases that were
created in the enterprise edition on the new standard edition server'
What do you recommend to me to do this migration?
Thanks a lot for your help!!!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!You can attach databases from EE to SE (in fact, you can attach across all e
ditions).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"MariaGuzman" <marisa@.devdex.com> wrote in message news:uet9BdaHFHA.3376@.TK2MSFTNGP14.phx.gb
l...
> Hi, now we have a server that is running in sql server2000 enterprise
> edition. For licenses problems we need to desinstall this edition and
> install the standard edition.
> Do somebody know if there is a problem in attach the databases that were
> created in the enterprise edition on the new standard edition server'
> What do you recommend to me to do this migration?
> Thanks a lot for your help!!!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||> You can attach databases from EE to SE (in fact, you can attach across all
editions).
Well, except a > 2GB database to MSDE... :-)|||Good point, Aaron. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ejmYeIbHFHA.2456@.TK2MSFTNGP09.phx.gbl...
> editions).
> Well, except a > 2GB database to MSDE... :-)
>|||Functionaly, the database should be equivalent. Unless you were doing
esoteric Distributed Partitioned Views or some such, you should run into any
problems.
Take a look at the product features of both editions to see if any of these
match thing you've been doing.
Also consider that if you had purchased Developer Edition to build your
systems, you would have been using Enterprise Edition and it would have been
likely that many users have deployed such systems to production level
Standard Edition. The only difference between DE and EE is the EULA.
Sincerely,
Anthony Thomas
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uet9BdaHFHA.3376@.TK2MSFTNGP14.phx.gbl...
Hi, now we have a server that is running in sql server2000 enterprise
edition. For licenses problems we need to desinstall this edition and
install the standard edition.
Do somebody know if there is a problem in attach the databases that were
created in the enterprise edition on the new standard edition server'
What do you recommend to me to do this migration?
Thanks a lot for your help!!!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Changing sql enterprise to sql standard edition.

Hi, now we have a server that is running in sql server2000 enterprise
edition. For licenses problems we need to desinstall this edition and
install the standard edition.
Do somebody know if there is a problem in attach the databases that were
created in the enterprise edition on the new standard edition server?
What do you recommend to me to do this migration?
Thanks a lot for your help!!!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You can attach databases from EE to SE (in fact, you can attach across all editions).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"MariaGuzman" <marisa@.devdex.com> wrote in message news:uet9BdaHFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Hi, now we have a server that is running in sql server2000 enterprise
> edition. For licenses problems we need to desinstall this edition and
> install the standard edition.
> Do somebody know if there is a problem in attach the databases that were
> created in the enterprise edition on the new standard edition server?
> What do you recommend to me to do this migration?
> Thanks a lot for your help!!!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||> You can attach databases from EE to SE (in fact, you can attach across all
editions).
Well, except a > 2GB database to MSDE... :-)
|||Good point, Aaron. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ejmYeIbHFHA.2456@.TK2MSFTNGP09.phx.gbl...
> editions).
> Well, except a > 2GB database to MSDE... :-)
>
|||Functionaly, the database should be equivalent. Unless you were doing
esoteric Distributed Partitioned Views or some such, you should run into any
problems.
Take a look at the product features of both editions to see if any of these
match thing you've been doing.
Also consider that if you had purchased Developer Edition to build your
systems, you would have been using Enterprise Edition and it would have been
likely that many users have deployed such systems to production level
Standard Edition. The only difference between DE and EE is the EULA.
Sincerely,
Anthony Thomas

"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uet9BdaHFHA.3376@.TK2MSFTNGP14.phx.gbl...
Hi, now we have a server that is running in sql server2000 enterprise
edition. For licenses problems we need to desinstall this edition and
install the standard edition.
Do somebody know if there is a problem in attach the databases that were
created in the enterprise edition on the new standard edition server?
What do you recommend to me to do this migration?
Thanks a lot for your help!!!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

changing passwords

I'm new on a project and need to change all web users passwords. Were would you start from Enterprise Manager?Are you talking about logging in to sql server?

I wouldn't think so...if it's a web app you're probably pooling...

Do they applcaition level security?

Do you use NT security (not for web users )

What's you're security model?|||Thanks for reply. It appears the last person in my spot did'nt follow any name convention that I see. Someone returned today from Thanksgiving vacation who show a strange table named then it made since. I was able to make the changes and get up & Runing.

Thanks
Originally posted by Brett Kaiser
Are you talking about logging in to sql server?

I wouldn't think so...if it's a web app you're probably pooling...

Do they applcaition level security?

Do you use NT security (not for web users )

What's you're security model?

Changing Password for SA

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition
Server. How do you change the password for SA? Do we need to do anything
before and after changing the password?
Thank you.
Diane> How do you change the password for SA?
Read about sp_password.

> Do we need to do anything before and after changing the password?
Hopefully you don't have any applications or users connecting using this log
in name. If you do, you
need to handle them.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Diane Walker" <ett9300@.yahoo.com> wrote in message news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gb
l...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Editio
n Server. How do you
> change the password for SA? Do we need to do anything before and after ch
anging the password?
> Thank you.
> Diane
>|||Hi,
sp_password stored procedure
but read this page as well
http://support.microsoft.com/kb/322336
if any of your application using sa user/password to connect to db then ,
you need to change that application as well
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Edition Server. How do you change the password for SA? Do we need to do
> anything before and after changing the password?
> Thank you.
> Diane
>|||ALTER LOGIN?
TheSQLGuru
President
Indicium Resources, Inc.
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Edition Server. How do you change the password for SA? Do we need to do
> anything before and after changing the password?
> Thank you.
> Diane
>|||Thank you very much for your prompt response. I guess that I need to change
the password off office hours. How do you find out what application is
using SA account? Thanks.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:OopWgAWmHHA.1532@.TK2MSFTNGP03.phx.gbl...
> ALTER LOGIN?
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
>|||You can set up a profiler run and have it trace login/out events and include
the Application Name as one of the columns. Note that profiler will have a
small impact on system performance.
TheSQLGuru
President
Indicium Resources, Inc.
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:eVgKfRWmHHA.596@.TK2MSFTNGP06.phx.gbl...
> Thank you very much for your prompt response. I guess that I need to
> change the password off office hours. How do you find out what
> application is using SA account? Thanks.
> "TheSQLGuru" <kgboles@.earthlink.net> wrote in message
> news:OopWgAWmHHA.1532@.TK2MSFTNGP03.phx.gbl...
>

Changing Password for SA

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition
Server. How do you change the password for SA? Do we need to do anything
before and after changing the password?
Thank you.
Diane
> How do you change the password for SA?
Read about sp_password.

> Do we need to do anything before and after changing the password?
Hopefully you don't have any applications or users connecting using this login name. If you do, you
need to handle them.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Diane Walker" <ett9300@.yahoo.com> wrote in message news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition Server. How do you
> change the password for SA? Do we need to do anything before and after changing the password?
> Thank you.
> Diane
>
|||ALTER LOGIN?
TheSQLGuru
President
Indicium Resources, Inc.
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Edition Server. How do you change the password for SA? Do we need to do
> anything before and after changing the password?
> Thank you.
> Diane
>
|||Thank you very much for your prompt response. I guess that I need to change
the password off office hours. How do you find out what application is
using SA account? Thanks.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:OopWgAWmHHA.1532@.TK2MSFTNGP03.phx.gbl...
> ALTER LOGIN?
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
>
|||You can set up a profiler run and have it trace login/out events and include
the Application Name as one of the columns. Note that profiler will have a
small impact on system performance.
TheSQLGuru
President
Indicium Resources, Inc.
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:eVgKfRWmHHA.596@.TK2MSFTNGP06.phx.gbl...
> Thank you very much for your prompt response. I guess that I need to
> change the password off office hours. How do you find out what
> application is using SA account? Thanks.
> "TheSQLGuru" <kgboles@.earthlink.net> wrote in message
> news:OopWgAWmHHA.1532@.TK2MSFTNGP03.phx.gbl...
>

Changing Password for SA

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition
Server. How do you change the password for SA? Do we need to do anything
before and after changing the password?
Thank you.
Diane> How do you change the password for SA?
Read about sp_password.
> Do we need to do anything before and after changing the password?
Hopefully you don't have any applications or users connecting using this login name. If you do, you
need to handle them.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Diane Walker" <ett9300@.yahoo.com> wrote in message news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition Server. How do you
> change the password for SA? Do we need to do anything before and after changing the password?
> Thank you.
> Diane
>|||Hi,
sp_password stored procedure
but read this page as well
http://support.microsoft.com/kb/322336
if any of your application using sa user/password to connect to db then ,
you need to change that application as well
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Edition Server. How do you change the password for SA? Do we need to do
> anything before and after changing the password?
> Thank you.
> Diane
>|||ALTER LOGIN?
--
TheSQLGuru
President
Indicium Resources, Inc.
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Edition Server. How do you change the password for SA? Do we need to do
> anything before and after changing the password?
> Thank you.
> Diane
>|||Thank you very much for your prompt response. I guess that I need to change
the password off office hours. How do you find out what application is
using SA account? Thanks.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:OopWgAWmHHA.1532@.TK2MSFTNGP03.phx.gbl...
> ALTER LOGIN?
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
>> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
>> Edition Server. How do you change the password for SA? Do we need to do
>> anything before and after changing the password?
>> Thank you.
>> Diane
>|||You can set up a profiler run and have it trace login/out events and include
the Application Name as one of the columns. Note that profiler will have a
small impact on system performance.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:eVgKfRWmHHA.596@.TK2MSFTNGP06.phx.gbl...
> Thank you very much for your prompt response. I guess that I need to
> change the password off office hours. How do you find out what
> application is using SA account? Thanks.
> "TheSQLGuru" <kgboles@.earthlink.net> wrote in message
> news:OopWgAWmHHA.1532@.TK2MSFTNGP03.phx.gbl...
>> ALTER LOGIN?
>> --
>> TheSQLGuru
>> President
>> Indicium Resources, Inc.
>> "Diane Walker" <ett9300@.yahoo.com> wrote in message
>> news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
>> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
>> Edition Server. How do you change the password for SA? Do we need to
>> do anything before and after changing the password?
>> Thank you.
>> Diane
>>
>

changing owner of stored procedure

Is there a way to change the owner of a stored procedure?
I used Enterprise Manager to create a stored procedure. But since it was
created under my login name, other users are denied permission. Rather than
explicitly giving permission to everyone, I would like to change the owner
to 'dbo'.
How?
Lisasp_changeobjectowner
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:ubuJHdw7DHA.2924@.tk2msftngp13.phx.gbl...
> Is there a way to change the owner of a stored procedure?
> I used Enterprise Manager to create a stored procedure. But since it was
> created under my login name, other users are denied permission. Rather
than
> explicitly giving permission to everyone, I would like to change the owner
> to 'dbo'.
> How?
> Lisa
>

changing owner of stored procedure

Is there a way to change the owner of a stored procedure?
I used Enterprise Manager to create a stored procedure. But since it was
created under my login name, other users are denied permission. Rather than
explicitly giving permission to everyone, I would like to change the owner
to 'dbo'.
How?
Lisasp_changeobjectowner
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:ubuJHdw7DHA.2924@.tk2msftngp13.phx.gbl...
> Is there a way to change the owner of a stored procedure?
> I used Enterprise Manager to create a stored procedure. But since it was
> created under my login name, other users are denied permission. Rather
than
> explicitly giving permission to everyone, I would like to change the owner
> to 'dbo'.
> How?
> Lisa
>

Changing location of log files in a Clustered Virtual Server

I set up a Clustered Virtual Server using Windows 2003 Enterprise SP! and
SQL2000 Enterprise SP2. When setting SQL it gave me the option to choose the
location of the data, now that the virtual server is functional I want to
change the location of the log files to a different resource of the cluster
(different drive) but it is not letting me do so. Hoe do you change location
s
of your drives in a clustered environment?
Any ideas?Same as in a non-clustered environment.
I would guess that the step you are missing is to make the SQL Service
dependent on the new clustered disk resource. Clustered SQL will only allow
you to write data files to disks that are in the same resource group AND
that SQL is dependent on.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Carlos" <carlosarango@.SQLserver.com> wrote in message
news:626F2CB6-A2E1-4CFB-A49F-E6413133BF78@.microsoft.com...
>I set up a Clustered Virtual Server using Windows 2003 Enterprise SP! and
> SQL2000 Enterprise SP2. When setting SQL it gave me the option to choose
> the
> location of the data, now that the virtual server is functional I want to
> change the location of the log files to a different resource of the
> cluster
> (different drive) but it is not letting me do so. Hoe do you change
> locations
> of your drives in a clustered environment?
> Any ideas?
>|||Geoff
Thanks so much !!!! That did it !!!
"Geoff N. Hiten" wrote:

> Same as in a non-clustered environment.
> I would guess that the step you are missing is to make the SQL Service
> dependent on the new clustered disk resource. Clustered SQL will only all
ow
> you to write data files to disks that are in the same resource group AND
> that SQL is dependent on.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Carlos" <carlosarango@.SQLserver.com> wrote in message
> news:626F2CB6-A2E1-4CFB-A49F-E6413133BF78@.microsoft.com...
>
>|||Hi
It is probably because the drive in question has not been added as a
resource to the sql server cluster in cluster manager.
John
"Carlos" <carlosarango@.SQLserver.com> wrote in message
news:626F2CB6-A2E1-4CFB-A49F-E6413133BF78@.microsoft.com...
>I set up a Clustered Virtual Server using Windows 2003 Enterprise SP! and
> SQL2000 Enterprise SP2. When setting SQL it gave me the option to choose
> the
> location of the data, now that the virtual server is functional I want to
> change the location of the log files to a different resource of the
> cluster
> (different drive) but it is not letting me do so. Hoe do you change
> locations
> of your drives in a clustered environment?
> Any ideas?
>