Protocols

May 21, 2001

Hello,

I need to find out what protocols are used by our client to connect to the SQL Server ?
And is there a way through which we can say that the client are using these protocols, from the Enterprise Manager ?

One more question i have is, I have a SQL server Installation at home on Win98. Why can't i rename the Server Name. I tried using the Sp sp_Dropserver,sp_addserver.

Any help would be of great help.

Thanks,
Shiva

View 2 Replies


ADVERTISEMENT

Which Protocols To Use?

Mar 8, 2007

My ASP website is located on one server & the MS SQL 2000 which is located on a separate physical server behind a separate firewall.

My question is related to Application Communication. I want to know how do the Servers exchange data with one another: which (logical connections to use, which protocols to use)?

View 5 Replies View Related

Ports And Protocols

Sep 9, 2004

Hi Folks ,

Got one for you .....

By default what ports and protocols do the following sql tools use....?

Enterprise Manager
SQL Query Analyser
SQL Profiler

And if anybody knows :

Performance Monitor
Mapping drives
Event Viewer
User/Server Manager

Any help would be greatly appreciated .....

View 1 Replies View Related

Network Protocols

Oct 9, 2007

I am having a problem with one of the PC's That remotely connects to my server.

When you go to connection properties (under Connect to server in the Management studio) on the users machine there are no options under Network Protocol only the <default> option.

All the rest of our PC's have the option of choosing TCP/IP , named pipe etc etc..

This computer is not able to connect to the server remotely however it can/does when it is on the network.

I figure its because it is attempting to connect over named pipe rather than TCP/IP but i cannot change this in the connection options as it is missing.

And as far as i know on the server i have the default set to TCP/IP but I am really unsure of this.

If anyone can help me out with this i would greatly appreciate it.

View 7 Replies View Related

How Can I Tell What Protocols Are Enabled For The Client?

Jun 21, 2004

If TCP/IP is the only protocol enabled on the General tab of the Client Network Utility, does it mean that other protocols are disabled and will not be used in communicating to SQL Servers on other machines?

In this case, should the registry HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer ClientSuperSocketNetLib only contain the Tcp entry?

If I have alias setup to use other protocol such as Named Pipes, does it mean that the alias cannot be connected since Named Pipes is not enabled?

Thank you for any help.

View 10 Replies View Related

Changing TCP/IP IP Addresses Under Protocols For SQLExpress

Jun 16, 2007

SQL Server Configuraton Manager,

Protocols for sqlexpress,

TCP/IP



When I initially installed SQL Server 2005 Express, it automatically picked up all the IP addresses (60 of them) I had on the server, and filled them in under TCP/IP - IP adresses Tab.



I recently took those IPs off the server and replaced them with 30 new IP addresses. Is there a way to have SQL Server 2005 Express read the Network configuration on the server and take the old IPs off the TCP/IP - IP addresses tab and put the new one's there?



Thanks,

Bill

View 3 Replies View Related

System.Web.Services.Protocols.SoapException

Apr 16, 2008



Hi,

I have successfully built a project and now want to deploy it for use, however I am getting the following error message:

Error 2 System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. ---> System.Web.HttpException: Maximum request length exceeded. at System.Web.HttpRequest.GetEntireRawContent() at System.Web.HttpRequest.get_InputStream() at System.Web.Services.Protocols.SoapServerProtocol.Initialize() --- End of inner exception stack trace --- at System.Web.Services.Protocols.SoapServerProtocol.Initialize() at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing) d:infra srss reportinginfrainfraInfra Enterprise.smdl 0 0

Any ideas on what is wrong?

Thanks!

View 7 Replies View Related

System.Web.Services.Protocols.SoapException

May 12, 2006

I am running VS Team Suite, and did a fresh installation of SQL Server 2005.

When I try to deploy the sample reports, build was successful.
However, when I try to deploy it, I got the following error:

System.Web.Services.Protocols.SoapException: Server was unable to process request, ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName) at
Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType() at
Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth() at
Microsoft.ReportingServices.WebServer.GlobalImpersonateClient() at
Microsoft.ReportingServices.WebServer.ReportingService2005.ctor() -- End of inner exception stack trace.


Anyone encountered a similar error?

Thanxs.

View 4 Replies View Related

No Certificates Available In The Protocols For MSSQKSERVER Properties Window

Apr 4, 2007

I am trying to set up SQL Server 2005 to use a test certificate from Thawte for SSL encryption. I have installed the certificate in the local computer, current user and service account's personal certificates folders. I have also installed the root certificate in the Trusted Root Certification Authorities folders of each. All this was done using MMC.



However, when I go to tell SQL Server to use the certificate, no certificates show up in the drop down box. I am using SQL Server Configuration Manager and doing the right-clickPropertiesCertificate steps shown in multiple KB and forum articles.



I have also checked the registry entry at HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServerSuperSocketNetLibCertificate. It is blank, which tells me SQL Server should be looking in the certificate store.





If I simply set the ForceEncryption flag, SQL Server starts up OK and generates a self-signed certificate. Using that, the session does get encrypted. However, I need to use a third party certificate.



I have hit a brick wall and am at a loss. Any help would be greatly appreciated.

View 10 Replies View Related

2014 Express / Network Configuration Protocols Empty?

May 21, 2015

I'm having issues with my sql server 2014 express configuration manager. I need to change protocols under Sql Server Network Configuration but there is nothing, no protocol listed, its empty.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved