473,382 Members | 1,273 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Development environment setup: connect to SQL Server 2000 database

Last week I asked a question about connection to database from client machine
(developer machine). I have changed the database security setup for "SQL
Server and Windows" under (local)Windows NT node of Enterprise Manager.
However, I could not setup a database connection to Server from Client using
Server Explorer of Visual Studio 2005. The detail is in the following.

Configuration of server and client:

Server: Windows Server 2000, SQL Server 2000
Authentication method: Active Directory Users and Computers (It is my first
time to use it)
User acount MyName with Admin role
User in database: domainName\MyName
SQL Server database security setup: "SQL Server and Windows" under
(local)Windows NT node

Client: Windows XP pro, Visual Studio 2005 pro

Operation of database connection:

1. Open Server Explorer on Visual Studio.
2. Add connection
3. Select Microsoft SQL Server and Continue
4. Select Server name: Server computer name
5. Select "use SQL Server authentication"
6. Type in User Name: "DomainName\MyName" or "MyNmae"
7. Type in User password: my windows server password
8. Test Connection
9. Error message: Login fails for user 'MyName' (or 'DomainName\MyName')

Thanks for any help

David



Oct 22 '07 #1
3 2587
after step 7, I type in a database name for connection

David

"david" wrote:
Last week I asked a question about connection to database from client machine
(developer machine). I have changed the database security setup for "SQL
Server and Windows" under (local)Windows NT node of Enterprise Manager.
However, I could not setup a database connection to Server from Client using
Server Explorer of Visual Studio 2005. The detail is in the following.

Configuration of server and client:

Server: Windows Server 2000, SQL Server 2000
Authentication method: Active Directory Users and Computers (It is my first
time to use it)
User acount MyName with Admin role
User in database: domainName\MyName
SQL Server database security setup: "SQL Server and Windows" under
(local)Windows NT node

Client: Windows XP pro, Visual Studio 2005 pro

Operation of database connection:

1. Open Server Explorer on Visual Studio.
2. Add connection
3. Select Microsoft SQL Server and Continue
4. Select Server name: Server computer name
5. Select "use SQL Server authentication"
6. Type in User Name: "DomainName\MyName" or "MyNmae"
7. Type in User password: my windows server password
8. Test Connection
9. Error message: Login fails for user 'MyName' (or 'DomainName\MyName')

Thanks for any help

David


Oct 22 '07 #2
sqlserver supports two types of users. sqlserver where the login and
password only exist in sqlserver (standard security) and windows
security, where the login defined in sqlserver is a nt account.

you created a nt account in sqlsever (sqlserver standard login do not
have a domain), so you must connect using windows authentication. this
means vs2005 must be running as the domain user you want to use in
sqlserver.

-- bruce (sqlwork.com)

david wrote:
Last week I asked a question about connection to database from client machine
(developer machine). I have changed the database security setup for "SQL
Server and Windows" under (local)Windows NT node of Enterprise Manager.
However, I could not setup a database connection to Server from Client using
Server Explorer of Visual Studio 2005. The detail is in the following.

Configuration of server and client:

Server: Windows Server 2000, SQL Server 2000
Authentication method: Active Directory Users and Computers (It is my first
time to use it)
User acount MyName with Admin role
User in database: domainName\MyName
SQL Server database security setup: "SQL Server and Windows" under
(local)Windows NT node

Client: Windows XP pro, Visual Studio 2005 pro

Operation of database connection:

1. Open Server Explorer on Visual Studio.
2. Add connection
3. Select Microsoft SQL Server and Continue
4. Select Server name: Server computer name
5. Select "use SQL Server authentication"
6. Type in User Name: "DomainName\MyName" or "MyNmae"
7. Type in User password: my windows server password
8. Test Connection
9. Error message: Login fails for user 'MyName' (or 'DomainName\MyName')

Thanks for any help

David


Oct 22 '07 #3
Thank you, Bruce.

Yesterday, I setup Database security as Windows Authentication. But I got
error message, somthing like 'untrusted computer'.
The login users for database are added from selecting Windows users. I added
windows users in Active Directory and setup role. The machine automatically
add the domain name before the user name. When I login to the server machine,
I do not need the domain name. And I can use Server Explorer to connect to
the server by using my server acount user/password.

In general, could you tell me what I should do on the server machine?

David

"bruce barker" wrote:
sqlserver supports two types of users. sqlserver where the login and
password only exist in sqlserver (standard security) and windows
security, where the login defined in sqlserver is a nt account.

you created a nt account in sqlsever (sqlserver standard login do not
have a domain), so you must connect using windows authentication. this
means vs2005 must be running as the domain user you want to use in
sqlserver.

-- bruce (sqlwork.com)

david wrote:
Last week I asked a question about connection to database from client machine
(developer machine). I have changed the database security setup for "SQL
Server and Windows" under (local)Windows NT node of Enterprise Manager.
However, I could not setup a database connection to Server from Client using
Server Explorer of Visual Studio 2005. The detail is in the following.

Configuration of server and client:

Server: Windows Server 2000, SQL Server 2000
Authentication method: Active Directory Users and Computers (It is my first
time to use it)
User acount MyName with Admin role
User in database: domainName\MyName
SQL Server database security setup: "SQL Server and Windows" under
(local)Windows NT node

Client: Windows XP pro, Visual Studio 2005 pro

Operation of database connection:

1. Open Server Explorer on Visual Studio.
2. Add connection
3. Select Microsoft SQL Server and Continue
4. Select Server name: Server computer name
5. Select "use SQL Server authentication"
6. Type in User Name: "DomainName\MyName" or "MyNmae"
7. Type in User password: my windows server password
8. Test Connection
9. Error message: Login fails for user 'MyName' (or 'DomainName\MyName')

Thanks for any help

David



Oct 22 '07 #4

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

Similar topics

2
by: Varkey | last post by:
Dear all, Can you please provide some information on the following issue, at the earliest. I have a development server setup in the network, say machine X. Also, there is another workstation,...
0
by: Mark Jerde | last post by:
(Sorry for the cross post but I've noticed lots of good advice in both groups.) I'm a solo software developer wanting to learn .NET. I did a lot of work in VB3 - VB6. I'm specifically...
0
by: M.sajjad | last post by:
Five Steps to Rapid Development with TierDeveloper 3.0 Unlock the power of rapid development when you use TierDeveloper from AlachiSoft in your N-Tier application development. Follow the steps...
5
by: Bill Willyerd | last post by:
I have been looking for some documentation that would support or reject my opinion on Production -vs- Development naming conventions. I believe that each environment should be housed on separate...
16
by: Linus | last post by:
Being a ASP developer for a consultant company thinking of starting developing with ASP.NET I have read literally hundreds of web pages and posts in discussion forums on the Internet to get an idea...
4
by: Richard Levasseur | last post by:
(Forewarning, most of these problems and solutions come from being the only developer in a 1 server department with no budget, few resources, unresponsive IT, and non-technical managers, so thats...
0
by: david | last post by:
I have developed web based information system under .NET application. The IIS, Visual Studio, and MS SQL Server are in the same server machine. Now the server will move to other site (another...
0
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
Last week I asked a question about connection to database from client machine (developer machine). There are two types of security setup for SQL Server database: Windows only and "SQL Server and...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.