Database remote access: password

[Guest]

I want to write program to remotely accesss to the database in SQL Server
under Windows 2000 server.

Which password should I use? password for database or password for Windows
2000 server? or something else?

When I use the password for my account in 2000 server (it allow me to access
to database locally), it doesn't work.

Thank you for any help.

David

 

[Eliyahu Goldin]

David,

Although it is possible to setup Windows authentication for remote database
access, it is much easier to use SQL one.

Find details here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch12.asp

 

[Guest]

Thank you

David

David,

Although it is possible to setup Windows authentication for remote database
access, it is much easier to use SQL one.

Find details here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch12.asp

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]

I want to write program to remotely accesss to the database in SQL Server
under Windows 2000 server.

Which password should I use? password for database or password for Windows
2000 server? or something else?

When I use the password for my account in 2000 server (it allow me to
access
to database locally), it doesn't work.

Thank you for any help.

David