Invoke or BeginInvoke cannot be called on a control until the window handle has been created..

November 21, 2010

If you installing new instance of SQL Server 2008 or adding new features to an existing one and got this error

SQL Server Setup has encountered the following error:
Invoke or BeginInvoke cannot be called on a control until the window handle has been created..

I won’t recommend you to go to http://support.microsoft.com/kb/975055 and waste your time installing SQL Server 2008 SP 1 because it won’t solve the problem.

Solution
Close IE\Explorer windows or anything you can open after doing your installation process 🙂 yes that’s it… weird..


SQL Server 2005/2008 errors during installation

June 24, 2010

2 days to install SQL Server 2008\2005 each time I try; It fails with this error

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, “How to: View SQL Server 2005 Setup Log Files” and “Starting SQL Server Manually.”

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlScript%40sqls%3a%3aService%3a%3aStart%40x41d

To solve the problem I had to disable the antivirus (BitDefender -what I’ve-) seems it prevents the windows installer to start any services! to over come this prevention stop your antivirus.

Another error message may appear after you install\uninstall SQL Server due to errors in installations…

SQL Server Setup has encountered the following error: The given key was not present in the dictionary..

although I’ve valid\legal SQL Server serial number I don’t know from where this error comes! what I had to is to install “Windows Install Clean Up” to clean any SQL Server installation. download it from http://support.microsoft.com/kb/290301


After installing SSRS! You can’t manage Reports site

March 31, 2010

It’s just a quick tip after you’ve successfully installed SQL Server Reporting Services on Windows Vista or Windows 7, you go to http://{Server-Name}/reports which redirects you to http://{Server-Name}/reports/Pages/Folder.aspx you find out that you can’t control anything and the site looks like this

Don’t worry what you should do is to, right click on Internet Explorer or your favorite browser then run as administrator and retype your SSRS Reports site URL http://{Server-Name}/reports you’ll find you can manage everything as you see

To not open your browser as administrator everytime you manage your Reports you should add your current user as Content Manager or as you wish. From Properties-> New Role Assignment -> Type the username of current user -> Select role -> OK

Open it without run as administrator it will look like as you want.


Replication Error “SQL Server is unable to connect to server..”

February 25, 2010

If you’re working in SQL Server Replication, you may get this message
SQL Server is unable to connect to server ‘Your server name‘.

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ‘Another server name‘. (Replication.Utilities)

It always appears as you change the instance name manually or network administrators change the computer name.

Actually your server name still as it’s and not changed with above changes so to avoid getting this message you should write these couple of T-SQL scripts every time you do one or all changes on the instance name

SELECT @@SERVERNAME — you’ll get a strange name, you may didn’t see it before…
GO
sp_dropserver ‘Old server name’ — you got it from pervious select.
GO
sp_addserver ‘SQL server instance name’,’local’ — the name of current instance.
GO
Then, restart the service, and go on you replication work…

SSIS insert bulk of data into remote table with trigger

November 4, 2009

hmmm, nice we have SSIS it makes life easier but it usually comes with non-understood problems like

“SQL Server Destination” (2185) failed with error code 0xC0202071 it means when you insert data into table in remote SQL Server don’t use SQL Server Destination component however use OLE DB Destination component, thank you SQL Server Central

Anyway I used OLE DB Destination component and everything went well but I found the trigger which updates something doesn’t fire simply because I do bulk insert and I should tell the BIDS please fire it.

So, right click on OLE DB Destination component then Show Advanced Editor… Component properties FastLoadOptions write FIRE_TRIGGERS

ssis postThank you Piotr Rodak


SQLCLR or T-SQL? A Brief Survey of Performance Options

September 8, 2009

Session #19: SQLCLR or T-SQL? A Brief Survey of Performance Options

Event: 24 Hours of PASS

Presenter: Adam Machanic

Download


Delivering Good Performance Consistently with SSIS

September 8, 2009

Session #1:
Event: 24 hours of PASS
Presenters:

Session #4: Delivering Good Performance Consistently with SSIS

Event: 24 Hours of PASS

Presenter: John Welch

Download

ssis1 Read the rest of this entry »