Re: Performance reduction of SQL 2005 server when connected from V

....in my ...system32 there is sqlncli.dll and in the registry there is
9.00.4035.00.

and unfortunately I could not run "SELECT * FROM sys.dm_exec_connections"
against the slow SQL 2005 remote server succesfully (through the SSMSE 2005)
because I got the following message:

"Msg 297, Level 16, State 1, Line 1
The user does not have permission to perform this action."

...so, here I am in full impasse!

Thank you for your help,

Matti


Rick Byham, (MSFT)" wrote:

Great question. I'm not sure. I don't think I've error tried to do this
before. (This will teach me a lesson not to shoot my mouth off. <g>)
Using the registry editor regedit, navigate to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Native
Client\CurrentVersion.
One of my computers says 9.00.4035.00
One of my computers says 9.0.9091.2 but that computer has a future build of
SQL Server on it, so that may be bogus.

The SQL Server Native Client files (sqlncli10.dll, sqlnclir10.rll, and
s10ch_sqlncli.chm) are installed to the following location:
%SYSTEMROOT%\system32\
Those are the SQL Server 2008 names. sqlncli.dll is the SQL Server 2005
name.
So on my Windows Server 2003 computer the file C:\WINNT\system32\sqlncli.dll
says it is 2005.90.4035.0

Also try connecting to the database, and then execute these queries.
SELECT session_id = @@SPID
will tell you what process ID is your current connection.
SELECT * FROM sys.dm_exec_connections
Will give you interesting info, such as the protocol name, and the protocol
version. And it would be interesting to see if your fast and slow computers
have the same info.
I don't know why the version numbers are different there. It says
protocol_version = 1930035203

I'll keep poking around. Maybe I'll try to wade through
http://msdn.microsoft.com/en-us/data/aa937733.aspx
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"MY" <MY@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:65AF5113-0689-471A-AECC-B7C59DCC05B3@xxxxxxxxxxxxxxxx

Thank you Rick for your reply,

I have two network connections, one defined for the wireless, and one for
the cable connection. And indeed, in the case of wireless connection there
was TCP/IPv6 also marked in the settings. I removed it but the problem
still
seems to continue!

How can I check out if the SQL Server Native Client version is the same
on the fast and slow clients?

Thank you,

Matti


"Rick Byham, (MSFT)" wrote:

I once had such a problem which I resolved by making sure I was
connecting
using IPv4 instead of IPv6. I'm not sure why it mattered.
For a SQL Server related reason, is the SQL Server Native Client the same
version on the fast and slow clients?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no
rights.

"MY" <MY@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:787110B1-3D78-47C6-A060-CB16217AAAE1@xxxxxxxxxxxxxxxx
Hello,

My problem is a strange and radiacal performance speed reduction of
remote
SQL 2005 server when connected from desktop (Vista OS). So, my desktop
application is remotely connecting to SQL 2005 server .

Strange also is that the problem is only related to SQL 2005 server
when
remotely connected, not when locally connected or not in the cases of
2000
or
2008 versions (I tested them all); the performance speed of these
versions
are as earlier. But when connected via web-app the problem does NOT
appear.

So, the problem concerns only the SQL 2005 server when connected
remotely
from desktop. This is also to be seen when I connect to my databases in
the
SQL 2005 server via Microsoft SQL Server Management Studio Express:
connection and the performance of operations is extremely slow in
compariosn
with the other versions of SQL server.

And yet what is more strange, the problem happens ONLY in PC's Vista OS
enviroment (premium) - when I tested via XP (.i.e. from different PC)
I
found no reduction in the speed of the SQL 2005 server remote
connection.

So, does anyone have any idea what might have caused this
radical performance reduction in SQL 2005 remote server
connection which seems to be related only to Vista (Premium)
OS enviroment?

Matti


.

Relevant Pages

  • Re: What is the best way to connect to a server not on the network?
    ... That 192 IP address is most likely not a remote one. ... but doesn't object to migrating the data to SQL server. ... I tried using ADO within Access to create a connection string to the remote ...
    (microsoft.public.access.modulesdaovba)
  • Re: Performance reduction of SQL 2005 server when connected from V
    ... Rick Byham (MSFT), SQL Server Books Online ... against the slow SQL 2005 remote server succesfully (through the SSMSE ... will tell you what process ID is your current connection. ...
    (microsoft.public.sqlserver.connect)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Performance reduction of SQL 2005 server when connected from V
    ... One of my computers says 9.0.9091.2 but that computer has a future build of SQL Server on it, ... will tell you what process ID is your current connection. ... How can I check out if the SQL Server Native Client version is the same ... > found no reduction in the speed of the SQL 2005 server remote> connection. ...
    (microsoft.public.sqlserver.connect)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)