Solved

SQL SERVER CONNECTION ERROR

Posted on 2014-01-30
1
629 Views
Last Modified: 2014-02-15
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
Comment
Question by:Varshini S
1 Comment
 
LVL 26

Accepted Solution

by:
Shaun Kline earned 500 total points
ID: 39821755
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question