netstat on my server

A netstat on my MSSQL server shows
TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2060 ESTABLISHED
TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2114 ESTABLISHED
TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com.com:2195 ESTABLISHED
TCP MSSQL12:ms-sql-s c2-asp9.mydomain.com:2215 ESTABLISHED
TCP MSSQL12:ms-sql-s wsp05956800wss.cr.net.cable.rogers.com:3063
ESTABLISHED
TCP MSSQL12:ms-sql-s mailserver.uslive.net:1972 ESTABLISHED
I know the first four connections are servers on my domain, with asp pages
connecting to the DB. The other too I dont know what those are. Does that
mean that some other sites are connecting to my server as well? If so how
can I tell what they are accessing? And how can I stop them? Thses are just
some of the connections in netstat, what else should I be looking for and
what ports should I block for security?
Im new to MSSQL so any help or links would be appreciated.
Thank youhi,
more over run ping ,nslookup and tracert command to see what it returns ,
it will help full to isolate it more , is mailserver.uslive.net is a
mailserver for you ?! have you configure your SQL box for sendmail or any
such application.
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"rvegas@.rogers.com" wrote:

> A netstat on my MSSQL server shows
> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2060 ESTABLISHED
> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2114 ESTABLISHED
> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com.com:2195 ESTABLISHED
> TCP MSSQL12:ms-sql-s c2-asp9.mydomain.com:2215 ESTABLISHED
> TCP MSSQL12:ms-sql-s wsp05956800wss.cr.net.cable.rogers.com:3063
> ESTABLISHED
> TCP MSSQL12:ms-sql-s mailserver.uslive.net:1972 ESTABLISHED
> I know the first four connections are servers on my domain, with asp pages
> connecting to the DB. The other too I dont know what those are. Does that
> mean that some other sites are connecting to my server as well? If so how
> can I tell what they are accessing? And how can I stop them? Thses are jus
t
> some of the connections in netstat, what else should I be looking for and
> what ports should I block for security?
> Im new to MSSQL so any help or links would be appreciated.
> Thank you
>
>|||Hi ,
is their any Internet connection running on your server ?! or Router ? is
your Web Application is allowed to access outside network ?! it clearly show
s
* wsp05956800wss.cr.net.cable.rogers.com:3063 ESTABLISHED * , which means
the Internet Connection is their which enale it to access outside local
domain too
* TCP MSSQL12:ms-sql-s mailserver.uslive.net:1972 ESTABLISHED * ,
this is a tcp port 1972 accessing your sql , if you have set some send mail
or any application like this .
more over ask your network team . and see SQL LOG for any activity logged
from this network and hey dont missed to read event log of Windows and
configure C2 Audit.
:-)
Regards
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"rvegas@.rogers.com" wrote:

> A netstat on my MSSQL server shows
> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2060 ESTABLISHED
> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2114 ESTABLISHED
> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com.com:2195 ESTABLISHED
> TCP MSSQL12:ms-sql-s c2-asp9.mydomain.com:2215 ESTABLISHED
> TCP MSSQL12:ms-sql-s wsp05956800wss.cr.net.cable.rogers.com:3063
> ESTABLISHED
> TCP MSSQL12:ms-sql-s mailserver.uslive.net:1972 ESTABLISHED
> I know the first four connections are servers on my domain, with asp pages
> connecting to the DB. The other too I dont know what those are. Does that
> mean that some other sites are connecting to my server as well? If so how
> can I tell what they are accessing? And how can I stop them? Thses are jus
t
> some of the connections in netstat, what else should I be looking for and
> what ports should I block for security?
> Im new to MSSQL so any help or links would be appreciated.
> Thank you
>
>|||since your email is @.rogers.net i would get that one connection is you, as
for the other is your sql server sending notifications ?
<rvegas@.rogers.com> wrote in message
news:e6QXqFcAGHA.216@.TK2MSFTNGP15.phx.gbl...
>A netstat on my MSSQL server shows
> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2060 ESTABLISHED
> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com:2114 ESTABLISHED
> TCP MSSQL12:ms-sql-s c2-asp1.mydomain.com.com:2195 ESTABLISHED
> TCP MSSQL12:ms-sql-s c2-asp9.mydomain.com:2215 ESTABLISHED
> TCP MSSQL12:ms-sql-s wsp05956800wss.cr.net.cable.rogers.com:3063
> ESTABLISHED
> TCP MSSQL12:ms-sql-s mailserver.uslive.net:1972 ESTABLISHED
> I know the first four connections are servers on my domain, with asp pages
> connecting to the DB. The other too I dont know what those are. Does that
> mean that some other sites are connecting to my server as well? If so how
> can I tell what they are accessing? And how can I stop them? Thses are
> just some of the connections in netstat, what else should I be looking for
> and what ports should I block for security?
> Im new to MSSQL so any help or links would be appreciated.
> Thank you
>|||Actually yes my server has a vb script that sends out emails.
Basically i want to know who is connecting to my server, and what they are
using.
My server is consuming a lot of ram and i want to find out why? maybe its
sites not releasing connections. How can i find this out?
Thanx
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:euohWjlAGHA.436@.TK2MSFTNGP10.phx.gbl...
> since your email is @.rogers.net i would get that one connection is you, as
> for the other is your sql server sending notifications ?
> <rvegas@.rogers.com> wrote in message
> news:e6QXqFcAGHA.216@.TK2MSFTNGP15.phx.gbl...
>|||you can use taskman to view what procs are using what memory.
also the current activity tab in EM will give you connection info.
PerfMon can aslo be used.
<rvegas@.rogers.com> wrote in message
news:OmOmw6mAGHA.3936@.TK2MSFTNGP12.phx.gbl...
> Actually yes my server has a vb script that sends out emails.
> Basically i want to know who is connecting to my server, and what they are
> using.
> My server is consuming a lot of ram and i want to find out why? maybe its
> sites not releasing connections. How can i find this out?
> Thanx
> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
> news:euohWjlAGHA.436@.TK2MSFTNGP10.phx.gbl...
>|||Hi,
the best thing is to check with SQL Profiler .
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"David J. Cartwright" wrote:

> you can use taskman to view what procs are using what memory.
> also the current activity tab in EM will give you connection info.
> PerfMon can aslo be used.
> <rvegas@.rogers.com> wrote in message
> news:OmOmw6mAGHA.3936@.TK2MSFTNGP12.phx.gbl...
>
>|||I have no RAM left on the server. Every time i logon and try anything the
server hanngs and needs to be rebooted.
The server has 2GB RAM and all is used up, so i need a way to figure which
domain is taking up all the ram.
Taskmanager shows sqlservr.exe taking up the ram.
I know i need to add ram, but first i want to make sure no users are abusing
the server.
"Andy Davis" <activecrypt@.gmail.com> wrote in message
news:D6BAD1B0-3550-4423-BB49-4EA2383EA093@.microsoft.com...[vbcol=seagreen]
> Hi,
> the best thing is to check with SQL Profiler .
> :-)
> Regards
> --
> Andy Davis
> Activecrypt Team
> ---
> SQL Server Encryption Software
> http://www.activecrypt.com
>
> "David J. Cartwright" wrote:
>|||you can restrict how much memery sql uses
<rvegas@.rogers.com> wrote in message
news:OyHnrPaBGHA.1312@.TK2MSFTNGP09.phx.gbl...
>I have no RAM left on the server. Every time i logon and try anything the
>server hanngs and needs to be rebooted.
> The server has 2GB RAM and all is used up, so i need a way to figure which
> domain is taking up all the ram.
> Taskmanager shows sqlservr.exe taking up the ram.
> I know i need to add ram, but first i want to make sure no users are
> abusing the server.
> "Andy Davis" <activecrypt@.gmail.com> wrote in message
> news:D6BAD1B0-3550-4423-BB49-4EA2383EA093@.microsoft.com...
>|||Hi,
nope it is not the solution , have you check EP for correct INDEX seeking !
statistics are all updated , index is defreged ! on top of all is your
application have complex calulation ?!

> The server has 2GB RAM and all is used up, so i need a way to figure which
> domain is taking up all the ram.
> Taskmanager shows sqlservr.exe taking up the ram.
> I know i need to add ram, but first i want to make sure no users are
> abusing the server.
-- IT SHOWS THAT YOUR SQL SERVER IS WITH IIS , RIGHT ?! I WOULD SUGGEST YOU
THAT CHOOSE RAID1 FOR OS AND RAID 5 OR RAID 10 (DEPENDS UPON READ / WRITE IS
MORE) BASED ON HOW YOUR APPLICATION WORKS (READ / WRITE MORE) .
ONE MORE THING , MAY BE YOU KNOW BUT IF YOU ARE USING STANDARD EDITION YOU
CAN NOT USE MORE THAN 2 GB OF RAM , YOU HAVE TO HAVE ENTERPRISE / DEV EDITIO
N
TO USE MORE THAN 2 GB OF RAM . READ MAXIMUM CAPICITY SPECIFICATION IN BOL
FOR MORE.
HTH
:-)
Regards
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"David J. Cartwright" wrote:

> you can restrict how much memery sql uses
> <rvegas@.rogers.com> wrote in message
> news:OyHnrPaBGHA.1312@.TK2MSFTNGP09.phx.gbl...
>
>

needful parts of MSSQL to create local cube

hi,
I'm creating local cube with Delphi. On my server with MSSQL it work well, but i need to know, which parts of MSSQL is needful to create this local cube (on the server) if i will creat and instal new server with MS SQL.
Thanks for reply.I think you need analysis services, which come with enterprise edition of SQL Server|||Originally posted by dbabren
I think you need analysis services, which come with enterprise edition of SQL Server
I have instaled AS and it works, but then I uninstall AS and it allredy works too.
I don't know whitch libraries wasn't uninstall.
Somewhere i read something about pivot table?? what is it and how to install...
thanks|||I've only ever seen pivot tables used in excel, but there may be other instances of it I'm not aware of.

Haven't actually ever set one up, but I can't imagine they are that complex to do.|||its in SQL Server as well!! - just looked it up in BOL - have a read of that - no need to install as its a feature|||Originally posted by dbabren
its in SQL Server as well!! - just looked it up in BOL - have a read of that - no need to install as its a feature
Thank you.
Can you tell me a title in BOL where it is writen pleas?|||type in "pivot table" in the keyword searh bit.|||Originally posted by dbabren
type in "pivot table" in the keyword searh bit.
If I understand it well, only install MS SQL without AS will work OK...|||if that does the job for you mate, then the answer is yes. Its a standard feature of SQL Server I believe.|||Originally posted by dbabren
if that does the job for you mate, then the answer is yes. Its a standard feature of SQL Server I believe.
Special thanks to you!|||Originally posted by dbabren
if that does the job for you mate, then the answer is yes. Its a standard feature of SQL Server I believe.
But i have once more problem...
If SQL server is on different station than application server, and application server obtain query to SQL I need some DLLs isnt it?
And what DLLs?|||I find it "PivotTable Service, DLLs" BOL|||Unfortunately, I don't know any more than it states in BOL on this topic, although from a brief reading of the article it appears that you need to install some dll files on you app server - perhaps there is someone in this forum who has made use of this pivot table service?

need urgent help with directory structure...

I accidently changed the directory sub folders orders in the
c:\Program Files\Microsoft SQL Server\MSSQL.3 folder (i believe it's
for reporting service)
now the reporting service won't start.
can anyone tell me what the sub direcotries should look like under that
directory?
thank you!!!Reporting Services
\LogFiles
\ReportManager
\...
\ReportServer
\...
\RSTempFiles
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1143834522.169647.108420@.i39g2000cwa.googlegroups.com...
>I accidently changed the directory sub folders orders in the
> c:\Program Files\Microsoft SQL Server\MSSQL.3 folder (i believe it's
> for reporting service)
> now the reporting service won't start.
> can anyone tell me what the sub direcotries should look like under that
> directory?
> thank you!!!
>

Need urgent help to sort this out!

I've made this example and it loads a picture into a database. (MsSql )
Take a look at the code, it works just fine however it leaves a process in sleeping mode "avaiting command" in Enterprise manager under "Management/current Activity/Process Info"
Is it supposed to be like this or is it supposed to be reemoved after .net is finished??
Code snip
_______________________________________________________

Dim connAsNew SqlConnection("Data Source = (local);Initial Catalog = " & "test;User ID = NAME; Password=PASSWORD;")

Dim cmdAsNew SqlCommand("Select * from tab_bild", cnn)

Try

conn.Open()

Dim myDatareaderAs SqlDataReader

myDatareader = cmd.ExecuteReader(CommandBehavior.CloseConnection)

DoWhile (myDatareader.Read())

Response.ContentType = myDatareader.Item("PersonImageType")

Response.BinaryWrite(myDatareader.Item("PersonImage"))

Loop

conn.Close()

Response.Write("Picture info succesfully retrieved")

Catch SQLexcAs SqlException

Response.Write("Read failed, Reason: " & SQLexc.ToString())

EndTry

EndSub
________________________________________________________________

Please can someone explain this for me or sort this out for me.
All help is welcome even if its only points me too a direction.

Regards
Tombola

You should move yourconn.Close() into a Finally block.
|||Thanks for the reply Morton!
I suspect that you mean something like this.
----------------

Try

conn.Open()

Dim myDatareaderAs SqlDataReader

myDatareader = cmd.ExecuteReader(CommandBehavior.CloseConnection)

DoWhile (myDatareader.Read())

Response.ContentType = myDatareader.Item("PersonImageType")

Response.BinaryWrite(myDatareader.Item("PersonImage"))

Loop

Response.Write("Bild info succesfully retrieved")

Catch SQLexcAs SqlException

Response.Write("Read failed, Reason: " & SQLexc.ToString())

Finally

conn.Close()

EndTry

----------------
However it still leaves a sleeping process, but it will eventually time out, and be killed, I suppose.
I dont think this would bee such a good solution tough, what if the server is short off memory and there is a lot of sleeping processes that just waits to be timed out. The system would eventually freeze I think. Both IIS and MsSql harvests memory if I remember right.
Anyway the question would still be, Should the .net SqlClient leave a sleeping process on the server when the SqlClient is finished with all its doings?
Regards
Tombola|||I believe what you are seeing is a phenomenon of connection pooling. This is a good thing.
You should likely add a cmd.Dispose() after the conn.Close(). AndI would also add a conn.Dispose() after the conn.Close() for goodmeasure. It's a good idea to Dispose any object which implementthe IDisposable interface once you are done with it.