Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 sa account for ASP.NET

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2005-02-10 : 12:03:08
I want to install SQL server 2000 in local pc and have ASP.NET application to access by using "sa" account. How to intall it?

chadmat
The Chadinator

1974 Posts

Posted - 2005-02-10 : 12:33:10
Insert Installation Disk.

Follow on screen instructions.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.
Go to Top of Page

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2005-02-10 : 13:30:12
There are options while in doing installation. That is my question.
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2005-02-10 : 14:53:48
When prompted during installation, you want to select Mixed Mode authentication, and not Windows Authentication. If SQL server is already installed, you can go into Enterprise Manager, right click on the database server, goto properties, then the security tab, and select "SQL Server and Windows" and that should change it for you.

My english teach would love that run-on sentance, but I really don't care becuase I love commas.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page
   

- Advertisement -