Rename Server - SQL 2005 RS

Windows 2003 R2, SQL 2005
I use Virtual Server images for my testing environments and so I need to be
able to take my master copy of an image and rename the server so that I can
put out on the network. When I do this, Reporting Services is unable to
connect to the database, which is no surprise really. I'm having trouble
finding info on how to fix this.
Anyone know what's involved with getting reporting services to work if you
rename the server?
--
thanks,
-JeffHave you tried using the Reporting Services Configuration Utility? This
tool lets' you point to the correct server.
--
Shaun Beane, MCT, MCDST, MCDBA
dbageek.blogspot.com
"Jefffff" <Jefffff@.discussions.microsoft.com> wrote in message
news:6E591CBD-F70B-4F50-B289-5EDF4BDB6D1B@.microsoft.com...
> Windows 2003 R2, SQL 2005
> I use Virtual Server images for my testing environments and so I need to
> be
> able to take my master copy of an image and rename the server so that I
> can
> put out on the network. When I do this, Reporting Services is unable to
> connect to the database, which is no surprise really. I'm having trouble
> finding info on how to fix this.
> Anyone know what's involved with getting reporting services to work if you
> rename the server?
> --
> thanks,
> -Jeff|||Many moons later, I've found some time to test this...
What I find is that after renaming the server, the Configuration Utility
doesn't work. When you launch it, you need to first connect to an instance
of Reporting Services, before you can configure anything, and after renaming
the server, you cannot connect to the Reporting Services instance on that
server, therefore you cannot configure anything.
Unless I'm missing something, it seems renaming your server means
reinstalling SRS.
I'm not sure how the utility connects to an SRS instance. If I had the time
to figure that out, maybe I could figure out a fix.
Anyone else out there dealing with this one?
--
thanks,
-Jeff
"Shaun Beane" wrote:
> Have you tried using the Reporting Services Configuration Utility? This
> tool lets' you point to the correct server.
> --
> Shaun Beane, MCT, MCDST, MCDBA
> dbageek.blogspot.com
> "Jefffff" <Jefffff@.discussions.microsoft.com> wrote in message
> news:6E591CBD-F70B-4F50-B289-5EDF4BDB6D1B@.microsoft.com...
> > Windows 2003 R2, SQL 2005
> >
> > I use Virtual Server images for my testing environments and so I need to
> > be
> > able to take my master copy of an image and rename the server so that I
> > can
> > put out on the network. When I do this, Reporting Services is unable to
> > connect to the database, which is no surprise really. I'm having trouble
> > finding info on how to fix this.
> >
> > Anyone know what's involved with getting reporting services to work if you
> > rename the server?
> >
> > --
> > thanks,
> > -Jeff
>
>

removing duplicated rows

Hi,
Need to remove the duplicated rows from a table which has text/ntext/image type columns. The table does not have any PK/Unique column. (I accept its a bad data model). But currently changing the data model is not possible. Hence doing changes in application.
I couldn't do 'SELECT DISTINCT * from table', since the table has text columns. Though there is no PK constraint, If I know that col1 and col2 are join PKs in the table, Is that possible to select the distinct rows from such a table.
Please advise,
Thanks,
Smithahttp://www.aspfaq.com/2431

wrote in message

news:e3d0a7da-ac87-46f8-a9c5-008fbcb4cd8d@.discussions.microsoft.com...

> Hi,

>

> Need to remove the duplicated rows from a table which has

> text/ntext/image type columns. The table does not have any PK/Unique

> column. (I accept its a bad data model). But currently changing the data

> model is not possible. Hence doing changes in application.

>

> I couldn't do 'SELECT DISTINCT * from table', since the table has text

> columns. Though there is no PK constraint, If I know that col1 and col2

> are join PKs in the table, Is that possible to select the distinct rows

> from such a table.

>

> Please advise,

>

> Thanks,

> Smitha

>

>

removing duplicated records

Hi,

Need to remove the duplicated rows from a table which has text/ntext/image type columns. The table does not have any PK/Unique column. (I accept its a bad data model). But currently changing the data model is not possible. Hence doing changes in application.

I couldn't do 'SELECT DISTINCT * from table', since the table has text columns. Though there is no PK constraint, If I know that col1 and col2 are join PKs in the table, Is that possible to select the distinct rows from such a table.

Please advise,

Thanks,
MiraJwhy dont u post the DDL of table,some describtion abt table|||maybe you could use group by and use max() function to exclude duplicates

select col1, col2, max(text_col3), max(text_col4)...
from t
group by col1, col2...|||why dont u post the DDL of table,some describtion abt table

Table :

create table test(col1 int, col2 int, col3 text, col4 image)|||it is quiet difficult to do, there are some options,
insert all records into temp table ,add unique column before transfering data to temp table

1.If data values are less
than 8000 characters, you can cast the values to VARCHAR(8000) and use DISTINCT or
GROUP by to get the unique row.


If data values are greater than
8000
characters you may have to use a cursor & loop through
the rows & delete the
rows. In some cases you may have to use
an identity column or a number table
( with a cross join
operation ) to easily distingush one row from another.
----------
This link may help u http://www.windowsitpro.com/SQLServer/Article/ArticleID/23234/23234.html