PB to connect a remote.

hi,

last week I posted a thread to explain that I was unable tu access a remote sqlserver from my personnal computer running wsindows XP.
I had a problem with my motherboard which obliged me to change it. I did, and decided to format my hard drive and reinstal only the programs needed, once upon SQL server could connect to my DB. I first instal XP, then the SP1 and after sql server. Then i configured the client network utility using an alias and giving the IP. It functionned well. Then I instal the soft I need (Sharp developp, webmatrix, flash XP (ftp), Together and office XP) but I was configuring Outlook when I got and CPU FAN warning. 256 mega de ram later, I was sure it will run like it did saturday but it was'nt. It make the same error as before the motherboard changing. So I reformat my hard drive and I don't understand what could it make weel run on satruday and the shunt down on monday.

so If you have an Idea of what to do, please help me,

wozoiI reinstall XP but not the SP1 and just SQL server it make the same eternal error connection open conect()).

somebody get an idea.

wozoi|||Please post the exact error and also any entries in the event log and your sql server log.|||hi and thanks,

On the remote server ther is no trace of a connection trying,
and i don't find on my computer the event log you asks.

In the Attachement you will find the screen shot and the translation (because I'm french) of the error.

Could you reply me where can i find the event log to send it to you.

thanks for your help.

pierre jean

password for sa was changed spontaneously

Hello!

We are running MS SQLServer 7.0 with ASP on Win 2k Server.
Today suddenly the Web server couldn't connect to the DB Server
because the password for sa was wrong.
We found out that the password was changed.

Is it some kind of hacking thing or just normal password expiration?
The same thing happended several month ago.

Thanks.

SamSam Kong (ssk@.chol.net) writes:
> We are running MS SQLServer 7.0 with ASP on Win 2k Server.
> Today suddenly the Web server couldn't connect to the DB Server
> because the password for sa was wrong.
> We found out that the password was changed.
> Is it some kind of hacking thing or just normal password expiration?
> The same thing happended several month ago.

There is no password expiration in SQL7. So that means that somebody
changed the password for you.

I would recommend that you change to Windows Authentication and turn
off SQL Authentication. I would also recommand that the web server
does not log with an account that has sysadm privileges. Preferrably
it should no special rights, but access to the SQL objects it needs
to access. (And that should ideally only be stored procedures!).

Finally, if the SQL Server is exposed on the Internet, you should
stick it behind a firewall.

All these precautions increase your security and decreases the risk
for malign attacks.

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

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

Password change

Hi,
I have a pull merge replication configured on two of my servers. These
servers replicate over the internet and use the sa password to connect to the
publisher. I know it is not a good practice to use the sa login for
replication purposes. But it has been configured this way. It would be too
much work to re-configure it. I am not sure about this.
But the question that I want to ask is, if i change my subscribers sa
password, replication stops working.
Can someone tell me what the problem can be?
Thank you in advance.
Regards,
Karthik
try to change also the sqlagent pasword.
zrod
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:CFBAAC11-60D8-4A9F-88D2-D14B98E4ED8D@.microsoft.com...
> Hi,
> I have a pull merge replication configured on two of my servers. These
> servers replicate over the internet and use the sa password to connect to
> the
> publisher. I know it is not a good practice to use the sa login for
> replication purposes. But it has been configured this way. It would be too
> much work to re-configure it. I am not sure about this.
> But the question that I want to ask is, if i change my subscribers sa
> password, replication stops working.
> Can someone tell me what the problem can be?
> Thank you in advance.
> Regards,
> Karthik
|||Your pull subscriber authenticates with the agent locally. You can specify
the account to use as well as its password via agent properties.
I think you want to look at [Distributor/Publisher/Subscriber]SecurityMode
and the logon and password parameters.
You should be able to use the accounts of your choice here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:CFBAAC11-60D8-4A9F-88D2-D14B98E4ED8D@.microsoft.com...
> Hi,
> I have a pull merge replication configured on two of my servers. These
> servers replicate over the internet and use the sa password to connect to
the
> publisher. I know it is not a good practice to use the sa login for
> replication purposes. But it has been configured this way. It would be too
> much work to re-configure it. I am not sure about this.
> But the question that I want to ask is, if i change my subscribers sa
> password, replication stops working.
> Can someone tell me what the problem can be?
> Thank you in advance.
> Regards,
> Karthik