April 21, 2011 at 4:41 am
A large section of SQL servers are no longer visible on our network through either the browse or XP_CMDShell 'OSQL -L' command. Although you can log onto them if you know the server address.
Having checked the servers through the SQL Configuration tool they are not hidden. This has happened virtually overnight. Can anyone make any suggestions as to why this might be ? SQL browser is started on these servers.
April 21, 2011 at 9:47 am
MarvinTheAndriod (4/21/2011)
Although you can log onto them if you know the server address.
Clarification please:
"server address" = explicit IP address?
Can you log in using server_name\instance_name?
ip_address\instance_name ?
server_name,port_number ?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 21, 2011 at 9:48 am
If the routers were changed to block UDP 1434 (lots of network people do this), it would prevent browsing.
April 21, 2011 at 10:13 am
Start the SQL Server Browser service from the
CONTROL-PANAL ->Administrative Tools -> Services
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 21, 2011 at 10:50 am
Syed Jahanzaib Bin hassan (4/21/2011)
CONTROL-PANAL ->Administrative Tools -> Services
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
http://www.aureus-salah.com[/quote%5D
Will you stop posting useless answer and READ the effing thread before posting? We know you have a website and now it's on my blacklist of sites and person to never trust.
April 21, 2011 at 10:53 am
Ninja's_RGR'us (4/21/2011)
Syed Jahanzaib Bin hassan (4/21/2011)
Start the SQL Server Browser service from theCONTROL-PANAL ->Administrative Tools -> Services
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
http://www.aureus-salah.com[/quote%5D
Will you stop posting useless answer and READ the effing thread before posting? We know you have a website and now it's on my blacklist of sites and person to never trust.
AMEN!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 21, 2011 at 11:48 am
can you prove this?
Read this page from microsoft,you hit and trial people,you people have limited knowledge i think so
http://msdn.microsoft.com/en-us/library/ms165724(v=sql.90).aspx
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 21, 2011 at 11:56 am
Syed Jahanzaib Bin hassan (4/21/2011)
Read this page from microsoft,you hit and trial people,you people have limited knowledge i think so
http://msdn.microsoft.com/en-us/library/ms165724(v=sql.90).aspx
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
http://www.aureus-salah.com[/quote%5D
You're a joke, 2nd line of the OP question :
Having checked the servers through the SQL Configuration tool they are not hidden. This has happened virtually overnight. Can anyone make any suggestions as to why this might be ? SQL browser is started on these servers.
And here's another one like this :
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159568
I actually care about the people here, you come off like you don't. I hope I'm wrong about this.
April 21, 2011 at 12:20 pm
If the SQL Server Browser service is not running, you can still connect to SQL Server if you provide the correct port number or named pipe. For example, you can connect to the default instance of SQL Server with TCP/IP if it is running on port 1433.
The following connections will not work:
Any component that tries to connect to a named instance without fully specifying all the parameters, such as the TCP/IP port or a named pipe.
Any component that generates or passes server or instance information that could later be used by other components to reconnect.
Connecting to a named instance without providing the port number or pipe. This includes Data Mirroring to a named instance and clustering a named instance.
Dedicated Administrator Connections to a named instance, or the default instance if not using TCP/IP port 1434.
The OLAP redirector service.
Enumerating servers in SQL Server Management Studio, Enterprise Manager, or Query Analyzer.
If you are using SQL Server in a client-server scenario, for example, when your application is accessing SQL Server across a network, if you stop or disable the SQL Server Browser service, you must assign a specific port number to each instance and write your client application code to always use that port number. This approach has the following problems:
You must update and maintain client application code to make sure it is connecting to the proper port.
The port you choose for each instance might be used by another service or application on the server, causing the SQL Server instance to be unavailable
read these lines joker
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 21, 2011 at 1:57 pm
Ninja's_RGR'us (4/21/2011)
Syed Jahanzaib Bin hassan (4/21/2011)
can you prove this?Read this page from microsoft,you hit and trial people,you people have limited knowledge i think so
http://msdn.microsoft.com/en-us/library/ms165724(v=sql.90).aspx
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
http://www.aureus-salah.com[/quote%5D
You're a joke, 2nd line of the OP question :
Having checked the servers through the SQL Configuration tool they are not hidden. This has happened virtually overnight. Can anyone make any suggestions as to why this might be ? SQL browser is started on these servers.
And here's another one like this :
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159568
I actually care about the people here, you come off like you don't. I hope I'm wrong about this.
I just had it out with this guy yesterday...you just beat me to the punch with your response calling him out for not reading the OP and for rarely adding any technical value in any of his posts.
http://www.sqlservercentral.com/Forums/Topic1096316-391-1.aspx
Syed Jahanzaib Bin hassan (4/21/2011)
read these lines joker
You're too much Syed :hehe:
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 21, 2011 at 2:09 pm
you hit and trial people
Let me be the first to say huh?:unsure:
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 21, 2011 at 2:28 pm
Dan.Humphries (4/21/2011)
you hit and trial people
Let me be the first to say huh?:unsure:
Well now I have 2 questions. Is he just trolling or is he hired help from india at 40$ week with "some" experience in SQL hired to spam the heck out of forums to get backlinks for a site.
There's no way he's genuinly trying to help people here. And if he does there's no way in hell he's qualified to do so.
April 21, 2011 at 7:48 pm
Syed Jahanzaib Bin hassan (4/21/2011)
If the SQL Server Browser service is not running, you can still connect to SQL Server if you provide the correct port number or named pipe. For example, you can connect to the default instance of SQL Server with TCP/IP if it is running on port 1433.The following connections will not work:
Any component that tries to connect to a named instance without fully specifying all the parameters, such as the TCP/IP port or a named pipe.
Any component that generates or passes server or instance information that could later be used by other components to reconnect.
Connecting to a named instance without providing the port number or pipe. This includes Data Mirroring to a named instance and clustering a named instance.
Dedicated Administrator Connections to a named instance, or the default instance if not using TCP/IP port 1434.
The OLAP redirector service.
Enumerating servers in SQL Server Management Studio, Enterprise Manager, or Query Analyzer.
If you are using SQL Server in a client-server scenario, for example, when your application is accessing SQL Server across a network, if you stop or disable the SQL Server Browser service, you must assign a specific port number to each instance and write your client application code to always use that port number. This approach has the following problems:
You must update and maintain client application code to make sure it is connecting to the proper port.
The port you choose for each instance might be used by another service or application on the server, causing the SQL Server instance to be unavailable
read these lines joker
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Who cares, you still didn't read the op question, still no hint in there. I'm glad you can copy / paste.
I'm done with you. Good luck with your life, you're going to need it.
April 22, 2011 at 4:04 am
whats the problem with you guys,I dont know why guy interrupting me,do your own work
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 22, 2011 at 4:35 am
Syed Jahanzaib Bin hassan (4/22/2011)
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
http://www.aureus-salah.com[/quote%5D
We appreciate all help, as long as it actually helps and is not going to destroy the servers we are supposed to protect. You give information that is just plain wrong and dangerous for the 100s of users who might use it.
Don't worry about me, I'll call it out everytime for everyone. You just "hapenned" to have given out 5-10 crappy "helps" in a row. That makes you long like your very incompetent or just trying to send people to your site.
I don't have anythingg against making a mistake, but you have to be willing to accept your errors and correct them, which again you have not done.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply