UNSOLVED

F.N.Z

updated

19 years ago

FN

F.N.Z

11 Posts

0

3571

May 25th, 2008 03:00

SQL in Vista

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?
  • DexterRC

    30 Posts

    114

    0

    Posted May 28th, 2008 13:00

    Are you installing an SQL server in Vista or trying to connect to one that you already have installed?
  • TomXPS

    1310 Posts

    114

    0

    Posted May 28th, 2008 14:00

    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.

     

     

     

     

  • F.N.Z

    11 Posts

    114

    0

    Posted May 29th, 2008 04:00

    Thanks a lot for your answer. I will examine your answer on my system, and I think it would work.