Port Security Question
Jul 23, 2005
Hey all.
I'm running SQL server 2000, on W2K server. All the latest patches/etc
for both installed.
I've a need to allow remote access to the DB. I have a strong password
on the sa account, and have completed the various security checklists
on the MS website, including running the baseline security program they
provide.
Due to the nature of the application, windows authentication is not
possible.
Besides someone trying to hack in via a password guess, are there any
other things I need to worry about? Again, all the latest patches and
what not are installed.
Thanks
Matt
View 3 Replies
ADVERTISEMENT
Dec 27, 2007
hi
at first i apologize u for bad english.
my sqlserver2000 works on Win2000 for many years in a wide network.
i have problem that it used 1434 UDP port to increase bandwidth traffic by sending many UDP packages to many IP which created randomly by SQLServer2000 when it find another SQLServer2000 after sending packages again new server start sending UDP Package to other.
then no one cant connect to Server.
i had a worm like this 2 years ago.
but this bug or worm could not be detected by any anti virus or any SP like SP4.
How can i solve this problem ?
Tanks
View 5 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
Dec 4, 2014
I use from sql server 2008. and c#
what is the best connectionstring?
I don't know if i use Persist Security Info and Integrated Security or not?
And if yes then their value must be true or false?
View 1 Replies
View Related
Oct 14, 2005
Hello there I have trying to figure out for days how to enable FullTrust for my Reporting Services security extension.
View 9 Replies
View Related
Jul 31, 2007
Hi,
I have posted this issue for a week, haven't got any reply yet, I posted it again and desperately need your help.
The article http://msdn2.microsoft.com/en-us/library/ms365343.aspx says:
Model Item Security can be set for differnt security filters, but when I use SQL Server Management Studio to set Model Item Security, it seems "Permissions" property surpass "Model Item Security" property. -- My report server is using Custom Authentication.
For example, in "Permissions" property of the model, if I checked "Use these roles for each group or user account" without setting any user or group, no matter what users I added to "Model Item Security" with "Secure individual model items independently for this model" checked, NO one user can see the model on report manager and report builder;
in above situation, if I added "user1" and gave role such as "Browser" role to "user1" in "Permissions" property, if I checked "Secure individual model items independently for this model" in "Model Item Security" property, even I did NOT grant "user1" to root model and any entities under the model, the "user1" is able to access the model and all entities in report builder.
My question is on the same report model, how to set "AdminFilter" (empty security filter) for administrator permissions and set "GeneralFilter" (filtered on UserID) for general user based on their UserID?
The article also says:
"Security filters are always applied, even for users who have Content Manager or Administrator permissions to the model. To allow administrators or other users to see all rows of an entity on which row-level security is defined, you can create an empty security filter (which always returns True) and then use the filter to grant those users access to all the rows."
So I defined 2 filters "GeneralFilter" and "AdminFilter" for "Staff" entity for my report model "SSRSModel", I expect after I deployed the report model, the administrator users use report builder to build reports with all rows available, and the non-admin users can only see rows based on their UserID.
I can only get one result at a time but not both:
either the rows are filtered or not filtered at all, no matter how I set the "SecurityFilter" for the entity: I tried setting both "AdminFilter" and "GeneralFilter" for SecurityFilter at the same time, combination of "DefaultSecurityFilter" and "SecurityFilter", or one at a time.
Your help is highly appreciated!
Desperate developer
View 1 Replies
View Related
Apr 26, 2007
hi i want to know what is the differance between
Persist Security Info=False;Integrated Security=Yes;
View 1 Replies
View Related
Oct 18, 2015
Is there any possibility to schedule SQL job execution as Windows Security Group? I need to run powershell script through SQL job with one of this group member's permissions.Â
View 4 Replies
View Related
Jul 6, 2007
I have Sql Server Express installed on Vista (service pack 2)
I have Visual Studio 2005 with an application that I'm trying to access it with within a WCF service.
The login ID of the service is added to the database.
The database has remote access turned on.
The ID is granted access to all databases within the server.
The thread is being set with WindowsProvider and the services set their thread to WindowsProvider.
The dataserver is set with using Windows Authentication for security.
When I open my connection to the database, though, it reports the typically useless message that the connection is not allowed and that the server may not allow remote connections.
How to I get past this? I've done everything right.
View 1 Replies
View Related
Jun 18, 2007
I want to use an Active Directory security group that is a Distribution List for a new role assignment for an existing report. Can someone tell me if this is possible? I get an error each time I try:
The user or group name <DLName> is not recognized. (rsUnknownUserName)"
View 1 Replies
View Related
Apr 8, 2004
Hello,
I hope someone could help me out here.....
I have set up a new web server in my DMZ. This web server needs to "talk" to an application server located on my LAN. It communicates via a COM + Component.
I would like to keep the access that is open between the DMZ & LAN to minimal, obviously for security reasons. Does anyone know what port is used for COM + communication?
Thank you!
Spootnicks
View 2 Replies
View Related
May 29, 2007
in SQL 2005, how do you find out what port number SQL is using and how can we change it Static port?
thanks,
View 1 Replies
View Related
Jun 7, 2000
Ok,
The Scenario is as follows:
24/7 Production Call Centre server running NT4.0 and SQL 6.5 with all the latest service packs.
SQL mail fails(with dull regularity) and the SQL server services stop.
When the SQL server Services are restarted an error message appears stating that Port 1433 is in use after which nobody can connect via TCP/IP. Obviously the port believes the previous SQL session is still running, and won't release the port to the "New Application requesting it".
On a unix system you can force a port reset so you don't need to shutdown and restart the box. Can you do this from either SQL or NT?
Any solutions would be greatly appreciated the DBA's are 100 Miles from the Servers, so restarts are reliant on other people!
View 2 Replies
View Related
Jan 31, 2003
Is there any way that I can avoid using 1433,1434 port on the clustered servers?
I have a active/passive (SQL1-active,SQL2-passive) cluster server and another active/passive cluster (SQL2-passive,SQL1-active).
(Its a Quassi active/active server)
I want to change all the sql server ports to other than 1433 and 1434.
Should I change in the registry
Localmachine-software-microsoft-mssqlserver-client-supersocketnetlib-tcp
or
Localmachine-software-microsoft-mssqlserver-mssqlserver-supersocketnetlib-tcpport
or
anywhere else?
Any suggestions are always welcome
View 7 Replies
View Related
May 4, 2001
Does anyone have an idea on why when using IP with port 1433 that on the SQL 2000 Server a bind failure happens on port 1433 and are not able to get to the SQL using IP but you can use Named Pipes.
Would greatly appreciate any help.
Walter
View 3 Replies
View Related
Apr 13, 2006
I've been diagnosing deadlocks for a last couple weeks at a client site and I understand the KEY: and TAB: locks issues. However, the client recently experienced a series of multi-branch deadlocks for which I can find no information. Attached is the deadlock text from the ERRORLOG. Any help would be much appreciated.
Nick
View 2 Replies
View Related
Feb 2, 2004
Did a search on port 1433 but nothing came up in the search.
This question is more geared to DBAs more then SQL developers.
I have a SQL 2000 server on a win2k3 machine. For some reason it will not listen in on TCP port 1433.
Shared memory and Named Pipes do though.
I checked the Server Network Utility and I see TCP/IP listed right under Named Pipes and I see that the default port is 1433.
Any ideas how to get SQL to listen on that port?
View 14 Replies
View Related
Jun 2, 2008
Hi Gurus,
Iwant to know PORT number of B on A server.
Iam following the following process to get B PORT number.
1) Loging to server A.
2)Opened SQL Server Configuration Manager.
3)Opened SQL Server 2005 Network Configuration.
4)Opened TCPIP properties of Protocol for B.
5)On that opened IP Address TAB
6)Got PORT number from TCP Dynamic Ports
Am i going n right way.
If not please advice me the right way to get port numbers.
Thanks,
ServerTeam
View 8 Replies
View Related
Aug 23, 2007
1. Is there a quick way to find out what port number SQL is listening to? I have 10 instances running on one server and I could find out by going to SQL log but it's bit time consuming.
2. quick way to change the port number?
thanks
View 1 Replies
View Related
Oct 30, 2007
I'm trying to setup SQL Server 2005 Express to communicate through a non standard port. I can connect to SQLServer on a remote machine using port 1433 when it is set as such but when I change the server to another port and try and connect using SSMSE I can't get through. I'm specifying the ip address and a colon followed by port number to connect.
For example: 123.123.123.123:1234
Any ideas?
----------------------------------
Standing on the shoulders of giants
View 9 Replies
View Related
Jan 7, 2008
Not sure how this particular topic should be labeled but I figured I would start here.
I have a third party Time and Attendance program that uses SQL 2000 and IIS on top of Win2003.
It also uses a client side program that sits on an XP box that pulls Time clocks entries than passes that info to the SQL server.
We recently needed to move to a different service, still utilizing the same Time and Attendance program but a different client utility that pulls the Time clocks. Both the client and Time and Attnedants program are developed by the same company.
All that being said the new clock utility cannot connect to the SQL service.
The difference between the 2 utilities is the first utility uses UDP, the second uses TCP and requires port 5405.
Basically the way I€™m seeing things is that the server does not have port 5405 open this also confirmed by the company the wrote the program.
There is no firewall on this server. RRAS is installed but does not have any filters enables which I believe means it will receive and pass all protocols to all ports.
Using a port scan utility it shows port 5405 not to be open
How can I get port 5405 open?
View 5 Replies
View Related
Jan 23, 2007
Hi:
Just wanted to find out what port does SSIS utilizes when communicated with a remote SQL Server. Is it 1434, 1433 or something? I have a SSIS Package on Server 1, which which does inserts on SQL DB on Server 2. I think between Server 1 and Server 2, some ports are being blocked because the 2 servers are separated by a firewall. When SSIS makes connection to Server 2 (SQL), what ports does it use? Also, any other tips would also help. Here is the error I am getting:
Cannot connect to 10.xx.xx.xx.
===================================
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
View 12 Replies
View Related
Nov 8, 2006
I installed a new instance and changed the default tcp/ip port and configured the applications. based on request i have changed the port to default 1433. now the problem is, the instance is not coming up. Then I restored the port now its working fine. But the application user wants 1433. could you please tell me why the instances is not comming up if the port is 1433? Thanks in advance
View 7 Replies
View Related
Apr 29, 2008
i am asked to change the default port 1433 to some other name by the audit team.
is it safe to change the port in cluster mode.
View 17 Replies
View Related
Jan 19, 2007
The powers that be at my company have decided to redisign our network. The big change is that they are completely separating the two domains, whereas I guess right now one runs inside of the other.
What this means to me is that I need to get a document together which shows all the connections between different SQL servers, web pages and services that I've created over the last year.
My question is, what ports do all of these things use to communicate with SQL Server 2000? I believe the only connections right now are using ADO/ADO.NET, or straight SQL Linked Servers.
View 5 Replies
View Related
Jul 20, 2005
Is there anybody out there with a MS SQL 2K Security Baseline orSecurity Checklist. Where can I get one????Thanks in advanceDavid
View 1 Replies
View Related
Feb 28, 2008
Hi;
I am looking for a way to log all security related events for SQL in Windows Security Log. I am trying to use SCOM for monitoring SQL and I am looking at ways to generate alerts in my SCOM Console for specific events in SQL e.g. A table is deleted, user is modified, deleted, etc. Is this possible and if yes how do I achieve the same?
Rgds;
View 6 Replies
View Related
Aug 3, 2006
In an environment where there are many initaitors speaking to a central target with frowarders in between, from what i can understand this best policy is to disable encryption on the endpoints, since dialog encryption will be enforced this is all that is really required, is this correct.
If the endpoints used encryption the message would need to be encrypted and decrypted at each forwarder resulting in slower perfromance, where as dialog encryption would only encrypt at the sender and decrypt at the target, so is this the best way to go?
Secondly is it best practice to open a dialog initally and send messages over this dialog for years never ending the conversation? This way the services only have to authenticate eachother once, if there are no reboots etc that is of course.
I would think performance wise sending each message and ending the conversation each time is a much greater overhead ? So would it be best practice to keep dialogs open and keep sending messages ?
Initally when i was learning service broker i thought that one must send a message and end the dialog until the next message, but i think the other way is the best option ?
Is this correct ?
Thanx
View 1 Replies
View Related
Feb 19, 2007
Hi
I'm designing a distributed application where I will have SQL Server 2005 distributed databases replicating data to my central hub which is again a SQL Server 2005 database using SQL Service Broker. Data will be sent from the central hub to the distributed sites and vice versa. I need to authenticate the communication and also secure the communication by encrypting the messages. Which security shall I use? Where do I configure the type of security being used? What is the difference between transport security Vs dialogue security - Full security model?
Thanks
View 4 Replies
View Related
Apr 17, 2007
Need url on good kb or article on converting sql 2000 to sql 2005 (full version not express)
Thanks,
Michael Oard
View 4 Replies
View Related
Jan 5, 2001
Hi,
Could anyone tell me how the data can be ported from informix to sql server ?
Is there a way to run the informix query from sql server ?
Thanks,
Vijay.
View 1 Replies
View Related
Dec 15, 2000
Does anyone know how to change the default port number of 1433 to somethinig else?
Thanks!
View 1 Replies
View Related
Nov 5, 2002
Does anyone thing it is a wise thing to change the default port for SQL? Will this adversely affect the server? Thanks.
View 2 Replies
View Related
