I'll have about 5 db's from an instance(server1instance1) mirrored to another server(server2/instance1). Do all of these db's have to have endpoints configured with different ports? I hope I'm clear on my question. Do I have to create a different endpoint for every db or can use the same endpoint? Thank you
Tej
What ports does SQLMail use to access MS Exchange Server?? We have SQL 7 running on a seperate non-trusted domain(within the same DMZ) from where Exchange Server exists. The only trust we want between the 2 domains is the SQLMail functionality for the DBA's and Administrators to use. I am aware that MS Exchange uses 110 port for POP3 and port 25 for SMTP. Does this apply to SQLMail as well? Thanks in advance for your support.
View 1 Replies View Relatedhi every on am searching for a file which contains information about
the instance in my sql server and the ports that this instances are running on ,am sure that there is a file like this but i cant find it please if u know it answer me ,,, and thanks alot for ur time//
MobashA
Hey all
I am using Transactional replication with updatebale subscriptions
What network ports are used for SQL server 2005 replication
This is for firewall config.
Thanx
Does anyone know what ports are required to be open (non-NT). We are placing the SQL-Server behind a UNIX firewall, and want to minimize the ports open.
View 1 Replies View RelatedHi 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 .....
Hello,How to determine, which ports do MS SQL Server instances listen to?I want to conect to sql server using PHP and I need to know exact portnumber. I suspect that my SQL (msde) server instances don't listen ondefault 1433 :]--Stefan
View 1 Replies View RelatedHopefully someone can answer this as I am yet to find any definitive information.
User access reports by default on port 80.
Report Manager and Report Viewer are on machine A. Catalog database is on SQL Server machine B along with the database being reported on.
What ports are required to be open between machine A and machine B? Does it use standard SQL port 1433, are there any other ports used?
Thanks
Hi,
Using SQL Configuration Manager, i have set my local instance to use TCP Dynamic Ports by setting the value under IPAll to be 0 (the value TCP Port is blank). However, when i start up the server this value gets set to a specific port. ie Before startup TCP Dynamic Ports = 0, After startup TCP Dynamic Ports = 2832. This value persists throughout SQL Server restarts.
Is this behaviour correct as I would have expected this value to stay 0?
I am using SQL Standard, SP2. SQL Browser is running.
Thanks in advance!
How would i open up ports on the server? Are they all open or do i have to specify which ones i want open? thanks
View 7 Replies View RelatedI have two instances of SQl 2005 running on a server. One I'm going to allow outside remote access to. But I don't want to do it on the default port. though I have it allowing remote and that seems to be working. I can seem to find where to change the default listening port.
and I scimmed the help and topics I saw. But didn't see one relevant to this question.
When a ReportViewer control is used to access a report on a remote SQL Server database, on what ports does the communcation occur? Does the control communicate on on the SQL Server ports of 1433 and 1434 or does it communcate as a web service on port 80 (or 443 for HTPPS)?
View 1 Replies View Related
Server A = primary SQL DBs (mirroring origination)
Server B = failover SQL DBs (mirroring destination)
For database mirroring a witness is required.
Can the witness live in another instance of SQL on server B?
If I am doing an Index Server query from SQL, such as:SELECTQ.*FROMOPENQUERY(FTIndexPM, ''SELECT path, characterization, rank, hitcountFROM SCOPE('DEEP TRAVERSAL OF .....can anyone tell me which TCP/UDP ports will be used between the SQLServer and the Index server if the Index Server is on another machine?I'm doing the query from SQL so that I can join the results with atable in the database and am not interested in doing the Index queryfrom the app server. I haven't been able to find any info on the netfor which firewall ports are used for this.
View 5 Replies View RelatedI was reading that Net-Library Encryption is an SSL utility. Does thatmean the traffic uses TCP port 443 or does it still use TCP 1433?Thanks.http://msdn.microsoft.com/library/d..._ar_cs_6fu6.asp
View 1 Replies View RelatedHi Everyone,
I am new to the forum and would like to have a question answered. I want to to install Sql Server Express with advanced services but also want to have IIS installed as well. My question is, how do I install IIS without it opening Port 45? When I installed it, it would not let me finish installation without letting it act as a server. Is there any work around to solve this problem that any of you have managed to use?
I would like to use SSL on SQL Server 2005.
With SSL, is all traffic from the client to the database on port 443 ? Or are other ports needed ?
With Windows Certificate Management Snap-in, a request for a certificate assumes that there is a local Certificate Authority. I don't have one and it is my understanding that I should buy a third party certificate to avoid a man in the middle attack. With IIS there is a certificate request process. Is there something similar I should use with SQL ?
Thank you.
When multiple instances of SQL 2005 are installed on a cluster or standalone server, is it best to have each instance configured to listen on a different port or will one port for all do? We don't use port 1433 and the port we do use is blocked at the firewall. I'd like to standardize on one port for all instances but I'm not sure of the ramifications. Any thoughts?
Thanks.
My SQL Server is a shared account at MaximumASP.com a client just deployed my .NET application on GoDaddy.com and they have all there ports blocked and my app cannot connect to the SQL Server. Using "Network Library =dbmssocn" in the connection string did not help and GoDaddy will not help. MY QUESTION IS: how can I get my .NET app to connect to the SQL Server? web service? This is the first time I have run into this problem. There seems like there has to be some way. THANKS IN ADVANCE!
View 2 Replies View RelatedWe have a 2 servers with 2 default instances,
Environment- SQL server 2012 SP2 | Windows Server 2008 R2
1server:
hostname-serverA , Instance-serverA and port-2040 Ip-192.164.1.1
2server:
hostname-serverB , Instance-serverB and port-2040 Ip-192.164.1.2
If i do a SSMS connection-the possible connections strings which can be used to connect to Instance "serverB" should be,
a.serverBserverB
b.serverB,2040
c.192.164.1.2,2040
Note: but even the connection string "serverBserverA,2040" also connects to Instance "serverB", when i try to connect from SSMS, In SSMS it shows the wrong instance name like, "serverBserverB", but it actually connects to Instance "serverA"
i.what is the reason behind this?
ii.Is there any way to avoid this connection, by performing server property changes, if any ?
We have an internal sql 2000 server that acts as the database backend for our
Internet presence. I believe that the sql server can be accessed because of a
firewall "exception" (?) that allows the external web server to talk to the
sql server using a specific IP address and port (namely that of the sql server.)
Now we need to install a sql 2005 instance on the same box which needs to act
as an Internet backend. The sql browser service will resolve all client
requests to the default or named instance. But I read that the sql browser service
assigns a "dynamic" port to the Instance! If that is the case, it's unlikely that,
unless the firewall has all ports open for outgoing traffic, that the sql instance will be
able to communicate with the web server.
My conclusion:
Leave the default instance (sql 2000) port at its current value;
assign the named instance an unused port;
Make sure the sql browser is running on the box!
Tell the firewall guys to make an exception for the new port.
Does this seems reasonable to you?
TIA,
barkingdog
I have an existing 2012 default SQL Express. It's set up on a VPS managed by a third party. I have an administrator account on this 2012 Windows server. I'm not much of a sysadmin or a DBA but I get around. ;)
I've installed a new NAMED instance on this VPS and can not connect to it with client tools (SSMS). If I remote in, I can connect this way.
What steps might a seasoned DBA expect to make when getting a new named instance ready for the world.
Assign a port? Check the port?
Open the firewall for the port?
Will this new named instance listen on a different port than the previously installed SQL Express instance?
Using SQL Server 2008, we would like propose mirroring between two servers of a critical database. Since we initiate, may require to clarify on its purpose and also required changes from application end.Any changes required from OS Level? (I believe both servers IP or Host name should be added in host entries. Mirroring ports should be allowed/open including Principal and mirror server IP Addresses): Windows Team.Any changes required from Application? (Instance name, authentication: user name and its password should be added in web config files): Application Team.Any changes required from Network Team?Also for mirroring both the principal and mirror servers should be with same version, does it only mean SQL Server 2008 versions are enough or does it also mean to say build numbers 10.00.4000 should also be same.URL....
View 5 Replies View RelatedI need to set up asyncronous data replication across two clustered instances of SQL 2012 across 2 Datacenters. Both the datacenters have a common domain however the vlans are different. There are only 3 small databases on the primary instance.
any issue in setting up mirroring in this case as vlans are different.
Operating system is Windows 2012.
Hi All
By mirroring I mean device mirror, since I do not think that there is a database mirror
We only have disk mirror. I also know that SQLServer 7.0 does not provide Mirror, unmirror or remirror. and for this we have to refer to Windows NT disk mirroring.
I need mirroring in both versions SQL Server 6.5 and 7.0
I want to have mirror on another server. I need this for tonight.
Sincerely.
I hereby let u know the steps that i undertook for performing mirroring
1. Created a database in Principal server named Mirror1 and one table named tblMirror1.( no values inside the table)
2. Repeated the same in Mirror in Witness
3. Selected the Principal server's database -->right click-->tasks-->mirror
4. from the left hand panel selected Options -->recovery model-->full
5. selected Mirroring from left hand panel-->configure secuirty-->entered mirror and witness name--Success
6. When I click on start mirroring I have an error stating
" Alter failed for database mirror1"
"Database mirroring cannot be enabled because Mirror1 database may have bulk logged changes that have not been backed up etc...."
7. followed this one
BACKUP database mirror1 TO DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'
got the answer as
Processed 160 pages for database 'mirror1', file 'Mirror1' on file 2.
Processed 1 pages for database 'mirror1', file 'Mirror1_log' on file 2.
BACKUP DATABASE successfully processed 161 pages in 0.318 seconds (4.147 MB/sec).
According to sources
Run a restore of this backup on your mirror.
This can be done through the GUI or using a T-SQL command.
The database restore must use the NO RECOVERY option, so the database stays in a loading state.
Also the database name on the mirror must be the exact same name as the principal
RESTORE TestMirror FROM DISK='C:Backup TestMirror_FULL.BAK' WITH NORECOVERY
Hence did the below
RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY
ERROR
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
HENCE MODIFIED AS
use master
go
RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
========
Kindly let me know please where am i going wrong
Regards
cmrhema
hello
if i run dbcc dbreindex on a database thats the principal in a mirrored pair, will the mirrored database indexes also be rebuilt?
i am for the first time creating the database mirroring.I am moving the all the usr databases and everything from test server to a new server called test1.And from that new server i am restoring on the another new server called test2 for database mirroring.But in the test server , the transaction logs are backup for every 15 minutes.So in this case is there a need to move all the logs to test1 and then to test2 for mirroring?? or there is no need to move transaction logs to the new servers at all??
my secnario
------------
server1 server2 server3
-------- ------- --------
test test1 (moving everything from test) test2(mirror for test1 )
all the transaction logs are backup in test for every 15 minutes. so in this case , do i need to move the transcation logs from test to test1 and test2
or there is not need to move at all??
thanks,
Can anyone please tell me what mirroring is??
Thanks in ADvance
RKNAIR
I have sql server 2005 on my vista laptop.
When i set up database mirroring, do i have to set up Principle,
mirror and witness on seperate servers as well as seperate instances.
Or can i install 3 seperate instances on the same laptop im using and still use mirroring? I have tried to start mirroring with all three instances on my laptop but i receive an error.
Regards
Rob
Hi All,
I am trying to set up database mirroring and in the initial phase of database restoring im getting some problem.
the scenario is .
1- I create a TestMirror on server1(which will be principal server) and backup full and transaction logs.
2- create TestMirror in server 2( Which is going to be used as mirror) .
3- restore the full backup of "TestMirror" from Principle Sever with NORECOVERY option.
this step results in a message box showing that the restore was successfull...
but the database explorer( management studio) shows the TestMirror in (restoring ...) state. and no more operations can be performed with this Database. ( because the database is in restoring mode).. please help what this issue is?
Thanks In Advance for any suggestions
-- Krishna
hello
i used following query to create endpoint
CREATE ENDPOINT Endpoint_Mirroring
STATE = STARTED
AS TCP (
LISTENER_PORT=5024
, LISTENER_IP = ALL
)
FOR DATABASE_MIRRORING (
AUTHENTICATION = CERTIFICATE HOST_A_cert
, ENCRYPTION = REQUIRED ALGORITHM RC4
, ROLE = ALL
);
GO
i got the following error msg:
Msg 1498, Level 16, State 2, Line 11
Database mirroring is disabled by default. Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments. To enable database mirroring for evaluation purposes, use trace flag 1400 during startup. For more information about trace flags and startup options, see SQL Server Books Online.
any help plzz
thanks in advance
Hello,
I have Microsoft SQL SERVER 2005 installed in my system.
To try out mirroring, I rightclicked on the database went to the tasks, but i found that in Status its written
"This database has not been configured for mirroring"
What shall I do now?