Changing the look of Report Manager

Is there a way to change the size of the text boxes and other items that appear in report manager when you run a report? I am referring to the size of the boxes that the user can enter information into to run the report.

Thank you,

Hi Kimberly

This has been discussed alot on the forum, in short the answer is "somewhat". You can modify the cascading style sheets for the report manager, I found a good thread on that yesterday but can't find it right now.

As for "branding" the site, one thread where this is discussed is here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295521&SiteID=1

Enjoy

Changing the logical name of a DB

Hi,
I recently restored one DB over another different one in order to import a
template of data into a new DB. I did this in Enterprise Manager. The gui
allowed me to change the physical file path & name to match the destination
file, but didn't allow me to change the logical name.
How can I now change the logical file names of the data & log files?
Many thanks for any help
You should do your best to learn the DDL equivalents of pointing and
clicking in the GUI, for two reasons: (a) you can easily store your scripts
in source control, and (b) you will have access to parts of the
functionality that didn't make it into the interface. Try this in Query
Analyzer:
ALTER DATABASE Database_Name
MODIFY FILE
(
NAME = Logical_Name,
NEWNAME = NEW_Logical_Name
);
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help
|||> How can I now change the logical file names of the data & log files?
You can use ALTER DATABASE...MODIFY FILE. For example:
ALTER DATABASE AdventureWorks
MODIFY FILE (
NAME='AdventureWorks_Data',
NEWNAME='AdventureWorks_Data_New')
See ALTER DATABASE in the Books Online for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help
|||Hello Dan,
Thank you very much for your help here.
Cheers
Ant
"Dan Guzman" wrote:

> You can use ALTER DATABASE...MODIFY FILE. For example:
> ALTER DATABASE AdventureWorks
> MODIFY FILE (
> NAME='AdventureWorks_Data',
> NEWNAME='AdventureWorks_Data_New')
> See ALTER DATABASE in the Books Online for details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>
|||What version are you running?
In SQL 2000 you cannot change the logical file names.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help
|||Hi Kalen,
Thanks for the reply but in fact it appears you can. I am using SQL 2000 &
have successfully changed the logical name simply by using the Alter table
modify file statement I was given above. It worked fine!
Thank you any way for your input on this though.
Cheer
Ant
"Kalen Delaney" wrote:

> What version are you running?
> In SQL 2000 you cannot change the logical file names.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>
>
|||Hi, Kalen.

> What version are you running?
> In SQL 2000 you cannot change the logical file names.
Perhaps you are thinking of SQL 7. IIRC, the ability to change the logical
names was introduced in SQL 2000.
Hope this helps.
Dan Guzman
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23dlcDj1UIHA.5980@.TK2MSFTNGP04.phx.gbl...
> What version are you running?
> In SQL 2000 you cannot change the logical file names.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>
|||You're right... as Dan indicated it was actually SQL 7, when the new files
structures and ALTER DATABASE command were first introduced, that there was
no way to change the logical name.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:B2DD5503-5FC5-4B16-8B3B-C38655367FDF@.microsoft.com...[vbcol=seagreen]
> Hi Kalen,
> Thanks for the reply but in fact it appears you can. I am using SQL 2000 &
> have successfully changed the logical name simply by using the Alter table
> modify file statement I was given above. It worked fine!
> Thank you any way for your input on this though.
> Cheer
> Ant
> "Kalen Delaney" wrote:
|||Thanks, Dan.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:C6D04793-D874-4B42-A440-ED117325CE42@.microsoft.com...
> Hi, Kalen.
>
> Perhaps you are thinking of SQL 7. IIRC, the ability to change the
> logical names was introduced in SQL 2000.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:%23dlcDj1UIHA.5980@.TK2MSFTNGP04.phx.gbl...
>

Changing the logical name of a DB

Hi,
I recently restored one DB over another different one in order to import a
template of data into a new DB. I did this in Enterprise Manager. The gui
allowed me to change the physical file path & name to match the destination
file, but didn't allow me to change the logical name.
How can I now change the logical file names of the data & log files?
Many thanks for any helpYou should do your best to learn the DDL equivalents of pointing and
clicking in the GUI, for two reasons: (a) you can easily store your scripts
in source control, and (b) you will have access to parts of the
functionality that didn't make it into the interface. Try this in Query
Analyzer:
ALTER DATABASE Database_Name
MODIFY FILE
(
NAME = Logical_Name,
NEWNAME = NEW_Logical_Name
);
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help|||> How can I now change the logical file names of the data & log files?
You can use ALTER DATABASE...MODIFY FILE. For example:
ALTER DATABASE AdventureWorks
MODIFY FILE (
NAME='AdventureWorks_Data',
NEWNAME='AdventureWorks_Data_New')
See ALTER DATABASE in the Books Online for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help|||Hello Dan,
Thank you very much for your help here.
Cheers
Ant
"Dan Guzman" wrote:
> > How can I now change the logical file names of the data & log files?
> You can use ALTER DATABASE...MODIFY FILE. For example:
> ALTER DATABASE AdventureWorks
> MODIFY FILE (
> NAME='AdventureWorks_Data',
> NEWNAME='AdventureWorks_Data_New')
> See ALTER DATABASE in the Books Online for details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> > Hi,
> > I recently restored one DB over another different one in order to import a
> > template of data into a new DB. I did this in Enterprise Manager. The gui
> > allowed me to change the physical file path & name to match the
> > destination
> > file, but didn't allow me to change the logical name.
> >
> > How can I now change the logical file names of the data & log files?
> >
> > Many thanks for any help
>|||What version are you running?
In SQL 2000 you cannot change the logical file names.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> Hi,
> I recently restored one DB over another different one in order to import a
> template of data into a new DB. I did this in Enterprise Manager. The gui
> allowed me to change the physical file path & name to match the
> destination
> file, but didn't allow me to change the logical name.
> How can I now change the logical file names of the data & log files?
> Many thanks for any help|||Hi Kalen,
Thanks for the reply but in fact it appears you can. I am using SQL 2000 &
have successfully changed the logical name simply by using the Alter table
modify file statement I was given above. It worked fine!
Thank you any way for your input on this though.
Cheer
Ant
"Kalen Delaney" wrote:
> What version are you running?
> In SQL 2000 you cannot change the logical file names.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
> > Hi,
> > I recently restored one DB over another different one in order to import a
> > template of data into a new DB. I did this in Enterprise Manager. The gui
> > allowed me to change the physical file path & name to match the
> > destination
> > file, but didn't allow me to change the logical name.
> >
> > How can I now change the logical file names of the data & log files?
> >
> > Many thanks for any help
>
>|||Hi, Kalen.
> What version are you running?
> In SQL 2000 you cannot change the logical file names.
Perhaps you are thinking of SQL 7. IIRC, the ability to change the logical
names was introduced in SQL 2000.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23dlcDj1UIHA.5980@.TK2MSFTNGP04.phx.gbl...
> What version are you running?
> In SQL 2000 you cannot change the logical file names.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>> Hi,
>> I recently restored one DB over another different one in order to import
>> a
>> template of data into a new DB. I did this in Enterprise Manager. The gui
>> allowed me to change the physical file path & name to match the
>> destination
>> file, but didn't allow me to change the logical name.
>> How can I now change the logical file names of the data & log files?
>> Many thanks for any help
>|||You're right... as Dan indicated it was actually SQL 7, when the new files
structures and ALTER DATABASE command were first introduced, that there was
no way to change the logical name.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:B2DD5503-5FC5-4B16-8B3B-C38655367FDF@.microsoft.com...
> Hi Kalen,
> Thanks for the reply but in fact it appears you can. I am using SQL 2000 &
> have successfully changed the logical name simply by using the Alter table
> modify file statement I was given above. It worked fine!
> Thank you any way for your input on this though.
> Cheer
> Ant
> "Kalen Delaney" wrote:
>> What version are you running?
>> In SQL 2000 you cannot change the logical file names.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://blog.kalendelaney.com
>>
>> "Ant" <Ant@.discussions.microsoft.com> wrote in message
>> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>> > Hi,
>> > I recently restored one DB over another different one in order to
>> > import a
>> > template of data into a new DB. I did this in Enterprise Manager. The
>> > gui
>> > allowed me to change the physical file path & name to match the
>> > destination
>> > file, but didn't allow me to change the logical name.
>> >
>> > How can I now change the logical file names of the data & log files?
>> >
>> > Many thanks for any help
>>|||Thanks, Dan.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:C6D04793-D874-4B42-A440-ED117325CE42@.microsoft.com...
> Hi, Kalen.
>> What version are you running?
>> In SQL 2000 you cannot change the logical file names.
> Perhaps you are thinking of SQL 7. IIRC, the ability to change the
> logical names was introduced in SQL 2000.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:%23dlcDj1UIHA.5980@.TK2MSFTNGP04.phx.gbl...
>> What version are you running?
>> In SQL 2000 you cannot change the logical file names.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://blog.kalendelaney.com
>>
>> "Ant" <Ant@.discussions.microsoft.com> wrote in message
>> news:8FFB9324-E3A9-4676-81C4-C8970539AC54@.microsoft.com...
>> Hi,
>> I recently restored one DB over another different one in order to import
>> a
>> template of data into a new DB. I did this in Enterprise Manager. The
>> gui
>> allowed me to change the physical file path & name to match the
>> destination
>> file, but didn't allow me to change the logical name.
>> How can I now change the logical file names of the data & log files?
>> Many thanks for any help
>>
>

Changing the ConnectionString property for a File Connection Manager

I have a package that I plan to run against about 700 databases to look for anomalies. I have several package variables in place that are passed in at runtime. One of them will hold the path and filename of the error log for the current database in process. I want each database to generate it's own error log for documentation and research purposes. However, when I run the package, it continues to use the path and filename that I entered when I created the File Connection Manager. I am trying to update that value in a Script Task by using the ConnectionManager class and setting the value for the "ConnectionString" property. This method is working for the OLEDB Connection Manager (which tells the package which Access database to process), but not for my File Connection Manager. Please help!

DO

Don't try and use a script task to do this. Use expressions: http://blogs.conchango.com/jamiethomson/archive/2006/03/11/3063.aspx

-Jamie

|||Thanks, you've done it again.

Changing the Apperance of the Report Manager Homepage

Hi,

Does anyone know how to change the Appearance of the Report Manager Homepage

i.e http://Localhost/Reports

Basically I want to add some Images instead of the Blank SQL Server RS Homepage.

Thanks in Advance for your Help,

Regards,

Sundar

http://www.ubookcase.com/book/Addison.Wesley/Hitchhikers.Guide.to.SQL.Server.2000.Reporting.Services/0321268288/ch11.html|||

Hi Buddy,

Thanks a lot for the Link !!

This gave me the information I was looking for !

Thanks,

Sundar

Changing TCP/IP IP addresses under Protocols for SQLExpress

SQL Server Configuraton Manager,

Protocols for sqlexpress,

TCP/IP

When I initially installed SQL Server 2005 Express, it automatically picked up all the IP addresses (60 of them) I had on the server, and filled them in under TCP/IP - IP adresses Tab.

I recently took those IPs off the server and replaced them with 30 new IP addresses. Is there a way to have SQL Server 2005 Express read the Network configuration on the server and take the old IPs off the TCP/IP - IP addresses tab and put the new one's there?

Thanks,

Bill

You have to reinstall your SQL Server to pick the new IP addresses. Are you listening on each IP address seperately or listening on IPALL? Those IPs does not matter if your server listens on IPALL.|||

Thanks a lot Xinwei, I reinstalled SQL Server and everything went fine.

Bill

changing sql server account using sem ...

when trying to change the sql server and sql server agent accounts using the
sql enterprise manager what is the syntax for a domain account that should be
used ( i.e. domainname/username, just username, domainname\username, etc... )
? when attempting to add an existing domain account an error message keeps
poping-up that says 'the account (local computername)/accountname is not a
valid windows account' ( for some reason it thinks its a local system account
instead of a domain account ) even though sql server is installed on the pdc.
tia ...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using the
> sql enterprise manager what is the syntax for a domain account that should be
> used ( i.e. domainname/username, just username, domainname\username, etc... )
> ? when attempting to add an existing domain account an error message keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system account
> instead of a domain account ) even though sql server is installed on the pdc.
> tia ...
|||Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.
http://support.microsoft.com/default...b;en-us;283811
Sincerely,
Anthony Thomas

"mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ? when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
> tia ...
|||Thanks Anthony.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"Anthony Thomas" wrote:

> Yes, but the recommended approach is to do it through EM. This way all of
> the necessary permissions and user rights assingments will be given
> appropriately. However, using the services msc is an alternative as long as
> you follow the KB article that describes manually setting all of the other
> requirements.
> http://support.microsoft.com/default...b;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
> news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
> Hello E-Double.
> I find it easiest to change the account using the services console (type
> services.msc in Start>Run), that way you can browse the network and or check
> the name that you enter so it will be prefixed correctly with the domain. I
> just find I don't have to think about it this way.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "E-Double" wrote:
> the
> be
> etc... )
> keeps
> account
> pdc.
>
>

changing sql server account using sem ...

when trying to change the sql server and sql server agent accounts using the
sql enterprise manager what is the syntax for a domain account that should be
used ( i.e. domainname/username, just username, domainname\username, etc... )
? when attempting to add an existing domain account an error message keeps
poping-up that says 'the account (local computername)/accountname is not a
valid windows account' ( for some reason it thinks its a local system account
instead of a domain account ) even though sql server is installed on the pdc.
tia ...Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:
> when trying to change the sql server and sql server agent accounts using the
> sql enterprise manager what is the syntax for a domain account that should be
> used ( i.e. domainname/username, just username, domainname\username, etc... )
> ? when attempting to add an existing domain account an error message keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system account
> instead of a domain account ) even though sql server is installed on the pdc.
> tia ...|||Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.
http://support.microsoft.com/default.aspx?scid=kb;en-us;283811
Sincerely,
Anthony Thomas
"mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:
> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ? when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
> tia ...|||Thanks Anthony.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"Anthony Thomas" wrote:
> Yes, but the recommended approach is to do it through EM. This way all of
> the necessary permissions and user rights assingments will be given
> appropriately. However, using the services msc is an alternative as long as
> you follow the KB article that describes manually setting all of the other
> requirements.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
> news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
> Hello E-Double.
> I find it easiest to change the account using the services console (type
> services.msc in Start>Run), that way you can browse the network and or check
> the name that you enter so it will be prefixed correctly with the domain. I
> just find I don't have to think about it this way.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "E-Double" wrote:
> > when trying to change the sql server and sql server agent accounts using
> the
> > sql enterprise manager what is the syntax for a domain account that should
> be
> > used ( i.e. domainname/username, just username, domainname\username,
> etc... )
> > ? when attempting to add an existing domain account an error message
> keeps
> > poping-up that says 'the account (local computername)/accountname is not a
> > valid windows account' ( for some reason it thinks its a local system
> account
> > instead of a domain account ) even though sql server is installed on the
> pdc.
> > tia ...
>
>

changing sql server account using sem ...

when trying to change the sql server and sql server agent accounts using the
sql enterprise manager what is the syntax for a domain account that should b
e
used ( i.e. domainname/username, just username, domainname\username, etc...
)
? when attempting to add an existing domain account an error message keeps
poping-up that says 'the account (local computername)/accountname is not a
valid windows account' ( for some reason it thinks its a local system accoun
t
instead of a domain account ) even though sql server is installed on the pdc
.
tia ...Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using t
he
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username, etc..
. )
> ? when attempting to add an existing domain account an error message keep
s
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system acco
unt
> instead of a domain account ) even though sql server is installed on the p
dc.
> tia ...|||Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.
http://support.microsoft.com/defaul...kb;en-us;283811
Sincerely,
Anthony Thomas
"mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ? when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
> tia ...|||Thanks Anthony.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"Anthony Thomas" wrote:

> Yes, but the recommended approach is to do it through EM. This way all of
> the necessary permissions and user rights assingments will be given
> appropriately. However, using the services msc is an alternative as long
as
> you follow the KB article that describes manually setting all of the other
> requirements.
> http://support.microsoft.com/defaul...kb;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
> news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
> Hello E-Double.
> I find it easiest to change the account using the services console (type
> services.msc in Start>Run), that way you can browse the network and or che
ck
> the name that you enter so it will be prefixed correctly with the domain.
I
> just find I don't have to think about it this way.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "E-Double" wrote:
>
> the
> be
> etc... )
> keeps
> account
> pdc.
>
>

changing owner of stored procedure

Is there a way to change the owner of a stored procedure?
I used Enterprise Manager to create a stored procedure. But since it was
created under my login name, other users are denied permission. Rather than
explicitly giving permission to everyone, I would like to change the owner
to 'dbo'.
How?
Lisasp_changeobjectowner
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:ubuJHdw7DHA.2924@.tk2msftngp13.phx.gbl...
> Is there a way to change the owner of a stored procedure?
> I used Enterprise Manager to create a stored procedure. But since it was
> created under my login name, other users are denied permission. Rather
than
> explicitly giving permission to everyone, I would like to change the owner
> to 'dbo'.
> How?
> Lisa
>

changing owner of stored procedure

Is there a way to change the owner of a stored procedure?
I used Enterprise Manager to create a stored procedure. But since it was
created under my login name, other users are denied permission. Rather than
explicitly giving permission to everyone, I would like to change the owner
to 'dbo'.
How?
Lisasp_changeobjectowner
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:ubuJHdw7DHA.2924@.tk2msftngp13.phx.gbl...
> Is there a way to change the owner of a stored procedure?
> I used Enterprise Manager to create a stored procedure. But since it was
> created under my login name, other users are denied permission. Rather
than
> explicitly giving permission to everyone, I would like to change the owner
> to 'dbo'.
> How?
> Lisa
>

changing LinkTarget default in Report Manager?

How do you change the LinkTarget default from _self to _blank i
Report Manager? I don't see how to change the report URLs in Repor
Manager to include &rc:LinkTarget=_blank
I am trying to jump to a URL from a report that will open a new windo
and the report is running in Report Manager
Any help would be greatly appreciatedHere is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"kwarmack" <kerry.warmack@.intel-dot-com.no-spam.invalid> wrote in message
news:1qOdnfifU8ATCCLfRVn_vg@.giganews.com...
> How do you change the LinkTarget default from _self to _blank in
> Report Manager? I don't see how to change the report URLs in Report
> Manager to include &rc:LinkTarget=_blank.
> I am trying to jump to a URL from a report that will open a new window
> and the report is running in Report Manager.
> Any help would be greatly appreciated.
>

Changing IP address

If I change the IP addresson the server that I am running
SQL Server on I can no longer access Enterprise Manager?
How do I fix that?Sounds like a name resolution problem.
Suggest registering the servers IP Address in EM rather than it's name
--
HTH
Ryan Waight, MCDBA, MCSE
"Bryan" <earlyriser@.knology.net> wrote in message
news:34c601c397e8$980dbd70$7d02280a@.phx.gbl...
> If I change the IP addresson the server that I am running
> SQL Server on I can no longer access Enterprise Manager?
> How do I fix that?|||Hi
If EM is using the IP address in the server registration, you will have to
remove the registration and re-register it. If you have not changed your DNS
(or hosts file) to reflect the new IP address then you will not be able to
access the server.
Can you PING the server by name?
John
"Bryan" <earlyriser@.knology.net> wrote in message
news:34c601c397e8$980dbd70$7d02280a@.phx.gbl...
> If I change the IP addresson the server that I am running
> SQL Server on I can no longer access Enterprise Manager?
> How do I fix that?|||Hi
If it is a name resolution problem then it would be better to sort out the
network problem!
John
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:u9qZKn%23lDHA.3256@.tk2msftngp13.phx.gbl...
> Sounds like a name resolution problem.
> Suggest registering the servers IP Address in EM rather than it's name
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Bryan" <earlyriser@.knology.net> wrote in message
> news:34c601c397e8$980dbd70$7d02280a@.phx.gbl...
> > If I change the IP addresson the server that I am running
> > SQL Server on I can no longer access Enterprise Manager?
> > How do I fix that?
>

Changing Domain Password loses Enterprise Manager UID's

When anyone at work changes their domain password they lose all their Enterp
rise Manager server connection details too. Is there a fix for this besides
backing up chunks of the registry ? (Each month the users are forced to chan
ge their passwords and this
really raises their ire on the matter...
Many thanks
ChrisThe following article may address your problem.
http://support.microsoft.com/?id=323280
Based on the nature of the problem service pack 3 for SQL Server 2000 needs
to be applied on the client machines affected by this.
Rand
This posting is provided "as is" with no warranties and confers no rights.