localhost/reports is blank? You can not configure any new reports right?
are you using windows 2008 server?
If you answer yes to these questions than proceed to the next part below.
Well, right click on IE and run as administrator
or remove UAC in windows 2008.
Thursday, September 23, 2010
Saturday, September 18, 2010
Moving? Tempdb is out of space
Moving Tempdb
In order to move the tempdb database, open SSMS and run the following query:
use master
go
Alter database tempdb modify file
(name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
go
Alter database tempdb modify file
(name = templog, filename = 'E:\Sqldata\templog.ldf')
Go
This command assumes that you are
moving the database files to E:\Sqldata directory
Monday, September 13, 2010
No mapping between account names and security IDs was done
SQL Server Setup has encountered the following error:
"No mapping between account names and security IDs was done."
"Error code 0x84BB0001."
"No mapping between account names and security IDs was done."
"Error code 0x84BB0001."
- go to services not ms sql config manager
- change the service(s) to run under local services
- reboot
you probably demoted domain controller or changed accounts somehow
Tuesday, September 7, 2010
Can not start MS SQL Server 2005 because ERRORLOG full?
Things to do:
P.S check the ERRORLOG it may be a GIG is size (Sql won't start).
- Check the MS Sql server 2005 configuration tool and make sure MS SQL server is started
- restart the MS Sql Server service ( this will cycle ERRORLOG to errorlog.1)
- launch SSMS and exec sp_cycle_ERRORLOG (use master)
P.S check the ERRORLOG it may be a GIG is size (Sql won't start).
Subscribe to:
Posts (Atom)