Re-installing SQL Server

A remote user messed up my installation of SQL SP3 and now the SQL Server property shows it has SP3 but in fact it never went though the process. I'm planning to re-isntll the SQL server then apply the SP3.
Is there an article or can someone give me some pointers of preparation prior to removing the current SQL server. Also, currently I only know to back up the database file. Can I backup and restore the Master DB and it will retore all users' login and pa
sswords to a particular database now on the server?
Thanks,
Alpha
Have you tried reinstalling sp3? If it still fails without a good reason, I
highly recommend you starting reinstallation from scratch because the
previous failed sp install may have corrupted the SQL instance, or at least
changed system schemas etc, leaving you in a inconsistent state. You can run
sp_help_revlogin to script out all user logins and save them. Also detach
all user dbs for future attach. You need to script out all jobs, alerts,
etc. also to avoid restoring msdb.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:3D37FDD1-7C11-4DAE-99A6-E2E12CC11A76@.microsoft.com...
> A remote user messed up my installation of SQL SP3 and now the SQL Server
property shows it has SP3 but in fact it never went though the process. I'm
planning to re-isntll the SQL server then apply the SP3.
> Is there an article or can someone give me some pointers of preparation
prior to removing the current SQL server. Also, currently I only know to
back up the database file. Can I backup and restore the Master DB and it
will retore all users' login and passwords to a particular database now on
the server?
> Thanks,
> Alpha
|||I tried reinstalling sp3 twice and both time it won't go through. The sql server status shows it has SP3 when in fact the installation never went through. It is in a confused state. I will be removing the sql server installation, deleted the folder and
then re-install from scratch. I search the on-line book for more detail of sp_help_revlogin but it is not found. Is there a typo?
Thanks,
Alpha
"Richard Ding" wrote:

> Have you tried reinstalling sp3? If it still fails without a good reason, I
> highly recommend you starting reinstallation from scratch because the
> previous failed sp install may have corrupted the SQL instance, or at least
> changed system schemas etc, leaving you in a inconsistent state. You can run
> sp_help_revlogin to script out all user logins and save them. Also detach
> all user dbs for future attach. You need to script out all jobs, alerts,
> etc. also to avoid restoring msdb.
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:3D37FDD1-7C11-4DAE-99A6-E2E12CC11A76@.microsoft.com...
> property shows it has SP3 but in fact it never went though the process. I'm
> planning to re-isntll the SQL server then apply the SP3.
> prior to removing the current SQL server. Also, currently I only know to
> back up the database file. Can I backup and restore the Master DB and it
> will retore all users' login and passwords to a particular database now on
> the server?
>
>
|||Yes, you can backup and restore master, model, everything... But I think I
would open a PSS call to get MS support for this... Perhaps they can help
you get through without re-install... The cost is just $249 I think..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:58D9149D-F7B0-423F-9EE7-CA7E1AC62C13@.microsoft.com...
> I tried reinstalling sp3 twice and both time it won't go through. The sql
server status shows it has SP3 when in fact the installation never went
through. It is in a confused state. I will be removing the sql server
installation, deleted the folder and then re-install from scratch. I search
the on-line book for more detail of sp_help_revlogin but it is not found.
Is there a typo?[vbcol=seagreen]
> Thanks,
> Alpha
>
> "Richard Ding" wrote:
reason, I[vbcol=seagreen]
least[vbcol=seagreen]
run[vbcol=seagreen]
detach[vbcol=seagreen]
Server[vbcol=seagreen]
I'm[vbcol=seagreen]
preparation[vbcol=seagreen]
to[vbcol=seagreen]
it[vbcol=seagreen]
on[vbcol=seagreen]

Re-installing SQL Server

A remote user messed up my installation of SQL SP3 and now the SQL Server pr
operty shows it has SP3 but in fact it never went though the process. I'm p
lanning to re-isntll the SQL server then apply the SP3.
Is there an article or can someone give me some pointers of preparation prio
r to removing the current SQL server. Also, currently I only know to back u
p the database file. Can I backup and restore the Master DB and it will ret
ore all users' login and pa
sswords to a particular database now on the server?
Thanks,
AlphaHave you tried reinstalling sp3? If it still fails without a good reason, I
highly recommend you starting reinstallation from scratch because the
previous failed sp install may have corrupted the SQL instance, or at least
changed system schemas etc, leaving you in a inconsistent state. You can run
sp_help_revlogin to script out all user logins and save them. Also detach
all user dbs for future attach. You need to script out all jobs, alerts,
etc. also to avoid restoring msdb.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:3D37FDD1-7C11-4DAE-99A6-E2E12CC11A76@.microsoft.com...
> A remote user messed up my installation of SQL SP3 and now the SQL Server
property shows it has SP3 but in fact it never went though the process. I'm
planning to re-isntll the SQL server then apply the SP3.
> Is there an article or can someone give me some pointers of preparation
prior to removing the current SQL server. Also, currently I only know to
back up the database file. Can I backup and restore the Master DB and it
will retore all users' login and passwords to a particular database now on
the server?
> Thanks,
> Alpha|||I tried reinstalling sp3 twice and both time it won't go through. The sql s
erver status shows it has SP3 when in fact the installation never went throu
gh. It is in a confused state. I will be removing the sql server installat
ion, deleted the folder and
then re-install from scratch. I search the on-line book for more detail of
sp_help_revlogin but it is not found. Is there a typo?
Thanks,
Alpha
"Richard Ding" wrote:

> Have you tried reinstalling sp3? If it still fails without a good reason,
I
> highly recommend you starting reinstallation from scratch because the
> previous failed sp install may have corrupted the SQL instance, or at leas
t
> changed system schemas etc, leaving you in a inconsistent state. You can r
un
> sp_help_revlogin to script out all user logins and save them. Also detach
> all user dbs for future attach. You need to script out all jobs, alerts,
> etc. also to avoid restoring msdb.
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:3D37FDD1-7C11-4DAE-99A6-E2E12CC11A76@.microsoft.com...
> property shows it has SP3 but in fact it never went though the process. I
'm
> planning to re-isntll the SQL server then apply the SP3.
> prior to removing the current SQL server. Also, currently I only know to
> back up the database file. Can I backup and restore the Master DB and it
> will retore all users' login and passwords to a particular database now on
> the server?
>
>|||Yes, you can backup and restore master, model, everything... But I think I
would open a PSS call to get MS support for this... Perhaps they can help
you get through without re-install... The cost is just $249 I think..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:58D9149D-F7B0-423F-9EE7-CA7E1AC62C13@.microsoft.com...
> I tried reinstalling sp3 twice and both time it won't go through. The sql
server status shows it has SP3 when in fact the installation never went
through. It is in a confused state. I will be removing the sql server
installation, deleted the folder and then re-install from scratch. I search
the on-line book for more detail of sp_help_revlogin but it is not found.
Is there a typo?[vbcol=seagreen]
> Thanks,
> Alpha
>
> "Richard Ding" wrote:
>
reason, I[vbcol=seagreen]
least[vbcol=seagreen]
run[vbcol=seagreen]
detach[vbcol=seagreen]
Server[vbcol=seagreen]
I'm[vbcol=seagreen]
preparation[vbcol=seagreen]
to[vbcol=seagreen]
it[vbcol=seagreen]
on[vbcol=seagreen]

Regular Disconnection occurs in query analyzer??

Hi,
today we have a strange case, my developpers are disconnected from the
server under query analyzer only from remote stations.
The user must refresh the connection at the higher level to be connected
again.
but every 10 to 15 minutes my users are disconnected again!!!
From what I can see, this event occurs for all clients at the same time.
Any idea?
I'm connected through Terminal server to my server to see if there is any
problem, and I don't see anything wrong.
There is nothing in the event log and nothing in the SQL Server log.
Thanks for your help.
Jerome.
> From: "Jj" <willgart@._A_hAotmail_A_.com>
> Subject: Regular Disconnection occurs in query analyzer?
> Date: Tue, 27 Apr 2004 15:29:43 -0400
> Hi,
> today we have a strange case, my developpers are disconnected from the
> server under query analyzer only from remote stations.
> The user must refresh the connection at the higher level to be connected
> again.
> but every 10 to 15 minutes my users are disconnected again!!!
> From what I can see, this event occurs for all clients at the same time.
> Any idea?
> I'm connected through Terminal server to my server to see if there is any
> problem, and I don't see anything wrong.
> There is nothing in the event log and nothing in the SQL Server log.
> Thanks for your help.
> Jerome.
Hi Jerome,
Check the SQL Server errorlogs for any errors coinciding with the
disconnects. If nothing, you may have to capture a network trace to find
out why users are disconnecting.
Hope this helps,
Eric Crdenas
SQL Server senior support professional

Regular Disconnection occurs in query analyzer??

Hi,
today we have a strange case, my developpers are disconnected from the
server under query analyzer only from remote stations.
The user must refresh the connection at the higher level to be connected
again.
but every 10 to 15 minutes my users are disconnected again!!!
From what I can see, this event occurs for all clients at the same time.
Any idea?
I'm connected through Terminal server to my server to see if there is any
problem, and I don't see anything wrong.
There is nothing in the event log and nothing in the SQL Server log.
Thanks for your help.
Jerome.> From: "Jj" <willgart@._A_hAotmail_A_.com>
> Subject: Regular Disconnection occurs in query analyzer?
> Date: Tue, 27 Apr 2004 15:29:43 -0400
> Hi,
> today we have a strange case, my developpers are disconnected from the
> server under query analyzer only from remote stations.
> The user must refresh the connection at the higher level to be connected
> again.
> but every 10 to 15 minutes my users are disconnected again!!!
> From what I can see, this event occurs for all clients at the same time.
> Any idea?
> I'm connected through Terminal server to my server to see if there is any
> problem, and I don't see anything wrong.
> There is nothing in the event log and nothing in the SQL Server log.
> Thanks for your help.
> Jerome.
--
Hi Jerome,
Check the SQL Server errorlogs for any errors coinciding with the
disconnects. If nothing, you may have to capture a network trace to find
out why users are disconnecting.
Hope this helps,
Eric Crdenas
SQL Server senior support professional

Regular Disconnection occurs in query analyzer??

Hi,
today we have a strange case, my developpers are disconnected from the
server under query analyzer only from remote stations.
The user must refresh the connection at the higher level to be connected
again.
but every 10 to 15 minutes my users are disconnected again!!!
From what I can see, this event occurs for all clients at the same time.
Any idea?
I'm connected through Terminal server to my server to see if there is any
problem, and I don't see anything wrong.
There is nothing in the event log and nothing in the SQL Server log.
Thanks for your help.
Jerome.> From: "Jéjé" <willgart@._A_hAotmail_A_.com>
> Subject: Regular Disconnection occurs in query analyzer?
> Date: Tue, 27 Apr 2004 15:29:43 -0400
> Hi,
> today we have a strange case, my developpers are disconnected from the
> server under query analyzer only from remote stations.
> The user must refresh the connection at the higher level to be connected
> again.
> but every 10 to 15 minutes my users are disconnected again!!!
> From what I can see, this event occurs for all clients at the same time.
> Any idea?
> I'm connected through Terminal server to my server to see if there is any
> problem, and I don't see anything wrong.
> There is nothing in the event log and nothing in the SQL Server log.
> Thanks for your help.
> Jerome.
--
Hi Jerome,
Check the SQL Server errorlogs for any errors coinciding with the
disconnects. If nothing, you may have to capture a network trace to find
out why users are disconnecting.
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional

Registry Key for SQL Server 2005 Surface Area Configuration...

Whitch registry key should be set to allow Local and remote connections in SQL Server 2005 Surface Area configuration?May I know why you need this explicit value to update, as it is not good in terms of updating registry key on fly.

Registry entries for application to connect to remote SQL Server DB

I am trying to switch a PowerBuilder application from using a local database (SQL Anywhere) to a remote SQL Server database. I am getting IM002 after defining the data source and pointing the application to the datasource.
Can someone please send me some examples of Registry entries where an application is pointed to a remote SQL Server database?
IM002 is not a SQL Server error message. This seems to be a power builder issue, and I think you have a batter
chance to get good advice in a PowerBuilder newsgroup...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rajeev" <rlpd@.hotmail.com> wrote in message news:72091455-61D9-475E-B9AB-5DAF5A1DE604@.microsoft.com...
> I am trying to switch a PowerBuilder application from using a local database (SQL Anywhere) to a remote SQL
Server database. I am getting IM002 after defining the data source and pointing the application to the
datasource.
> Can someone please send me some examples of Registry entries where an application is pointed to a remote SQL
Server database?

Registry entries for application to connect to remote SQL Server DB

I am trying to switch a PowerBuilder application from using a local database
(SQL Anywhere) to a remote SQL Server database. I am getting IM002 after d
efining the data source and pointing the application to the datasource.
Can someone please send me some examples of Registry entries where an applic
ation is pointed to a remote SQL Server database?IM002 is not a SQL Server error message. This seems to be a power builder is
sue, and I think you have a batter
chance to get good advice in a PowerBuilder newsgroup...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rajeev" <rlpd@.hotmail.com> wrote in message news:72091455-61D9-475E-B9AB-5DAF5A1DE604@.micro
soft.com...
> I am trying to switch a PowerBuilder application from using a local database (SQL
Anywhere) to a remote SQL
Server database. I am getting IM002 after defining the data source and poin
ting the application to the
datasource.
> Can someone please send me some examples of Registry entries where an application
is pointed to a remote SQL
Server database?

Registry entries for application to connect to remote SQL Server DB

I am trying to switch a PowerBuilder application from using a local database (SQL Anywhere) to a remote SQL Server database. I am getting IM002 after defining the data source and pointing the application to the datasource
Can someone please send me some examples of Registry entries where an application is pointed to a remote SQL Server database?IM002 is not a SQL Server error message. This seems to be a power builder issue, and I think you have a batter
chance to get good advice in a PowerBuilder newsgroup...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rajeev" <rlpd@.hotmail.com> wrote in message news:72091455-61D9-475E-B9AB-5DAF5A1DE604@.microsoft.com...
> I am trying to switch a PowerBuilder application from using a local database (SQL Anywhere) to a remote SQL
Server database. I am getting IM002 after defining the data source and pointing the application to the
datasource.
> Can someone please send me some examples of Registry entries where an application is pointed to a remote SQL
Server database?

Registering SQL SERVER

Hi,
How to register a Remote SQL SERVER from a node in Local Area Network?You need to set up a linked server. See Linked Server in Books Online. If you need more help, let us know.

Registering a server

I am having difficulty registering to a newly installed server.
The server resides in a remote location.
The server is using mixed mode. I set a user up on the server named
SQLMANAGER with admin rights and also set up a user (SQLMANAGER) in SQL with
the same rights.
Whe I attempt to register the server I receive the following message :
"server does not exist or access denied"
I have 4 other servers which I have registered sucessfully, but none on this
segment of the network.
The IP am registering from is 105.1.13.206 and the server IP is 105.1.2.47.
I checked the log on the server and it is listening on port 1433.
Suggestions please!
Are you trying to register by server name or IP?
Jacco Schalkwijk
SQL Server MVP
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:03DCDD15-8280-40F4-88E1-3FE05472EB69@.microsoft.com...
>I am having difficulty registering to a newly installed server.
> The server resides in a remote location.
> The server is using mixed mode. I set a user up on the server named
> SQLMANAGER with admin rights and also set up a user (SQLMANAGER) in SQL
> with
> the same rights.
> Whe I attempt to register the server I receive the following message :
> "server does not exist or access denied"
> I have 4 other servers which I have registered sucessfully, but none on
> this
> segment of the network.
> The IP am registering from is 105.1.13.206 and the server IP is
> 105.1.2.47.
> I checked the log on the server and it is listening on port 1433.
> Suggestions please!
>
|||I have tried both.
The server does not come up in the server list so I entered it in manually.
On the server, I am able register the server to itself with no problem. I
am even able to register the server to the server that is failing to connect
to it.
"Jacco Schalkwijk" wrote:

> Are you trying to register by server name or IP?
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Gary" <Gary@.discussions.microsoft.com> wrote in message
> news:03DCDD15-8280-40F4-88E1-3FE05472EB69@.microsoft.com...
>
>

Registering a server

I am having difficulty registering to a newly installed server.
The server resides in a remote location.
The server is using mixed mode. I set a user up on the server named
SQLMANAGER with admin rights and also set up a user (SQLMANAGER) in SQL with
the same rights.
Whe I attempt to register the server I receive the following message :
"server does not exist or access denied"
I have 4 other servers which I have registered sucessfully, but none on this
segment of the network.
The IP am registering from is 105.1.13.206 and the server IP is 105.1.2.47.
I checked the log on the server and it is listening on port 1433.
Suggestions please!Are you trying to register by server name or IP?
Jacco Schalkwijk
SQL Server MVP
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:03DCDD15-8280-40F4-88E1-3FE05472EB69@.microsoft.com...
>I am having difficulty registering to a newly installed server.
> The server resides in a remote location.
> The server is using mixed mode. I set a user up on the server named
> SQLMANAGER with admin rights and also set up a user (SQLMANAGER) in SQL
> with
> the same rights.
> Whe I attempt to register the server I receive the following message :
> "server does not exist or access denied"
> I have 4 other servers which I have registered sucessfully, but none on
> this
> segment of the network.
> The IP am registering from is 105.1.13.206 and the server IP is
> 105.1.2.47.
> I checked the log on the server and it is listening on port 1433.
> Suggestions please!
>|||I have tried both.
The server does not come up in the server list so I entered it in manually.
On the server, I am able register the server to itself with no problem. I
am even able to register the server to the server that is failing to connect
to it.
"Jacco Schalkwijk" wrote:

> Are you trying to register by server name or IP?
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Gary" <Gary@.discussions.microsoft.com> wrote in message
> news:03DCDD15-8280-40F4-88E1-3FE05472EB69@.microsoft.com...
>
>

Registering a remote instance of MSDE

Hi..
I have been trying to register a remote instance..but have no success.
The MSDE instance is behind a firewall...So in the firewall im doing a port
fowarding.
The port that i have setup for forwarding is 1433 (TCP), is that correct?
i have installed the MSDE just like this:
setup SAPWD="MyPass" INSTANCENAME="MSDE" DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
Is there anything wrong?
Why i cant register that instance in my machine?
Thanks
hi Marcos,
Marcos Lommez wrote:
> Hi..
> I have been trying to register a remote instance..but have no success.
> The MSDE instance is behind a firewall...So in the firewall im doing
> a port fowarding.
> The port that i have setup for forwarding is 1433 (TCP), is that
> correct?
> i have installed the MSDE just like this:
> setup SAPWD="MyPass" INSTANCENAME="MSDE" DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> Is there anything wrong?
> Why i cant register that instance in my machine?
TCP 1433 should be wrong as you installed a named instance...
Microsoft only got 1 unique TCP/IP port for SQL Server
assigned by IANA, port TCP/IP 1433... but named instances never listen to
that port that is "reserved" for default instances... so Microsoft embedded
an additional service in order to allow dynamic ports assignemen/resolution
for named instance, and the MDAC stack has been modified as well to
integrate this feature (MDAC 2.6 and above)
for named instance you have 2 options... dynamic (default) or fixed static
port assignement..
loosely speaking, for dynamic port, when the specified instance starts, it
always searches for an unused port (actually it always uses the very same
port, if free)... the SQL Server Resolution Service, listening on UDP 1434
port, intercepts all remote connections to the instances, asks the instance
for it's used port, and redirects all connections to that specific port,
adding some little overhead to the traffic...
again, very very loosely speaking, the client makes a query, which is
reloaded by the MDAC stack to the appropriate network protocol [we are
talking about TCP/IP], that intiates the connection over a random tcp port
greater than 1024 to destination port; the listener service is the first
hand-shaker and intercepts the foreign call, queries the instance for it's
used port and negotiates a TCP/IP port for the 2 end points...
for a static assigned port, the listener on UDP 1434 port is not required,
but you have to map a server alias on each remote client pointing to the
correct fixed assigned port.. and again, the client intiates the connection
over a random tcp port greater than 1024 to destination port (say 1059). The
Subscriber should be allowed to make inbound (ANY) connections to
{say 1059} on a random port. The Publisher should be allowed to establish
outgoing connections to the subscriber from (ANY) to {say 1059}...
for Windows XP sp2 integrated Firewall closes all ports, you have to add an
exception for that in order to allow external access,
http://support.microsoft.com/default.aspx?scid=kb;[LN];841251 ,
http://support.microsoft.com/?id=841249 ,
http://support.microsoft.com/default.aspx?kbid=839980
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks so much Andrea...
In my case the solution is to use a fixed port.
But how do i set a specific port to use?
Im using MSDE 2000 running on Win2k Server
Thanks again
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escreveu na mensagem
news:47np01Fg9pf2U1@.individual.net...
> hi Marcos,
> Marcos Lommez wrote:
> TCP 1433 should be wrong as you installed a named instance...
> Microsoft only got 1 unique TCP/IP port for SQL Server
> assigned by IANA, port TCP/IP 1433... but named instances never listen to
> that port that is "reserved" for default instances... so Microsoft
embedded
> an additional service in order to allow dynamic ports
assignemen/resolution
> for named instance, and the MDAC stack has been modified as well to
> integrate this feature (MDAC 2.6 and above)
> for named instance you have 2 options... dynamic (default) or fixed static
> port assignement..
> loosely speaking, for dynamic port, when the specified instance starts, it
> always searches for an unused port (actually it always uses the very same
> port, if free)... the SQL Server Resolution Service, listening on UDP 1434
> port, intercepts all remote connections to the instances, asks the
instance
> for it's used port, and redirects all connections to that specific port,
> adding some little overhead to the traffic...
> again, very very loosely speaking, the client makes a query, which is
> reloaded by the MDAC stack to the appropriate network protocol [we are
> talking about TCP/IP], that intiates the connection over a random tcp port
> greater than 1024 to destination port; the listener service is the first
> hand-shaker and intercepts the foreign call, queries the instance for it's
> used port and negotiates a TCP/IP port for the 2 end points...
> for a static assigned port, the listener on UDP 1434 port is not required,
> but you have to map a server alias on each remote client pointing to the
> correct fixed assigned port.. and again, the client intiates the
connection
> over a random tcp port greater than 1024 to destination port (say 1059).
The
> Subscriber should be allowed to make inbound (ANY) connections to
> {say 1059} on a random port. The Publisher should be allowed to establish
> outgoing connections to the subscriber from (ANY) to {say 1059}...
> for Windows XP sp2 integrated Firewall closes all ports, you have to add
an
> exception for that in order to allow external access,
> http://support.microsoft.com/default.aspx?scid=kb;[LN];841251 ,
> http://support.microsoft.com/?id=841249 ,
> http://support.microsoft.com/default.aspx?kbid=839980
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Marcos,
Marcos Lommez wrote:
> Thanks so much Andrea...
> In my case the solution is to use a fixed port.
> But how do i set a specific port to use?
> Im using MSDE 2000 running on Win2k Server
just run the Server Network Utility (svrnetcn.exe), select the TCP/IP
protocol and access it's properties.. the port currently use is there...
just type the port you want to use and confirm...
then you can access the registry value
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNetLib\Tcp
(for a default instance)
or
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\InstanceName\MSSQLServer\SuperSocketNetLib\ Tcp (for a named instance)
and check the
TcpDynamicPorts ...
it's value should be empty...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea Montanari wrote:
> hi Marcos,
> Marcos Lommez wrote:
> just run the Server Network Utility (svrnetcn.exe), select the TCP/IP
> protocol and access it's properties.. the port currently use is
> there... just type the port you want to use and confirm...
> then you can access the registry value
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNetLib\Tcp
> (for a default instance)
> or
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\InstanceName\MSSQLServer\SuperSocketNetLib\ Tcp (for a named
> instance) and check the
> TcpDynamicPorts ...
> it's value should be empty...
http://support.microsoft.com/default...b;en-us;823938
:-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply