Development environment setup: connect to SQL Server 2000 database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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
 
Back
Top