473,473 Members | 1,483 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Database remote access: password

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
Nov 2 '06 #1
2 1146
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/de...SecNetch12.asp

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"david" <da***@discussions.microsoft.comwrote in message
news:AE**********************************@microsof t.com...
>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


Nov 2 '06 #2
Thank you

David

"Eliyahu Goldin" wrote:
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/de...SecNetch12.asp

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"david" <da***@discussions.microsoft.comwrote in message
news:AE**********************************@microsof t.com...
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


Nov 2 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: william | last post by:
Hi, I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:\Collect.mdb'. It is already opened exclusively by...
5
by: Terry | last post by:
Hi All, Im having problems setting up the federated database. The commands Im using are as follows: CATALOG TCPIP NODE 'FSYS1' REMOTE <ip> SERVER <port> CREATE SERVER svr_docket TYPE...
20
by: xixi | last post by:
hi, we use db2 udb v8.1 on windows, i am trying to use federated database objects to create wrapper, even though i have update dbm cfg using federated yes, i still get error "the instance for the...
0
by: Bennett Haselton | last post by:
In Visual Studio .Net 2002 Server Explorer, if I add a new connection under "Data Connections", I can specify a remote server name and the username and password that I want to use, but then when...
3
by: Hrvoje Vrbanc | last post by:
Hello all! Scenario: - web server at one location (domain) with VS 2003 - SQL server at a remote location (domain) - VPN connection on port 1433 between the two domains I have no troubles...
3
by: Steve Teeples | last post by:
I am writing my first database application. I am unable to even get to first base because I can't seem to access the data in the database. Each time the "Fill" command is executed I get an...
3
by: jason | last post by:
I've been playing around with new (for 2.0) membershp functionality. I was able to build a simple login form that secures a directory on a project I built locally on my development desktop. ...
8
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
Now we have some trouble to directly access to SQL Server database. I would like to know if there is a special protocol in the communication between SQL SERVER client and databse system. What is...
0
debasisdas
by: debasisdas | last post by:
DATABASE LINK =============== A database link is a path through which a remote user in another database can connect to any other database. Once created database link exists as an object in the...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.