Showing posts with label connect. Show all posts
Showing posts with label connect. Show all posts

Friday, March 30, 2012

Network connection problem when trying to use SSMS

I have two SQL servers that are having the same problem. I have
recently installed SSMS on my laptop, and when I try to connect to one
of my SQL Servers using SSMS, the NIC card dies. I have two NICs in
both of these servers, one on the normal LAN, and the other NIC is
used on a separate VLAN that the servers use to talk to each other.
After a minute or two of being connected to the SQL database, the
server just stops responding. I can't ping it, I can't RDP into it,
and I can't connect to any of the DBs on it from the LAN. I can still
access the server from one of the other servers, however, because that
NIC is not affected. As soon as I open a web browser from that server
and try to go to an external website, the NIC reactivates and I can
access it from the LAN again. I can manage the DBs on the other
server using SSMS without a problem, however. An associate of mine,
is having the exact same problem, but with the other server. He is
able to manage the server that I can't from the LAN using SSMS, and
vice versa. I've done some googling, but haven't had any luck as of
yet.
Has anyone else seen this and know how to fix it'
Thanks, in advance.Hi Matt
I assume you have tried changing the NICs?
Have you looked at the perfmon counters to see the NIC activity?
Are you using any monitoring, AV, IDS or software update software on your
networks?
John
"Matt" wrote:
> I have two SQL servers that are having the same problem. I have
> recently installed SSMS on my laptop, and when I try to connect to one
> of my SQL Servers using SSMS, the NIC card dies. I have two NICs in
> both of these servers, one on the normal LAN, and the other NIC is
> used on a separate VLAN that the servers use to talk to each other.
> After a minute or two of being connected to the SQL database, the
> server just stops responding. I can't ping it, I can't RDP into it,
> and I can't connect to any of the DBs on it from the LAN. I can still
> access the server from one of the other servers, however, because that
> NIC is not affected. As soon as I open a web browser from that server
> and try to go to an external website, the NIC reactivates and I can
> access it from the LAN again. I can manage the DBs on the other
> server using SSMS without a problem, however. An associate of mine,
> is having the exact same problem, but with the other server. He is
> able to manage the server that I can't from the LAN using SSMS, and
> vice versa. I've done some googling, but haven't had any luck as of
> yet.
> Has anyone else seen this and know how to fix it'
> Thanks, in advance.
>

Monday, March 26, 2012

NET Compact Framework with Oracle Lite

Please help!!
I need to use NET Compact Framework and Oracle Lite.
Does somebody know if there is a provider ADOCE to connect an
application in NET Compact Framework with Oracle Lite?
Thanks in advance.
sergei98
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message218909.htmlYou should try an Oracle newsgroup, maybe
"sergei98" <sergei98.z49mb@.mail.mcse.ms> wrote in message
news:sergei98.z49mb@.mail.mcse.ms...
quote:

> Please help!!
> I need to use NET Compact Framework and Oracle Lite.
> Does somebody know if there is a provider ADOCE to connect an
> application in NET Compact Framework with Oracle Lite?
> Thanks in advance.
>
> sergei98
> ---
> Posted via http://www.mcse.ms
> ---
> View this thread: http://www.mcse.ms/message218909.html
>
sql

Wednesday, March 7, 2012

needing help to connect to server

I am new working with JDBC. I am having problems with
having the drivers reconized. I have gotten the 3 .jar
files. Here is what I do any detailed info would help.
I have taken the code off the site
http://support.microsoft.com/default.aspx?scid=kb;en-
us;313100#4
and added the user and pass that I need.
I compile it javac xxx.java
I have tried to specify where the drivers are I have moved
then in the dir where the xxx.java files are and I still
get this error
java.lang.ClassNotFoundException:
com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged
(Native Method)
at java.net.URLClassLoader.findClass(Unknown
Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass
(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown
Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at Connect.getConnection(Connect.java:29)
at Connect.displayDbProperties(Connect.java:47)
at Connect.main(Connect.java:83)
Error Trace in getConnection() :
com.microsoft.jdbc.sqlserver.SQLServerDriver
Any help that you can give me is great. Take in mind that
I am new at this and will need a little more detail
responce.
Thanks Tom
"Tom Teer" wrote:

> I am new working with JDBC. I am having problems with
> having the drivers reconized. I have gotten the 3 .jar
> files. Here is what I do any detailed info would help.
> I have taken the code off the site
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;313100#4
> and added the user and pass that I need.
> I compile it javac xxx.java
> I have tried to specify where the drivers are I have moved
> then in the dir where the xxx.java files are and I still
> get this error
> java.lang.ClassNotFoundException:
> com.microsoft.jdbc.sqlserver.SQLServerDriver
> at java.net.URLClassLoader$1.run(Unknown Source)
> at java.security.AccessController.doPrivileged
> (Native Method)
> at java.net.URLClassLoader.findClass(Unknown
> Source)
> at java.lang.ClassLoader.loadClass(Unknown Source)
> at sun.misc.Launcher$AppClassLoader.loadClass
> (Unknown Source)
> at java.lang.ClassLoader.loadClass(Unknown Source)
> at java.lang.ClassLoader.loadClassInternal(Unknown
> Source)
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Unknown Source)
> at Connect.getConnection(Connect.java:29)
> at Connect.displayDbProperties(Connect.java:47)
> at Connect.main(Connect.java:83)
> Error Trace in getConnection() :
> com.microsoft.jdbc.sqlserver.SQLServerDriver
> Any help that you can give me is great. Take in mind that
> I am new at this and will need a little more detail
> responce.
> Thanks Tom
>
Tom,
It appears that you are still unable to load the drivers for SQL Server.
If the driver's JAR files are inside the same directory as your application,
make sure that you have . (dot) as one of the arguments in your system's
classpath.
Alternatively, add the JAR files to your system's CLASSPATH. That would make
them available to any Java application system-wide.
Be sure to add them to the classpath in the form
%location%/msutils.jar;%location/mssqlserver.jar - that is with the full file
name.
Hope this helps,
Yuval
|||"Tom Teer" wrote:

> I am new working with JDBC. I am having problems with
> having the drivers reconized. I have gotten the 3 .jar
> files. Here is what I do any detailed info would help.
> I have taken the code off the site
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;313100#4
> and added the user and pass that I need.
> I compile it javac xxx.java
> I have tried to specify where the drivers are I have moved
> then in the dir where the xxx.java files are and I still
> get this error
> java.lang.ClassNotFoundException:
> com.microsoft.jdbc.sqlserver.SQLServerDriver
> at java.net.URLClassLoader$1.run(Unknown Source)
> at java.security.AccessController.doPrivileged
> (Native Method)
> at java.net.URLClassLoader.findClass(Unknown
> Source)
> at java.lang.ClassLoader.loadClass(Unknown Source)
> at sun.misc.Launcher$AppClassLoader.loadClass
> (Unknown Source)
> at java.lang.ClassLoader.loadClass(Unknown Source)
> at java.lang.ClassLoader.loadClassInternal(Unknown
> Source)
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Unknown Source)
> at Connect.getConnection(Connect.java:29)
> at Connect.displayDbProperties(Connect.java:47)
> at Connect.main(Connect.java:83)
> Error Trace in getConnection() :
> com.microsoft.jdbc.sqlserver.SQLServerDriver
> Any help that you can give me is great. Take in mind that
> I am new at this and will need a little more detail
> responce.
> Thanks Tom
>
|||Tom,
You could also try running your application as:
java -cp .;.\msbase.jar;.\msutil.jar;.\mssqlserver.jar xxx
Sue Purkis
DataDirect Technologies
yuvalz <yuvalz@.discussions.microsoft.com> wrote in message news:<19B25152-8E15-4893-B56A-6D3A4FE7D85D@.microsoft.com>...[vbcol=seagreen]
> "Tom Teer" wrote:

Needed to connect Remote DB by Client Tool (Enterprise Manager)

Here is what I knew: usr/pwd, Domain, Server and Database.

How to set Enterprise Manager, then can I connect to DB ?

Take a look at the following:

Connecting to your SQL Database using Enterprise Manager

HTH