Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
caswest1
Starting Member
3 Posts |
 Posted - 2009-07-08 : 19:18:28
|
| I get error 3417 when trying to start SQL service. I've already tried to decrompess my data files, add 'network service' to data folder, and tried to switch the sql server 'log on' from network service to local account and interface with desktop, all to no avail. It seems all the internet fixes that work for everyone else are not working for me, and I'm wondering if anyone can help me out?its windows xp sp3, sql server 2005 .Matt Evans |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-09 : 00:08:28
|
| what account is sql service running under? are u local admin on xp box? |
 |
|
|
caswest1
Starting Member
3 Posts |
Posted - 2009-07-09 : 14:15:14
|
| sql is running under local and logged in as pc's admin.Matt Evans |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-09 : 15:42:29
|
| is this sqlexpress?tried making service account your logon?what do you see in eventvwr? |
|
|
|
caswest1
Starting Member
3 Posts |
Posted - 2009-07-09 : 17:26:17
|
| yes this is sqlexpress. service account was originally the login then i tried switching it to local system account. In eventviewer it references the master database files .mdf .ldf are corrupt and need to be rebuilt. I tried a recovery tool to rebuild the master database, but that didn't work out. I've googled this error and it seems many people have had this, but none of the fixes have worked so far in my case. When i run the sqlserver.exe it says the installation is corrupt or has been tampered with.Matt Evans |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-09 : 18:27:04
|
| is this a new installation?were u able to start it and connect b4? |
|
|
|
|
|
|
Error 3417