Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 656
  • Last Modified:

SQL SERVER CONNECTION ERROR

I am getting following error when I tried to connect my SQL server.


A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The specified network name is no longer available.)

Connection String:

  <add name="remoteServer" connectionString="Data Source=192.168.1.4,1433;Initial Catalog=MyDb;Persist Security Info=True;Connection Timeout=130;User ID=crmuser;Password=abcd123456" providerName="System.Data.SqlClient" />
0
Varshini S
Asked:
Varshini S
1 Solution
 
Shaun KlineLead Software EngineerCommented:
If you remove the ",1433" from the data source property, do you get the same error? (The 1433 is a port number, and generally is not needed unless SQL server has been set up to run against a non-standard port.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now