SqlGenerator
SqlGenerator copied to clipboard
Conn String: For trusted connection, no user/pass is required, so its failing
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.
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.
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 :)