Friday, April 12, 2013

[SQL 2012] Sql Server 2012 can't see 2nd drive

[SQL 2012] Sql Server 2012 can't see 2nd drive


Sql Server 2012 can't see 2nd drive

Posted: 14 May 2012 02:33 PM PDT

I installed Sql Server 2012 Express. Everything went without a hitch until I attempted to create a new database and place it on a second drive (E:). The location window displays C: and an external drive (Z:), but not the E: drive where I wish to place the database. Permissions show full control, but Sql Server won't display it.

Event ID: 7000 The SQL Server...service failed to start due to the following error: Access is denied.

Posted: 12 Apr 2013 02:18 AM PDT

Yesterday I worked through a new install of SQLServer 2012 with SP1 on Microsoft Windows Server 2012 Standard on a VMware virtual machine. Once complete I noticed the services were stopped and there were errors in the OS system log:[code]Log Name: SystemSource: Service Control ManagerDate: 4/11/2013 12:50:41 PMEvent ID: 7000Task Category: NoneLevel: ErrorKeywords: ClassicUser: N/AComputer: ...Description:The SQL Server (MSSQLSERVER) service failed to start due to the following error: Access is denied.[/code]I wrote a blog on the solution here:[url]http://jonmorisissqlblog.blogspot.com/2013/04/event-id-7000-sql-serverservice-failed.html[/url]

Report Format via SQL Server 2012

Posted: 12 Apr 2013 01:29 AM PDT

HiPlease could somone advice which is the best method for creating a report from SQL that will have 1 desktop machine per page wiith all the software that has been installed.All the software and desktop information are held within SQL SEVER 2012 database.Projects Team needs to ensure when pc is refreshed the same licensed software goes back on.ThanksClive

Columnstore Indexing - There is insufficient system memory in resource pool 'default' to run this query.

Posted: 11 Apr 2013 04:55 AM PDT

disregard for now, hopeful that I found what I was looking for

No comments:

Post a Comment

Search This Blog