Setup for Development environment?

Similar Threads:

1.Development environment setup: connect to SQL Server 2000 data

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

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

3.Development Environment Setup

Hi,

We are newbies and have just gotten our servers,  is there 
any reference documentation available that shows us how to 
setup our development environment?

Thanks

4.Development Environment Setup Help

(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 interested in learning web stuff.  The goal of
this post is to get help for setting up my home system for development &
testing, and easy uploading of the apps to my web host.

My web host is DiscountASP.net.  I have both a web site (.NET 1.1 capable)
and SQL Server 2000 with this host.

My home setup is a WinXP Pro laptop, a Win2000 Pro desktop, and a cheap Dell
desktop with Win Server 2003 Standard (installed despite the objections of
the built in LAN card. <g>)  Yes, MSDN Universal helped make this possible.
DSL + a router gets me to the internet.

Several months ago, before I got deeply involved in non-programming
projects, I installed VS.NET 1.0 & did some playing around.  I found it was
necessary to work with Administrator access on my Win2000 Pro box when doing
web stuff, and this fundamentally bothers me.  Too many bad things can
happen when you're working Administrator equivalent.  Books and internet
information indicated that setting up a "real" server was the way to go.  So
I bought an inexpensive desktop, managed to get Win 2003 Server installed on
it, and ...  didn't do anything else before getting involved in other work.

Now I have the time (and the urgent need) to get some web apps working.  I'd
like to develop on my home system, have everything under Visual SourceSafe
control, and upload to folders on my web site.  What are the minimum things
to do to make this a reality?

I have a 1088 page book on Win Server 2003.  As I flip through the book, I'm
amazed at my depth of ignorance. <g>  Given enough time I know I can figure
anything out -- I've written MS DOS 1.0 TSRs, for crying out loud.  But
instead of a long Win Server 2003 learning curve I'm looking for a short,
straight "learning sidewalk".  I just want to be able to have a "complete
development setup" at home to upload to my host.

I don't think I'm the first person who has wanted to do this but so far I
haven't found anything on the net.  "Win Server 2003 For Dummies Who Want To
Stay That Way" isn't listed on Amazon.  <g>

Thanks!

   -- Mark

5.Development Environment setup?

I had asked this question about a week ago, but never got any feedback. I am 
going to post it again:

I need some advice on how I should setup my development environment.  I am 
developing in ASP.Net with VB.net (.NET 2.0). I am working with multiple 
sites. Some sites that use SSL are on two separate servers (in production). I 
work alone and do not have a team of developers. In the old days of classic 
ASP I had a development server that I could host all my sites on. To develop 
in ASP.net on that same server I need to install FrontPage server extensions. 
That has been a real mess. I gave up on that. I was using VSS 2005 and the 
server extensions would mess up my source database for some reason. I also 
had trouble with the FP-SE not allowing me to log in. I don mind developing 
everything on one XP development machine, but wanted to get peoples opinions 
on how I would set it up. What is the most effective way for me to work on 
multiple sites on an XP machine? Has anyone tried developing sites on a 
server without server extensions? I am using windows XP and 2003 if you 
hadn already guessed. Since some of my sites, in production, have separate 
server for SSL, would I need 2 separate projects? I guess I would. Thanks to 
all who respond.

Daniel

6. Development environment setup

7. development environment architecture for ASP.NET development team

8. Executing VS.NET ERROR: Ms development environment has not been installed for the current user