Can not create new replication after changing server name

After i changed my computer's name(eg. the original computer name is 'SERVER-1',I has changed it to 'SERVER-2'),I can not create a new replication in SQL Server 2005.The error message :

New Publication Wizard
SQL Server is unable to connect to server 'SERVER-2'.

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'SERVER-1'. (Replication.Utilities)

What's wrong?
Should I reinstall SQL Server 2005?

Hi, microzt,

It's possible to rename machine name with SQL Server 2005 installed and have SQL Server 2005 works correctly with the new machine name, however, there are some extra steps need to be performed to accomplish this besides simply renamed the machine name in OS and it only works when you don't have replication enabled before the server renaming (i.e. no distributor is setup, no publications etc).

You need to update sys.servers system catalog view with the new machine name after you renamed the OS machine name:

This can also be done if you use dedicated Admin connection (sqlcmd -A) to update sys.servers (sqlserver need to be started in single user mode for the update to work, otherwise, you will hit error that system catalog view can not be updated manually)

C:\>sqlcmd -A
1> update sys.servers set name='SERVER-2'
2> go

(1 rows affected)
Warning: System table ID 43 has been updated directly in database ID 1 and cache coherence may not h
ave been maintained. SQL Server should be restarted.
1> exit

After you successfully updated sys.servers (or sysservers), replication can be enabled correctly on the renamed SQL Server instance.

Hope That helps.

Zhiqiang

|||

The other way of change server name in sys.servers catalog view is to use sp_dropserver and sp_addserver, for example:

sp_dropserver @.server='SERVER-1'
sp_addserver @.server='SERVER-2', @.local='LOCAL'

Then restart SQL Server service and replication should work fine.

|||Thank you for your help!
The replication work fine now.

Can not create a database in VS.Net using SQL

I am taking a course in ASP.Net at Finger Lakes Community
College. I am trying to create a database in VS.Net using
SQL. In the computer lab we have the class in I can
create a database in VS.Net using SQL. In the open lab
and at home on my P.C. I have VS.Net and SQL Server 2000
loaded. Every is the same BUT I cannot create a database
using SQL on my P.C. or in the open lab. I am set up as
the administrator and have all the rights I need to creat
a database. The permissions are the same from one lab to
the other and on my P.C. and the server is on. My System
Admininstrator and Teacher are just as confused as I am.
We need to resolve this issue before the start of the
fall semester. Does anyne have an idea on why this is
happening?Please be a bit more clear as to what is happening. How are you trying to
create the database? What error are you getting when you try?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> I am taking a course in ASP.Net at Finger Lakes Community
> College. I am trying to create a database in VS.Net using
> SQL. In the computer lab we have the class in I can
> create a database in VS.Net using SQL. In the open lab
> and at home on my P.C. I have VS.Net and SQL Server 2000
> loaded. Every is the same BUT I cannot create a database
> using SQL on my P.C. or in the open lab. I am set up as
> the administrator and have all the rights I need to creat
> a database. The permissions are the same from one lab to
> the other and on my P.C. and the server is on. My System
> Admininstrator and Teacher are just as confused as I am.
> We need to resolve this issue before the start of the
> fall semester. Does anyne have an idea on why this is
> happening?|||I start VS.Net and open a new project for ASP.Net. I then
go to Server Explorer and right click on Data Connections
and select Create a new SQL Database. In the window where
you enter the server I type in the local server's name
and then type in the name of the database I want to
create. It may take a moment or two but I'll get an error
message stating "Can not create a databse on this
server". when I check the permissions in Enterprise
Manager I see that all the permissions are set for me to
e able to create a database.
>--Original Message--
>Please be a bit more clear as to what is happening. How
are you trying to
>create the database? What error are you getting when you
try?
>--
>Andrew C. Madsen
>Information Architect
>Harley-Davidson Motor Company
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
>> I am taking a course in ASP.Net at Finger Lakes
Community
>> College. I am trying to create a database in VS.Net
using
>> SQL. In the computer lab we have the class in I can
>> create a database in VS.Net using SQL. In the open lab
>> and at home on my P.C. I have VS.Net and SQL Server
2000
>> loaded. Every is the same BUT I cannot create a
database
>> using SQL on my P.C. or in the open lab. I am set up as
>> the administrator and have all the rights I need to
creat
>> a database. The permissions are the same from one lab
to
>> the other and on my P.C. and the server is on. My
System
>> Admininstrator and Teacher are just as confused as I
am.
>> We need to resolve this issue before the start of the
>> fall semester. Does anyne have an idea on why this is
>> happening?
>
>.
>|||Ok. Are you using SQL Authentication? Is the server in the open lab in the
same domain as your PC? Is the SQL Server and the home PC in the same
domain? VS.net will not move across domains.
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx.gbl...
> I start VS.Net and open a new project for ASP.Net. I then
> go to Server Explorer and right click on Data Connections
> and select Create a new SQL Database. In the window where
> you enter the server I type in the local server's name
> and then type in the name of the database I want to
> create. It may take a moment or two but I'll get an error
> message stating "Can not create a databse on this
> server". when I check the permissions in Enterprise
> Manager I see that all the permissions are set for me to
> e able to create a database.
>
> >--Original Message--
> >Please be a bit more clear as to what is happening. How
> are you trying to
> >create the database? What error are you getting when you
> try?
> >
> >--
> >Andrew C. Madsen
> >Information Architect
> >Harley-Davidson Motor Company
> >"mmoon" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> >> I am taking a course in ASP.Net at Finger Lakes
> Community
> >> College. I am trying to create a database in VS.Net
> using
> >> SQL. In the computer lab we have the class in I can
> >> create a database in VS.Net using SQL. In the open lab
> >> and at home on my P.C. I have VS.Net and SQL Server
> 2000
> >> loaded. Every is the same BUT I cannot create a
> database
> >> using SQL on my P.C. or in the open lab. I am set up as
> >> the administrator and have all the rights I need to
> creat
> >> a database. The permissions are the same from one lab
> to
> >> the other and on my P.C. and the server is on. My
> System
> >> Admininstrator and Teacher are just as confused as I
> am.
> >> We need to resolve this issue before the start of the
> >> fall semester. Does anyne have an idea on why this is
> >> happening?
> >
> >
> >.
> >sql

Can not create a database in VS.Net using SQL

I am taking a course in ASP.Net at Finger Lakes Community
College. I am trying to create a database in VS.Net using
SQL. In the computer lab we have the class in I can
create a database in VS.Net using SQL. In the open lab
and at home on my P.C. I have VS.Net and SQL Server 2000
loaded. Every is the same BUT I cannot create a database
using SQL on my P.C. or in the open lab. I am set up as
the administrator and have all the rights I need to creat
a database. The permissions are the same from one lab to
the other and on my P.C. and the server is on. My System
Admininstrator and Teacher are just as confused as I am.
We need to resolve this issue before the start of the
fall semester. Does anyne have an idea on why this is
happening?Please be a bit more clear as to what is happening. How are you trying to
create the database? What error are you getting when you try?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx
.gbl...
> I am taking a course in ASP.Net at Finger Lakes Community
> College. I am trying to create a database in VS.Net using
> SQL. In the computer lab we have the class in I can
> create a database in VS.Net using SQL. In the open lab
> and at home on my P.C. I have VS.Net and SQL Server 2000
> loaded. Every is the same BUT I cannot create a database
> using SQL on my P.C. or in the open lab. I am set up as
> the administrator and have all the rights I need to creat
> a database. The permissions are the same from one lab to
> the other and on my P.C. and the server is on. My System
> Admininstrator and Teacher are just as confused as I am.
> We need to resolve this issue before the start of the
> fall semester. Does anyne have an idea on why this is
> happening?|||I start VS.Net and open a new project for ASP.Net. I then
go to Server Explorer and right click on Data Connections
and select Create a new SQL Database. In the window where
you enter the server I type in the local server's name
and then type in the name of the database I want to
create. It may take a moment or two but I'll get an error
message stating "Can not create a databse on this
server". when I check the permissions in Enterprise
Manager I see that all the permissions are set for me to
e able to create a database.

>--Original Message--
>Please be a bit more clear as to what is happening. How
are you trying to
>create the database? What error are you getting when you
try?
>--
>Andrew C. Madsen
>Information Architect
>Harley-Davidson Motor Company
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message
> news:2266a01c45d38$c2973e20$a101280a@.phx
.gbl...
Community[vbcol=seagreen]
using[vbcol=seagreen]
2000[vbcol=seagreen]
database[vbcol=seagreen]
creat[vbcol=seagreen]
to[vbcol=seagreen]
System[vbcol=seagreen]
am.[vbcol=seagreen]
>
>.
>|||Ok. Are you using SQL Authentication? Is the server in the open lab in the
same domain as your PC? Is the SQL Server and the home PC in the same
domain? VS.net will not move across domains.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx
.gbl...[vbcol=seagreen]
> I start VS.Net and open a new project for ASP.Net. I then
> go to Server Explorer and right click on Data Connections
> and select Create a new SQL Database. In the window where
> you enter the server I type in the local server's name
> and then type in the name of the database I want to
> create. It may take a moment or two but I'll get an error
> message stating "Can not create a databse on this
> server". when I check the permissions in Enterprise
> Manager I see that all the permissions are set for me to
> e able to create a database.
>
> are you trying to
> try?
> message
> Community
> using
> 2000
> database
> creat
> to
> System
> am.

Can not create a database in VS.Net using SQL

I am taking a course in ASP.Net at Finger Lakes Community
College. I am trying to create a database in VS.Net using
SQL. In the computer lab we have the class in I can
create a database in VS.Net using SQL. In the open lab
and at home on my P.C. I have VS.Net and SQL Server 2000
loaded. Every is the same BUT I cannot create a database
using SQL on my P.C. or in the open lab. I am set up as
the administrator and have all the rights I need to creat
a database. The permissions are the same from one lab to
the other and on my P.C. and the server is on. My System
Admininstrator and Teacher are just as confused as I am.
We need to resolve this issue before the start of the
fall semester. Does anyne have an idea on why this is
happening?
Please be a bit more clear as to what is happening. How are you trying to
create the database? What error are you getting when you try?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> I am taking a course in ASP.Net at Finger Lakes Community
> College. I am trying to create a database in VS.Net using
> SQL. In the computer lab we have the class in I can
> create a database in VS.Net using SQL. In the open lab
> and at home on my P.C. I have VS.Net and SQL Server 2000
> loaded. Every is the same BUT I cannot create a database
> using SQL on my P.C. or in the open lab. I am set up as
> the administrator and have all the rights I need to creat
> a database. The permissions are the same from one lab to
> the other and on my P.C. and the server is on. My System
> Admininstrator and Teacher are just as confused as I am.
> We need to resolve this issue before the start of the
> fall semester. Does anyne have an idea on why this is
> happening?
|||Please be a bit more clear as to what is happening. How are you trying to
create the database? What error are you getting when you try?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"mmoon" <anonymous@.discussions.microsoft.com> wrote in message
news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
> I am taking a course in ASP.Net at Finger Lakes Community
> College. I am trying to create a database in VS.Net using
> SQL. In the computer lab we have the class in I can
> create a database in VS.Net using SQL. In the open lab
> and at home on my P.C. I have VS.Net and SQL Server 2000
> loaded. Every is the same BUT I cannot create a database
> using SQL on my P.C. or in the open lab. I am set up as
> the administrator and have all the rights I need to creat
> a database. The permissions are the same from one lab to
> the other and on my P.C. and the server is on. My System
> Admininstrator and Teacher are just as confused as I am.
> We need to resolve this issue before the start of the
> fall semester. Does anyne have an idea on why this is
> happening?
|||I start VS.Net and open a new project for ASP.Net. I then
go to Server Explorer and right click on Data Connections
and select Create a new SQL Database. In the window where
you enter the server I type in the local server's name
and then type in the name of the database I want to
create. It may take a moment or two but I'll get an error
message stating "Can not create a databse on this
server". when I check the permissions in Enterprise
Manager I see that all the permissions are set for me to
e able to create a database.

>--Original Message--
>Please be a bit more clear as to what is happening. How
are you trying to
>create the database? What error are you getting when you
try?
>--
>Andrew C. Madsen
>Information Architect
>Harley-Davidson Motor Company
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
Community[vbcol=seagreen]
using[vbcol=seagreen]
2000[vbcol=seagreen]
database[vbcol=seagreen]
creat[vbcol=seagreen]
to[vbcol=seagreen]
System[vbcol=seagreen]
am.
>
>.
>
|||I start VS.Net and open a new project for ASP.Net. I then
go to Server Explorer and right click on Data Connections
and select Create a new SQL Database. In the window where
you enter the server I type in the local server's name
and then type in the name of the database I want to
create. It may take a moment or two but I'll get an error
message stating "Can not create a databse on this
server". when I check the permissions in Enterprise
Manager I see that all the permissions are set for me to
e able to create a database.

>--Original Message--
>Please be a bit more clear as to what is happening. How
are you trying to
>create the database? What error are you getting when you
try?
>--
>Andrew C. Madsen
>Information Architect
>Harley-Davidson Motor Company
>"mmoon" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2266a01c45d38$c2973e20$a101280a@.phx.gbl...
Community[vbcol=seagreen]
using[vbcol=seagreen]
2000[vbcol=seagreen]
database[vbcol=seagreen]
creat[vbcol=seagreen]
to[vbcol=seagreen]
System[vbcol=seagreen]
am.
>
>.
>
|||Ok. Are you using SQL Authentication? Is the server in the open lab in the
same domain as your PC? Is the SQL Server and the home PC in the same
domain? VS.net will not move across domains.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx.gbl...[vbcol=seagreen]
> I start VS.Net and open a new project for ASP.Net. I then
> go to Server Explorer and right click on Data Connections
> and select Create a new SQL Database. In the window where
> you enter the server I type in the local server's name
> and then type in the name of the database I want to
> create. It may take a moment or two but I'll get an error
> message stating "Can not create a databse on this
> server". when I check the permissions in Enterprise
> Manager I see that all the permissions are set for me to
> e able to create a database.
>
> are you trying to
> try?
> message
> Community
> using
> 2000
> database
> creat
> to
> System
> am.
|||Ok. Are you using SQL Authentication? Is the server in the open lab in the
same domain as your PC? Is the SQL Server and the home PC in the same
domain? VS.net will not move across domains.
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
<anonymous@.discussions.microsoft.com> wrote in message
news:2283801c45d41$8d809c50$a401280a@.phx.gbl...[vbcol=seagreen]
> I start VS.Net and open a new project for ASP.Net. I then
> go to Server Explorer and right click on Data Connections
> and select Create a new SQL Database. In the window where
> you enter the server I type in the local server's name
> and then type in the name of the database I want to
> create. It may take a moment or two but I'll get an error
> message stating "Can not create a databse on this
> server". when I check the permissions in Enterprise
> Manager I see that all the permissions are set for me to
> e able to create a database.
>
> are you trying to
> try?
> message
> Community
> using
> 2000
> database
> creat
> to
> System
> am.

Can not connect to SQL Express from a different computer

Hello,

I have the following problem: I can not connect to an instance of SQL Express from a computer different than the one that the SQL Express is installed on.

When trying to connect through Management Express Studio Express CTP I get the following error:

****

TITLE: Connect to Server

Cannot connect to (nameofserver)\SQLEXPRESS.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

****

I can connect to the Express instance without problems from the same computer on which the server is installed on.

SQL Express is installed on a computer running Windows 2003 with SP1.

That computer also has SQL Server 2000, Workgroup Edition installed.

Both, SQL Express and Management Studio have been downloaded form the MSDN web site last week (so, I believe, they're the latest available versions).

In the SQL Server Configuration Manager, under SQL Server 2005 Network Configuration -> Protocols for SQLEXPRESS, Shared Memory, Named Pipes and TCP/IP are enabled, VIA is disabled.

In the SQL Server Configuration Manager, under SQL Server 2005 Native Client Configuration -> Client Protocols, Shared Memory, Named Pipes and TCP/IP are enabled, VIA is disabled.

After enabling these protocols the computer was restarted.

SQL Server Browser service is running.

Both, SQL Server and SQL Server Browser, were set to run under the deafult NetworkService account during setup.

There is a warning in the Event Log (Application section) logged by the SQLBrowser which says:

The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid.

I've searched a lot and tried a lot of different things, but I have not been able to resolve this issue. Please help.

Have you checked the following link: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx ?|||

Thanks for the link.

I have already tried all the things listed in the article multiple times (enabled protocols, SQL Browser Service running, there is no firewall on the server, I disabled firewall on the client when trying to connect).

(I haven't tried the registry thing because I'm dealing with the final relase of SQL Express and not the CTP.)

I believe my problem has to do with the warning that's logged by the SQL Server Browser service in the Event Log:

The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid.

I have found a couple of references to the same message on the Internet, but none of them offered a solution.

Any other suggestions?

|||

I am also seeing these same symptoms, except I'm just trying to access SQL Express from the same machine it is installed on. I've followed all of the suggested steps I could find, and still get the error message about configuration of AdminConnection\TCP protocol not being valid. I've also, in desperation, disabled the firewall altogether: that didn't change the behavior at all.

I can't get a TCP Connect to SQL Express to work to save my soul.

Can not connect to non-default instance from remote computer

I installed SQL2005 as default instance.
After that I installed SQL2000 with instance name "SQL2K". Then I installed
SP4.
I can'not connect to SQL2K instance from remote machine. But if I log on at
machine on which SQL Server installed I can connect to instance.
And I can connect to default instance (SQL2005) from remote machine.
How to solve this problem?
Is the SQL Server Browser service running? It helps resolve names of named
instances to the port number. Since SQL Server 2005 is the default instance,
it is probably using port 1433. Therefore SQL Server 2000 must be using some
other port, but you don't know which port, but the SQL Server Browser
service will know.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Alexey Rokhin" <ar@.hotmail.com> wrote in message
news:%23PF4wc16FHA.1416@.TK2MSFTNGP09.phx.gbl...
>I installed SQL2005 as default instance.
> After that I installed SQL2000 with instance name "SQL2K". Then I
> installed SP4.
> I can'not connect to SQL2K instance from remote machine. But if I log on
> at machine on which SQL Server installed I can connect to instance.
> And I can connect to default instance (SQL2005) from remote machine.
> How to solve this problem?
>

Can not connect to non-default instance from remote computer

I installed SQL2005 as default instance.
After that I installed SQL2000 with instance name "SQL2K". Then I installed
SP4.
I can'not connect to SQL2K instance from remote machine. But if I log on at
machine on which SQL Server installed I can connect to instance.
And I can connect to default instance (SQL2005) from remote machine.
How to solve this problem?Is the SQL Server Browser service running? It helps resolve names of named
instances to the port number. Since SQL Server 2005 is the default instance,
it is probably using port 1433. Therefore SQL Server 2000 must be using some
other port, but you don't know which port, but the SQL Server Browser
service will know.
--
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Alexey Rokhin" <ar@.hotmail.com> wrote in message
news:%23PF4wc16FHA.1416@.TK2MSFTNGP09.phx.gbl...
>I installed SQL2005 as default instance.
> After that I installed SQL2000 with instance name "SQL2K". Then I
> installed SP4.
> I can'not connect to SQL2K instance from remote machine. But if I log on
> at machine on which SQL Server installed I can connect to instance.
> And I can connect to default instance (SQL2005) from remote machine.
> How to solve this problem?
>

can no longer connect to SQL Server express error:40

Hi,

I have been working for a few weeks on a local SQL server (express) on my computer all worked ok, until 2 days ago I got the following error message:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

Where can I find the setting for remote connections? Also any idea why this happened?

rgds

Frank

Hi,

see my Screencasts on my website for enabling / configuring Remote Connections.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Can I replicate data from sqlserver 6.5 to sqlserver 2000?

There are several tables in a computer running sql server 6.5.
I want to replicate it to another computer running sql server 2000.
Can it work?
How to do it?
Thank you very much.There are several tables in a computer running sql server 6.5. I want to replicate it to another computer running sql server 2000.
Q1 Can it work?
Q2 How to do it?
Thank you very much.

A1 Yes, though 6.5 does not support newer features e.g.(merge).
A2 Publish in 6.5, subscribe in 2k, For details see 6.5 and 2k BOL.|||The following article should be very helpful - I stumbled across it a couple of days ago because I am in the middle of upgrading a ss 7 to ss2k with transactional replication with immediate updating (which is a little problematic)

article (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replimpl_4joy.asp)|||Originally posted by rnealejr
The following article should be very helpful - I stumbled across it a couple of days ago because I am in the middle of upgrading a ss 7 to ss2k with transactional replication with immediate updating (which is a little problematic)

article (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replimpl_4joy.asp)

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon
SQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon
|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
SimonSQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Sorry - forgot to mention that if you have any remote logins, then you may
get an error. If so, you need to drop those before you can drop the
servername.
Apologies for the incomplete first response - was just running to the coffee
machine - it's that time of the day
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon|||Some thoughts here:
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Simon Harvey" <nothanks@.hotmail.com> wrote in message news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx
.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is
> it "name agnostic"?
> Many thanks
> Simon

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
SimonSQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Sorry - forgot to mention that if you have any remote logins, then you may
get an error. If so, you need to drop those before you can drop the
servername.
Apologies for the incomplete first response - was just running to the coffee
machine - it's that time of the day :)
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon|||Some thoughts here:
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Simon Harvey" <nothanks@.hotmail.com> wrote in message news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is
> it "name agnostic"?
> Many thanks
> Simon

Can I install the SQL 2005 Express beside SQL 2000 server to the same computer?

Hello,

Sorry for my question, I know, that there were several topics about sql 2000 vs SQL 2005, I read all them but unfortunately I haven't got the correct answer. I must install my intranet application that uses asp.net 2.0 and SQL 2005 Express to a Windows 2003 server with SQL 2000. It is possible to install SQL 2005 Express beside the 2000 server? It is very important, because I have no possibility to test and that Win2003 server there are a few programs that use SQL 2000. What will happen with the 2000 databases and their programs if I install the 2005 Express to the server? They will work fine with 2000 and my application will work with 2005?

Or instead it should I configure my application to use 2000 capable connentionstrings?

Keeping it short and simple, the answer isYes

Regards

|||Thanks|||

Following on from that question, how do you connect to the databases?

I currently have SQL2000 and connect using localhost in the connection string.

Now that I have SQL2005 Express installed alongside it, what do I use for that?

Cheers
pie