SQL Server 2008 - Firewall

by 6. December 2008 00:08

Excerpt from following link: 

"Firewall systems help prevent unauthorized access to computer resources. If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked.

To access an instance of the SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server to allow access. The firewall is a component of Microsoft Windows. You can also install a firewall from another company. This topic discusses how to configure the Windows firewall, but the basic principles apply to other firewall programs."

There a more ports than TCP 1433 that need to be opened - read complete document at:

http://msdn.microsoft.com/en-us/library/cc646023.aspx 

 

SQL Server - Setting SA password in SQLExpress

by 10. September 2008 04:59

I locked myself out of a development database once by setting my "default" database to a newly created database and then later deleting it - the system wouldn't let me login.   Since then I've made it a point to have at least two Admin accounts into my SQL Server database.

It's been a while since I installed a new Server Instance so I had to relearn the steps taken (which are far easier with SQL Server 2005) - they follow:

  1. Launch SQL Server Management Studio
  2. Click on Security | Logins
  3. Right click on SA select Properties
  4. Select "Status" page
  5. Select Login of "Enabled" (radio button)
  6. Select "General" page
  7. type in new password

if you attempt to login as "SA" with your new password you will be greated with the following message:

Login failed for user 'sa'.  The user is not associated with a trusted SQL Server connection (Microsoft SQL Server, Error: 18452)

To resolve this comply with the following steps:

  1. Right click on the "Server" (not the database)
  2. Select Properties
  3. Select Security page
  4. Change Server Authentication to "SQL Server and Windows Authentication mode"
  5. Right click on the "Server"
  6. Select "Restart"

You'll now be able to login to your server as SA

Tags:

SQL Server 2008 - Notifications System discontinued

by 11. August 2008 00:19

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2897203&SiteID=1

After spending a week learning SQL Server 2005 Notification Services (to include Architecture via UML Diagrams for the team) we learned that Notification Systems will not be supported in SQL Server 2008.  Since there is a hefty learning curve to configuring it (but once configured very powerful) I was going to write an open source application for setting up and configuring a Notification Service; I actually created a prototype application for work that required less than 50 lines of code for configuration...   Time had been budgeted for me to convert the prototype into an application; I told my manager I would have the open source product (at no cost to them) but the company wanted to have ownership.

Needless to say my programming efforts for Notification Services will be discontinued also (reference CompositeWPF ShellApp blogs)....

SQL Server 2005 - How to Install Samples

by 24. July 2008 12:31

With our folder monitor being overrun (processing taking to long) we brain-stormed numerous ways to get over 50,000 images to process (our load test) without dropping an image.   A team member suggested SQL Server 2005 Notification Services as a possible solution. Thus began my adventure to create a prototype; samples are not installed by default and they aren't as easy to install as one might think....

I've come to gain a huge respect for Microsoft Tutorials; I find they consistently save hours of time and now (more than ever) provide an abundance of information and details.   As I opened the tutorial for Notification Services it told me I had to setup SMTP and install the Samples.   I installed the SQL Server 2005 Standard Edition CD and selected tools (I'm running from memory) and after some churning and burning it came back with a dialog box that told me I had process Sql Server Tools from the control panel's programs feature.  This is where the fun started because there is no SQL Server Tools in the program list.

Longgggg story short - you have to remove SQL Server 2005 (I needed to get the samples installed so was going to uninstall everything and reinstall).  If this sounds odd to you, that you have to remove SQL Server 2005 to install your samples, then we think alike - you really don't have to remove SQL Server 2005 but this isn't readily apparent and I never would have figured it out had I not been so frustrated that I decided to remove it.... to my surprise the SQL Server 2005 REMOVE button results in a checkbox list of items to remove - one of them being SQL Server Tools!!!

I unstalled SQL Server Tools, went back to the installation process, had it install everything and was happy to see my samples folder and files!  After hours of effort I was ready to work.

Notice

Blog videos and references to CodePlex projects are no longer valid