I'm an RIA Developer who owns a motorcycle custom paint shop, who loves to race anything with wheels. I also enjoy woodworking, cooking, fine wines, liqueurs and dark beers. So if nothing else my blog should be eclectic.  

Category: Windows XP

Apr 16 2008

Install a new SQL Server Instance from Command Prompt

I was having some issues doing a standard install of SQL Server 2005 SP2 (Standard). No matter what I did, the install complained about versioning issues. I knew you could blindly run a full install from command promt but I had never needed/wanted to. Out of desperation I decided to give the install a try from command the prompt and had great succcess.

setup.exe /qb INSTANCENAME=EGPS ADDLOCAL=SQL_Engine SAPWD=***** AGTACCOUNT=ComputerName\Services AGTPASSWORD=***** SQLACCOUNT=ComputerName\Services SQLPASSWORD=***** SQLAUTOSTART=1 SECURITYMODE=SQL

Read more...

0 comments - Posted by Russell Brown at 11:55 PM - Categories: SQL | Windows XP | Development

Categories

Monthly Archives

Tech Blogs I Read

Motorcycle Links