SQL Server 2005 on VISTA fails to start


 

some appreciated. stuck 2 days now. ( got dim view of vista @ point...)

running windows vista business, sp1 on dell optiplex 740 (amd tripple core 2.3) 4gb ram.

 

trying install sql server 2005, developer x86 edition.

 

on start of install following warniing "this program has known compatibility issues". recommends online, did , found nothing useful. further says "after sql server setup completes, must apply sql server 2005 service pack 2 (sp2) or later service pack before run sql server 2005 on version of windows" 

 

so assumed install, , service pack , good.  except cannot through install.

  • it goes through prerequisties fine
  • system config check - no problems
  • under components install select sql server database services (i've tried selecting everything...and db engine - same results)
  • i've tried default , named instances
  • i've tried domain accounts ( in local admin group), local system account, network service account....all same outcome
  • i've set not start services on completion. thinking need first sp2...no help....
  • i've tried windows , mixed mode authentication...

 

the install runs, , @ end tries start service ( though said not to...).. service fails start , install rolls back. fail error following...

"the sql server service failed start. more information, see sql server books online topics, "how to: view sql server 2005 setup log files" , "starting sql server manually"

another window opens says

"sql server windows nt has stopped working" following details

problem signature:

problem event name: appcrash

application name: sqlservr.exe

application version: 2005.90.1399.0

application timestamp: 434f82e9

fault module name: sqlservr.exe

fault module version: 2005.90.1399.0

fault module timestamp: 434f82e9

exception code: c0000005

exception offset: 01019027

os version: 6.0.6001.2.1.0.256.6

locale id: 7177

additional information 1: 6cf9

additional information 2: 674b42c7f9bfadbd89ec03f15703c069

additional information 3: d0f5

additional information 4: 3fbecdc6cabbbde98d4edf37ffeef848

 

attempts start  manually fail well.

 

any appreciated.

 

kmarais

 

 

 

might additional processor seem have running. disarray reigns in odd numberssmile



SQL Server  >  SQL Server Setup & Upgrade



Comments

Post a Comment

Popular posts from this blog

SQL server replication error Cannot find the dbo or user defined function........

hi there, i ran problem while deploying sql 2008 transactional replication between 2 servers lets assume server , b. actually created  both distributor , publisher on server , after created subscriber pointed server b, launch replication monitor , found big red cross. when click on tab "distributor subscriber history" error says "cannot find either column "dbo" or user defined-function or aggregate "dbo.ufnleadingzeros", or name ambiguous". can body regarding issue. regards, ishuv hi, you need compare data , others reseved, index size, unused should not compared. differs. here server - data - 87896 kb server b - data - 78152 kb server data size includes publication tables, can't compare directly. need check article article know exact data size. SQL Server  >  ...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

Admin Permissions

hi need create new 'role' following permissions, 1. access sql server logs. 2. access maintenance plans ( can avoid access) 3. access activity monitor 4. normal access product databases , not system db´s need guidance on how it, can point me in right direction please? thanks 1.grant  execute on xp_readerrorlog [domainname\ad user or group]; 2. http://technet.microsoft.com/en-us/library/ms191002.aspx 3.view server state permission 4. make user member of dbo_owner database role. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  >  ...
Read more