Development environment setup: connect to SQL Server 2000 database - DOTNET

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
>
>
>
>
>
>
>

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
>
>
>
>
>
>
>

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
> >
> >
> >
> >
> >
> >
> >
>