SSRS DSN connection

I was setting up a System DSN connection to use in SSRS. I would create the ODBC connection using the SQL Server Native Client 11 driver on the SYSTEM tab of ODBC connections. Then in SSRS, the DSN name would not appear. This is because I needed to create the DSN using the 32 bit ODBC ui, which is not the default on my machine. I had to specifically load it using : C:\Windows\SysWOW64\odbcad32.exe

Now it will show in SSRS.

 

 

 

I had found this on SO:

Are you using a 64-bit machine? If so, be aware that on a 64-bit machine there are TWO ODBC Data Source Administrators, one for 32-bit and one for 64-bit drivers. If you create a System DSN in either one, it is not visible in the other.

The 64-bit version is usually in C:\Windows\System32\odbcad32.exe

The 32-bit version is usually in C:\Windows\SysWOW64\odbcad32.exe

I’m not sure which version Reporting Services is looking for but try opening both versions up and re-creating your DSN in the one where it’s missing (assuming there are both 32-bit and 64-bit drivers for your data source).

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s