I 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.
Is it possible to change authentication mode after sql express has allready been installed?
I have admin rights on the computer and i want to change authentication mode to "sql server and windowns authentications mode".
Is this possible somehow?
Maybe by logging in with a trusted conncection?
I need to do it unattended on several computers after they have been installed.
Hi,
I am wondering using transfer sql server objects task in a sub-package and feeding tableslist property from the parent package. which works fine.
problem :
I want to be able to change the name in the fly so if I have
TableA I want to copy it for the destination as TableB
is there any work arround this just using transfer sql server objects task.
Thanks
Hi,
Is it possible to change the Dataflow tasks properties with VB coding? I've managed to change the properties of the control Flow tasks with VB code! as I wan to create a generic dataflow that will change everytime I run it.
Cheers
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 RelatedI'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
Hopefully 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 RelatedWhen 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 RelatedIf 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?
- When I disable "allow remote connections to this server" from server properties>connection page, I can still remotely connect to the server from SSMS...so what is the impact of enable/disabling it?
- what is the impact of changing the remote query timeout (on the same page) from default value?
Fellow Devs,
I have an instance of SQL Server Express 2005 running on another box and I have Remote Connections enabled over both TCP/IP and Named Pipes, but on my other box I keep getting the error that the server does not accept Remote Connections.
Any ideas why this might be happening? Is there some other configuration?
HiI'm going insane.I have a club starter kit on my local server which is working fine.I have migrated the database to my remote host and seems to have transfered ok.For a brief period I was able to connect to the database remotely, but now I cannot I get the following, even though SQL Server Surface Area Config is set to accept remote connections.An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)This is my connection string;<add name="ClubSiteDB" connectionString="Data Source=xx.xxx.xx.xx,xxxx; Network Library=DBMSSOCN; Initial Catalog=tets; User ID=sqladminbob;Password=sqlbob4398;" providerName="System.Data.SqlClient="/>I hav also tried to use aspnet_regsql.exe to add the remote provider but I get the same message. Thanks
View 3 Replies View RelatedI am trying to add a linked server from a AMD x64 server (Windows 2003) with SQL Server 2005 64 bit to a Server running SQL 2000. These are not in the same domain.
I can create a linked server using the option "Be made using the login's current security context" but can not when trying to specify the security context, i.e. sa and the sa password. When I try I get the following message:
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote server 'DTS_FSERVER'.
I have several other x64 server that I have no problem creating a linked server and specifying sa and the sa password.
The problem with using "the login's current security context" option is that I get an error when trying to run any Jobs against the linked server. The job fails withe the following error:
Executed as user: NT AUTHORITYSYSTEM. Access to the remote server is denied because no login-mapping exists. [SQLSTATE 42000] (Error 7416). The step failed.
I'm sure the two errors are related. Any ideas what is going on?
I just want to find out what the difference between a remote login and a remote query is. I'd have thought that a remote query inherently requires a remote login.
View 6 Replies View Related
Has anyone seen this error? It comes up when my app executes a select statement via linked server (from MSSQL 2000 to 2005) the second time it runs. It's basically a timed poll of tables in the remote database. It works once but the second time it executes I get the error from the remote db, it's just a select but I guess the cursor is still open so it can't run again. After the exception the select will run again, once and it just repeats. I have researched it a little and it looks like it mostly has to do with the isolation level of the transaction. Unfortunately based on the componet being used to access the database I don't beleive I have the ability to use transact SQL to call the isolation level (s) listed.
Here's the weird part though, at another site the same scenario is running fine. Same primary and remote db versions of MSSQL as well as the application and it runs fine. I guess my question is what type of setup parameters that may be defined in MSSQL 2005 for the remote database might make it behave in this manner in one instance and not the other? TIA in advance for any thoughts/assistance.
DT
Hello everyone, I am trying to connect to a remote SQL 2005 database from Microsoft SQL Server Management Studio.I enabled the remote connection on the server and creating a user on the server.I am trying to connect to the server from my workstation using sql server authentication with the login name already created on the server.
I am receiving this error: cannot connect to "server name"cannot open user default database. Login failed.Login failed for user "username".(Microsoft SQL Server, Error: 4064)
Can you help?
hai,
when iam opening an application which is using sqlsever2005.
Its showing an error.
an error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
plz help.
Thanks in advance.
Being new to this mobile game, ive created a database locally and now wish to place it onto my server but when I change my connection string from c:folderdb.sdf to \Serverfolderdb.sdf i get an error that says "value does not fall within the expected range" ive also tried mapping it ie Q:db.sdf
what am I doing wrong?