Sql Enterprise Edition: possibility

Showing posts with label possibility. Show all posts

Tuesday, March 27, 2012

Enumerate all available sql servers

Is there a possibility to enumerate all available sql servers in pure java.
At this time i execute osl -L and interprete the result.
Process p = runTime.exec("osql -L");
Computers without a msde or sql server installed do not have the osql
program. Is there a way to install osql? Or is there an other way to find all
available sql servers?
Thanks in advance Davy
You could simply try to connect to port 1433 of all machines and/or use
a JDBC driver that supports named pipes and try to connect via named
pipe to each machine in the network. This might take quite a while,
though.
Alin.
|||Thanks for the respond.
I already tried to connect to all machines, but i took a while (some minutes
which is too long).
I also tried to open a socket on port 1433, but sql server does not respond.
Is there a possibility to multicast a udp message to all ms-sql-monitors
(port 1434)?
Pipes is maybe an alternitive, but i'm not sure if pipes are enabled.
Davy
|||UDP port 1434 might just work. Give it a try and let me know how it
goes.
Alin.
|||Davy:
Rolling your own sqlbrowse with UDP on port 1434 should work, but if
you're considering going through OSQL then you'd be better off using
ODBC (SQLBrowseConnect) which is on every Windows box.
Be careful that this broadcast method is pretty imprecise -- Windows
machines after XPSP2 (esp. W2K3+) turn off port 1434 by default, and the
SQL Server 2005 will also ship with this port off by default for most
scenarios.
-shelby
Shelby Goerlitz
Microsoft SQL Server
"Davy" <Davy@.discussions.microsoft.com> wrote in message
news:Davy@.discussions.microsoft.com:
> Thanks for the respond.
> I already tried to connect to all machines, but i took a while (some
> minutes
> which is too long).
> I also tried to open a socket on port 1433, but sql server does not
> respond.
> Is there a possibility to multicast a udp message to all ms-sql-monitors
> (port 1434)?
> Pipes is maybe an alternitive, but i'm not sure if pipes are enabled.
> Davy
|||It’s quite difficult to find out the structure of the udp messages send by
the sql monitor. If anyone knows the udp structure all information is
welcome. I can try to write the udp messages with some help.
Davy
"Alin Sinpalean" schreef:

> UDP port 1434 might just work. Give it a try and let me know how it
> goes.
> Alin.
>
|||So it doesn’t seem a good idea?
I'll give it try, if someone has any idea which information to store in the
udp messages.
I tried the SQLBrowseConnect method as well. I couldn't call it directly
from java, but I found a C++ program.
http://www.sqldev.net/misc/ListSQLSvr.htm
It's easy to use from java and it uses the SQLBrowseConnect API, which is
osql independent.
Thank you very much
Davy
|||> I'll give it try, if someone has any idea which information to store
in the
> udp messages.
Just send a single 0x02 byte. You can find more info about the response
here [jTDS source code]:
http://cvs.sourceforge.net/viewcvs.p...=1.7&view=auto
Alin.
|||So, it's not even that difficult. I'm working on it, i hope to finish it
tomorrow. I'll post the result. Maybe one more question: any idea how to find
out the multicast address?
Right now i'm testing with a fixed 10.0.0.255 multicast address. Probably
this address want be te same for every company, but how can i calculate this
address?
Davy
"Alin Sinpalean" schreef:

> in the
> Just send a single 0x02 byte. You can find more info about the response
> here [jTDS source code]:
> http://cvs.sourceforge.net/viewcvs.p...=1.7&view=auto
> Alin.
>
|||Ok, i created some classes to look up all sql servers reachable by a
computer. The program performs a lookup of all subnets of a computer and send
the 02 multicast message on each subnet.
Where should i put the classes? Here as plain text on the forum?
To lookup the subnet of an ip, I use IPCONFIG. Ipconfig is translated, so I
included english, french and dutch. If you need more languages you should add
the texts. I'll add some comment to the source code.
Davy
"Alin Sinpalean" wrote:

> in the
> Just send a single 0x02 byte. You can find more info about the response
> here [jTDS source code]:
> http://cvs.sourceforge.net/viewcvs.p...=1.7&view=auto
> Alin.
>
sql

Friday, March 9, 2012

Enterprise Manager list databases

quote:
Originally posted by borko
Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
Borko

Enterprise Manager list databases

Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
BorkoNot any supported way. The only way I know of would be to hack the stored procedure that EM uses to
retrieve the database list. This is not supported and done at your own risk. I don't recommend it.
Possibly, you find such hack if you search the newsgroup archives.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message news:ctakq8$c0n$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from listing other databases on
> SQL server?
> Every user can see the list of databases but can change only his database. Is there a way to set
> it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>|||Even if you "hacked" the system sp, the next hotfix or service pack release
would overwrite any work you had done. Moreoer, the
INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
user.
This is the nature of a DBMS, to announce its existence and the catalogues
it make available. It is up to the DBA to secure those systems, not to hide
them.
Out of curiosity, why the need to conceal the names?
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
Not any supported way. The only way I know of would be to hack the stored
procedure that EM uses to
retrieve the database list. This is not supported and done at your own risk.
I don't recommend it.
Possibly, you find such hack if you search the newsgroup archives.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message
news:ctakq8$c0n$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on
> SQL server?
> Every user can see the list of databases but can change only his database.
Is there a way to set
> it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>|||In news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl,
Anthony Thomas <ALThomas@.kc.rr.com> said:
> Even if you "hacked" the system sp, the next hotfix or service pack
> release would overwrite any work you had done. Moreoer, the
> INFORMATION_SCHEMA.SCHEMATA would still be available to query for
> EVERY user.
> This is the nature of a DBMS, to announce its existence and the
> catalogues it make available. It is up to the DBA to secure those
> systems, not to hide them.
> Out of curiosity, why the need to conceal the names?
If you're running a shared database server (i.e. one which is used by
different companies), you may wish to hide the other database names or
indeed their quantity!
--
Steve|||FYI, in next version of SQL Server you will only see objects etc on which you have permissions...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Steve" <steve@.somewhere.invalid.com> wrote in message
news:sx7Kd.207465$ju.35135@.news.easynews.com...
> In news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl,
> Anthony Thomas <ALThomas@.kc.rr.com> said:
>> Even if you "hacked" the system sp, the next hotfix or service pack
>> release would overwrite any work you had done. Moreoer, the
>> INFORMATION_SCHEMA.SCHEMATA would still be available to query for
>> EVERY user.
>> This is the nature of a DBMS, to announce its existence and the
>> catalogues it make available. It is up to the DBA to secure those
>> systems, not to hide them.
>> Out of curiosity, why the need to conceal the names?
> If you're running a shared database server (i.e. one which is used by
> different companies), you may wish to hide the other database names or
> indeed their quantity!
> --
> Steve
>|||Hi,
Provider (that I am stuck with) doesn't allow me to use Enterprise Manager
because of privacy/business secret ... they don't want me to be able to see
what users are on the server (database names)
Just out of curiosity, is it possible to get the database list from ASP?
Thanks,
Borko
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> Even if you "hacked" the system sp, the next hotfix or service pack
> release
> would overwrite any work you had done. Moreoer, the
> INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
> user.
> This is the nature of a DBMS, to announce its existence and the catalogues
> it make available. It is up to the DBA to secure those systems, not to
> hide
> them.
> Out of curiosity, why the need to conceal the names?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
> Not any supported way. The only way I know of would be to hack the stored
> procedure that EM uses to
> retrieve the database list. This is not supported and done at your own
> risk.
> I don't recommend it.
> Possibly, you find such hack if you search the newsgroup archives.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "borko" <borko@.borko.co.co> wrote in message
> news:ctakq8$c0n$1@.ls219.htnet.hr...
>> Hi everyone,
>> Is there a possibility to block SQL user using Enterprise Manager from
> listing other databases on
>> SQL server?
>> Every user can see the list of databases but can change only his
>> database.
> Is there a way to set
>> it up just his own and nothing else.
>> Suggestions, links, ... appreciated
>> Thanks,
>> Borko
>|||> Just out of curiosity, is it possible to get the database list from ASP?
You can get a list of databases from any programming language from which you can execute SQL
statements:
SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA
or
SELECT name FROM sysdatabases
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message news:ctd2p1$4j2$1@.ls219.htnet.hr...
> Hi,
> Provider (that I am stuck with) doesn't allow me to use Enterprise Manager because of
> privacy/business secret ... they don't want me to be able to see what users are on the server
> (database names)
> Just out of curiosity, is it possible to get the database list from ASP?
> Thanks,
> Borko
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
>> Even if you "hacked" the system sp, the next hotfix or service pack release
>> would overwrite any work you had done. Moreoer, the
>> INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
>> user.
>> This is the nature of a DBMS, to announce its existence and the catalogues
>> it make available. It is up to the DBA to secure those systems, not to hide
>> them.
>> Out of curiosity, why the need to conceal the names?
>> Sincerely,
>>
>> Anthony Thomas
>>
>> --
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>> message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
>> Not any supported way. The only way I know of would be to hack the stored
>> procedure that EM uses to
>> retrieve the database list. This is not supported and done at your own risk.
>> I don't recommend it.
>> Possibly, you find such hack if you search the newsgroup archives.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "borko" <borko@.borko.co.co> wrote in message
>> news:ctakq8$c0n$1@.ls219.htnet.hr...
>> Hi everyone,
>> Is there a possibility to block SQL user using Enterprise Manager from
>> listing other databases on
>> SQL server?
>> Every user can see the list of databases but can change only his database.
>> Is there a way to set
>> it up just his own and nothing else.
>> Suggestions, links, ... appreciated
>> Thanks,
>> Borko
>>
>|||And the old standby, sp_helpdb.
This is kind of the point, a server ALWAYS announces its services. You have
to do quite a bit of homework to block that.
This is another good reason to ALWAYS choose a default database for EVERY
login, not just master. If users are used to automatically landing in
"their" databases, there is less need to query for others.
However, nothing is absolute; so, these are minor twiddles and not a real
solution. The real solution is what Tibor pointed out, that the upcoming
version has security in mind and that you will only view what you have
permission to.
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uLM0lmSBFHA.3820@.TK2MSFTNGP11.phx.gbl...
> Just out of curiosity, is it possible to get the database list from ASP?
You can get a list of databases from any programming language from which you
can execute SQL
statements:
SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA
or
SELECT name FROM sysdatabases
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message
news:ctd2p1$4j2$1@.ls219.htnet.hr...
> Hi,
> Provider (that I am stuck with) doesn't allow me to use Enterprise Manager
because of
> privacy/business secret ... they don't want me to be able to see what
users are on the server
> (database names)
> Just out of curiosity, is it possible to get the database list from ASP?
> Thanks,
> Borko
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
>> Even if you "hacked" the system sp, the next hotfix or service pack
release
>> would overwrite any work you had done. Moreoer, the
>> INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
>> user.
>> This is the nature of a DBMS, to announce its existence and the
catalogues
>> it make available. It is up to the DBA to secure those systems, not to
hide
>> them.
>> Out of curiosity, why the need to conceal the names?
>> Sincerely,
>>
>> Anthony Thomas
>>
>> --
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
>> message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
>> Not any supported way. The only way I know of would be to hack the stored
>> procedure that EM uses to
>> retrieve the database list. This is not supported and done at your own
risk.
>> I don't recommend it.
>> Possibly, you find such hack if you search the newsgroup archives.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "borko" <borko@.borko.co.co> wrote in message
>> news:ctakq8$c0n$1@.ls219.htnet.hr...
>> Hi everyone,
>> Is there a possibility to block SQL user using Enterprise Manager from
>> listing other databases on
>> SQL server?
>> Every user can see the list of databases but can change only his
database.
>> Is there a way to set
>> it up just his own and nothing else.
>> Suggestions, links, ... appreciated
>> Thanks,
>> Borko
>>
>

Tuesday, March 27, 2012

Enumerate all available sql servers

Friday, March 9, 2012

Enterprise Manager list databases

Enterprise Manager list databases

Enterprise Manager list databases

Enterprise Manager list databases

Enterprise Manager list databases

Enterprise Manager list databases

Sql Enterprise Edition

Blog Archive

About Me