Conn String: For trusted connection, no user/pass is required, so its failing

[smartmeter]

For trusted connection, there should not be user/pass - so its failing, also, I suggest that the Integrated/trusted connection setting should be a drop down.

I can fix and make a change if you want, or its simple below with ref.

Connection String Link

Standard Security

Server=myServerAddress;Database=myDataBase;User Id=myUsername;
Password=myPassword;

Trusted Connection Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Connect via an IP address

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;
Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

Attach a database file on connect to a local SQL Server Express instance

Server=.\SQLExpress;AttachDbFilename=C:\MyFolder\MyDataFile.mdf;Database=dbname;
Trusted_Connection=Yes;

Browse DB/attach would be as nice as well.

[jaklithn]

The initial entry is just there for reference to easier add the connection string of your choice, either using Trusted_Connection or User Id/Password. But apparently that was not obvious :)