| Author |
Set default SQL Server-instance
|
|
| Thor W Hammer 2006-03-08, 7:23 am |
| We had SQL Server 2000 as the default sql server instance on a machine.
Now we have installed a SQL Server 2005 under the instance name sql2005.
We are able to connect to the new sql server instance by postfixing the host
in the connection string like this: server/sql2005.
How can we set up the server machine so that the new server becomes the
default sql server instance so that we don't have to prefix the connection
strings?
TWH
| |
| Uri Dimant 2006-03-08, 7:23 am |
| Hi
Only Re-Install SQL Server
"Thor W Hammer" <thorwhammer@hotmail.com> wrote in message
news:440ed77a$1@news
.broadpark.no...
> We had SQL Server 2000 as the default sql server instance on a machine.
> Now we have installed a SQL Server 2005 under the instance name sql2005.
>
> We are able to connect to the new sql server instance by postfixing the
> host in the connection string like this: server/sql2005.
>
> How can we set up the server machine so that the new server becomes the
> default sql server instance so that we don't have to prefix the connection
> strings?
>
> TWH
>
| |
| Thor W Hammer 2006-03-08, 9:23 am |
| This means we have to set up all the databases and users/logins, or just
install over the existing one?
TWH
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:eCYciKrQGHA.4344@TK2MSFTNGP12.phx.gbl...
> Hi
> Only Re-Install SQL Server
>
>
>
> "Thor W Hammer" <thorwhammer@hotmail.com> wrote in message
> news:440ed77a$1@news
.broadpark.no...
>
>
| |
| Uri Dimant 2006-03-08, 9:23 am |
| Hi
No,backup your databases and keep them in the safe place.
Re-install SQL Server and then restore all user's databases
"Thor W Hammer" <thorwhammer@hotmail.com> wrote in message
news:440eddca$1@news
.broadpark.no...
> This means we have to set up all the databases and users/logins, or just
> install over the existing one?
>
> TWH
>
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:eCYciKrQGHA.4344@TK2MSFTNGP12.phx.gbl...
>
>
| |
| Thor W Hammer 2006-03-08, 11:23 am |
| I don't believe it, the server costs around $10.000 so there must be some
more elegant way of doing this.
TWH
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:eUtNscrQGHA.2536@tk2msftngp13.phx.gbl...
> Hi
> No,backup your databases and keep them in the safe place.
> Re-install SQL Server and then restore all user's databases
>
>
>
> "Thor W Hammer" <thorwhammer@hotmail.com> wrote in message
> news:440eddca$1@news
.broadpark.no...
>
>
| |
| Uri Dimant 2006-03-08, 11:23 am |
| :-))))))
The Enterprise Edition costs more than 20.000$
"Thor W Hammer" <thorwhammer@hotmail.com> wrote in message
news:440f004d$1@news
.broadpark.no...
>I don't believe it, the server costs around $10.000 so there must be some
>more elegant way of doing this.
>
> TWH
>
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:eUtNscrQGHA.2536@tk2msftngp13.phx.gbl...
>
>
| |
| Roger Wolter[MSFT] 2006-03-10, 3:23 am |
| You can upgrade the SQL Server 2000 instance to SQL Server 2005 in place.
If the SQL Server 2000 database the one that has the production data on it?
If not, you'll have to transfer the database from the named instance.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Thor W Hammer" <thorwhammer@hotmail.com> wrote in message
news:440eddca$1@news
.broadpark.no...
> This means we have to set up all the databases and users/logins, or just
> install over the existing one?
>
> TWH
>
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:eCYciKrQGHA.4344@TK2MSFTNGP12.phx.gbl...
>
>
|
|
|
|