Hello,
I have a new installation of SQL 2000 (via SBS 2003). When it was originally
setup, "Windows Only" security was configured. Using the "Server Properties
" dialog in Enterprise Manager, I tried changing it to "Windows and SQL", bu
t the changes don't "stick"
after clicking OK. I tried some other general changes (for example: min/max
memory) and none of the changes I make are stored after clicking OK.
Has anyone run across this before?
ThanksHi,
I have not encountered this sort of sitiuations before,
For changing the Memory and other parameters please try executing
SP_CONFIGURE procedure (Look books online for info).
For changing the Authentication mode you have to change the registry entry
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\Microsoft SQL
Server\HARISQL\MSSQLServer]
Change the value for "LoginMode" to 2 for SQL server and Windows , AFter
this restart SQL server sevice and verify the status.
Thanks
Hari
MCDBA
"FJOHN" <anonymous@.discussions.microsoft.com> wrote in message
news:A9887B4F-FFD3-4E7A-B465-210476166479@.microsoft.com...
> Hello,
> I have a new installation of SQL 2000 (via SBS 2003). When it was
originally setup, "Windows Only" security was configured. Using the "Server
Properties" dialog in Enterprise Manager, I tried changing it to "Windows
and SQL", but the changes don't "stick" after clicking OK. I tried some
other general changes (for example: min/max memory) and none of the changes
I make are stored after clicking OK.
> Has anyone run across this before?
> Thanks|||It sounds like the login that SQL Server is running under may NOT have
permissions to alter the registry keys for SQL Server...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"FJOHN" <anonymous@.discussions.microsoft.com> wrote in message
news:A9887B4F-FFD3-4E7A-B465-210476166479@.microsoft.com...
> Hello,
> I have a new installation of SQL 2000 (via SBS 2003). When it was
originally setup, "Windows Only" security was configured. Using the "Server
Properties" dialog in Enterprise Manager, I tried changing it to "Windows
and SQL", but the changes don't "stick" after clicking OK. I tried some
other general changes (for example: min/max memory) and none of the changes
I make are stored after clicking OK.
> Has anyone run across this before?
> Thankssql
Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts
Tuesday, March 20, 2012
Friday, February 24, 2012
change sql server from CS to Case Insensitive
Hi,
I setup a SQL server with case sensitive. How can I change
it into case insensitive?
If I use rebuildm, would it destroy my existing db?
When I ran rebuildm.exe, I got error message "Rebuild
Master failed with error -1:". Any hint?
Thank you for your help.|
| Hi,
| I setup a SQL server with case sensitive. How can I change
| it into case insensitive?
--
I will assume that you are using SQL Server 2000. In this version, sort
order can be different up to column level.
To change the server-wide sort order, you need to perform the following:
1. Use rebuildm to rebuild the master database and specify the desired case
insensitive sort order.
2. Use Alter database to specify the sort order per database.
One concern when moving from case sensitive to case sensitive is you might
encounter duplicate object names. For instance, when you move from case
sensitive to case insensitive sort order a table named "tAbLe1" will be the
same as a table named "TaBlE1".
Hope this helps,
--
Eric Cárdenas
SQL Server support|||> 1. Use rebuildm to rebuild the master database and specify the desired
case
> insensitive sort order.
1.5 Restore the databases.
> 2. Use Alter database to specify the sort order per database.
3. Use ALTER TABLE ... ALTER COLUMN to change collation for all existing
columns. And drop constraints and indexes to be able to do this.
Changing collation is (still) not a trivial task, unfortunately.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Eric Cardenas" <ecard@.anonymous.com> wrote in message
news:AXhdme7vDHA.2772@.cpmsftngxa07.phx.gbl...
> |
> | Hi,
> | I setup a SQL server with case sensitive. How can I change
> | it into case insensitive?
> --
> I will assume that you are using SQL Server 2000. In this version, sort
> order can be different up to column level.
> To change the server-wide sort order, you need to perform the following:
> 1. Use rebuildm to rebuild the master database and specify the desired
case
> insensitive sort order.
> 2. Use Alter database to specify the sort order per database.
> One concern when moving from case sensitive to case sensitive is you might
> encounter duplicate object names. For instance, when you move from case
> sensitive to case insensitive sort order a table named "tAbLe1" will be
the
> same as a table named "TaBlE1".
> Hope this helps,
> --
> Eric Cárdenas
> SQL Server support
>
I setup a SQL server with case sensitive. How can I change
it into case insensitive?
If I use rebuildm, would it destroy my existing db?
When I ran rebuildm.exe, I got error message "Rebuild
Master failed with error -1:". Any hint?
Thank you for your help.|
| Hi,
| I setup a SQL server with case sensitive. How can I change
| it into case insensitive?
--
I will assume that you are using SQL Server 2000. In this version, sort
order can be different up to column level.
To change the server-wide sort order, you need to perform the following:
1. Use rebuildm to rebuild the master database and specify the desired case
insensitive sort order.
2. Use Alter database to specify the sort order per database.
One concern when moving from case sensitive to case sensitive is you might
encounter duplicate object names. For instance, when you move from case
sensitive to case insensitive sort order a table named "tAbLe1" will be the
same as a table named "TaBlE1".
Hope this helps,
--
Eric Cárdenas
SQL Server support|||> 1. Use rebuildm to rebuild the master database and specify the desired
case
> insensitive sort order.
1.5 Restore the databases.
> 2. Use Alter database to specify the sort order per database.
3. Use ALTER TABLE ... ALTER COLUMN to change collation for all existing
columns. And drop constraints and indexes to be able to do this.
Changing collation is (still) not a trivial task, unfortunately.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Eric Cardenas" <ecard@.anonymous.com> wrote in message
news:AXhdme7vDHA.2772@.cpmsftngxa07.phx.gbl...
> |
> | Hi,
> | I setup a SQL server with case sensitive. How can I change
> | it into case insensitive?
> --
> I will assume that you are using SQL Server 2000. In this version, sort
> order can be different up to column level.
> To change the server-wide sort order, you need to perform the following:
> 1. Use rebuildm to rebuild the master database and specify the desired
case
> insensitive sort order.
> 2. Use Alter database to specify the sort order per database.
> One concern when moving from case sensitive to case sensitive is you might
> encounter duplicate object names. For instance, when you move from case
> sensitive to case insensitive sort order a table named "tAbLe1" will be
the
> same as a table named "TaBlE1".
> Hope this helps,
> --
> Eric Cárdenas
> SQL Server support
>
Change Shared Data Source at runtime based on a parameter
I have 11 databases identical databases except that they have different usename and passwords. I want to setup 11 Shared Data Sources and set the report to choose a different Shared Data Source based off of a parameter. Is this possiable
Changing shared data sources dynamically is currently not supported.
The closest you can get through expressions in the report is to use a non-shared data source with an expression-based connection string. This option and other options are discussed in more detail in this relating thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=16395&SiteID=1
-- Robert
Thursday, February 16, 2012
Change report host server name?
We have a SSRS web setup on one of our servers, and originally it was setup
using the server's internal name. we want to be able to change this to use
the external name. When you go to a report the frame which hosts the report
output the src shows http://zweb/reportserver. we want this to show instead
http://www.mycompany.com/reportserver. how can we change this?
we tried changing the rsreportserver.config.
We want to host the reports page under our clients sites so we can give them
reports for their web stats and the like. So eg. we have a client named
www.myclient.com. under their site, we made a virtual directory which points
to the server\reports web site.
Thanks in advance,
- Arthur Dent.I have run into the same problem. I tried changing the baseUrl and I end
up getting a 401 error.
--
Message posted via http://www.sqlmonster.com|||Found the answer to my problem here:
http://www.sqljunkies.com/forums/showpost.aspx?postid=4393
Also you may want to do a search on this term:
ReportServerExternalURL
It is a setting that microsoft says you need to set, but I couldn't get it
to work. I got mine to work using the link above!
Hope this helps!
--
Message posted via http://www.sqlmonster.com|||You need to make sure you have edited the RSReportManager.config file to
point to the new server.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Benedict via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9c496e631eb14a3f81be421acb338af7@.SQLMonster.com...
>I have run into the same problem. I tried changing the baseUrl and I end
> up getting a 401 error.
> --
> Message posted via http://www.sqlmonster.com
using the server's internal name. we want to be able to change this to use
the external name. When you go to a report the frame which hosts the report
output the src shows http://zweb/reportserver. we want this to show instead
http://www.mycompany.com/reportserver. how can we change this?
we tried changing the rsreportserver.config.
We want to host the reports page under our clients sites so we can give them
reports for their web stats and the like. So eg. we have a client named
www.myclient.com. under their site, we made a virtual directory which points
to the server\reports web site.
Thanks in advance,
- Arthur Dent.I have run into the same problem. I tried changing the baseUrl and I end
up getting a 401 error.
--
Message posted via http://www.sqlmonster.com|||Found the answer to my problem here:
http://www.sqljunkies.com/forums/showpost.aspx?postid=4393
Also you may want to do a search on this term:
ReportServerExternalURL
It is a setting that microsoft says you need to set, but I couldn't get it
to work. I got mine to work using the link above!
Hope this helps!
--
Message posted via http://www.sqlmonster.com|||You need to make sure you have edited the RSReportManager.config file to
point to the new server.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Benedict via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9c496e631eb14a3f81be421acb338af7@.SQLMonster.com...
>I have run into the same problem. I tried changing the baseUrl and I end
> up getting a 401 error.
> --
> Message posted via http://www.sqlmonster.com
Change replicationAgent that starts SQLSERVERAGENT
Hi,
We are using Push subscription in our transactional replication setup in SQL
2K and I noticed that the SQLSERVERAGENT service is started by a local
account called replicationAgent. Is it a problem for me to change it to a
different local account? If it is ok to change it, do I need to change it
also in the subscriber computer and is it necessary that both account name
and password need to be the same?
Wingman
It is ok to change it to an account in the local administrator group, or an
account which has write permission to the default snapshot share.
Make sure that the job owner is sa otherwise it probably will not start.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:67E05E17-2202-477C-BB62-75695B821516@.microsoft.com...
> Hi,
> We are using Push subscription in our transactional replication setup in
> SQL
> 2K and I noticed that the SQLSERVERAGENT service is started by a local
> account called replicationAgent. Is it a problem for me to change it to
> a
> different local account? If it is ok to change it, do I need to change it
> also in the subscriber computer and is it necessary that both account name
> and password need to be the same?
> Wingman
|||Thanks as always.
Wing
"Wingman" wrote:
> Hi,
> We are using Push subscription in our transactional replication setup in SQL
> 2K and I noticed that the SQLSERVERAGENT service is started by a local
> account called replicationAgent. Is it a problem for me to change it to a
> different local account? If it is ok to change it, do I need to change it
> also in the subscriber computer and is it necessary that both account name
> and password need to be the same?
> Wingman
We are using Push subscription in our transactional replication setup in SQL
2K and I noticed that the SQLSERVERAGENT service is started by a local
account called replicationAgent. Is it a problem for me to change it to a
different local account? If it is ok to change it, do I need to change it
also in the subscriber computer and is it necessary that both account name
and password need to be the same?
Wingman
It is ok to change it to an account in the local administrator group, or an
account which has write permission to the default snapshot share.
Make sure that the job owner is sa otherwise it probably will not start.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:67E05E17-2202-477C-BB62-75695B821516@.microsoft.com...
> Hi,
> We are using Push subscription in our transactional replication setup in
> SQL
> 2K and I noticed that the SQLSERVERAGENT service is started by a local
> account called replicationAgent. Is it a problem for me to change it to
> a
> different local account? If it is ok to change it, do I need to change it
> also in the subscriber computer and is it necessary that both account name
> and password need to be the same?
> Wingman
|||Thanks as always.
Wing
"Wingman" wrote:
> Hi,
> We are using Push subscription in our transactional replication setup in SQL
> 2K and I noticed that the SQLSERVERAGENT service is started by a local
> account called replicationAgent. Is it a problem for me to change it to a
> different local account? If it is ok to change it, do I need to change it
> also in the subscriber computer and is it necessary that both account name
> and password need to be the same?
> Wingman
Sunday, February 12, 2012
Change of Ownership??
I am having a problem with object ownership.
The person who setup the SQL Server setup the "dbo" account with his personal permissions. I need to change "dbo" so that the login name is the system account and not a personal account. Is this possible?
If this is not possible can I change the ownership of a system object?
I was able to change ownershipof user objects using the "sp_changeobjectowner" stored procedure, but it did not seem to work for system objects.
Any way around this?
- Ericdid you try sp_changedbowner? This would change the database ownership which I believe should change the system object ownership?>?|||The dbo user is so tightly "hardwired" into the database that I'd give the user a new login, change the ownership of their tables to that new user, and stop right there. I wouldn't even consider allowing the user to keep using dbo.
-PatP
The person who setup the SQL Server setup the "dbo" account with his personal permissions. I need to change "dbo" so that the login name is the system account and not a personal account. Is this possible?
If this is not possible can I change the ownership of a system object?
I was able to change ownershipof user objects using the "sp_changeobjectowner" stored procedure, but it did not seem to work for system objects.
Any way around this?
- Ericdid you try sp_changedbowner? This would change the database ownership which I believe should change the system object ownership?>?|||The dbo user is so tightly "hardwired" into the database that I'd give the user a new login, change the ownership of their tables to that new user, and stop right there. I wouldn't even consider allowing the user to keep using dbo.
-PatP
Subscribe to:
Posts (Atom)