468,107 Members | 1,395 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

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 2320
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Mark Jerde | last post: by
reply views Thread by M.sajjad | last post: by
16 posts views Thread by Linus | last post: by
4 posts views Thread by Richard Levasseur | last post: by
reply views Thread by =?Utf-8?B?ZGF2aWQ=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.