SQL Server Database Connection String?

As A. DIMO says, you cannot authenticate using integrated security on *NIX. It's not a windows box.

As A. DIMO says, you cannot authenticate using integrated security on *NIX. It's not a windows box.In your SQL Server Management studio, create a login that uses SQL Server authentication and not Windows Authentication.

Ensure it has the necessary writes on the database in question. Next, remove the Integrated Security=SSPI part of the connection string. That should do the trick.

Part of the problem is that I have very limited access to the server: it's for a school project and the server is on a school server. Can one change his own account authentication type? Or would I need an admin to do that?

– mikhailvs Oct 25 at 15:57 1 @mikhailvs you'd have to get the School DBA to create a SQL-Server account for you to connect with. Send him a nice email saying "I love windows, but... ", and make sure to finish it off with lots of – mikhailvs Oct 25 at 22:20.

You cannot use sql server integrated authentication with linux, you have to use sql server authentication.

While not a direct answer to your question, this site is useful for almost any connection string question: connectionstrings.com/. At the risk of sounding like a commercial: It's your one-stop-shop for connection strings!

1, Back in the old days it was wotsits file formats that was the melting part of information. That was quickly replaced by connectionstrings.com :D – Moo-Juice Oct 25 at 15:56.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions