SQL Server connection fails

– IDK: I don’t know
– Y: yes
– N: no

Which version is your SQL Server ?
– I don’t know
– 2016
– 2014
– 2005

Are you using an IP in the conenction string?
– Y
– N

Is the application that need to conenct on the same machine of SQL Server ?
– Y
– N

Are you using a Trusted conenction?
– IDK
– Y
– N

Are you using “localhost” as server name?
– IDK
– Y
– N

Do you know which connection string are you using?
– IDN
– Y
– N

Are the TCP inbound/outboundport allowed for port 1433?
– IDN
– Y
– N

The Login user in SQL Server is allowed to connect and login?
– IDN
– Y
– N

+ A001: use “(local)” instead of “localhost”
+ A002: check this: https://support.microsoft.com/en-us/help/328306/potential-causes-of-the-sql-server-does-not-exist-or-access-denied-err
+ A003: use “(local)” or instead of the IP address
+ A004: check this settings in Server/Security/Logins/User/(right click)/Properties/(Status section)
[attach image]

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s