For <Development Only>, recommend
Use the Local System account,
That's the way SQL7 installed...
But, I also recommend that if/when you get close to going live, that
you create an environment that emulates the Production.
>Ignore the above post. I installed SQL Server so many times I forget I
>didn't leave the password blank during the last attempt.
>Compared to ODBC and mySQL, SQL Server 2000 seems unnessary complicated to
>install. What's considered the best way to install the thing for development
>purposes - is it a domain account or local account; mixed authentication or
>NT only authentication?
>> I'm just getting into ASP and SQL Server but I'm finding it very difficult
>> to connect to the database. I've reinstalled SQL Server 3 times trying the
>> different options; trying to get it to work but no luck. At the moment I
>> installed SQL Server with a domain account with mixed NT/SQL Server
>> authentification. Below is the connection string using JScript:
>> conn.Open("Provider=SQLOLEDB;Data Source=MARKHLAPTOP;Initial
>> And the error code is:
>> though other times its 0x80004005 (unspecified error)
>> Anybody any ideas?