As I said above, alphanumeric fields will be treated as an NVARCHAR, not a VARCHAR (techinally, as I said, DT_WSTR, and DT_STR respectively). This is an intentional behaviour (as it...

I believe the user is talking about SSIS, as the default field type on that for a alphanumeric field is DT_WSTR, which translates to nvarchar on SQL Server. If so,...

mw112009 (11/21/2016)

---

YES

It works for me ( because I have VS2015 installed on my desktop 0 So the connection info is perfect. It is a compatibility issue where a report produced...

rajemessage 14195 (11/22/2016)

---

1) select * from abc where abc.abcid =(select top 1 xyz.abcid from xyz where xyzid =@xyz order by xyz.abcid )

2) Select * from df where df.dfid in (select...

Wondering if it's an SSL error, or that named pipes or that TCP/IP is disabled.

Do you have any issues connecting to the SQL Server instance from any other computer on...

planetmatt (11/22/2016)

---

As I said, no explicit permissions. The...

You'll need multiple datasets to achieve this. I don't have any DDL for what you current set up is, but hopefully this'll help you out.

Firstly, I'm going to create a...

What are the permissions of the account you are viewing this dialogue box from? Do you have permission to impersonate?

Phil Parkin (11/22/2016)

---

We have installed SQL Server 2016 Web Edition (64-bit) on a new virtualised database server running Windows Server 2016 Standard. We have an existing web server running Windows...

As Ed said, they must be the exact same AD Account. I'm therefore hoping you are using a Domain Controller, with Domain Accounts. If you are using Local accounts, you...

I would, to be honest, be surprised that the user is unable to connect from SSMS 2012 but can from SSMS 2008. What authentication method are you using?

I have SSMS...

What do you mean "The company will not allow it"?

If you're not allowed to export tables contents to a CSV, why are you trying if it's against company policy to...

SQL Server 2012 does come in both 32bit and 64 editions.

You can find the download page here (it's the last option in the download list).

As for the DSN, I'm afraid...

You've already asked this question, and deleted your post content. Why?

http://www.sqlservercentral.com/Forums/Topic1835402-3411-1.aspx

People have given you a link to MSDN there.

I don't have an answer for that I'm afraid, I've not used external hosting.