The Server Network Address Can Not Be Reached Or Does Not Exist
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
ADVERTISEMENT
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
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
Jun 29, 2015
We have a big software that run a warehouse distribution center, written in .NET Backhand is a SQL Server 2008 R2 STD database.
Now, it seems there is a problem with the sessions not being properly closed after each call to the DB. Here is the message got form SQL:
DESCRIPTION:A new connection was rejected because the maximum number of connections on session ID 57 has been reached. Close an existing connection on this session and retry.
In the .NET code, connection is made with the following code:
If oConn Is Nothing Then oConn = New SqlConnection
If oConn.State = ConnectionState.Open Then oConn.Close()
With oConn
.ConnectionString = "Server=" & Server & ";Database=" & DB & ";User ID=" & User & ";Password=" & Pass & ";Connection Timeout=" & 5 & ";MultipleActiveResultSets=" & True
.Open()
End With
This code is called once, at the opening of the software
StoredProc are call with the code:
Try
oCmd = New SqlCommand
With oCmd
.Connection = oConn
.CommandType = CommandType.StoredProcedure
[Code] .....
So every Command is closed after execution, yet, they stay active in the SQL Server. Is there something I'm missing here?
View 3 Replies
View Related
Aug 5, 2015
I have a simple SP that returns 2 columns with 4 inner joins, results are about 100 odd rows max, nothing complicated. When I run the SP via SSMS it works fine, as soon as this is run via an application server the SP fails to complete with the error :
Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.
We are not getting anywhere near the expression limit so I cannot understand why we are suddenly receiving this error. 2 weeks ago this query was running fine, no updates have been rolled out to the SQL database servers or application servers but the error is suddenly appearing on both prod and dev environments.
View 1 Replies
View Related
Jul 23, 2005
I'll try and keep this brief so in a nutshell:I have large distributed java system running on a Windows 2003 server(4cpu 8Gb memory).Periodically the following exceptions occurs in the servers:java.net.SocketException: No buffer space available (maximumconnections reached?): recv failedI know for a fact we are not using too many TCPIP sockets or runningtoo many socket servers.I have googled this error and found very little to help me.What buffer space is this?What does recv failed mean?(Is it at all relevant that sql server is running on the same box?)Any advice appreciated.Thanks in advance.Dan
View 5 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
Nov 24, 2005
Hi,Can anyone tell me if he ever got this issue and how he get the solution. In my asp.net 2.0 application i close always ma connexions to sqlserver in the finally clause (the open is in the try); I open 1 ou 2 connecxions per aspx page, i close them always (in the finally clause or at the bottum of the form). Sometimes, the application is down with the messageCan not open a new connexion, max pool size is reached !!!!I host my application on a remote server, i have no performance issues, only this great problem !!!i cant view the status of connexion on the sqlserver, so what can i do, or how shoud i develop my connection.thanks in advance to all of yuo who will help me.Imed.
View 1 Replies
View Related
Mar 2, 2000
When attempting to view the articles which belong to a publication the error 823 is raised. The replication is working fine but can the publication can not be altered or deleted. An article in the publication needs to be removed to allow structure change. Any one seen this message before?
Error 823: I/O error 38 (reached end of file) detected during read of BUF pointer=ox1161zcdo page ptr = 0x13a9e000 pageid = (ox1:ox1495a) dbid=7, status=0x801 file d:mssql7datawestdeeping_data.mdf
Any one have any idead on what causes it or how to get around it or prevent it again??
View 2 Replies
View Related
Mar 23, 2001
We have been running SQL Server 7 for the past 6 months, with no problems at all. All of a sudden, we have received the error message 17050, that the maximum limit for connections has been reached. We cannot now start Enterprise Manager or do anything. We have tried fiddling with licencing in control panel but to no avail. Does anyone have any idea why this has suddenly happened? Any tips would be great!
Cheers.
View 2 Replies
View Related
May 28, 2007
I am trying to setup transactional replication between Server A and Server B. There are 265 databases on each server.
I am running SQL Server 2005 on Windows Server 2003. The problem comes in at the 201st database. The message in the SQL Server Agent Error Log is :
Warning,[398] The job (WSSWPG09-EmpirePaint-WSSWPG06-104) has been queued because the maximum number of working threads (400) are already running. This job will be executed as soon as one of the working thread finishes execution.
SQL Server's max worker threads is set to 0. The Distribution, LogReader and T-SQL subsystems have been increased to 200 max_worker_threads.
Is there some other setting (maybe a Windows Registry setting) that can be configured to fix this? Or have I just hit a physical maximum of the processor?
Any help is much appreciated.
View 3 Replies
View Related
Jan 11, 2007
Does the user get an error message?
What error does an application get that tries to insert additional data via ODBC?
View 10 Replies
View Related
Sep 26, 2007
I am working on a large application built on the 1.1 framework in VS2003 (SQL Server 2000 DB) and keep getting this error:
'Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached'.
I can run the app in Debug 10 consecutive times, doing the exact same thing every time, and the error will occur at 10 different points, and 10 different calls to the data-access layer.
There is a data-access layer that is responsible for executing sql statements and stored procs. Every function in the data-access layer handles connections in the following way:
Try ' setup data adapter da.Fill(ds, "ResultSet") Return dsCatch ex As Exception ' send the exception back to the client Throw exFinally ' release objects da.Dispose() conn.Close() : conn.Dispose()End Try
I have read numerous posts about making sure not to leak connections. I have watched the connections within the SQL Activity Monitor and, at the most, there are 5 connections open at any given time. I use the default timeout and pool size values (30 sec. and 100 connections) in my connection strings. I am 99% positive that I am not leaking connections. Are there any other explanations for why this is happening?
View 4 Replies
View Related
Sep 7, 2007
i believe this is the right thread... i recently had an issue where my xpstar.dll would not register and i read to fix the issue to reapply the SP so i installed SP4 i now am getting this error... please help!
2007-09-07 14:24:19.24 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQLlogERRORLOG'.
2007-09-07 14:24:19.24 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2007-09-07 14:24:19.36 server SQL Server configured for thread mode processing.
2007-09-07 14:24:19.38 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-09-07 14:24:19.40 server Attempting to initialize Distributed Transaction Coordinator.
2007-09-07 14:24:20.44 spid3 Starting up database 'master'.
2007-09-07 14:24:20.49 spid3 Error: 823, Severity: 24, State: 5.
2007-09-07 14:24:20.49 spid3 ReadFileHdr: Operating system error 38(Reached the end of the file.) encountered.
2007-09-07 14:24:20.49 spid3 Error: 5159, Severity: 16, State: 3.
2007-09-07 14:24:20.49 spid3 09/07/07 14:24:20 Stack Overflow Dump not possible - Exception c00000fd E at 0x00449CA1
2007-09-07 14:24:20.49 spid3 Address=449ca1 Exception Code = c00000fd
2007-09-07 14:24:20.49 spid3 eax=ba65a0de ebx=00000002 ecx=42ba8740 edx=0bb0a830
2007-09-07 14:24:20.49 spid3 esi=00000001 edi=42ba8740 eip=00449ca1 esp=0bb09fc4
2007-09-07 14:24:20.49 spid3 ebp=0bb0a56c efl=00010212
2007-09-07 14:24:20.49 spid3 cs=1b ss=23 ds=23 es=23 fs=3b gs=0
2007-09-07 14:24:20.49 spid3 1: Frame: 0BB0A56C Return Address 00449CA1
2007-09-07 14:24:20.49 spid3 2: Frame: 0BB0AD88 Return Address 00449E10
2007-09-07 14:24:20.49 spid3 3: Frame: 0BB0AD9C Return Address 0044A14B
2007-09-07 14:24:20.49 spid3 4: Frame: 0BB0ADAC Return Address 0044A17D
2007-09-07 14:24:20.49 spid3 5: Frame: 0BB0ADF8 Return Address 0044A19B
2007-09-07 14:24:20.49 spid3 6: Frame: 0BB0AE18 Return Address 004CD11C
2007-09-07 14:24:20.49 spid3 7: Frame: 0BB0B2A8 Return Address 005ED83E
2007-09-07 14:24:20.49 spid3 8: Frame: 0BB0B2FC Return Address 00405473
2007-09-07 14:24:20.49 spid3 9: Frame: 0BB0B324 Return Address 00449357
2007-09-07 14:24:20.49 spid3 10: Frame: 0BB0B350 Return Address 00449329
2007-09-07 14:24:20.49 spid3 11: Frame: 0BB0B378 Return Address 00448EE1
2007-09-07 14:24:20.49 spid3 12: Frame: 0BB0B3E0 Return Address 0060CFF5
2007-09-07 14:24:20.49 spid3 13: Frame: 0BB0BC04 Return Address 006D0991
2007-09-07 14:24:20.49 spid3 14: Frame: 0BB0BC18 Return Address 0044A14B
2007-09-07 14:24:20.49 spid3 15: Frame: 0BB0BC28 Return Address 0044A17D
2007-09-07 14:24:20.49 spid3 16: Frame: 0BB0BC74 Return Address 0044A19B
2007-09-07 14:24:20.49 spid3 17: Frame: 0BB0BC94 Return Address 004CD11C
2007-09-07 14:24:20.49 spid3 18: Frame: 0BB0C124 Return Address 005ED83E
2007-09-07 14:24:20.49 spid3 19: Frame: 0BB0C178 Return Address 00405473
2007-09-07 14:24:20.49 spid3 20: Frame: 0BB0C1A0 Return Address 00449357
2007-09-07 14:24:20.49 spid3
2007-09-07 14:24:20.49 spid3 TotalPhysicalMemory = 2146951168, AvailablePhysicalMemory = 1552097280
2007-09-07 14:24:20.49 spid3 AvailableVirtualMemory = 376274944, AvailablePagingFile = 3696713728
View 6 Replies
View Related
Jul 23, 2005
Hello SQL gurus!I am trying to write a query that will return a set of continguous rowsfrom a table, and limit the number of rows returned when a maximumtotal has been reached by adding a value in one of the columns.For example, the two columns below represent 2 columns in a table.a 2b 2c 2d 3e 4f 5g 5I want to start at, say "c", and return all the rows after it as longas the sum of the numbers in column 2 (starting at "c") don't exceed10. The result I'm after would be thusc 2d 3e 4....because 2 + 3 + 4 = 9 < 10Any ideas? Many thanks.
View 4 Replies
View Related
Jul 20, 2005
We are running three web sites in a clustered environmentWLBS. The web servers are connected to a Database Serverrunning MS SQL server enterprise edition licensed as perCPU license. The Windows 2000 Advanced Server Licensingmode on all the servers is per SEAT license.Our customers are accessing our web servers and after sometime getting error 500, Maximum concurrent users havereached.We have been told by our software provider that theconnection problem lies with the ADO components whichcommunicating with the SQL server.We have been turning round and round, without any luck.Your help will be highly appreciated.Thanks and best regardsDaveLearning is a Never Ending process*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Dec 3, 2013
I have data as below: select ID,code,go,back from tableA
ID code go back
2 C US UK
2 A UK US
1 A US UK
1 Z UK US
1 C UK US
1 A US UK
I only want to pull out whole ID group which code Z exist. I tried as below:
select ID,code,go,back from tableA A
where exists
( select ID,go,back
from tableA B with (nolock)
where A.ID = B.ID
and A.code='Z')
But it only appear:
ID code go back
1 Z UK US
How can I appear with the group as well?
ID code go back
1 A US UK
1 Z UK US
1 C UK US
1 A US UK
View 3 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
Oct 12, 2015
One of our production databases was setup mirroring, log shipping and replication on it, the log file was setup unrestricted growth. This morning one index rebuilding process generated lots of logs, and the log file disk ran out of space, the database was in recovery mode. so we had to disable log shipping, pause mirroring and replication, expand log file disk, restarted SQL instance to fix the issue. Now we want to setup the log file to maximum size 80G, the whole log file disk is 120G.
So if the log file reached 80G next time, we can change the max size to 90G or 100G and it's easier to fix the space issue. My question is, if the database log file reached max size,
1. is the database still available?
2. Will the active session causing the issue be rollback to release space back?
View 5 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
