My connection string does not connect when using username and password - SQL (Urgent)
Posted on 2016-08-02
We have just replaced the server at a client and I am now trying to get my software to connect to the SQL database.
The connection string for the previous server was:
data source=MYSERVERNAME;initial catalog=dbHCA;persist security info=True;user id=myuser;password=mypassword;MultipleActiveResultSets=True;
This returns an error login failed for user 'myuser'.
Server authentication is set to both SQL and Windows
My user uses SQL server authentication and is mapped to dbHCA as a db_owner.
The properties look exactly the same as the previous server.
Am I missing something?
I did not setup the SQL server and we are using SQL server 2016.
Please let me know if you require more information.
As a side note: I can connect using integrated security
Data Source=MYSERVERNAME;Initial Catalog=dbHCA;Integrated Security=True