First off, I am not an IT guy or intimately familiar with dealing with databases. If any of this sounds dumb, that 's why.
Currently, I have an Excel macro using a connection string to get records from a database on one of our servers. The syntax is:
Currently, I have an Excel macro using a connection string to get records from a database on one of our servers. The syntax is:
quote:I would like to use something like:
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
quote:The first connection string works, but when I try the second, it says that logon failed. As I understand it, SSPI just uses the current Windows credentials, so why can't I just enter Windows credentials (my idea is to have an account for this macro to use since lots of people without server access will need to use it)?
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;
User Id=myUsername;Password=myPassword;