August 9, 2009 at 11:54 am
After installing SQL 2008 and VS 2008, when I boot the PC (Windows XP), it has long delay. I can't run nothing!
In Event Viewer (System) it has this errors:
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7022
Date:8/9/2009
Time:19:00:48
User:N/A
Computer:K2008
Description:
The SQL Server Reporting Services (MSSQLSERVER) service hung on starting.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
In Event Viewer (Application) it has some of these errors about all databases:
Event Type:Error
Event Source:MSSQLSERVER
Event Category:Server
Event ID:17207
Date:8/9/2009
Time:18:58:46
User:N/A
Computer:K2008
Description:
FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 37 43 00 00 10 00 00 00 7C......
0008: 06 00 00 00 4b 00 32 00 ....K.2.
0010: 30 00 30 00 38 00 00 00 0.0.8...
0018: 00 00 00 00 ....
Please help me to solve this!
August 9, 2009 at 12:04 pm
What is your hard ware configuration? You know you need at least 1gig of ram I run 2gig. And you also need VS2008 to be SP1 and .NET 3.5 also SP1.
Kind regards,
Gift Peddie
August 9, 2009 at 3:18 pm
I have 2 GB RAM. I Installed first SQL Server 2008 Enteprise, than I uninstalled Visual Studio 2008 Shell-Integration. After that I installed Visual Studio 2008 RTM, and immediately VS 2008 SP1 (with .NET 3.5 SP1). Very helpful guide is here.
I choose NT AUTHORITY\SYSTEM account for SQL Server services. Only two last was Local Service.
Please do you have idea about this delay?????? I can't find any info!!!!
August 9, 2009 at 6:29 pm
I choose NT AUTHORITY\SYSTEM account for SQL Server services. Only two last was Local Service.
You need to create a domain account with enough permissions to run both SQL Server service and SQL Server Reporting Service. And XP is not the operating system for Enterprise edition which require server operating system but you can run the developer edition.
Kind regards,
Gift Peddie
August 10, 2009 at 6:32 am
I don't have domain! It is stand-alone pc. I have only one administrator user account in XP without password. I don't like to create separate accounts for sql.
It is needed to set a password for existing account? With Developer Editions can I solve these issues?
Please Gift Peddie, explain me one more time!
Thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply