-
Service broker and database mail
A couple of weeks ago, I set up database mail on one server, and verified that it worked. A few days ago, my friend called because the mail was not working for him. This is the message I got when ran sp_send_dbmail stored procedure: Msg 14650, Level 16, State 1, Procedure sp_send_dbmail, Line 68 Service…
-
Midsommar and kräftskiva
The normally reserved Swedes celebrate summer in a big way. The biggest celebration of all is Midsommar, where people put up a maypole, sing and dance around it while imitating frogs, pigs, and violen playing, and just be merry in general. I’ve never attended Midsommar celebration during my summer trips in Sweden, because we were…
-
Sql Server Browser needs to be started for remote connection to a named instance
A default installation of Sql Server 2005 is pretty easy. After install, you can connect to it remotely, either through Sql Server Management Studio or sqlcmd. However, if you install a named instance on the same box, you may not be able to connect to it remotely, although connecting to it locally would still work.…
-
Issues connecting to SSIS and browsing packages in msdb when database service is clustered
In Sql Server 2005, you cannot cluster Sql Server Integration Service (SSIS). During database cluster install, you can pick to install Integration Service. SSIS will only be installed on the node where installation process starts from. For example, suppose you have Node1 and Node2, and the install is started from Node1, then database service and…
-
One year of blogging and trying to get out of my funk
It has been a little more than a year now since I started blogging. I started writing Sql Server related entries at http://blogs.sqlservercentral.com/blogs/haidong_ji/default.aspx. Shortly after that, I established this site, where I post all my blog entries. My purpose is simple: sharing my musings and observations, sharing my learning experience of various technologies, and keeping…