I am changing the IP Number on a Win 2003 Enterprise Server running SQL 2000
Std. This SQL servert is accessed by a second machine running a SharePoint
web site.
After changing the numbers to the new network on both machines and rebooting
both machines, I get "SQL Server does not exist or access denied".
I can ping each machine from the other getting the new ip numbers, I can see
the machines from each other via NetBios.
Is there something else that needs to be done?
Paul@.CommerceStreet.comDoes sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
for this info.
You also want to run cliconfg.exe to see if you have your Sharepoint
pointing to the correct server/IP.
"Paul@.CommerceStreet.com"
<Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> I am changing the IP Number on a Win 2003 Enterprise Server running SQL
2000
> Std. This SQL servert is accessed by a second machine running a SharePoint
> web site.
> After changing the numbers to the new network on both machines and
rebooting
> both machines, I get "SQL Server does not exist or access denied".
> I can ping each machine from the other getting the new ip numbers, I can
see
> the machines from each other via NetBios.
> Is there something else that needs to be done?
> Paul@.CommerceStreet.com|||running cliconfg.exe and changing the IP Number seems to have fixed the
problem. Thanks!
PF
"oj" wrote:
> Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
> for this info.
> You also want to run cliconfg.exe to see if you have your Sharepoint
> pointing to the correct server/IP.
>
> "Paul@.CommerceStreet.com"
> <Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
> news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> > I am changing the IP Number on a Win 2003 Enterprise Server running SQL
> 2000
> > Std. This SQL servert is accessed by a second machine running a SharePoint
> > web site.
> >
> > After changing the numbers to the new network on both machines and
> rebooting
> > both machines, I get "SQL Server does not exist or access denied".
> >
> > I can ping each machine from the other getting the new ip numbers, I can
> see
> > the machines from each other via NetBios.
> >
> > Is there something else that needs to be done?
> >
> > Paul@.CommerceStreet.com
>
>
Showing posts with label second. Show all posts
Showing posts with label second. Show all posts
Sunday, February 19, 2012
Changing IP Number on SQL 2000 Std
I am changing the IP Number on a Win 2003 Enterprise Server running SQL 2000
Std. This SQL servert is accessed by a second machine running a SharePoint
web site.
After changing the numbers to the new network on both machines and rebooting
both machines, I get "SQL Server does not exist or access denied".
I can ping each machine from the other getting the new ip numbers, I can see
the machines from each other via NetBios.
Is there something else that needs to be done?
Paul@.CommerceStreet.com
Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
for this info.
You also want to run cliconfg.exe to see if you have your Sharepoint
pointing to the correct server/IP.
"Paul@.CommerceStreet.com"
<Paul@.CommerceStreet.com@.discussions.microsoft.com > wrote in message
news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> I am changing the IP Number on a Win 2003 Enterprise Server running SQL
2000
> Std. This SQL servert is accessed by a second machine running a SharePoint
> web site.
> After changing the numbers to the new network on both machines and
rebooting
> both machines, I get "SQL Server does not exist or access denied".
> I can ping each machine from the other getting the new ip numbers, I can
see
> the machines from each other via NetBios.
> Is there something else that needs to be done?
> Paul@.CommerceStreet.com
|||running cliconfg.exe and changing the IP Number seems to have fixed the
problem. Thanks!
PF
"oj" wrote:
> Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
> for this info.
> You also want to run cliconfg.exe to see if you have your Sharepoint
> pointing to the correct server/IP.
>
> "Paul@.CommerceStreet.com"
> <Paul@.CommerceStreet.com@.discussions.microsoft.com > wrote in message
> news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> 2000
> rebooting
> see
>
>
Std. This SQL servert is accessed by a second machine running a SharePoint
web site.
After changing the numbers to the new network on both machines and rebooting
both machines, I get "SQL Server does not exist or access denied".
I can ping each machine from the other getting the new ip numbers, I can see
the machines from each other via NetBios.
Is there something else that needs to be done?
Paul@.CommerceStreet.com
Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
for this info.
You also want to run cliconfg.exe to see if you have your Sharepoint
pointing to the correct server/IP.
"Paul@.CommerceStreet.com"
<Paul@.CommerceStreet.com@.discussions.microsoft.com > wrote in message
news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> I am changing the IP Number on a Win 2003 Enterprise Server running SQL
2000
> Std. This SQL servert is accessed by a second machine running a SharePoint
> web site.
> After changing the numbers to the new network on both machines and
rebooting
> both machines, I get "SQL Server does not exist or access denied".
> I can ping each machine from the other getting the new ip numbers, I can
see
> the machines from each other via NetBios.
> Is there something else that needs to be done?
> Paul@.CommerceStreet.com
|||running cliconfg.exe and changing the IP Number seems to have fixed the
problem. Thanks!
PF
"oj" wrote:
> Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
> for this info.
> You also want to run cliconfg.exe to see if you have your Sharepoint
> pointing to the correct server/IP.
>
> "Paul@.CommerceStreet.com"
> <Paul@.CommerceStreet.com@.discussions.microsoft.com > wrote in message
> news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> 2000
> rebooting
> see
>
>
Changing IP Number on SQL 2000 Std
I am changing the IP Number on a Win 2003 Enterprise Server running SQL 2000
Std. This SQL servert is accessed by a second machine running a SharePoint
web site.
After changing the numbers to the new network on both machines and rebooting
both machines, I get "SQL Server does not exist or access denied".
I can ping each machine from the other getting the new ip numbers, I can see
the machines from each other via NetBios.
Is there something else that needs to be done?
Paul@.CommerceStreet.comDoes sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
for this info.
You also want to run cliconfg.exe to see if you have your Sharepoint
pointing to the correct server/IP.
"Paul@.CommerceStreet.com"
<Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> I am changing the IP Number on a Win 2003 Enterprise Server running SQL
2000
> Std. This SQL servert is accessed by a second machine running a SharePoint
> web site.
> After changing the numbers to the new network on both machines and
rebooting
> both machines, I get "SQL Server does not exist or access denied".
> I can ping each machine from the other getting the new ip numbers, I can
see
> the machines from each other via NetBios.
> Is there something else that needs to be done?
> Paul@.CommerceStreet.com|||running cliconfg.exe and changing the IP Number seems to have fixed the
problem. Thanks!
PF
"oj" wrote:
> Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORL
OG
> for this info.
> You also want to run cliconfg.exe to see if you have your Sharepoint
> pointing to the correct server/IP.
>
> "Paul@.CommerceStreet.com"
> <Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
> news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> 2000
> rebooting
> see
>
>
Std. This SQL servert is accessed by a second machine running a SharePoint
web site.
After changing the numbers to the new network on both machines and rebooting
both machines, I get "SQL Server does not exist or access denied".
I can ping each machine from the other getting the new ip numbers, I can see
the machines from each other via NetBios.
Is there something else that needs to be done?
Paul@.CommerceStreet.comDoes sqlserver listen on the new ip. Take a quick look at sqlserver ERRORLOG
for this info.
You also want to run cliconfg.exe to see if you have your Sharepoint
pointing to the correct server/IP.
"Paul@.CommerceStreet.com"
<Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> I am changing the IP Number on a Win 2003 Enterprise Server running SQL
2000
> Std. This SQL servert is accessed by a second machine running a SharePoint
> web site.
> After changing the numbers to the new network on both machines and
rebooting
> both machines, I get "SQL Server does not exist or access denied".
> I can ping each machine from the other getting the new ip numbers, I can
see
> the machines from each other via NetBios.
> Is there something else that needs to be done?
> Paul@.CommerceStreet.com|||running cliconfg.exe and changing the IP Number seems to have fixed the
problem. Thanks!
PF
"oj" wrote:
> Does sqlserver listen on the new ip. Take a quick look at sqlserver ERRORL
OG
> for this info.
> You also want to run cliconfg.exe to see if you have your Sharepoint
> pointing to the correct server/IP.
>
> "Paul@.CommerceStreet.com"
> <Paul@.CommerceStreet.com@.discussions.microsoft.com> wrote in message
> news:16E6AD58-39D6-4798-A194-6BBF8790A227@.microsoft.com...
> 2000
> rebooting
> see
>
>
Tuesday, February 14, 2012
Changing default local server
Hi!
How can i change default assignment of local SQL server instance.
I have two instances installed on my computer, one - SQL personal 2000,
second - SQL developer 2000. I have to install Reporting Services on SQL
Developer, but first, i need to install Service Pack 3a on SQL Delveoper. Th
e
default instance of SQL server is - Personal (I see it as (local) in
enterprise manager). Even, if I'll stop SQL Personal server, I still would
not be able to install Reporting Services on SQL Developer. I always get
error - SQL Server Service Pack 3a not installed.
Please, tell me, how can I solve this problem !
Thanks!
Igor.Igor,
Why not install SP3a on each SQL Server? Or better yet SP4. For greater
control over the RS installation see the 'Installing Reporting Services from
the Command Line' topic in the Reporting Services Books Online. Also be
sure to download the latest version of RS BOL at
http://www.microsoft.com/downloads/...&DisplayLang=en
HTH
Jerry
"Igor" <Igor@.discussions.microsoft.com> wrote in message
news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
> Hi!
> How can i change default assignment of local SQL server instance.
> I have two instances installed on my computer, one - SQL personal 2000,
> second - SQL developer 2000. I have to install Reporting Services on SQL
> Developer, but first, i need to install Service Pack 3a on SQL Delveoper.
> The
> default instance of SQL server is - Personal (I see it as (local) in
> enterprise manager). Even, if I'll stop SQL Personal server, I still would
> not be able to install Reporting Services on SQL Developer. I always get
> error - SQL Server Service Pack 3a not installed.
> Please, tell me, how can I solve this problem !
> Thanks!
> Igor.|||There is a problem. I do not know how to force to install Service Pack for
the SQL Developer server.
The problem is that the SQL Personal already was installed in computer, and
the SQL Developer has been installed additionaly. For Example, the instance
of SQL Personal is "SQLSRV1" (the same as computer name), in enterprise
manager i see it as (local), and instance of SQL Developer server is
"SQLSRV1\NEW_DEV". Here is a problem ! The Service pack takes only SQL
Personal server and do not see SQL Developer, even if I'll stop SQL Personal
server and SQL Developer is running.
The question is: how to force Service Pack to be installed on SQL Developer
server in this configuration.
I already install Reporting services on other computers with one instance of
SQL server and it works perfectly !
Is there any way to solve this ?
Thanks!
Igor.
"Jerry Spivey" wrote:
> Igor,
> Why not install SP3a on each SQL Server? Or better yet SP4. For greater
> control over the RS installation see the 'Installing Reporting Services fr
om
> the Command Line' topic in the Reporting Services Books Online. Also be
> sure to download the latest version of RS BOL at
> http://www.microsoft.com/downloads/...&DisplayLang=en
> HTH
> Jerry
> "Igor" <Igor@.discussions.microsoft.com> wrote in message
> news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
>
>
How can i change default assignment of local SQL server instance.
I have two instances installed on my computer, one - SQL personal 2000,
second - SQL developer 2000. I have to install Reporting Services on SQL
Developer, but first, i need to install Service Pack 3a on SQL Delveoper. Th
e
default instance of SQL server is - Personal (I see it as (local) in
enterprise manager). Even, if I'll stop SQL Personal server, I still would
not be able to install Reporting Services on SQL Developer. I always get
error - SQL Server Service Pack 3a not installed.
Please, tell me, how can I solve this problem !
Thanks!
Igor.Igor,
Why not install SP3a on each SQL Server? Or better yet SP4. For greater
control over the RS installation see the 'Installing Reporting Services from
the Command Line' topic in the Reporting Services Books Online. Also be
sure to download the latest version of RS BOL at
http://www.microsoft.com/downloads/...&DisplayLang=en
HTH
Jerry
"Igor" <Igor@.discussions.microsoft.com> wrote in message
news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
> Hi!
> How can i change default assignment of local SQL server instance.
> I have two instances installed on my computer, one - SQL personal 2000,
> second - SQL developer 2000. I have to install Reporting Services on SQL
> Developer, but first, i need to install Service Pack 3a on SQL Delveoper.
> The
> default instance of SQL server is - Personal (I see it as (local) in
> enterprise manager). Even, if I'll stop SQL Personal server, I still would
> not be able to install Reporting Services on SQL Developer. I always get
> error - SQL Server Service Pack 3a not installed.
> Please, tell me, how can I solve this problem !
> Thanks!
> Igor.|||There is a problem. I do not know how to force to install Service Pack for
the SQL Developer server.
The problem is that the SQL Personal already was installed in computer, and
the SQL Developer has been installed additionaly. For Example, the instance
of SQL Personal is "SQLSRV1" (the same as computer name), in enterprise
manager i see it as (local), and instance of SQL Developer server is
"SQLSRV1\NEW_DEV". Here is a problem ! The Service pack takes only SQL
Personal server and do not see SQL Developer, even if I'll stop SQL Personal
server and SQL Developer is running.
The question is: how to force Service Pack to be installed on SQL Developer
server in this configuration.
I already install Reporting services on other computers with one instance of
SQL server and it works perfectly !
Is there any way to solve this ?
Thanks!
Igor.
"Jerry Spivey" wrote:
> Igor,
> Why not install SP3a on each SQL Server? Or better yet SP4. For greater
> control over the RS installation see the 'Installing Reporting Services fr
om
> the Command Line' topic in the Reporting Services Books Online. Also be
> sure to download the latest version of RS BOL at
> http://www.microsoft.com/downloads/...&DisplayLang=en
> HTH
> Jerry
> "Igor" <Igor@.discussions.microsoft.com> wrote in message
> news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
>
>
Changing default local server
Hi!
How can i change default assignment of local SQL server instance.
I have two instances installed on my computer, one - SQL personal 2000,
second - SQL developer 2000. I have to install Reporting Services on SQL
Developer, but first, i need to install Service Pack 3a on SQL Delveoper. The
default instance of SQL server is - Personal (I see it as (local) in
enterprise manager). Even, if I'll stop SQL Personal server, I still would
not be able to install Reporting Services on SQL Developer. I always get
error - SQL Server Service Pack 3a not installed.
Please, tell me, how can I solve this problem !
Thanks!
Igor.
Igor,
Why not install SP3a on each SQL Server? Or better yet SP4. For greater
control over the RS installation see the 'Installing Reporting Services from
the Command Line' topic in the Reporting Services Books Online. Also be
sure to download the latest version of RS BOL at
http://www.microsoft.com/downloads/d...DisplayLang=en
HTH
Jerry
"Igor" <Igor@.discussions.microsoft.com> wrote in message
news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
> Hi!
> How can i change default assignment of local SQL server instance.
> I have two instances installed on my computer, one - SQL personal 2000,
> second - SQL developer 2000. I have to install Reporting Services on SQL
> Developer, but first, i need to install Service Pack 3a on SQL Delveoper.
> The
> default instance of SQL server is - Personal (I see it as (local) in
> enterprise manager). Even, if I'll stop SQL Personal server, I still would
> not be able to install Reporting Services on SQL Developer. I always get
> error - SQL Server Service Pack 3a not installed.
> Please, tell me, how can I solve this problem !
> Thanks!
> Igor.
|||There is a problem. I do not know how to force to install Service Pack for
the SQL Developer server.
The problem is that the SQL Personal already was installed in computer, and
the SQL Developer has been installed additionaly. For Example, the instance
of SQL Personal is "SQLSRV1" (the same as computer name), in enterprise
manager i see it as (local), and instance of SQL Developer server is
"SQLSRV1\NEW_DEV". Here is a problem ! The Service pack takes only SQL
Personal server and do not see SQL Developer, even if I'll stop SQL Personal
server and SQL Developer is running.
The question is: how to force Service Pack to be installed on SQL Developer
server in this configuration.
I already install Reporting services on other computers with one instance of
SQL server and it works perfectly !
Is there any way to solve this ?
Thanks!
Igor.
"Jerry Spivey" wrote:
> Igor,
> Why not install SP3a on each SQL Server? Or better yet SP4. For greater
> control over the RS installation see the 'Installing Reporting Services from
> the Command Line' topic in the Reporting Services Books Online. Also be
> sure to download the latest version of RS BOL at
> http://www.microsoft.com/downloads/d...DisplayLang=en
> HTH
> Jerry
> "Igor" <Igor@.discussions.microsoft.com> wrote in message
> news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
>
>
How can i change default assignment of local SQL server instance.
I have two instances installed on my computer, one - SQL personal 2000,
second - SQL developer 2000. I have to install Reporting Services on SQL
Developer, but first, i need to install Service Pack 3a on SQL Delveoper. The
default instance of SQL server is - Personal (I see it as (local) in
enterprise manager). Even, if I'll stop SQL Personal server, I still would
not be able to install Reporting Services on SQL Developer. I always get
error - SQL Server Service Pack 3a not installed.
Please, tell me, how can I solve this problem !
Thanks!
Igor.
Igor,
Why not install SP3a on each SQL Server? Or better yet SP4. For greater
control over the RS installation see the 'Installing Reporting Services from
the Command Line' topic in the Reporting Services Books Online. Also be
sure to download the latest version of RS BOL at
http://www.microsoft.com/downloads/d...DisplayLang=en
HTH
Jerry
"Igor" <Igor@.discussions.microsoft.com> wrote in message
news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
> Hi!
> How can i change default assignment of local SQL server instance.
> I have two instances installed on my computer, one - SQL personal 2000,
> second - SQL developer 2000. I have to install Reporting Services on SQL
> Developer, but first, i need to install Service Pack 3a on SQL Delveoper.
> The
> default instance of SQL server is - Personal (I see it as (local) in
> enterprise manager). Even, if I'll stop SQL Personal server, I still would
> not be able to install Reporting Services on SQL Developer. I always get
> error - SQL Server Service Pack 3a not installed.
> Please, tell me, how can I solve this problem !
> Thanks!
> Igor.
|||There is a problem. I do not know how to force to install Service Pack for
the SQL Developer server.
The problem is that the SQL Personal already was installed in computer, and
the SQL Developer has been installed additionaly. For Example, the instance
of SQL Personal is "SQLSRV1" (the same as computer name), in enterprise
manager i see it as (local), and instance of SQL Developer server is
"SQLSRV1\NEW_DEV". Here is a problem ! The Service pack takes only SQL
Personal server and do not see SQL Developer, even if I'll stop SQL Personal
server and SQL Developer is running.
The question is: how to force Service Pack to be installed on SQL Developer
server in this configuration.
I already install Reporting services on other computers with one instance of
SQL server and it works perfectly !
Is there any way to solve this ?
Thanks!
Igor.
"Jerry Spivey" wrote:
> Igor,
> Why not install SP3a on each SQL Server? Or better yet SP4. For greater
> control over the RS installation see the 'Installing Reporting Services from
> the Command Line' topic in the Reporting Services Books Online. Also be
> sure to download the latest version of RS BOL at
> http://www.microsoft.com/downloads/d...DisplayLang=en
> HTH
> Jerry
> "Igor" <Igor@.discussions.microsoft.com> wrote in message
> news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
>
>
Changing default local server
Hi!
How can i change default assignment of local SQL server instance.
I have two instances installed on my computer, one - SQL personal 2000,
second - SQL developer 2000. I have to install Reporting Services on SQL
Developer, but first, i need to install Service Pack 3a on SQL Delveoper. The
default instance of SQL server is - Personal (I see it as (local) in
enterprise manager). Even, if I'll stop SQL Personal server, I still would
not be able to install Reporting Services on SQL Developer. I always get
error - SQL Server Service Pack 3a not installed.
Please, tell me, how can I solve this problem !
Thanks!
Igor.Igor,
Why not install SP3a on each SQL Server? Or better yet SP4. For greater
control over the RS installation see the 'Installing Reporting Services from
the Command Line' topic in the Reporting Services Books Online. Also be
sure to download the latest version of RS BOL at
http://www.microsoft.com/downloads/details.aspx?FamilyID=5e550d73-8f35-435e-bb71-c8573a1cdbdb&DisplayLang=en
HTH
Jerry
"Igor" <Igor@.discussions.microsoft.com> wrote in message
news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
> Hi!
> How can i change default assignment of local SQL server instance.
> I have two instances installed on my computer, one - SQL personal 2000,
> second - SQL developer 2000. I have to install Reporting Services on SQL
> Developer, but first, i need to install Service Pack 3a on SQL Delveoper.
> The
> default instance of SQL server is - Personal (I see it as (local) in
> enterprise manager). Even, if I'll stop SQL Personal server, I still would
> not be able to install Reporting Services on SQL Developer. I always get
> error - SQL Server Service Pack 3a not installed.
> Please, tell me, how can I solve this problem !
> Thanks!
> Igor.|||There is a problem. I do not know how to force to install Service Pack for
the SQL Developer server.
The problem is that the SQL Personal already was installed in computer, and
the SQL Developer has been installed additionaly. For Example, the instance
of SQL Personal is "SQLSRV1" (the same as computer name), in enterprise
manager i see it as (local), and instance of SQL Developer server is
"SQLSRV1\NEW_DEV". Here is a problem ! The Service pack takes only SQL
Personal server and do not see SQL Developer, even if I'll stop SQL Personal
server and SQL Developer is running.
The question is: how to force Service Pack to be installed on SQL Developer
server in this configuration.
I already install Reporting services on other computers with one instance of
SQL server and it works perfectly !
Is there any way to solve this ?
Thanks!
Igor.
"Jerry Spivey" wrote:
> Igor,
> Why not install SP3a on each SQL Server? Or better yet SP4. For greater
> control over the RS installation see the 'Installing Reporting Services from
> the Command Line' topic in the Reporting Services Books Online. Also be
> sure to download the latest version of RS BOL at
> http://www.microsoft.com/downloads/details.aspx?FamilyID=5e550d73-8f35-435e-bb71-c8573a1cdbdb&DisplayLang=en
> HTH
> Jerry
> "Igor" <Igor@.discussions.microsoft.com> wrote in message
> news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
> > Hi!
> >
> > How can i change default assignment of local SQL server instance.
> >
> > I have two instances installed on my computer, one - SQL personal 2000,
> > second - SQL developer 2000. I have to install Reporting Services on SQL
> > Developer, but first, i need to install Service Pack 3a on SQL Delveoper.
> > The
> > default instance of SQL server is - Personal (I see it as (local) in
> > enterprise manager). Even, if I'll stop SQL Personal server, I still would
> > not be able to install Reporting Services on SQL Developer. I always get
> > error - SQL Server Service Pack 3a not installed.
> >
> > Please, tell me, how can I solve this problem !
> >
> > Thanks!
> > Igor.
>
>
How can i change default assignment of local SQL server instance.
I have two instances installed on my computer, one - SQL personal 2000,
second - SQL developer 2000. I have to install Reporting Services on SQL
Developer, but first, i need to install Service Pack 3a on SQL Delveoper. The
default instance of SQL server is - Personal (I see it as (local) in
enterprise manager). Even, if I'll stop SQL Personal server, I still would
not be able to install Reporting Services on SQL Developer. I always get
error - SQL Server Service Pack 3a not installed.
Please, tell me, how can I solve this problem !
Thanks!
Igor.Igor,
Why not install SP3a on each SQL Server? Or better yet SP4. For greater
control over the RS installation see the 'Installing Reporting Services from
the Command Line' topic in the Reporting Services Books Online. Also be
sure to download the latest version of RS BOL at
http://www.microsoft.com/downloads/details.aspx?FamilyID=5e550d73-8f35-435e-bb71-c8573a1cdbdb&DisplayLang=en
HTH
Jerry
"Igor" <Igor@.discussions.microsoft.com> wrote in message
news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
> Hi!
> How can i change default assignment of local SQL server instance.
> I have two instances installed on my computer, one - SQL personal 2000,
> second - SQL developer 2000. I have to install Reporting Services on SQL
> Developer, but first, i need to install Service Pack 3a on SQL Delveoper.
> The
> default instance of SQL server is - Personal (I see it as (local) in
> enterprise manager). Even, if I'll stop SQL Personal server, I still would
> not be able to install Reporting Services on SQL Developer. I always get
> error - SQL Server Service Pack 3a not installed.
> Please, tell me, how can I solve this problem !
> Thanks!
> Igor.|||There is a problem. I do not know how to force to install Service Pack for
the SQL Developer server.
The problem is that the SQL Personal already was installed in computer, and
the SQL Developer has been installed additionaly. For Example, the instance
of SQL Personal is "SQLSRV1" (the same as computer name), in enterprise
manager i see it as (local), and instance of SQL Developer server is
"SQLSRV1\NEW_DEV". Here is a problem ! The Service pack takes only SQL
Personal server and do not see SQL Developer, even if I'll stop SQL Personal
server and SQL Developer is running.
The question is: how to force Service Pack to be installed on SQL Developer
server in this configuration.
I already install Reporting services on other computers with one instance of
SQL server and it works perfectly !
Is there any way to solve this ?
Thanks!
Igor.
"Jerry Spivey" wrote:
> Igor,
> Why not install SP3a on each SQL Server? Or better yet SP4. For greater
> control over the RS installation see the 'Installing Reporting Services from
> the Command Line' topic in the Reporting Services Books Online. Also be
> sure to download the latest version of RS BOL at
> http://www.microsoft.com/downloads/details.aspx?FamilyID=5e550d73-8f35-435e-bb71-c8573a1cdbdb&DisplayLang=en
> HTH
> Jerry
> "Igor" <Igor@.discussions.microsoft.com> wrote in message
> news:E7B65CD3-64FF-4E84-9D6B-003F98E4EFAD@.microsoft.com...
> > Hi!
> >
> > How can i change default assignment of local SQL server instance.
> >
> > I have two instances installed on my computer, one - SQL personal 2000,
> > second - SQL developer 2000. I have to install Reporting Services on SQL
> > Developer, but first, i need to install Service Pack 3a on SQL Delveoper.
> > The
> > default instance of SQL server is - Personal (I see it as (local) in
> > enterprise manager). Even, if I'll stop SQL Personal server, I still would
> > not be able to install Reporting Services on SQL Developer. I always get
> > error - SQL Server Service Pack 3a not installed.
> >
> > Please, tell me, how can I solve this problem !
> >
> > Thanks!
> > Igor.
>
>
Subscribe to:
Posts (Atom)