Browsing articles from "September, 2011"
Sep
30
2011

SuperSocket info: (SpnRegister): Error 8344 SuperSocket Info: (SPNRegister) : Error 1355 SuperSocket info: SpnUnRegister() : Error 8344

Several times when you open Windows event log you may find some supoer socket related errors for SQL server, you may be amused that everything is working fine then why such errors, microsoft has provided a very good article on such issues, this error occur when you have configured SQL services to run under domain service account. Please find article review below, Error message/Symptoms: When SQL Server starts on a computer that is running Microsoft […]

Sep
15
2011

Redirecting SQL Client connection to different instance of SQL who is listening to 1433 (default port) without altering client ConnectionString

Here is a very useful article by Vipul T. Shah via his blog http://blogs.technet.com/b/vipulshah/archive/2010/06/07/redirecting-sql-client-connection-to-different-instance-of-sql-who-is-listening-to-1433-default-port-without-altering-client-connectionstring.aspx Excerpt from his article, Scenario: Current Setup: SQL Server 2005 Default instance – PRODServer listening at default port 1433 Client Connection String using SQL Native Client – Provider=SQLNCLI ; Server=PRODServer; Database=PRODDB; Trusted_Connection=Yes; with TCP/IP protocol with default port 1433 Now – Upgrade Happens… a side-by-side upgrade on a same server. New Setup: SQL Server 2008 Named Instance – PRODServer\NewPRO Now if […]

Sep
1
2011

Maximum Capacity Specification for SQL Server 2005 and 2008 !

I was going through some posts related to SQL Server capacity and came across this link – http://technet.microsoft.com/en-us/library/ms143432(SQL.100).aspx. Its amazing to see the max capacity specification for SQL Server. These are for SQL Server 2008, but they haven’t changed from SQL Server 2005’s limit. I would love to see systems with near capacity in below specifications: SQL Server Database Engine object Maximum sizes/numbers SQL Server (32-bit) Maximum sizes/numbers SQL Server (64-bit) Database size 1,048,516 terabytes […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

September 2011
M T W T F S S
« Aug   Oct »
 1234
567891011
12131415161718
19202122232425
2627282930  

View Post by Categories

%d bloggers like this: