Unable to do SQL Stored Procedure debugging remotely from VS2010

This post describes an interesting scenario that I came across when working with on Visual Studio Project based issue. In this situation, customer was unable to debug stored procedures on a remote SQL Server using Visual Studio. The SQL Server was running on a Virtual Machine that was in a different domain than the domain…

0

ODBC drivers not visible in the ODBC Data Source Administrator (odbcad32.exe)

I recently had an issue where after the installation of a Third party Client side tools, we were not able view the drivers listed in the ODBC Data Source Administrator (odbcad32.exe). In order to create a DSN to use this third party driver, we had to take a backup/export of the registry key of an…

9

Things to keep in mind regarding Registry while migrating a 32 bit application from Vista x64 to Windows 7 x64

If you are migrating a 32 bit application from Vista x64  to Windows 7 x64 and your application relies on some information in registry. There are few things you should consider as following. In Windows 7, registry is virtualized. As a result, wow64 applications don’t have to explicitly provide registry path with Wow6432Node node. For…

1

“ORA-12154: TNS: could not resolve the connect identifier specified” error while creating a linked server to Oracle

This is one of the most common errors while creating linked server to Oracle database. Today I will discuss the reason for this error and possible resolutions. Full error message: OLE DB provider “MSDAORA” for linked server “LINKED_ORA” returned message “ORA-12154: TNS:could not resolve the connect identifier specified”. Msg 7303, Level 16, State 1, Line…

33

Using Network trace to troubleshoot intermittent connectivity issues

Intermittent connectivity issues from a client machine when connecting to a remote database server can be often attributed to the network layer. By collecting the network traces and reviewing them we can tell why the connections failed to succeed or if the existing connections were getting closed. Recently I worked on a case where the…

9

How to troubleshoot connectivity issues using Windbg

Using the Windows Debugging tool WinDBG you can attach a live process and debug. You can set up break-points at different function calls and debug when the process hits and stops to the break-points. When you do not have the source code (which is true for most of the products that we use as end…

0

Why is my ConnectionString incorrect..?

Folks, I wanted to post this experience as I struggled for a couple of days trying to figure out what’s wrong in my connection string when I handled a migration scenario from Windows 2000 to Windows 2008. I had a bunch of VBScripts doing database update jobs running successfully over years on the Windows 2000/XP…

20

Write method of OpenSQLFileStream is generating Event 2000 Errors on SQL Server

One of my customers was experiencing a lot of event 2000 errors on the SQL Server Machine. These were happening every time when they call the Write method to a SQLfilestream from an XP client. The issue occurs only on XP Client OS and not on any other Operating System. Below is the OpenSQLFileStreamAPI Call…

1

Unable to execute a remote stored procedure over a linked server

I ran into an interesting situation when executing a Remote Stored Procedure on Linked Server using four part query.  Vista-3139 which is a SQL Server 2005 instance is linked to the SERV2003\SQLDUMMY which is a SQL Server 2000 named instance. When I tried to execute a stored procedure: EXEC [SERV2003\SQLDUMMY].SQLAdmin.dbo.sp_ddlevents Got the following error message. Could…

6

How best to connect to a default instance of SQL Server listening on a non-standard port with a firewall enabled.

We had a case recently where the Default instance of SQL Server was listening on a non-default port. Any guesses what happened when the client tried to connect to the Default instance using TCP?  Reading KB 823938 will provide a clue but doesn’t spell it out.  The relevant portion of the KB reads: “If a…

3