changing the default port on a clustered 2005 server.

I am unclear as to which Ip address to change the standard port on. When setting up a cluster you have multiple IP address's including the nic that is used for the heartbeat. I have not found any documention on how to change both nodes to listen on a port other than 1433..

Any help would be greatly appreciated.

Set the one titled "IPAll" (you may need to scroll to the bottom of the list). The clustered SQL Server instance will apply it to the actual IP addresses of the cluster.

changing the default port on a clustered 2005 server.

I am unclear as to which Ip address to change the standard port on. When setting up a cluster you have multiple IP address's including the nic that is used for the heartbeat. I have not found any documention on how to change both nodes to listen on a port other than 1433..

Any help would be greatly appreciated.

Set the one titled "IPAll" (you may need to scroll to the bottom of the list). The clustered SQL Server instance will apply it to the actual IP addresses of the cluster.

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 security model

how do i reconfigure an installed sql server to use standard security
(sql login/pwd) instead of only accepting trusted connections
(requiring windows login/pwd)
thanks,
jasonnever mind, i found it in the enterprise manager server properties
security tab.

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