Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
smartmeter opened this issue Jun 26, 2016 · 1 comment

Comments

@smartmeter
Copy link

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
Copy link
Owner

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 :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants