I have a Dell laptop with vista home basic. I want to install SQL on it, but every time I faced a problem in the middle of it. it has been stop with an error that can not connect to the MSSQLSERVER with the 'sa' account.I don't want to change my vist to xp because of this problem.what can I do? I need SQL very much, does it have any solution?
I have installed SQL 2005 Developer with no problem. You need to install the base product and then install SP2 for it to work on Vista. I think normally the SA account is disabled but can be enabled as one of the optiosns. Also with Vista the local admin is not normally a member of SQL Admin account but you get to add it as an option when you install SP2. Also reading you post you need to enable SQL accounts access if you want to use SA. Normally domain accounts are the default.
SQL 2005 Personal Edition should work also same restriction on SP2.
DexterRC
30 Posts
114
0
Posted May 28th, 2008 13:00