How to rename an instance

I have a machine with both SQL Server 2000 and SQL Server 2005. I found
out that I cannot use an instance name for SQL Server 2000 that has
already been used by SQL Server 2005.
I need to rename the instance named "APP_DB" in SQL Server 2005 to be
"APP_DB05", and use "APP_DB" for SQL Server 2000. That way I don't have
to uninstall "APP_DB" from SQL Server 2005 because I need it in the future.
So, how to rename an instance? Thanks.Hi
I don't know of a way to do this other than stop the services for the SQL
2005 instance of APP_DB and install a new instance. You can detach/attach
from one instance to the other. This is not going to save you much and will
use up disc space.
John
"q_test" <jluost1@.yahoo.com> wrote in message
news:4443EC3F.7080901@.yahoo.com...
>I have a machine with both SQL Server 2000 and SQL Server 2005. I found out
>that I cannot use an instance name for SQL Server 2000 that has already
>been used by SQL Server 2005.
> I need to rename the instance named "APP_DB" in SQL Server 2005 to be
> "APP_DB05", and use "APP_DB" for SQL Server 2000. That way I don't have to
> uninstall "APP_DB" from SQL Server 2005 because I need it in the future.
> So, how to rename an instance? Thanks.
>

How to rename an instance

I have a machine with both SQL Server 2000 and SQL Server 2005. I found
out that I cannot use an instance name for SQL Server 2000 that has
already been used by SQL Server 2005.
I need to rename the instance named "APP_DB" in SQL Server 2005 to be
"APP_DB05", and use "APP_DB" for SQL Server 2000. That way I don't have
to uninstall "APP_DB" from SQL Server 2005 because I need it in the future.
So, how to rename an instance? Thanks.Hi
I don't know of a way to do this other than stop the services for the SQL
2005 instance of APP_DB and install a new instance. You can detach/attach
from one instance to the other. This is not going to save you much and will
use up disc space.
John
"q_test" <jluost1@.yahoo.com> wrote in message
news:4443EC3F.7080901@.yahoo.com...
>I have a machine with both SQL Server 2000 and SQL Server 2005. I found out
>that I cannot use an instance name for SQL Server 2000 that has already
>been used by SQL Server 2005.
> I need to rename the instance named "APP_DB" in SQL Server 2005 to be
> "APP_DB05", and use "APP_DB" for SQL Server 2000. That way I don't have to
> uninstall "APP_DB" from SQL Server 2005 because I need it in the future.
> So, how to rename an instance? Thanks.
>sql

how to remote connection to an SQL server on the same network?

hi
i added 2 databases to my SQL server on a machine next door using Microsoft SQL server management studio express... I made sure that the server allows remote connection

then from this computer i pass a connection string to my SQLCLient in VB2005 that looks a bit like this

Code: ( text )

1. ConnString = "Server=USER-PTDH8Z5ESH\SQLEXPRESS;Database=FSS.MDB;Trusted_Con nection=True;User Instance=True"

for which it gives me this error when i open the connection
SQLConnecton.Open()

System.Data.SqlClient.SqlException: 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)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Flying_School_Scheduler.DBEngine.StartConnection() in

whats the big idea?
i'm in a bit of a tight schedule here... can anyone help me here? ?

First, let me express my aplogies for not getting to your question sooner. It would be not too trite to say that since most of us that take our time to respond to questions such as yours, are volunteers, and we are often also on a tight schedule. Simple, straightforward requests for assistance are looked at and perhaps even responded to far sooner than demanding, whining ones...

As to the 'big deal' with your connection string: There are a couple of possibilites:

Often using 'prohibited' characters in a server name requires extra handling, such as enclosing the name in square brackets. You might try:
Server=[USER-PTDH8Z5ESH\SQLEXPRESS]; Is the database itself named FSS.MDB, or could that, by mistake, be the database file name?|||

Normally, error 26 is caused by a few common problems that are easily fixed. Please take a look at this posting as it should probably fix your problem: http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

Thanks,

Il-Sung.

How to register SQLExpress 2005 from SQL Server Management Studio?

I noticed SQL2005 XE installation does not come with SQL Server
Management Studio. If I install SQL2005 XE on a machine, how can I
connect to it thru SQL Server Management Studio from my workstation?
In sql2k, you can register a SQL MSDE thru EM, is there a change to
this in sql2k5? I went thru the readme file for sql2005 xe but there's
no mention of this topic.
I do not want to use SSMSE mentioned in this article to manage the
sql2005 xe, I want to use the regular SQL Server Management Studio to
manage it.
<http://support.microsoft.com/kb/907716>
Thank you"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1132274300.199134.140290@.g44g2000cwa.googlegroups.com...
>
> I noticed SQL2005 XE installation does not come with SQL Server
> Management Studio. If I install SQL2005 XE on a machine, how can I
> connect to it thru SQL Server Management Studio from my workstation?
> In sql2k, you can register a SQL MSDE thru EM, is there a change to
> this in sql2k5? I went thru the readme file for sql2005 xe but there's
> no mention of this topic.
> I do not want to use SSMSE mentioned in this article to manage the
> sql2005 xe, I want to use the regular SQL Server Management Studio to
> manage it.
> <http://support.microsoft.com/kb/907716>
>
Register it just like any named instance. However by default TCP/IP, Named
Pipes and the Browser service are disabled in Express Edition installs.
Enable them to connect to the named instance from a remote machine.
David|||hmm...that's what i thought. however i was unable to register the XE.
(i understand TCP/IP was disabled by default).
can the machine have hyphen in it? such as 'my-test-machine'?

How to redeploy reports?

Hello everyone,

I have created a selection of reports in VS and deployed them to my test machine. I would now like to deploy the project to the live machine, I cant install visual studio on this machine and the test machine cannot connect to live.

What is the best way to move my reports into the live environment?

Any help appreciated.

Kind regards
Taz

you need to change the reportserver path and deploy from your dev environment. (right click on ur report project - properties in VS)

probably you would have given http://localhost/reportserver

u need to change it to http://livemachine/reportserver.

and you can use the same method to deploy the reports. you can deploy to any reportserver after changing the name in that place.

|||

Hi,

thanks for the reply. is it possible todo this without my dev environment? The reports are part of a software package which I would like to deply through some installer if possible.

Is this possible?

Kind regards
Taz

|||

Hi Taz,

Russel Christopher shows a solution here:
http://blogs.msdn.com/bimusings/archive/2006/03/01/541599.aspx

cheers
Markus

|||

Fabulous,

exactly what I was looking for. You are a legend, thank you.

Taz

|||

I know there have been a couple of replies to your question. I would like to reccommend RSScripter. It works very well for deploying our sites. You can find it at http://www.sqldbatips.com/showarticle.asp?ID=62.

R

|||

Hi Ron,

i think the tool you linked to is much more like what I was after. I appreciate the link.

Kind regards
Taz

|||

My pleasure. You might want to look at the scripts it generates and clean them up. They have quite a bit of overhead. I hand-crafted ours (one login to SSRS, etc.) and they run much, much faster.

R

How to read a cell of Excel in Script task?

BTW, I cannot use Office automation because MS office is not installed on the machine.

Thanks,
Without using office automation, you are quite limited to what you can get out.
Either use Excel Source, which is like a flat table of rows and columns, or a 3rd party product like Data Defractor which allows you to "drill" into the document and return specific areas.