jands
asked on
Sql Express 2008 R2 Client Dropping Connection/Wont Connect
We recently migrated a users database from Microsoft Access to Sql Server express 2008 R2. They have a mixed environment of XP and Windows 7 professional machines. The server is Windows Standard 2003 with the latest service pack. The problem is that some of the machines intermittently either have an error when launching the program that uses sqlesxpress from the server or drops the connection throughout the day. The error is unable to connect/or locate the servername/database name. I can connect to shares and the server for other things. We have tried pinging from these pc's for a 24 hour period in which there were no drops. We also replaced the NIC on one of them and were still experiencing the same issues. Some machines dont have any problems at all both xp and 7. We are at a loss for what to try next and we think it may be a sql issue?
Any thought?
Any thought?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Will you please elaborate on the remotesql your speaking of? Where would I find these settings?
Can you please go through these URLs :
http://www.codeproject.com/Articles/190780/SQL-Server-2008-R2-Setup-Configurations-Remote-Acc
http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx
Regards,
vijay kadadi
http://www.codeproject.com/Articles/190780/SQL-Server-2008-R2-Setup-Configurations-Remote-Acc
http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx
Regards,
vijay kadadi
ASKER
We have resoled the issue. The problem was that in sql config manager there are a few protocols. I was told that named pipes and TCP/IP needed to be enabled. They were enabled at first glance, however when I right click on TCP/IP and chose properties there was a tab called IP Addresses. In there it listed the specific ip addresses on the server (both NICS and the loop back address. These were all disabled in this menu. I enabled this feature on all IP addresses that were listed and all seems fine now. I would like to close this as solved on my own. How do I close this?
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for jands's comment #a38420730
for the following reason:
This has resolved the issue.
Accepted answer: 0 points for jands's comment #a38420730
for the following reason:
This has resolved the issue.
@jands
Yes correct Remote Mssql Server configuration settings are changed.
In my comment same is the Answer there.
Regards,
vijay kadadi
Yes correct Remote Mssql Server configuration settings are changed.
In my comment same is the Answer there.
Regards,
vijay kadadi
ASKER
The computer GMJIM tried to connect to the server \\servername using the trust relationship established by the STERLING0 domain. However, the computer lost the correct security identifier (SID) when the domain was reconfigured. Reestablish the trust relationship.
EVENT ID - 5513 NETLOGON
and
The session setup from the computer GINAOFFICE failed to authenticate. The name(s) of the account(s) referenced in the security database is GINAOFFICE$. The following error occurred:
Access is denied.
EVENT - 5722 NETLOGON
The session setup from the computer GINAOFFICE failed to authenticate. The name(s) of the account(s) referenced in the security database is GINAOFFICE$. The following error occurred:
Access is denied.