Chaning password

I have several merge replications running pushing subscriptions from one
server to the other. After some problems we recreated the databases (se
previous questions). However after pushing up all data everything worked fine
until we changed the administrator password on the subsciber server. Now I
get an error message 20084 at the publisher /18452 at the subscriber and the
message "Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection." What is the problem? i have registred the
servers via the 'sa' user and connect via the 'sa' user and have both
sql-server and windows as login possibilities. Sql-server and agent is
started via the administrator account (win2000) but i have stopped and
restarted the service changing the password in the services.
Best wishes
Mats
The "Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection." error normally means one of three things.
The NT account you are using to authenticate with does not have rights to
access the machine, its password is invalid, or you are using windows
authentication only and trying to connect using a SQL account and password.
You have to be a little careful with the account on the subscriber.
When the subscriber's SQL Server agent connects to the publisher it by
default will impersonate the SQL Server agent account on the publisher. In
other words the accounts and passwords of the account the SQL Server agent
on the Subscriber will have to match the account on the Publisher, or will
have to be in the administrator group on the publisher.
You can also specify a SQL account. In this case your SQL Server agent
account on the subscriber will have to match the SQL Server agent account on
the publisher, or be in the administrator group, or have rights to access
the snapshot folder share on the publisher.
I think your best approach, if you can do it, is to make the administrator
accounts on both servers have the same password, or to use another
administrator account on the subscriber, and add this account to the admin
group on the publisher.
HTH - its a little tricky to implement.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:E2956017-73FA-4EBA-8D86-F58A0B4D24C7@.microsoft.com...
>I have several merge replications running pushing subscriptions from one
> server to the other. After some problems we recreated the databases (se
> previous questions). However after pushing up all data everything worked
> fine
> until we changed the administrator password on the subsciber server. Now I
> get an error message 20084 at the publisher /18452 at the subscriber and
> the
> message "Login failed for user '(null)'. Reason: Not associated with a
> trusted SQL Server connection." What is the problem? i have registred the
> servers via the 'sa' user and connect via the 'sa' user and have both
> sql-server and windows as login possibilities. Sql-server and agent is
> started via the administrator account (win2000) but i have stopped and
> restarted the service changing the password in the services.
>
> --
> Best wishes
> Mats

Chaning login name

There have been some major changes here at work, and in order to keep up we
need to change some of the Group names in Active directory. Will the
changes that are made in Active Directory cascade down into SQL Server?
What is the protocol for this type of change?
Thanks,
DrewNo. On 2005, you can rename a login (to reflect the name change) using ALTER LOGIN.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Drew" <drew.laing@.swvtc.dmhmrsas.virginia.gov> wrote in message
news:OQx$0ftqIHA.5096@.TK2MSFTNGP02.phx.gbl...
> There have been some major changes here at work, and in order to keep up we need to change some of
> the Group names in Active directory. Will the changes that are made in Active Directory cascade
> down into SQL Server? What is the protocol for this type of change?
> Thanks,
> Drew
>|||What is the protocol for SQL Server 2000?
Thanks,
Drew
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:C42BDB9F-51A2-424C-8C25-58B905FB94E4@.microsoft.com...
> No. On 2005, you can rename a login (to reflect the name change) using
> ALTER LOGIN.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Drew" <drew.laing@.swvtc.dmhmrsas.virginia.gov> wrote in message
> news:OQx$0ftqIHA.5096@.TK2MSFTNGP02.phx.gbl...
>> There have been some major changes here at work, and in order to keep up
>> we need to change some of the Group names in Active directory. Will the
>> changes that are made in Active Directory cascade down into SQL Server?
>> What is the protocol for this type of change?
>> Thanks,
>> Drew
>|||You can't change the name for a login in 2000. You'd have to delete and re-create the login...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Drew" <drew.laing@.swvtc.dmhmrsas.virginia.gov> wrote in message
news:%234%233Q7tqIHA.2292@.TK2MSFTNGP03.phx.gbl...
> What is the protocol for SQL Server 2000?
> Thanks,
> Drew
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:C42BDB9F-51A2-424C-8C25-58B905FB94E4@.microsoft.com...
>> No. On 2005, you can rename a login (to reflect the name change) using ALTER LOGIN.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Drew" <drew.laing@.swvtc.dmhmrsas.virginia.gov> wrote in message
>> news:OQx$0ftqIHA.5096@.TK2MSFTNGP02.phx.gbl...
>> There have been some major changes here at work, and in order to keep up we need to change some
>> of the Group names in Active directory. Will the changes that are made in Active Directory
>> cascade down into SQL Server? What is the protocol for this type of change?
>> Thanks,
>> Drew
>>
>

Chaning an Instance name

Hi
I have a quick question about renaming an instance.
I used sp_dropserver and dropped the instance name
I used sp_addserver '<servername>, 'local' and changed the local instance
name.
After stopping and restarting the instance, i was able to connect to the new
instance name.
But i can still connect using the old instance name also.
I want to drop the old instance name completely.
How do i do that?
--Uday
See question number 5 in:
Frequently asked questions - SQL Server 2000 - multiple instances
http://support.microsoft.com/newsgroups/default.aspx
AMB
"Udayasree" wrote:

> Hi
> I have a quick question about renaming an instance.
> I used sp_dropserver and dropped the instance name
> I used sp_addserver '<servername>, 'local' and changed the local instance
> name.
> After stopping and restarting the instance, i was able to connect to the new
> instance name.
> But i can still connect using the old instance name also.
> I want to drop the old instance name completely.
> How do i do that?
> --Uday

Chaning an Instance name

Hi
I have a quick question about renaming an instance.
I used sp_dropserver and dropped the instance name
I used sp_addserver '<servername>, 'local' and changed the local instance
name.
After stopping and restarting the instance, i was able to connect to the new
instance name.
But i can still connect using the old instance name also.
I want to drop the old instance name completely.
How do i do that?
--UdaySee question number 5 in:
Frequently asked questions - SQL Server 2000 - multiple instances
http://support.microsoft.com/newsgroups/default.aspx
AMB
"Udayasree" wrote:
> Hi
> I have a quick question about renaming an instance.
> I used sp_dropserver and dropped the instance name
> I used sp_addserver '<servername>, 'local' and changed the local instance
> name.
> After stopping and restarting the instance, i was able to connect to the new
> instance name.
> But i can still connect using the old instance name also.
> I want to drop the old instance name completely.
> How do i do that?
> --Uday

Chaning an Instance name

Hi
I have a quick question about renaming an instance.
I used sp_dropserver and dropped the instance name
I used sp_addserver '<servername>, 'local' and changed the local instance
name.
After stopping and restarting the instance, i was able to connect to the new
instance name.
But i can still connect using the old instance name also.
I want to drop the old instance name completely.
How do i do that?
--UdaySee question number 5 in:
Frequently asked questions - SQL Server 2000 - multiple instances
http://support.microsoft.com/newsgroups/default.aspx
AMB
"Udayasree" wrote:

> Hi
> I have a quick question about renaming an instance.
> I used sp_dropserver and dropped the instance name
> I used sp_addserver '<servername>, 'local' and changed the local instance
> name.
> After stopping and restarting the instance, i was able to connect to the n
ew
> instance name.
> But i can still connect using the old instance name also.
> I want to drop the old instance name completely.
> How do i do that?
> --Uday