After the install of PostgreSQL 8.4.5 should be done I got the following error: Installation may not complete correctly. The database cluster initialization failed. The services was not installed. The solution is simple. 1. Manually create the directory structure from PostgreSQL. In my case D:\PostgreSQL\8.4\data 2. Allow full access to all users ( including “postgres” [...]
Archive | SQL RSS for this section
Microsoft SQL Server Management Studio 2005 is to slow
In a corporate environment it is not uncommon for Microsoft SQL Server Management Studio (SSMS) for SQL Server 2005 to take over 45 seconds to start as well as lags and delays when opening various windows and dialog boxes from within the application. If you are experiencing this issue, then a quick fix is to add [...]
Troubleshooting SQL Server 2005 “No global profile is configured…”
1. Open Management Studio 2. Expand Management 3. Right click on Database Mail 4. Select Configure Database Mail 5. In the Welcome to Database Mail Configuration Wizard, click Next6. In Select Configuration Task window, select Manage Profile Security 7. In Manage Profile Security window, make sure you have a profile that is selected as default. [...]
ASP.NET 2.0 not registered in IIS
When ASP.NET is installed on your computer but not registered in your IIS you probably installed .Net before IIS. This is easily repaired with the following command “%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe” -i Bookmark on Delicious Digg this post Recommend on Facebook Share on Linkedin share via Reddit Share with Stumblers Share on technorati Tweet about it Subscribe to [...]
Manually uninstall Windows Internal Database
When you deploy Windows SharePoint Services 3.0 in a single-server configuration by using the Basic installation option, the Setup program automatically installs and configures Windows Internal Database. However, an entry for Windows Internal Database is not created in the Add or Remove Programs tool. If you remove Windows SharePoint Services 3.0, the Setup program does [...]
After restart Virtual Center Server does not start automatically
In my case the SQL server and the Virtual Center server are on the same server. So I need to make the Virtual Center Server service dependent of the SQL server. To make this happen type the following in a DOS box. sc config vpxd depend= MSSQLSERVER Bookmark on Delicious Digg this post Recommend on [...]
No mail send with SQL Maintenance Plan
Yesterday I setup a Maintenance plan for SQL 2005 with a notification trough mail. This morning I checked my mailbox, but no mail from the SQL server. After a quick look in the history from the Maintenance plan, I’ve saw the following error. Could not generate mail report.An exception occurred while executing a Transact-SQL statement [...]
