SQL Server Network Address Question
Feb 2, 2000
We have a SQL Server 7.0 SP1 NT 4 SP5 that has 40 or so clients connecting to it via a software package using NT Authentication. It was noticed that in Enterprise MGR, in Current activity panel under Network Address that all 40 or so clients do not show there individual MAC address, there are 3 different addresses, one does appear to be a client that is repeated for several other clients, one appears to be a network hub and the third one we have not determined what it is. These are all WIN 95 clients. When we use NT Workstation to connect to this SQL Server with Query Analyzer it does show the correct MAC address. Any ideas on what is wrong or where to start? Any help would be appreciated! Thanks
View 2 Replies
ADVERTISEMENT
Apr 3, 2008
Hi all
When i am trying to configure Mirroring .i am getting the below error.
The server network address "TCP://RDEEPA:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)
. TCP/IP and Name pipe connection is enabled in both principle and mirror server configuration.
I post the complete error message below ,which is in red
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'success'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server network address "TCP://RDEEPA:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
View 21 Replies
View Related
Jun 23, 2015
how to change the port of SQL-Server 2012 mirroring port rather than 5022, can I use different port and how?
[URL]
View 3 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
Aug 21, 2002
Currently running SQL Server 7.0 on numerous Windows NT 4.0 SP6 servers.
Need to change the IP address of these servers to a private scheme.
What effect will this have on SQL Server 7.0
Thanks
View 1 Replies
View Related
Nov 2, 1999
I have SQL ver 7.0 running on NT ver 4.0 sp5
I had to change the name of the server from server1 to server2
now I am Getting a message
"Your SQL server installation is either corrupt or has been tampered with (Unknown package id). Please rerun setup"
is there any other way besides rerunning setup ?
Thanks in Advance ??
Peter
View 2 Replies
View Related
Apr 22, 2003
Hello,
Soon, we are going to redesign our servers and their positioning insofar as web access is concerned. The SQL Server will go to a DMZ.
Its IP Address (as well as hostname) is to be changed. Can you offer suggestions about what to be aware of on these two items?
I've been involved in a hostname change befoew (and, it's a pain), but never an IP Address.
Thanks, MichaelG
View 2 Replies
View Related
Aug 19, 2002
We changed the TCP/IP address on on of our BDC's this weekend (also runs SQL 6.5). Now some of our client workstations are not able to connect to the database using TCP/IP. They can connect with named pipes, but it doesn't "stick" on a reboot. It goes back to connecting with tcp/ip. Some of the client workstations can connect with tcp/ip. Could someone help me with this? I'm confused. I can ping the server by name from the workstations and it resolves the tcp/ip address correctly.
View 2 Replies
View Related
Dec 5, 2005
Hi im trying to save the location of images to a sql server db in the form of a url, i am trying to find out what datatype this comes under here. In ms access u can just select the hyperlink option in the data type dropdown and it saves the address entered into these fields as a hyperlink to the database. How can u do this in sql server ?????
View 3 Replies
View Related
Jul 23, 2005
I don't know much about MS SQL-Server. I'm having SQL server 2000 andgoing to change IP address of the server. What need to be done?
View 1 Replies
View Related
Jul 20, 2005
A server with SQL 2000 installed is moving to a new physical location. Ourcompany standards mean that the name of the server and the IP address of theserver will change also. This SQL instance name is the same as the servername. Will I have to uninstall and reinstall SQL Server (and recover thedatabases) when this move is made so that the instance name equals theserver name? Is there a stored procedure that changes the instance name tothe server name? Thank you.
View 1 Replies
View Related
Aug 18, 2015
Is there any windows API available to find the IP address on which the process is listening.
Want to find the IP address on which SQL Server is listening.Â
View 4 Replies
View Related
Feb 11, 2008
hi,
i want to write MS SQL query which will give me IP of the SQL server...is this possible using MS SQL?
Thanks in advance
Chetan S. Raut
View 3 Replies
View Related
Sep 3, 2014
I am asking about a virtual IP for SQL Server, is there a way we can assign a different IP to SQL Server other than the server's(host) IP address? like the same what we do in a clustered env.
View 3 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
Feb 27, 2008
I have not been able to find any substantive documentation on connecting a DataSource to the database via the IP address of the SQL Server. Does anyone know of a good reference on the topic? I want to be able to access the data on the server while developing and testing locally on my laptop (not on the same network).
View 2 Replies
View Related
Jan 5, 2001
Hi, folks!
My server machine have 2 ip address (Private and real), but my sql server is just listening on the first one and the default 127.0.0.1
What Can I do to resolve that?
Please, Any idea would be really apreciate a lot!
TIA.
Armando
Cti, Miami
View 2 Replies
View Related
Jul 22, 2000
I'm working with a small ISP/Hosting company and we set up a development server with NT, Site Server, SQL 6.5, and Site Site Commerce Edition. It has been working fine, but the other night their network guy assigned a new IP address to the NT server.
Now SQL server can't talk to/find the NT server. Any time you try to look at anything in Enterprise Manager, it throws the error:
DBLibrary - Server is unavailable or does not exist...general network error.
We can't figure out how/where to tell SQL Server that NT has a new IP address, and get it all working again.
Any suggestions appreciated...
View 1 Replies
View Related
Jun 8, 2007
Hi, there,
I am creating a job, which will run a DTS package (SQL 2000), Due to the way it set up, I need to pass the IP address as the server name,
for example, say the IP address is 64.84.50.11
User name is sa
password is webpass
package name is datadump1
I used the command
EXEC master..xp_cmdshell 'dtsrun /S64.84.50.11 /Usa /Pwebpass /Ndatadump1'
when I run it in query analyzer, it returns an error,
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '/'.
Is there anyone know what's wrong with my command?
Thank you very much
View 1 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
May 4, 2004
Dear all,
I wasn't able to connect to my SQL server 2000 database (which reside in the network in a windows 2003 server) after the IP address of the server has changed and the server is shut down, moved and re-started.
I was able to connect to this server by using ADO using VB. I was able to register this server in my EM and was able to create ODBC connection. Just when using ADO.NET, I wasn't able to connect. Any ideas? Will there be any caching within ADO.NET still pointing to the old IP address?
Thank you for all the help in advance.
View 5 Replies
View Related
Oct 7, 2004
How I can register MSSQL Server 2000 by IP Address-
I installed MSSQL Server 2000 sp3a, Enterprise edition on windows 2000 advanced server box with sp4. It’s primarily give instance with name like servername/sqlindia, Where sqlindia is instance and servername is physical machine name.
I would like to registration of sqlserver instance by IP Address. How I can do it.
Thanking You
R.Mall
View 1 Replies
View Related
Aug 26, 2015
we have a server (Windows server 2008 R2 Standard) that runs a hyper V manager.The Hyper V manager runs 2 virtual servers.
One of the virtual servers uses the software XAMPP (it’s a web portal). The local IP for the virtual machine is 192.168.0.xxx
I have configured the XAMPP in a way so that any user in our domain can access the portal when the user writes the ip address in the web browser.Instead of the ip address, I want the user to be able to write a specific given name.
How can I create this?
View 3 Replies
View Related
Jan 16, 2007
can any one guide me how to change the default port address of apache which is 80 to any other port number. coz the default port number is taken by iis also.
View 1 Replies
View Related
Mar 1, 2002
Hi all,
I'd like to link a SQL Server database / table to Microsoft Exchange Server E-Mail-Address data, for an Employee Directory project.
I've read a little about "Web Store", a little about ExOLEDB, but I've come across nothing along practical lines. I.e., I still don't know where to begin!
For example the "Web Store" should be created on the SQL server, but how do you create it? Any insights will be greatly appreciated.
Gallagher
View 1 Replies
View Related
Mar 11, 2014
i have a situation where is need to get email address from a varchar column. Here is some sample data for five records; The format can be change.
dummy text;
Tel: +44 (0)1234 566788;
Email: bbc@co.uk
Admissions dummy text;
T: +44 (0)1234 4444;
E: xyz@co.uk;
dummy text;
dummy text;
Tel: +123 32323 33;
Email: test@yahoo.com;
dummy text;
t: +88 (0) 115 333 5553;
f: +99 (0) 115 222 8888
e: dummy@gmail.com;
dummy text;
t: +11 (0) 222 222 2222;
e: myemail@test.com;
w:http://www.yahoo.com/faqs;
View 4 Replies
View Related
Mar 9, 2011
IF you need to change the IP Address of a SQL Server Failover Cluster instance, here is the steps:
1. Open up Failover Cluster manager.
2. Expand the MS Cluster Instance that your SQL Cluster instance resides on.
3. Expand Services and applications.
4. Select the SQL Server Service.
5. In the main window pane (Middle Screen), you should see your SQL Server Cluster name, expand the plus to the left of it.
6. Under your SQL Server Cluster name, you should now see an 'IP address' section, right click on it and go to properties.
7. In the properties pane, you can change your IP address by entering a static IP.....or assigning a DHCP enabled IP.
View 1 Replies
View Related
