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?
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:
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.
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.
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)
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)
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?
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
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
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)
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
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
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
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
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?
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.
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??
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?
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.
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?
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.
I want to use TCP/IP network protocol on the server and have my clients using TCP/IP Net library. I have having some problems with this...The server will not register if I only have TCP/IP without Named Pipes using Standard Security in SQL Server. If I have TCP/IP and Named Pipes, the client can't register the server. Can someone explain in detail to me on using TCPIP on the server and client?
i try to create a dump device on a drive remote from the sql server(6.5),using machinenamefolderdump.dat. it creates the dump but when i tried to initial the backup it gives and error system that the device is offline. thanks in advance
I've read that the SQL dump can only be done directly into the local server. Is there a way to put directly the dump into another server via the network (not copying it but writing it during the process of backup). Any help much apreciate.
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.
hello group,a few days ago i used the following backup statement and everthingworked fine:sp_addumpdevice 'disk','pipedump','\192.x.x.xLData est.bak'Backup database Test to pipedumpThe same statement is not working today!!!!!What's the reason?Please dont tell me that check if the network path exists or not! I'vechecked the path and permissions. Everything is ok!Thanks in advanceDebian*** Sent via Developersdex http://www.developersdex.com ***
I'm converting an old vb6 application with Access to VB 2005 and SQL server 2005
I installed SQL Express 2005 on the server and my application running from the the server works fine, however when I run the app from a WS I get the following error:
"An attemp to attach an auto-named database for the \xbladec3 Data.mdf failed. A DAtabase with the same name exists, or specified file cannot be opened, or it is located on UNC share"
Checking the server TCP, pipes and all that stuff are enabled.
I have installed SQL server 2005 in my machine. Now when we restore the database, I have check the size of database file .mdf/.ldf is very large. So now I wants to place these two files in any other machine in network.
But when I try to do the same, I am getting "Error 5110: network device not supported for database files.".
Please anyone guide me about the process. So that I can place these 2 files in another machine in network or any sharepoint.
My database has a table. This table has a column ( named : No.) set to be a primary key, and it's ( identity). When several people access the database in the same time and add some data, some of them will see this error message : ( column (No.) doesn't allow repeated values) How can I solve this problem?