SQL Express Default Instance

As of SQL Express 2008 R2, installing a default instance (not named) requires manually naming the instance to “MSSQLSERVER” for a functioning server on the default port.

This problem is documented at http://www.kendalvandyke.com/2009/01/installing-sql-express-2008-as-default.html – bug still exists in the SQL 2008 R2 Express installer. Workaround is fairly simple, just use “named instance” of MSSQLSERVER during setup.

Another important note, use “SQL Server Configuration Manager” to enable TCP, Shared Memory, and Named Pipes connectivity on all SQL Server instances and clients on the server. This will allow standard connectivity for Java JDBC, SQL Native Client, and other vital application connection methods.

Cheers!

Advertisements

About notesbytom

Keeping technology notes on WordPress.com to free up my mind to solve new problems rather than figuring out the same ones repeatedly :-).
This entry was posted in Database and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s