Can not exclude a connection to the SQL server

#1 · January 14, 2019, 1:14 pm

Hi,

When I start the project on the IIS server I get the following error message:

2019-01-14T14:08:38.4684132+01:00 0HLJQ45I1BO9S:00000007 [ERR] An error occurred using the connection to database '"TipWebTest"' on server '"SQL-NEW"'. (5fc3407c)
System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'TALK-IP\BINGO2-WEB$'.

In the appsettings.json file I have the following entry.

"ConnectionStrings": {

"DefaultConnection": "server=SQL-NEW;database=TipWebTest;user id=sa; password=password;Integrated Security=SSPI;Trusted_Connection=True;MultipleActiveResultSets=true"
},

I do not understand why the login is not with the user name which is registered, but with the name of the computer.

Can someone help me here?

regards Ingo

#2 · January 14, 2019, 2:12 pm

Hi,

I found the error:

"server=SQL-NEW;database=TipWebTest;user id=sa; password=password;MultipleActiveResultSets=true"

with this connection string its work fine!

Eben Monney has reacted to this post.

#3 · January 14, 2019, 4:36 pm

Glad you have it working.

IMPORTANT!

This forum is now archived. Click here for the New Support Forum