Browsing articles in "Tips & Tricks"
Dec
20
2011

SQL Server 2005 is inaccessible remotely – error:26-Error locating server

Today while working with one Veritas cluster server, faced following error (one of the common error – error:26), There are few basic troubleshooting steps a normal DBA follow, 1. Under ‘SQL Server Surface Area configuration manager’, go to ‘Surface Area configuration for services and connections’, go to ‘Server instance’ > ‘Database Engine’ > ‘Remote connections’ 2. In remote connections, first and foremost, your ‘local and remote connections’ should be enabled in case you would like […]

Nov
2
2011

How to insert a simple (Tick) Checkbox into office 2007?

Today I was struggling to insert a checkbox in Excel 2007, found a good tip as below, This can be done via Developer ribbon bar. If you do not see Developer as one of the tab options along the top (in the ribbon bar), do the following: 1. Click the Office logo in the top left corner 2. Down below besides Exit Excel you will find ‘Excel Options’, click it 3. In the ‘Popular’ window, […]

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 […]

Pages:«123456789

Subscribe to this blog via Email

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

Join 254 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2020
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31  

View Post by Categories

%d bloggers like this: