How to change SQL Server Browser service back to port 1434

Gurus,
Running SQL Server 2005 SP2. The SQL Server Browser service but since I am
running on dynamic ports it is not listening on 1434. In fact, looking thru
Configuration Manager I am not able to tell what port it is listening on or
how to change it back to 1434. Any ideas?
--
SpinSQL Browser always listens to 1434. It is the database engine that might be static or dynamic.
Browser is only there to translate between instance name and port number.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Spin" <Spin@.invalid.com> wrote in message news:67rgfkF2or7t6U1@.mid.individual.net...
> Gurus,
> Running SQL Server 2005 SP2. The SQL Server Browser service but since I am running on dynamic
> ports it is not listening on 1434. In fact, looking thru Configuration Manager I am not able to
> tell what port it is listening on or how to change it back to 1434. Any ideas?
> --
> Spin
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:89DD7ACA-DAB4-40D4-987F-5C6CA9B329B1@.microsoft.com...
> SQL Browser always listens to 1434. It is the database engine that might
> be static or dynamic. Browser is only there to translate between instance
> name and port number.
On my SQL Server I opened a CMP prompt a 'Netsat' command returned nothing
listening on port 1434. SQL Browser service IS running.|||"Spin" <Spin@.invalid.com> wrote in message
news:67ro9qF2q0vlvU1@.mid.individual.net...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:89DD7ACA-DAB4-40D4-987F-5C6CA9B329B1@.microsoft.com...
> On my SQL Server I opened a CMP prompt a 'Netsat' command returned nothing
> listening on port 1434. SQL Browser service IS running.
Disregard. I've done some reading and the SQL Browser service listens on a
UDP port, netstat only shows TCP ports on which connections are either
established or the server is listening. I have to figure out what UDP ports
are being listened. This may be a bit more difficult.|||"Spin" <Spin@.invalid.com> wrote in message
news:67rrf3F2q34siU1@.mid.individual.net...
> "Spin" <Spin@.invalid.com> wrote in message
> news:67ro9qF2q0vlvU1@.mid.individual.net...
> Disregard. I've done some reading and the SQL Browser service listens on
> a UDP port, netstat only shows TCP ports on which connections are either
> established or the server is listening. I have to figure out what UDP
> ports are being listened. This may be a bit more difficult.
Using TCPView.exe from Microsoft, I can clearly see now on at least one SQL
Server that the SQL Broswer service is listening on UDP 1434!
Tibor, am I correct in believing that the SQL Browser listening port CANNOT
be changed?|||> Tibor, am I correct in believing that the SQL Browser listening port CANNOT be changed?
Yes, that is the way I understand it. The whole purpose of SQL Browser is to be a fixed port. This
is so that outsiders can query it (that specific port) for the port number for an instance name.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Spin" <Spin@.invalid.com> wrote in message news:67rtnuF2qnt8iU1@.mid.individual.net...
> "Spin" <Spin@.invalid.com> wrote in message news:67rrf3F2q34siU1@.mid.individual.net...
>> "Spin" <Spin@.invalid.com> wrote in message news:67ro9qF2q0vlvU1@.mid.individual.net...
>> Disregard. I've done some reading and the SQL Browser service listens on a UDP port, netstat
>> only shows TCP ports on which connections are either established or the server is listening. I
>> have to figure out what UDP ports are being listened. This may be a bit more difficult.
> Using TCPView.exe from Microsoft, I can clearly see now on at least one SQL Server that the SQL
> Broswer service is listening on UDP 1434!
> Tibor, am I correct in believing that the SQL Browser listening port CANNOT be changed?
>
>|||You can use netstat to show UDP ports that are being listened on. Run the
following:
cmd>netstat -ano
One of UDP rows in the result will have port 1434. Find the the PID, and run
tasklist to confirm that the PID is sql browser.
Linchi
"Spin" wrote:
> "Spin" <Spin@.invalid.com> wrote in message
> news:67ro9qF2q0vlvU1@.mid.individual.net...
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> > in message news:89DD7ACA-DAB4-40D4-987F-5C6CA9B329B1@.microsoft.com...
> > On my SQL Server I opened a CMP prompt a 'Netsat' command returned nothing
> > listening on port 1434. SQL Browser service IS running.
> Disregard. I've done some reading and the SQL Browser service listens on a
> UDP port, netstat only shows TCP ports on which connections are either
> established or the server is listening. I have to figure out what UDP ports
> are being listened. This may be a bit more difficult.
>
>sql

How to change SA Password?

Hi, i'm running SQL Server 2000, the SA password hasn't been changed since it was installed. How do i go aobut changing the SA password? thanks in advice to any one who can help.Use EM - you'll find it under Security / Logins.

How to change login in linked server (From Sql Security to Integrated Sec)

We are having some commercial applications that are running on sql servers at different sites, all with sql security. The software vendor wants to copy data into staging tables on our BI server. But our BI server only support Integrated security.

But how can i say, in the definition of a linked server (at the remote machines) to swicth security system ?

If it is possible i could enter a fixed domain-account in that users fields, but i suppose that this field was intended for SqlServer security.

Hi,

Create a login say (Remoteaccess) on both the server and give permission on the database(fullrights).

Use this remote login in ur linked server.

Then u can permorm ETL process on both the server.

The same way u can do on other servers also.

Another way is u can setup replication(but it will increase overhead).

regards

Mohd Sufian

|||

You can drop the existing linked server login mapping using sp_droplinkedsrvlogin and recreate them using sp_addlinkedsrvlogin. In the new login mapping, you can set the @.useself parameter to true.

Let us know if this works!

sql

How to Change Data Directory to D: drive

Hi everyone,
I have a problem here. I install SQL Server and set it's Data Folder to C:
drive.
Unfortunately my C drive is running out of space and I plan to add another
drive (D: drive).
I want to move my database to D: drive, but however I cannot see D: drive in
the SQL Server Enterprise Manager
when I try to add a new database.
Could anyone help me?
Best Regards,
Deili.Hi,
Execute the command XP_FIXEDDRIVES from Query Anayzer. If you can see D
drive then you can very well move the datbases to D drive. If you are not
able to
see please check the access prev. of D Drive.
How to Move.
1. Detach all user databases (SP_detach_db)
2. Move it to D Drive
3. Attach the dataabases (SP_attach_db)
How to chage the default data folder:
In Enterprise manager , right click above server -- Properties
select "database setting" option, there you can chage the
Default data and Log directory.
Thanks
Hari
MCDBA
"news.microsoft.com" <deili@.yahoo.com> wrote in message
news:OrfWGmw1DHA.2680@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Hi everyone,
> I have a problem here. I install SQL Server and set it's Data Folder to C:
> drive.
> Unfortunately my C drive is running out of space and I plan to add another
> drive (D: drive).
> I want to move my database to D: drive, but however I cannot see D: drive

---

in

quote:

---

> the SQL Server Enterprise Manager
> when I try to add a new database.
> Could anyone help me?
> Best Regards,
> Deili.
>

---

How to Change Data Directory to D: drive

Hi everyone,
I have a problem here. I install SQL Server and set it's Data Folder to C:
drive.
Unfortunately my C drive is running out of space and I plan to add another
drive (D: drive).
I want to move my database to D: drive, but however I cannot see D: drive in
the SQL Server Enterprise Manager
when I try to add a new database.
Could anyone help me?
Best Regards,
Deili.Hi,
Execute the command XP_FIXEDDRIVES from Query Anayzer. If you can see D
drive then you can very well move the datbases to D drive. If you are not
able to
see please check the access prev. of D Drive.
How to Move.
1. Detach all user databases (SP_detach_db)
2. Move it to D Drive
3. Attach the dataabases (SP_attach_db)
How to chage the default data folder:
In Enterprise manager , right click above server -- Properties
select "database setting" option, there you can chage the
Default data and Log directory.
Thanks
Hari
MCDBA
"news.microsoft.com" <deili@.yahoo.com> wrote in message
news:OrfWGmw1DHA.2680@.TK2MSFTNGP11.phx.gbl...
> Hi everyone,
> I have a problem here. I install SQL Server and set it's Data Folder to C:
> drive.
> Unfortunately my C drive is running out of space and I plan to add another
> drive (D: drive).
> I want to move my database to D: drive, but however I cannot see D: drive
in
> the SQL Server Enterprise Manager
> when I try to add a new database.
> Could anyone help me?
> Best Regards,
> Deili.
>sql

How to catchup job schedule? Scheduled jobs not running.

Hi,
I try not to schedule jobs during sw/hw maintenance windows, but sometimes
it happens - even more so now with active windows update running. It just
shuts down without regard to what's running.
Unfortunately, when the sql server comes back up, it doesn't run jobs that
are past due. I can't seem to find any setting that would 'catch-up' the
jobs. Would you share your thoughts on how to deal with this situation.
thanks
Doug
I don't think there is a "built-in" function for this type of situation.
However, you can create your own stored procedure that queries
msdb..sysjobhistory and look for run_status = 0, then use sp_start_job to
start those jobs that failed. And then you can set up a scheduled job to run
this SP during every restart.
"Doug Little" wrote:

> Hi,
> I try not to schedule jobs during sw/hw maintenance windows, but sometimes
> it happens - even more so now with active windows update running. It just
> shuts down without regard to what's running.
> Unfortunately, when the sql server comes back up, it doesn't run jobs that
> are past due. I can't seem to find any setting that would 'catch-up' the
> jobs. Would you share your thoughts on how to deal with this situation.
> thanks
> --
> Doug

How to catchup job schedule? Scheduled jobs not running.

Hi,
I try not to schedule jobs during sw/hw maintenance windows, but sometimes
it happens - even more so now with active windows update running. It just
shuts down without regard to what's running.
Unfortunately, when the sql server comes back up, it doesn't run jobs that
are past due. I can't seem to find any setting that would 'catch-up' the
jobs. Would you share your thoughts on how to deal with this situation.
thanks
DougI don't think there is a "built-in" function for this type of situation.
However, you can create your own stored procedure that queries
msdb..sysjobhistory and look for run_status = 0, then use sp_start_job to
start those jobs that failed. And then you can set up a scheduled job to ru
n
this SP during every restart.
"Doug Little" wrote:

> Hi,
> I try not to schedule jobs during sw/hw maintenance windows, but sometimes
> it happens - even more so now with active windows update running. It just
> shuts down without regard to what's running.
> Unfortunately, when the sql server comes back up, it doesn't run jobs that
> are past due. I can't seem to find any setting that would 'catch-up' the
> jobs. Would you share your thoughts on how to deal with this situation.
> thanks
> --
> Doug

How to catchup job schedule? Scheduled jobs not running.

Hi,
I try not to schedule jobs during sw/hw maintenance windows, but sometimes
it happens - even more so now with active windows update running. It just
shuts down without regard to what's running.
Unfortunately, when the sql server comes back up, it doesn't run jobs that
are past due. I can't seem to find any setting that would 'catch-up' the
jobs. Would you share your thoughts on how to deal with this situation.
thanks
--
DougI don't think there is a "built-in" function for this type of situation.
However, you can create your own stored procedure that queries
msdb..sysjobhistory and look for run_status = 0, then use sp_start_job to
start those jobs that failed. And then you can set up a scheduled job to run
this SP during every restart.
"Doug Little" wrote:
> Hi,
> I try not to schedule jobs during sw/hw maintenance windows, but sometimes
> it happens - even more so now with active windows update running. It just
> shuts down without regard to what's running.
> Unfortunately, when the sql server comes back up, it doesn't run jobs that
> are past due. I can't seem to find any setting that would 'catch-up' the
> jobs. Would you share your thoughts on how to deal with this situation.
> thanks
> --
> Doug

How to call remote object using C# Stored procedure

I want to call a windows based service running with remote objects listner from a C# Stored procedure. Any idea how to do that?

Hi-

I'm actually not quite sure what you would like to do, but if you could clarify, I can try to help.

I think your question may be how to do this within C#. 99.9% of the time, if it’s possible to do in C#, then it’s possible to do in SQLCLR (under atleast the UNSAFE permission set).

I'd recommend using MSDN or clarifying what you need to do to make your scenario work within a console application. Once you have your scenario working in a console application, you could port your code to map a stored procedure to an entry point.

Thanks!
Jason

|||

I am running a windows service with one exposed object using remoting.

I want to call that from stored procedure/function created in SQL Server using C#.

How to call remote object using C# Stored procedure

I want to call a windows based service running with remote objects listner from a C# Stored procedure. Any idea how to do that?

Hi-

I'm actually not quite sure what you would like to do, but if you could clarify, I can try to help.

I think your question may be how to do this within C#. 99.9% of the time, if it’s possible to do in C#, then it’s possible to do in SQLCLR (under atleast the UNSAFE permission set).

I'd recommend using MSDN or clarifying what you need to do to make your scenario work within a console application. Once you have your scenario working in a console application, you could port your code to map a stored procedure to an entry point.

Thanks!
Jason

|||

I am running a windows service with one exposed object using remoting.

I want to call that from stored procedure/function created in SQL Server using C#.

How to call remote object using C# Stored procedure

I want to call a windows based service running with remote objects listner from a C# Stored procedure. Any idea how to do that?

Hi-

I'm actually not quite sure what you would like to do, but if you could clarify, I can try to help.

I think your question may be how to do this within C#. 99.9% of the time, if it’s possible to do in C#, then it’s possible to do in SQLCLR (under atleast the UNSAFE permission set).

I'd recommend using MSDN or clarifying what you need to do to make your scenario work within a console application. Once you have your scenario working in a console application, you could port your code to map a stored procedure to an entry point.

Thanks!
Jason

|||

I am running a windows service with one exposed object using remoting.

I want to call that from stored procedure/function created in SQL Server using C#.

How to call an image via code behind

I'm running ssrs 2005 and want to write a function in the code in the page
something like this:
Public Shared Function ShowImage(val as integer) AS Image
IF val = 4 Then
Return apply.png
ELSE
Return nothing
END IF
End Function
Where apply.png is an image in the report project folder (source=external)
How can I do this?
--
moondaddy@.newsgroup.nospamI found a solution.
Basically, if a condition is true then I want to display the image. so I
put the following iff function in the images visibility property's hidden
section.
=IIF(Fields!VP_qpcCap.Value = 4,False,True)
I suppose if I had more complex logic, I could run a function in the code
behind and have it return true or false. then call that function in the
visibility property's hidden section.
"moondaddy" <moondaddy@.newsgroup.nospam> wrote in message
news:%23MMR56TPIHA.4740@.TK2MSFTNGP02.phx.gbl...
> I'm running ssrs 2005 and want to write a function in the code in the page
> something like this:
> Public Shared Function ShowImage(val as integer) AS Image
> IF val = 4 Then
> Return apply.png
> ELSE
> Return nothing
> END IF
> End Function
> Where apply.png is an image in the report project folder (source=external)
> How can I do this?
>
> --
> moondaddy@.newsgroup.nospam
>|||On Dec 12, 11:44 pm, "moondaddy" <moonda...@.newsgroup.nospam> wrote:
> I found a solution.
> Basically, if a condition is true then I want to display the image. so I
> put the following iff function in the images visibility property's hidden
> section.
> =IIF(Fields!VP_qpcCap.Value = 4,False,True)
> I suppose if I had more complex logic, I could run a function in the code
> behind and have it return true or false. then call that function in the
> visibility property's hidden section.
> "moondaddy" <moonda...@.newsgroup.nospam> wrote in message
> news:%23MMR56TPIHA.4740@.TK2MSFTNGP02.phx.gbl...
>
> > I'm running ssrs 2005 and want to write a function in the code in the page
> > something like this:
> > Public Shared Function ShowImage(val as integer) AS Image
> > IF val = 4 Then
> > Return apply.png
> > ELSE
> > Return nothing
> > END IF
> > End Function
> > Where apply.png is an image in the report project folder (source=external)
> > How can I do this?
> > --
> > moonda...@.newsgroup.nospam- Hide quoted text -
> - Show quoted text -
1. Add an Image object to your Report
2. Set the Value expression to "=Code.ShowImage( Fields!
VP_qpcCap.Value )
3. Change the ShowImage function to return a String
4. Change the Return line to Return "apply.pjm" (put it in double
quotes)
-- Scott

How to bring down a database

I have a need to shutdown a database on a server.
But it has other databases, I want to leave other
databases up and running.
How can I bring down a database and then how can
I bring it back up without affecting other databases
on the same server.
Thank you,
-LeOne way would be put the db in single user mode, then detach the db, and
then reattach it.
Quentin
"Linda" <anonymous@.discussions.microsoft.com> wrote in message
news:2a00201c46536$90a1aad0$a301280a@.phx
.gbl...
> I have a need to shutdown a database on a server.
> But it has other databases, I want to leave other
> databases up and running.
> How can I bring down a database and then how can
> I bring it back up without affecting other databases
> on the same server.
> Thank you,
> -Le|||Assuming you have already logged out or killed all user processes you can
take the DB offline as follows:
EXEC sp_dboption 'DATABASE_NAME', 'offline', 'TRUE'
Perhaps more useful is to make the database single-user only:
USE DATABASE_NAME
EXEC sp_dboption 'DATABASE_NAME', 'single user', 'TRUE'
David Portas
SQL Server MVP
--|||Hi,
To make a database Offline:-
alter database <dbname> set single_user with rollback immediate -- turns
database to single user
go
alter database <dbname> set offline
-- To set database online and multi user
alter database <dbname> set online
go
alter database <dbname> set multi_user
go
THanks
Hari
MCDBA
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:oZ-dncVuSMhJW3DdRVn-uw@.giganews.com...
> Assuming you have already logged out or killed all user processes you can
> take the DB offline as follows:
> EXEC sp_dboption 'DATABASE_NAME', 'offline', 'TRUE'
> Perhaps more useful is to make the database single-user only:
> USE DATABASE_NAME
> EXEC sp_dboption 'DATABASE_NAME', 'single user', 'TRUE'
> --
> David Portas
> SQL Server MVP
> --
>|||David,
Thank you,
-Le
>--Original Message--
>Assuming you have already logged out or killed all user
processes you can
>take the DB offline as follows:
>EXEC sp_dboption 'DATABASE_NAME', 'offline', 'TRUE'
>Perhaps more useful is to make the database single-user
only:
>USE DATABASE_NAME
>EXEC sp_dboption 'DATABASE_NAME', 'single user', 'TRUE'
>--
>David Portas
>SQL Server MVP
>--
>
>.
>|||Hari,
Thank you,
-Le

>--Original Message--
>Hi,
>To make a database Offline:-
>alter database <dbname> set single_user with rollback
immediate -- turns
>database to single user
>go
>alter database <dbname> set offline
>
>-- To set database online and multi user
>alter database <dbname> set online
>go
>alter database <dbname> set multi_user
>go
>THanks
>Hari
>MCDBA
>
>
>"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org>
wrote in message
>news:oZ-dncVuSMhJW3DdRVn-uw@.giganews.com...
user processes you can[vbcol=seagreen]
user only:[vbcol=seagreen]
>
>.
>|||Quentin,
Thank you,
-Le

>--Original Message--
>One way would be put the db in single user mode, then
detach the db, and
>then reattach it.
>Quentin
>
>"Linda" <anonymous@.discussions.microsoft.com> wrote in
message
> news:2a00201c46536$90a1aad0$a301280a@.phx
.gbl...
>
>.
>