Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to scan network computers for installed SQL Servers
- Thread starter andreis
- Start date
From SQL Server itself?
Are you sure this is the right forum to ask such question?
You should use NetServerEnum() API with SV_TYPE_SQLSERVER.
But that is for your front end not from SQL Server itself.
Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Are you sure this is the right forum to ask such question?
You should use NetServerEnum() API with SV_TYPE_SQLSERVER.
But that is for your front end not from SQL Server itself.
Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
ousoonerjoe
Programmer
Can you not set that via the Group Policies in Active Directory? I would think that would allow control and governance over who has the authority.
"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.
"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.
fredericofonseca
IS-IT--Management
not correct forum for sure.
But only safe way is to run a software inventory on each pc. There is software for that available on the net.
I don't know why you are trying to prevent this on SQL Server alone. If it is licensing, then you should also worry about other software. If not then there is really no valid reason for developers not to have a SQL Server instance on their PC. This will most of the times allow them to work better, and not to overload the servers.
If it is only licensing, then see into allowing them to install MSDE/SQL Server Express instead, as it is free and will give them the same functionality. This is off course assuming your company has the correct licenses for the Server.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
FAQ219-2884
FAQ181-2886
But only safe way is to run a software inventory on each pc. There is software for that available on the net.
I don't know why you are trying to prevent this on SQL Server alone. If it is licensing, then you should also worry about other software. If not then there is really no valid reason for developers not to have a SQL Server instance on their PC. This will most of the times allow them to work better, and not to overload the servers.
If it is only licensing, then see into allowing them to install MSDE/SQL Server Express instead, as it is free and will give them the same functionality. This is off course assuming your company has the correct licenses for the Server.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
FAQ219-2884
FAQ181-2886
- Status
Similar threads
- Locked
- Question
- Locked
- Question
