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
ADVERTISEMENT
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
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
View Related
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
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
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
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
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
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
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
Sep 30, 2004
Hello all,
We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.
This site receives the following error as seen in the topic:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
%>
Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.
The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.
Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.
Should have 330 rows if it works right.
View 2 Replies
View Related
May 19, 2004
Hi
While running a DTS, many times the error message: "[DBNETLIB][ConnetionWrite (WrapperWrite()).]General network error. Check your network documentation." appears.
Does somebody knows why?
I am running the DTS from a computer (not the server where the DTS is stored) and it is connected without any problem when this happens.
Thanks!!
Regards
Lautaro - Argentina.
View 4 Replies
View Related
Oct 4, 2007
Hi Every one,
I am using .Net 1.1 for my web application.
And my database server is SQL Server 2005.
My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,
General Network Error. Check your network documentation
I have also searched many articles and tried following solutions but nothing working
- connectiontimeout = 0, max pool size = 7500/100, pooling = false
- SSL disabling enforce security false as mentioned in microsoft kb article.
And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)
Can any one please help me to solve this error?
With Regards,
View 3 Replies
View Related
May 26, 2007
Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
View 2 Replies
View Related
Oct 4, 2007
Hi,I am using .Net 1.1 for my web application.And my database server is SQL Server 2005. My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,General Network Error. Check your network documentation I have also searched many articles and tried following solutions but nothing working- connectiontimeout = 0, max pool size = 7500/100, pooling = false- SSL disabling enforce security false as mentioned in microsoft kb article. And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string) Can any one please help me to solve this error?
View 2 Replies
View Related
Feb 8, 2004
When I try to update the site setting, I get this Error and I don't know how to fix.
Server Error in '/DotNetNuke' Application.
--------------------------------------------------------------------------------
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
Line 281:
Line 282: myConnection.Open()
Line 283: myCommand.ExecuteNonQuery()
Line 284: myConnection.Close()
Line 285: End Sub
Source File: C:DotNetNukeComponentsAdminDB.vb Line: 283
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
DotNetNuke.AdminDB.UpdatePortalInfo(Int32 PortalId, String PortalName, String PortalAlias, String LogoFile, String FooterText, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, String ExpiryDate, Double HostFee, Double HostSpace, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory) in C:DotNetNukeComponentsAdminDB.vb:283
DotNetNuke.SiteSettings.Update_Click(Object sender, EventArgs e) in C:DotNetNukeadminPortalSiteSettings.ascx.vb:287
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Please Help!
Thank you,
dlouanis
View 2 Replies
View Related
Jan 9, 2006
I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop.
I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field.
I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card.
I have a test table with 10 images, not one more than 4 MB. I cannot complete a test run prior to receiving the general network error.
The pocketPC is connected via activesync to the desktop, and I connect to the database with:
Integrated Security=false;
user id=sa
password=admin.
Any help with this strange error would be greatly appreciated.
Wil
View 5 Replies
View Related
Oct 11, 2006
Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.
The Error details are as follows:
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
View 1 Replies
View Related
Aug 16, 2005
Hi,I am getting the following error (When i am trying to update the column thru windows service) Please let me know the solution for the following.The following error is comming only when i set CommandTimeout to infinity (Commandtimeout=0).General network error. Check your network documentation. Number 11 Procedure ConnectionRead (recv()). Class 20 State 0 Source .Net SqlClient Data Provider Server Line number 0 Thanks and Best RegardsNagaraju A
View 2 Replies
View Related
Jul 28, 2007
Hi all,
What is client network and server network alias in SQL server.
when and why we should use that mean what is the requirement of ALIAS in SQL Server.
Thanks
View 5 Replies
View Related
Jul 20, 2005
We are developing with SQL 7 Developer Edition and planning to installMSDE with the VB application. We received the following question fromthe IT dept. of our client:"Does your version of SQLServer database work well across a framerelay wide area network?"Should there be any problems regarding speed, etc.?Thanks!Ernie Adsett
View 2 Replies
View Related
Nov 15, 2006
Hello
I am new to .net and asp.net. On my local network i have our accounting system using sql 2005 and also a have an access database. We need to get this data to our web site sql 2005 database which is not connected to our network. Can somebody advise me on which would be the best and most secure way? Should i use Web Services to communicate between the network and the web server or use some other method like FTP, smtp?
Thanks in advance for any help
View 4 Replies
View Related
May 9, 2007
as far as i know, i can use these types of network libraries:
•
dbnmpntw - Win32 Named Pipes
•
dbmssocn - Win32 Winsock TCP/IP
•
dbmsspxn - Win32 SPX/IPX
•
dbmsvinn - Win32 Banyan Vines
•
dbmsrpcn - Win32 Multi-Protocol (Windows RPC)
may be someone knows, where i could find comparision and details of each one, when witch to use?
View 1 Replies
View Related
Dec 29, 2004
Hi,
Running a stored procedure in query analyser returns data but when running the asp.net page which uses that stored procedure returns an exception which is:
General network error. Check your network documentation
Do you know what the problem could be please?
Thanks
View 3 Replies
View Related
May 15, 2002
I have problems using SQL Profiler from a Windows2000 client PC to an SQL 7 server which is on a Windows NT machine. I can use profiler o.k. from an NT client (using Named Pipes), but can't seem to get it to work on my Windows2000 PC.
I tried changing the Default Network Library on my PC to use TCP/IP, but it still does not work. The server has a default of Named Pipes.
Can I get the server to use either Named Pipes or TCP/IP depending on whether the client communicating is an NT or Windows2000 PC?
Or is this not the problem? Is there a problem with Windows2000 and Named Pipes?
View 5 Replies
View Related
Apr 4, 2001
Hi,
I am trying to restore SQL7 DB from the Network M/C,here is the Procedure i am following
i have backup file on ABCsqlbackup where ABC is M/c Name on the network
from my Server i mapped ABCsqlbackup to the I drive
then from enterprise magager i tried to restore DB and i gave path as I:xyz.bak
for backup device location where xyz.bak is backup file name.
when i tried to restore like this it is giving error "unable to verify backup file location"
and i checked in SQL server logs i found that message like..
"Unable to open Backup Device I:xyz.bak Failed to open.Operating system error,Unknown user name or bad password"
and that Sqlbackup directory is shared and it has full access to everyone.
Can anybody tell me how to restore from the Network, and where i am doing wrong.
Thanks in Advance
Mark
View 2 Replies
View Related
Jul 10, 2001
Hi Friend,
Is there any way in SQL Server by which I can locate the names of all the SQL-servers on the network. I was wondering if I can execute some query on Master database to find the above info??? Any clues??
Thanks in advance
Wiz
View 1 Replies
View Related
May 15, 2000
hello,
i am trying to run a data transformation service from my win 98 machine running the sql7 server client. i keep getting the error 'general network error'
it used to work before but doen't anymore. any ideas?
thanks,
ayan
View 1 Replies
View Related
Jun 5, 2000
In the SQL Server Network Utility, I am trying to add a second entry for TCP/IP to listen on a port in addition to the default of 1433. I
keep receiving this error, "A network configuration already existst with the name specified. Please choose another name" How can I make
this happen?
View 1 Replies
View Related
Oct 12, 2000
I've had no issues using JET as a linkedserver against SQL7 & 2K when the
MDB is local to the server. But when I attempt to query an MDB on a network
that has been linked (successfully), I get a message stating:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: The Microsoft JET database engine cannot
opoen the file 'I:DatabasesTestDB.MDB'. It is already opened exclusively
by another user, or you need permission to view its data.]
I know it's not opened exclusively so I assume its a permission thing.
I executed sp_serveroption [JETDB], 'DATA ACCESS', 'TRUE'
and
sp_addlinkedsrvlogin JETDB, FALSE, NULL,NULL
and tried
sp_addlinkedsrvlogin JETDB, 'false', 'sa', 'admin', NULL
Even the OPENROWSET method fails against a network located MDB. The second
I do all these things to a local MDB... Success!
Can SQL Server not use JET databases that are located on a network drive?
Thanks
--
Patrick Logan, MCSD
Senior Technical Development Advisor
McKessonHBOC -- Extended Care Solutions Group
pat.logan@itb.mckhboc.com
Opinions expressed are my own and not necessarily those of McKessonHBOC.
View 3 Replies
View Related
Nov 24, 2003
Can anybody enlighten me how SQL Server (7.0 or 2000)to bound itself to Network name and IP in DNS? (My question is about server level Name/IP matching rather than Client Network Utility setting).
Is there any registry in Window level to manage it? Is there any published article about this topic?
Thank you very much
Mary
View 1 Replies
View Related
Jun 25, 2002
How do I backup SQL Server databases to disk over my network?
View 4 Replies
View Related
Oct 6, 1998
Hi everyone,
I have several SQL Server 6.5 machines. I would like to see what network support each server uses and change it if possible through the Enterprise Manager.
Thanks...Binh
View 1 Replies
View Related
