Hi,
I have a sql server 7 running on a machine with two disk partitions (D: and E:).
The data files xxx.mdf and xxx.ldf are stored in D:, which has very few space available. I want to copy these files to E: but I get an error saying that it is not possible to change the source file of a database. Is it possible to do it or do i have to create another data file in E: and keep the old one in D:?
Thanks in advance,
browsersp_detach_db + sp_attach_db ... with (...)|||detach the database ... copy to new location ... then attach
or
backup the database ... restore ... sp_renamedb|||thanks ms_sql_dba and Enigma, it worked properly!sql
Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts
Thursday, March 22, 2012
Saturday, February 25, 2012
Changing number of per processor licenses
I want to change the number of licenses from 2 to 1 so I can use one license
on another machine. To accomplish this, do I need to physically remove the
CPU or I can unselect 1 processor from the Processor Tab of properties sheet
.You would violate license agreement by only unselecting one processor from E
M's config dialog. The
license terms states you need one proc license per processor that the OS can
use. So either disable
one processor in BIOS (if possible) or remove it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:0768CDED-D7D6-4E3F-8450-25B56D297A64@.microsoft.com...[vbcol=seagreen]
>I want to change the number of licenses from 2 to 1 so I can use one licens
e
> on another machine. To accomplish this, do I need to physically remove the
> CPU or I can unselect 1 processor from the Processor Tab of properties sheet.[/vbc
ol]
on another machine. To accomplish this, do I need to physically remove the
CPU or I can unselect 1 processor from the Processor Tab of properties sheet
.You would violate license agreement by only unselecting one processor from E
M's config dialog. The
license terms states you need one proc license per processor that the OS can
use. So either disable
one processor in BIOS (if possible) or remove it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:0768CDED-D7D6-4E3F-8450-25B56D297A64@.microsoft.com...[vbcol=seagreen]
>I want to change the number of licenses from 2 to 1 so I can use one licens
e
> on another machine. To accomplish this, do I need to physically remove the
> CPU or I can unselect 1 processor from the Processor Tab of properties sheet.[/vbc
ol]
Changing number of per processor licenses
I want to change the number of licenses from 2 to 1 so I can use one license
on another machine. To accomplish this, do I need to physically remove the
CPU or I can unselect 1 processor from the Processor Tab of properties sheet.
You would violate license agreement by only unselecting one processor from EM's config dialog. The
license terms states you need one proc license per processor that the OS can use. So either disable
one processor in BIOS (if possible) or remove it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:0768CDED-D7D6-4E3F-8450-25B56D297A64@.microsoft.com...
>I want to change the number of licenses from 2 to 1 so I can use one license
> on another machine. To accomplish this, do I need to physically remove the
> CPU or I can unselect 1 processor from the Processor Tab of properties sheet.
on another machine. To accomplish this, do I need to physically remove the
CPU or I can unselect 1 processor from the Processor Tab of properties sheet.
You would violate license agreement by only unselecting one processor from EM's config dialog. The
license terms states you need one proc license per processor that the OS can use. So either disable
one processor in BIOS (if possible) or remove it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:0768CDED-D7D6-4E3F-8450-25B56D297A64@.microsoft.com...
>I want to change the number of licenses from 2 to 1 so I can use one license
> on another machine. To accomplish this, do I need to physically remove the
> CPU or I can unselect 1 processor from the Processor Tab of properties sheet.
Changing number of per processor licenses
I want to change the number of licenses from 2 to 1 so I can use one license
on another machine. To accomplish this, do I need to physically remove the
CPU or I can unselect 1 processor from the Processor Tab of properties sheet.You would violate license agreement by only unselecting one processor from EM's config dialog. The
license terms states you need one proc license per processor that the OS can use. So either disable
one processor in BIOS (if possible) or remove it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:0768CDED-D7D6-4E3F-8450-25B56D297A64@.microsoft.com...
>I want to change the number of licenses from 2 to 1 so I can use one license
> on another machine. To accomplish this, do I need to physically remove the
> CPU or I can unselect 1 processor from the Processor Tab of properties sheet.
on another machine. To accomplish this, do I need to physically remove the
CPU or I can unselect 1 processor from the Processor Tab of properties sheet.You would violate license agreement by only unselecting one processor from EM's config dialog. The
license terms states you need one proc license per processor that the OS can use. So either disable
one processor in BIOS (if possible) or remove it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:0768CDED-D7D6-4E3F-8450-25B56D297A64@.microsoft.com...
>I want to change the number of licenses from 2 to 1 so I can use one license
> on another machine. To accomplish this, do I need to physically remove the
> CPU or I can unselect 1 processor from the Processor Tab of properties sheet.
Changing name of machine running MSDE - ISSUE??
As part of a data center migration, I am going to be changing the name of
several servers that are running MSDE. Does MSDE have the same issues with
changing the name of the system it runs on as SQL Server does?
thanks,
Jason
hi Jason,
Jason wrote:
> As part of a data center migration, I am going to be changing the
> name of several servers that are running MSDE. Does MSDE have the
> same issues with changing the name of the system it runs on as SQL
> Server does?
>
yes
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
several servers that are running MSDE. Does MSDE have the same issues with
changing the name of the system it runs on as SQL Server does?
thanks,
Jason
hi Jason,
Jason wrote:
> As part of a data center migration, I am going to be changing the
> name of several servers that are running MSDE. Does MSDE have the
> same issues with changing the name of the system it runs on as SQL
> Server does?
>
yes
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Friday, February 24, 2012
Changing Machine Names MSDE
I have a local install of MSDE on my workstation. I have also defined a
linked server with another SQL Server on our network. I accepted all the
defaults when I installed MSDE and the server got named my machine name.
Everything is working great.
linked server with another SQL Server on our network. I accepted all the
defaults when I installed MSDE and the server got named my machine name.
Everything is working great.
Our IT department now needs to change my machine name. What effect will
this have on my current SQL installation?
Help and suggestions appreciated.
Thanks,
Frank
*** Sent via Developersdex http://www.developersdex.com ***Frank Bishop (fbishop@.viper.com) writes:
> I have a local install of MSDE on my workstation. I have also defined a
> linked server with another SQL Server on our network. I accepted all the
> defaults when I installed MSDE and the server got named my machine name.
> Everything is working great.
> Our IT department now needs to change my machine name. What effect will
> this have on my current SQL installation?
If memory serves, the server name changes automatically. However,
@.@.servername usually gets messed up.
To this end to:
exec sp_dropserver 'oldname'
exec sp_addserver 'newname', 'local'
Then stop and restart SQL Server.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Changing machine name & IP number on SQL Server 7.
Hi all!
We run a NT4 server machine running SQL 7 which contains some vital data on older databases. This machine was PDC for a long time, untill we got a new win2k server, which got the same machine name and IP number as the old NT4 machine which isn't yet connected to the AD. This new server does SQL 2000.
Since it's still important for us to have access to the SQL 7 data which cannot be used on SQL2000 server, I want to put the NT4 machine in the Win2k domain, but when I change the server's name and IP adress into something free (machine name and IP number are both taken over by new server) the SQL 7 server won't start anymore.
Is there anyone out there that knows how to solve this problem?
Thanks!!!! A LOT! :D :DI think you can run SQL 7 on the same machine as SQL 2000 and they won't bump into eachother.
blindman|||You can have SQL 2000 and one of the previous versions on the same machine. See if you want to do this. If not, see if the following article resolves your issues.
http://www.databasejournal.com/features/mssql/print.php/10894_2194711_3
All the best
We run a NT4 server machine running SQL 7 which contains some vital data on older databases. This machine was PDC for a long time, untill we got a new win2k server, which got the same machine name and IP number as the old NT4 machine which isn't yet connected to the AD. This new server does SQL 2000.
Since it's still important for us to have access to the SQL 7 data which cannot be used on SQL2000 server, I want to put the NT4 machine in the Win2k domain, but when I change the server's name and IP adress into something free (machine name and IP number are both taken over by new server) the SQL 7 server won't start anymore.
Is there anyone out there that knows how to solve this problem?
Thanks!!!! A LOT! :D :DI think you can run SQL 7 on the same machine as SQL 2000 and they won't bump into eachother.
blindman|||You can have SQL 2000 and one of the previous versions on the same machine. See if you want to do this. If not, see if the following article resolves your issues.
http://www.databasejournal.com/features/mssql/print.php/10894_2194711_3
All the best
Changing machine name
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?|||cheers for the link, quite a few handy wee tips in there!
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> if i change the actual machine name of my SQL Server, it will not allow me
> into SQL Server. is there a way around this? apart from not changin the
> machine name?
>
>|||And a few more here :-)
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message news:%23fJPJ13iEHA.3288@.TK2MSFTN
GP10.phx.gbl...
> cheers for the link, quite a few handy wee tips in there!
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
>
into SQL Server. is there a way around this? apart from not changin the
machine name?See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?|||cheers for the link, quite a few handy wee tips in there!
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> if i change the actual machine name of my SQL Server, it will not allow me
> into SQL Server. is there a way around this? apart from not changin the
> machine name?
>
>|||And a few more here :-)
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message news:%23fJPJ13iEHA.3288@.TK2MSFTN
GP10.phx.gbl...
> cheers for the link, quite a few handy wee tips in there!
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
>
Changing Machine Name
Quick question. We already have SQL 2000 running on a machine on which we need to change the machine name. Will this cause a problem with the inner workings of SQL Server? Will it have to be reinstalled or is there a stored procedure available to make the change in SQL server (if necessary)?you will have to run
sp_dropserver <old_name>
go
sp_addserver <new_name>
Also, if you have created jobs under the old name you will have to rename the originating server (in sysjobs in MSDB) or you will not be able to edit them.
HTH|||Originally posted by rhigdon
you will have to run
sp_dropserver <old_name>
go
sp_addserver <new_name>
Also, if you have created jobs under the old name you will have to rename the originating server (in sysjobs in MSDB) or you will not be able to edit them.
HTH
Thanks, Ray. This is good information!
sp_dropserver <old_name>
go
sp_addserver <new_name>
Also, if you have created jobs under the old name you will have to rename the originating server (in sysjobs in MSDB) or you will not be able to edit them.
HTH|||Originally posted by rhigdon
you will have to run
sp_dropserver <old_name>
go
sp_addserver <new_name>
Also, if you have created jobs under the old name you will have to rename the originating server (in sysjobs in MSDB) or you will not be able to edit them.
HTH
Thanks, Ray. This is good information!
Changing machine name
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?
See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?
|||cheers for the link, quite a few handy wee tips in there!
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> if i change the actual machine name of my SQL Server, it will not allow me
> into SQL Server. is there a way around this? apart from not changin the
> machine name?
>
>
|||And a few more here :-)
http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message news:%23fJPJ13iEHA.3288@.TK2MSFTNGP10.phx.gbl...
> cheers for the link, quite a few handy wee tips in there!
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
>
into SQL Server. is there a way around this? apart from not changin the
machine name?
See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?
|||cheers for the link, quite a few handy wee tips in there!
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> if i change the actual machine name of my SQL Server, it will not allow me
> into SQL Server. is there a way around this? apart from not changin the
> machine name?
>
>
|||And a few more here :-)
http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message news:%23fJPJ13iEHA.3288@.TK2MSFTNGP10.phx.gbl...
> cheers for the link, quite a few handy wee tips in there!
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
>
Changing machine name
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?|||cheers for the link, quite a few handy wee tips in there!
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> if i change the actual machine name of my SQL Server, it will not allow me
> into SQL Server. is there a way around this? apart from not changin the
> machine name?
>
>|||And a few more here :-)
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message news:%23fJPJ13iEHA.3288@.TK2MSFTNGP10.phx.gbl...
> cheers for the link, quite a few handy wee tips in there!
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> > See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> > news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> >
> > if i change the actual machine name of my SQL Server, it will not allow me
> > into SQL Server. is there a way around this? apart from not changin the
> > machine name?
> >
> >
> >
>
into SQL Server. is there a way around this? apart from not changin the
machine name?See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?|||cheers for the link, quite a few handy wee tips in there!
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> if i change the actual machine name of my SQL Server, it will not allow me
> into SQL Server. is there a way around this? apart from not changin the
> machine name?
>
>|||And a few more here :-)
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message news:%23fJPJ13iEHA.3288@.TK2MSFTNGP10.phx.gbl...
> cheers for the link, quite a few handy wee tips in there!
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> > See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> > news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> >
> > if i change the actual machine name of my SQL Server, it will not allow me
> > into SQL Server. is there a way around this? apart from not changin the
> > machine name?
> >
> >
> >
>
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.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
>
>
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
>
>
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
>
>
Sunday, February 12, 2012
changing database owner to access diagrams
hello,
i recently changed the machine name of my development computer and am now no longer able to create or view any diagrams for the sql database that was created by the old machine name user. i receive an error where I cannot make myself "the dbo of this database." i can see the old name in the "owner" properties field of the mdf database, but the box is grayed out and i am unable to change it to the new machine/user name. is there a way to change the owner of the database to my new machine/user name? the new name has admin rights and the computer is a standalone workstation not connected to a network.
i am using sql server 2005 express edition with visual web developer.
thanks!
Hi,
you can achieve this by sp_changedbowner store procedure refer ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/516ef311-e83b-45c9-b9cd-0e0641774c04.htm in SQL BOL.
Hemantgiri S. Goswami
|||thank you for the response. unfortunately, i am new to sql and do not know where or how to use this command. do i use VWD? Sql Server Management Studio Express does not allow me to navigate to the directory where the database resides. also, one additional piece of information: only the machine name changed.
old name: "old_machine_name/steve"
new name: "new_machine_name/steve"
which EXEC command should I use to change ownership of the database to the new name?
EXEC sp_changedbowner 'new_machine_name/steve'
or simply,
EXEC sp_changedbowner 'steve'
i am concerned that there is a larger problem with permissions and sql. anytime I add a new website and new database in VWD, the default "owner" field comes up with the old name, "old_machine_name/steve". how do I change this default so that all future databases and web sites have the new owner, "new_machine_name/steve"?
thanks!
|||Hi,
When you rename your Server name it will reflect to your SQL Server too, your sql server's name also change refer http://blog.opsan.com/archive/2005/05/10/465.aspx for more. If you wants to change the DB Owner Open
SQL Server Management Studio -> connect -> Click on New Query -> run exec sp_changedbowner <schema> Refer http://weblogs.asp.net/dneimke/archive/2003/11/10/36691.aspx and http://weblogs.asp.net/eporter/archive/2004/10/29/249627.aspx for more on DB owner change.
Hemantgiri S. Goswami
|||ok i tried using Sql Server Management Studio Express but was unable to navigate into the "C:\Documents and Settings\Steve\My Documents\My Web Sites\WebSite1\AppData" user directory. even though Steve is a user with admin rights, the Add database window would not open any directories below the Steve directory. therefore, i was unable to even see the mdf file to open.
i tried copying the complete web site to a c:\temp directory and was able to navigate to the AppData directory and open the database. when I ran the sql command in a query window:
EXEC sp_changedbowner 'Steve'
i received the error:
"Cannot find the principal 'Steve', because it does not exist or you do not have permission."
I received the same error when using this command: EXEC sp_changedbowner 'new_machine_name/Steve'
i did try renaming the computer name back to the old_machine_name, rebooted, and was successfully able to open the Diagrams directory of the database in the user Steve directory. Although I find this very strange, i do not know why it fails when I simply change the computer name to new_machine_name. do you have any insight to this? it still seems that there is a default setting using the old_machine_name/Steve stored somewhere in VWD or SQL Server 2005 Express.
thanks!
|||Hi,
That is because of Schema refer Schema in BOL and below articles http://www.databasejournal.com/features/mssql/article.php/3481751 and http://www.sswug.org/see/SQL_Server_2005_-_Schema_Definition-19357
Hemantgiri S. Goswami
|||i finally gave up and called Microsoft. the root cause was not found, but the fix was to create a new user with admin rights, then move all the files over to the new user account. the new machine name is now recognized and i am able to access the diagrams folder for the database. i hope this helps others with similar user account issues.
thanks for your help!
changing database owner to access diagrams
hello,
i recently changed the machine name of my development computer and am now no longer able to create or view any diagrams for the sql database that was created by the old machine name user. i receive an error where I cannot make myself "the dbo of this database." i can see the old name in the "owner" properties field of the mdf database, but the box is grayed out and i am unable to change it to the new machine/user name. is there a way to change the owner of the database to my new machine/user name? the new name has admin rights and the computer is a standalone workstation not connected to a network.
i am using sql server 2005 express edition with visual web developer.
thanks!
Hi,
you can achieve this by sp_changedbowner store procedure refer ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/516ef311-e83b-45c9-b9cd-0e0641774c04.htm in SQL BOL.
Hemantgiri S. Goswami
|||thank you for the response. unfortunately, i am new to sql and do not know where or how to use this command. do i use VWD? Sql Server Management Studio Express does not allow me to navigate to the directory where the database resides. also, one additional piece of information: only the machine name changed.
old name: "old_machine_name/steve"
new name: "new_machine_name/steve"
which EXEC command should I use to change ownership of the database to the new name?
EXEC sp_changedbowner 'new_machine_name/steve'
or simply,
EXEC sp_changedbowner 'steve'
i am concerned that there is a larger problem with permissions and sql. anytime I add a new website and new database in VWD, the default "owner" field comes up with the old name, "old_machine_name/steve". how do I change this default so that all future databases and web sites have the new owner, "new_machine_name/steve"?
thanks!
|||Hi,
When you rename your Server name it will reflect to your SQL Server too, your sql server's name also change refer http://blog.opsan.com/archive/2005/05/10/465.aspx for more. If you wants to change the DB Owner Open
SQL Server Management Studio -> connect -> Click on New Query -> run exec sp_changedbowner <schema> Refer http://weblogs.asp.net/dneimke/archive/2003/11/10/36691.aspx and http://weblogs.asp.net/eporter/archive/2004/10/29/249627.aspx for more on DB owner change.
Hemantgiri S. Goswami
|||ok i tried using Sql Server Management Studio Express but was unable to navigate into the "C:\Documents and Settings\Steve\My Documents\My Web Sites\WebSite1\AppData" user directory. even though Steve is a user with admin rights, the Add database window would not open any directories below the Steve directory. therefore, i was unable to even see the mdf file to open.
i tried copying the complete web site to a c:\temp directory and was able to navigate to the AppData directory and open the database. when I ran the sql command in a query window:
EXEC sp_changedbowner 'Steve'
i received the error:
"Cannot find the principal 'Steve', because it does not exist or you do not have permission."
I received the same error when using this command: EXEC sp_changedbowner 'new_machine_name/Steve'
i did try renaming the computer name back to the old_machine_name, rebooted, and was successfully able to open the Diagrams directory of the database in the user Steve directory. Although I find this very strange, i do not know why it fails when I simply change the computer name to new_machine_name. do you have any insight to this? it still seems that there is a default setting using the old_machine_name/Steve stored somewhere in VWD or SQL Server 2005 Express.
thanks!
|||Hi,
That is because of Schema refer Schema in BOL and below articles http://www.databasejournal.com/features/mssql/article.php/3481751 and http://www.sswug.org/see/SQL_Server_2005_-_Schema_Definition-19357
Hemantgiri S. Goswami
|||i finally gave up and called Microsoft. the root cause was not found, but the fix was to create a new user with admin rights, then move all the files over to the new user account. the new machine name is now recognized and i am able to access the diagrams folder for the database. i hope this helps others with similar user account issues.
thanks for your help!
Subscribe to:
Posts (Atom)