Connections to SQL server are slow on one machine

Hi all,
My client PC is very slow to connect to all SQL server databases.
Other client machines are having no problem at all. I even tried
connecting to my local MSDE database, and the same behavior results.
If I try to connect via a .NET application it is also slow.

The connection is always made if I wait long enough, but then when I go
to query a table it is very slow again, even if I'm only returning one
row from a table with 5 fields.

Does anyone have any suggestions on how to troubleshoot this?

Thanks.check whether the ping time are different too ...
try switching off local firewall ...

"foreman_bob" <smhceh@.gmail.com> schrieb im Newsbeitrag
news:1137940934.406196.284270@.g47g2000cwa.googlegr oups.com...
> Hi all,
> My client PC is very slow to connect to all SQL server databases.
> Other client machines are having no problem at all. I even tried
> connecting to my local MSDE database, and the same behavior results.
> If I try to connect via a .NET application it is also slow.
> The connection is always made if I wait long enough, but then when I go
> to query a table it is very slow again, even if I'm only returning one
> row from a table with 5 fields.
> Does anyone have any suggestions on how to troubleshoot this?
> Thanks.|||What net library are you using? Is it the same net lib as the other
people that don't have issues? Are you authenticating the same way?Are
you requesting SSL or multiprotocol encryption from the client? Are
you located on the same LAN as the other users or do you dialup through
your 28KB modem into a VPN connection?

Greg|||I found out what was causing my problem today. I had ODBC tracing
turned on. As soon as I turned it off everything was fine.

Thanks for your replies.

Greg wrote:
> What net library are you using? Is it the same net lib as the other
> people that don't have issues? Are you authenticating the same way?Are
> you requesting SSL or multiprotocol encryption from the client? Are
> you located on the same LAN as the other users or do you dialup through
> your 28KB modem into a VPN connection?
> Greg|||wow.

Thank you! I am filing this one off!!!! I can totally see myself
turning it on, wandering off and forgetting it is on.

ick.

Connection to Analysis services from VB - very slow

Dear All,

I noticed a strange problem with one of my client's computers where in establishing a connection with Analysis services from VB takes 6 seconds, when the computer is not connected to network, but it takes only a fraction of a second when the computer is in networ. We use ADOMD to connect to Analysis server. Analysis services is installed in the local machine.

I ran dependency walker and found that the dll WS2_32.dll (winsock dll) is taking most of the time when establishing connection.

This issue is very important for us and it would be great, if someone could help me in this.

Thanks in advance,

Niyas

Have you tried to use aternative machine name when connecting locally?

Try connecting to your Analysis Server using "localhost" or "127.0.0.1"

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Hi Edward,

Thanks for your reply. I did try connecting to Analysis services using localhost, but there is no difference in the performance. I also created a machine level account (not in any domain) and tried connecting to Analysis services. But still, it does not show any difference.

This problem occurs in our client's machine alone and not in my computer or in my colleagues computers.

Thanks,

Niyas

|||

This might be related to VB initialization. Try posting your question on VB forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=32&SiteID=1

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward,

I doubt whether this could be VB initialization problem, because the same problem occurred, when I tried to create a connection string using a .udl file. When I set the machine name, login credentials (Windows NT),driver and when I tested the conenction, it took 6 seconds, when I'm not in network and fraction of a second when I'm in network.

Thanks,

Niyas.

|||

Good. This is not VB related.

This is looks to be a general network problem. Try and see if you can find solution to this situation in windows networking forum. I doubt this is related to Analysis Services. Looks like generic connectivity problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Connection to Analysis services from VB - very slow

Dear All,

I noticed a strange problem with one of my client's computers where in establishing a connection with Analysis services from VB takes 6 seconds, when the computer is not connected to network, but it takes only a fraction of a second when the computer is in networ. We use ADOMD to connect to Analysis server. Analysis services is installed in the local machine.

I ran dependency walker and found that the dll WS2_32.dll (winsock dll) is taking most of the time when establishing connection.

This issue is very important for us and it would be great, if someone could help me in this.

Thanks in advance,

Niyas

Have you tried to use aternative machine name when connecting locally?

Try connecting to your Analysis Server using "localhost" or "127.0.0.1"

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Hi Edward,

Thanks for your reply. I did try connecting to Analysis services using localhost, but there is no difference in the performance. I also created a machine level account (not in any domain) and tried connecting to Analysis services. But still, it does not show any difference.

This problem occurs in our client's machine alone and not in my computer or in my colleagues computers.

Thanks,

Niyas

|||

This might be related to VB initialization. Try posting your question on VB forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=32&SiteID=1

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward,

I doubt whether this could be VB initialization problem, because the same problem occurred, when I tried to create a connection string using a .udl file. When I set the machine name, login credentials (Windows NT),driver and when I tested the conenction, it took 6 seconds, when I'm not in network and fraction of a second when I'm in network.

Thanks,

Niyas.

|||

Good. This is not VB related.

This is looks to be a general network problem. Try and see if you can find solution to this situation in windows networking forum. I doubt this is related to Analysis Services. Looks like generic connectivity problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.