I'm looking for information on how the various pieces/parts of RS could work
in our environment. Currently that:
+ several SQL Server 2000 boxes (individual instances on individual and
distinct servers) on Windows Server 2003.
+ multiple load balanced web servers running on Windows 2000 with IIS5,
mixture of "classic" ASP and .NET web applications authored in Visual
Studio, Visual Studio .NET 2003.
We have a need to implement Reporting Services, but are confused about the
path to take. My instinct tells me to start a brand new implementation of
RS by using SQL 2005. For us, that should not be a problem. We could
easily take one of our SQL 2k boxes and upgrade to SQL 2005.
But now the questions are related to the implications on our .NET
development and production/runtime environments.
1) do we need to install .NET 2.0 on our web servers? (I'm assuming yes)
2) will this impact our existing .NET 1.1 applications in anyway?
3) what about our developers, all set up already w/ Visual Studio .NET 2003
and ASP.NET 1.1? Will they need install Visual Studio .NET 2005 and ASP.NET
2.0? Will this affect their existing visual studio projects?
Or, to minimize the impact, will only report *authors* need to have VS 2005?
4) To make reports available on our existing ASP.NET 1.1 based intranet, do
we need to have ASP.NET 2.0 web pages developed or can existing ASP.NET 1.1
web pages work?
Hopefully this gives you the gist of the kind of technical nitty-gritty I'm
after. Any links, direct info, etc. would be greatly appreciated.
Thanks.
-- MargoFirst. RS 2005 can be installed on a 2000 database. You do need to have a
2005 license though.
RS 2005 is more fully featured and I do think if you are starting out I
would go that route.
RS 2005 is a framework 2.0 app. It comes with a version of VS 2005 so you do
not have to purchase VS 2005 unless you want the new controls.
VS 2005 and VS 2003 can coexist side by side (I am doing that).
Only report authors need VS 2005 environment.
From asp.net 1.1 web pages you can integrate either using url integration or
web services. BUT, the new controls from VS 2005 allow much easier and
tighter integration. The new controls require asp.net 2.0 (2.0 framework).
You can definitely have both 1.1 and 2.0 framework on the same IIS server.
If you want the new controls then buy VB.Net professional (cheapest way to
get the new controls).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Margo Noreen" <margo_no_spam@.on2morning.com> wrote in message
news:eAHcFxLBGHA.2788@.TK2MSFTNGP14.phx.gbl...
> I'm looking for information on how the various pieces/parts of RS could
> work in our environment. Currently that:
> + several SQL Server 2000 boxes (individual instances on individual and
> distinct servers) on Windows Server 2003.
> + multiple load balanced web servers running on Windows 2000 with IIS5,
> mixture of "classic" ASP and .NET web applications authored in Visual
> Studio, Visual Studio .NET 2003.
> We have a need to implement Reporting Services, but are confused about the
> path to take. My instinct tells me to start a brand new implementation of
> RS by using SQL 2005. For us, that should not be a problem. We could
> easily take one of our SQL 2k boxes and upgrade to SQL 2005.
> But now the questions are related to the implications on our .NET
> development and production/runtime environments.
> 1) do we need to install .NET 2.0 on our web servers? (I'm assuming yes)
> 2) will this impact our existing .NET 1.1 applications in anyway?
> 3) what about our developers, all set up already w/ Visual Studio .NET
> 2003 and ASP.NET 1.1? Will they need install Visual Studio .NET 2005 and
> ASP.NET 2.0? Will this affect their existing visual studio projects?
> Or, to minimize the impact, will only report *authors* need to have VS
> 2005?
> 4) To make reports available on our existing ASP.NET 1.1 based intranet,
> do we need to have ASP.NET 2.0 web pages developed or can existing ASP.NET
> 1.1 web pages work?
> Hopefully this gives you the gist of the kind of technical nitty-gritty
> I'm after. Any links, direct info, etc. would be greatly appreciated.
> Thanks.
> -- Margo
>
>|||Thank you for the quick reply Bruce... this actually confirms what I was
reading and otherwise stitching together; it was nice to get another nod in
that direction... Seems like it shouldn't be so hard... <g>.
-- Margo
Showing posts with label mixed. Show all posts
Showing posts with label mixed. Show all posts
Wednesday, March 21, 2012
Mixed Security Mode for MSDE?
Hi all... MSDE installs with pure Windows Security. Can it be
reconfigured to use mixed security? Does somebody know how this can be
done?
I have tried it using Enterprise Manager in a scenario where that tool
was availeable due to presence of SQL 2K Standard, however, MSDE did
not accept a configuration change to mixed security mode.
Somebody's got a clue?
Tim
hi Tim,
"Tim" <TimWalter@.hotmail.com> ha scritto nel messaggio
news:ca5b4dee.0410200712.4615c0a7@.posting.google.c om
> Hi all... MSDE installs with pure Windows Security. Can it be
> reconfigured to use mixed security? Does somebody know how this can be
> done?
> I have tried it using Enterprise Manager in a scenario where that tool
> was availeable due to presence of SQL 2K Standard, however, MSDE did
> not accept a configuration change to mixed security mode.
> Somebody's got a clue?
after modifying the Security mode via EM, you have to restart the server...
anyway, you can have a look at
http://support.microsoft.com/default...en-us;Q285097, in the part
regarding the window registry...
for your convenience, at the link following my sign., you can find a user
interface similar to Entrprise Manager where you can graphically perform
this task too..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
reconfigured to use mixed security? Does somebody know how this can be
done?
I have tried it using Enterprise Manager in a scenario where that tool
was availeable due to presence of SQL 2K Standard, however, MSDE did
not accept a configuration change to mixed security mode.
Somebody's got a clue?
Tim
hi Tim,
"Tim" <TimWalter@.hotmail.com> ha scritto nel messaggio
news:ca5b4dee.0410200712.4615c0a7@.posting.google.c om
> Hi all... MSDE installs with pure Windows Security. Can it be
> reconfigured to use mixed security? Does somebody know how this can be
> done?
> I have tried it using Enterprise Manager in a scenario where that tool
> was availeable due to presence of SQL 2K Standard, however, MSDE did
> not accept a configuration change to mixed security mode.
> Somebody's got a clue?
after modifying the Security mode via EM, you have to restart the server...
anyway, you can have a look at
http://support.microsoft.com/default...en-us;Q285097, in the part
regarding the window registry...
for your convenience, at the link following my sign., you can find a user
interface similar to Entrprise Manager where you can graphically perform
this task too..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
mixed recovery modes
Are there any limitations in SQL Server 2000, or 2005 in working with one
database in full recovery mode and another in simple recovery mode?
Under other platforms, you can't join between a logged and non-logged
database.
I think the answer is "no problem", but I would like to be sure.
In particular, I'm thinking about changing the recovery model of the
database drop off point to the search engine to simple, as its just a copy
and is reset daily from production.No problem. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospam@.nospam.org> wrote in message news:ec6fVRL8HHA.2004@.TK2MSFTNGP06.phx.gbl...
> Are there any limitations in SQL Server 2000, or 2005 in working with one database in full
> recovery mode and another in simple recovery mode?
> Under other platforms, you can't join between a logged and non-logged database.
> I think the answer is "no problem", but I would like to be sure.
> In particular, I'm thinking about changing the recovery model of the database drop off point to
> the search engine to simple, as its just a copy and is reset daily from production.
>|||ty sir.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eAGqgSL8HHA.1204@.TK2MSFTNGP03.phx.gbl...
> No problem. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:ec6fVRL8HHA.2004@.TK2MSFTNGP06.phx.gbl...
>> Are there any limitations in SQL Server 2000, or 2005 in working with one
>> database in full recovery mode and another in simple recovery mode?
>> Under other platforms, you can't join between a logged and non-logged
>> database.
>> I think the answer is "no problem", but I would like to be sure.
>> In particular, I'm thinking about changing the recovery model of the
>> database drop off point to the search engine to simple, as its just a
>> copy and is reset daily from production.
>
database in full recovery mode and another in simple recovery mode?
Under other platforms, you can't join between a logged and non-logged
database.
I think the answer is "no problem", but I would like to be sure.
In particular, I'm thinking about changing the recovery model of the
database drop off point to the search engine to simple, as its just a copy
and is reset daily from production.No problem. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospam@.nospam.org> wrote in message news:ec6fVRL8HHA.2004@.TK2MSFTNGP06.phx.gbl...
> Are there any limitations in SQL Server 2000, or 2005 in working with one database in full
> recovery mode and another in simple recovery mode?
> Under other platforms, you can't join between a logged and non-logged database.
> I think the answer is "no problem", but I would like to be sure.
> In particular, I'm thinking about changing the recovery model of the database drop off point to
> the search engine to simple, as its just a copy and is reset daily from production.
>|||ty sir.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eAGqgSL8HHA.1204@.TK2MSFTNGP03.phx.gbl...
> No problem. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:ec6fVRL8HHA.2004@.TK2MSFTNGP06.phx.gbl...
>> Are there any limitations in SQL Server 2000, or 2005 in working with one
>> database in full recovery mode and another in simple recovery mode?
>> Under other platforms, you can't join between a logged and non-logged
>> database.
>> I think the answer is "no problem", but I would like to be sure.
>> In particular, I'm thinking about changing the recovery model of the
>> database drop off point to the search engine to simple, as its just a
>> copy and is reset daily from production.
>
Mixed Portrait and Landscape
I want to print the first page of the report in the Portrait mode and the
subsequent pages in the Landscape mode. I don't know if it is doable in
RS2005. Any idear?
Thanks,It is not doable.
I've done something similar to this. What I did was, using data driven
subscriptions I created two sets of pdf documents (a set of portrait
and a set of landscape) and named them very similar to each other. For
example, sample_ltr.pdf and sample_rpt.pdf. Using a batch pdf printing
software, I was able to print the portrait which was the _ltr.pdf first
followed by the landscape document (_rpt.pdf).
Good luck
Isa Terzi * Senior Developer Analyst
Business Intelligence Team
Tower Group Companies
iterzi@.twrgrp.com
subsequent pages in the Landscape mode. I don't know if it is doable in
RS2005. Any idear?
Thanks,It is not doable.
I've done something similar to this. What I did was, using data driven
subscriptions I created two sets of pdf documents (a set of portrait
and a set of landscape) and named them very similar to each other. For
example, sample_ltr.pdf and sample_rpt.pdf. Using a batch pdf printing
software, I was able to print the portrait which was the _ltr.pdf first
followed by the landscape document (_rpt.pdf).
Good luck
Isa Terzi * Senior Developer Analyst
Business Intelligence Team
Tower Group Companies
iterzi@.twrgrp.com
Mixed Mode vs. Windows Authentication
I am trying to create a query that can determine if a user id is using mixed mode/windows/both authentication. I need to do this so that it can run on both sql server 2000 and 2005, meaning I can't use any of the sys.* views. Is there a single query could use for both systems?
-Kyle
-Kyle
Hi kschlap,
there is no method for your issue.
but maybe you can try to build a view to select cross these 2 servers.
create view v_loginid_info
as
select 'servname'='mssql2k', loginid
from mssql2k.master.dbo.sysprocesses
union all
select 'servname'='mssql2k05', loginid
from mssql2k05.master.sys.sysprocess
try to think about.
hoping this can help you.
Best Regrads,
Hunt.
|||I have found the query...select name, is_policy_checked
from sys.sql_logins
When I use this query, it doesn't pick up the windows authenticated users. Is there a way to get it to pick up all users?
-Kyle|||
How about something like this:
select name, isntuser from syslogins
isntuser=1 means Windows authentication
isntuser=0 means SQL Server authentication
Ben
sqlMixed mode user name conflict
I'm adding a domain user and there appears to be massive confusion within
SQL 2000 Enterprise Manager when the the domain user is the same as the
mixed mode SQL authentication name, as in
Mixed Mode username = myUserName
Windows Domain Name = myDomain\MyUserName
attempting to give database access to the domain user thru the
Security->logins screen results in
Err 21002 SQL-DMO user 'myUserName'already exists
but you can add it through the database/users screen.
I haven't tried it with 2005 yet...Enterprise Manager isn't actually confused - it is just
preventing you from adding duplicate user names in the
database. The problem is that Enterprise Manager uses
different default database names for Windows logins
depending on how you add the user to the database
When you add the user myDomain\MyUserName to a database from
the Logins in Enterprise Manager, the default database user
name will be MyUserName.
When you add it to the database from the Database Users node
in Enterprise Manager, the default database user name is
myDomain\MyUserName.
When you go to add the user through either methods in
Enterprise Manager, you can modify the default user name for
the database. If you have or will have SQL logins with the
same names as Windows logins without the domain, add the
Windows logins to databases using the domain prefix.
Or you can avoid it by using Query Analyzer and using
sp_grantdbacess 'LoginName'
By default, the login name (with the prefix for windows
logins) will be used. You can specify your own database user
name but the default will work in your case.
-Sue
On Wed, 9 Aug 2006 12:13:26 -0600, "mark gross"
<mgross@.deq.idaho.gov> wrote:
>I'm adding a domain user and there appears to be massive confusion within
>SQL 2000 Enterprise Manager when the the domain user is the same as the
>mixed mode SQL authentication name, as in
>Mixed Mode username = myUserName
>Windows Domain Name = myDomain\MyUserName
>attempting to give database access to the domain user thru the
>Security->logins screen results in
> Err 21002 SQL-DMO user 'myUserName'already exists
>but you can add it through the database/users screen.
>I haven't tried it with 2005 yet...
>
SQL 2000 Enterprise Manager when the the domain user is the same as the
mixed mode SQL authentication name, as in
Mixed Mode username = myUserName
Windows Domain Name = myDomain\MyUserName
attempting to give database access to the domain user thru the
Security->logins screen results in
Err 21002 SQL-DMO user 'myUserName'already exists
but you can add it through the database/users screen.
I haven't tried it with 2005 yet...Enterprise Manager isn't actually confused - it is just
preventing you from adding duplicate user names in the
database. The problem is that Enterprise Manager uses
different default database names for Windows logins
depending on how you add the user to the database
When you add the user myDomain\MyUserName to a database from
the Logins in Enterprise Manager, the default database user
name will be MyUserName.
When you add it to the database from the Database Users node
in Enterprise Manager, the default database user name is
myDomain\MyUserName.
When you go to add the user through either methods in
Enterprise Manager, you can modify the default user name for
the database. If you have or will have SQL logins with the
same names as Windows logins without the domain, add the
Windows logins to databases using the domain prefix.
Or you can avoid it by using Query Analyzer and using
sp_grantdbacess 'LoginName'
By default, the login name (with the prefix for windows
logins) will be used. You can specify your own database user
name but the default will work in your case.
-Sue
On Wed, 9 Aug 2006 12:13:26 -0600, "mark gross"
<mgross@.deq.idaho.gov> wrote:
>I'm adding a domain user and there appears to be massive confusion within
>SQL 2000 Enterprise Manager when the the domain user is the same as the
>mixed mode SQL authentication name, as in
>Mixed Mode username = myUserName
>Windows Domain Name = myDomain\MyUserName
>attempting to give database access to the domain user thru the
>Security->logins screen results in
> Err 21002 SQL-DMO user 'myUserName'already exists
>but you can add it through the database/users screen.
>I haven't tried it with 2005 yet...
>
Mixed mode to Windows mode without trace....
Hi folks,
I have a SQL 2005 OTC. CTP version running on Windows 2003 server.
I would like to find out how the SQL server option changed to Windows Authentication mode from Mixed mode over the weekend. From the SQL log, I don't see when it changed. I would like to see Date/Time and client IP. If I can see User ID (windows) that would be great. Where I can find these info in SQL server?
Thank you in advance...
SHJ
If you were not explicitly auditing server logins during that period, you cannot obtain this information later. Also, an authentication mode change will not take effect until the server is restarted. Was your server restarted over the week-end? You should be able to see this from the errorlogs because a new errorlog would be started.
Thanks
Laurentiu
Mixed mode to Windows mode without trace....
Hi folks,
I have a SQL 2005 OTC. CTP version running on Windows 2003 server.
I would like to find out how the SQL server option changed to Windows Authentication mode from Mixed mode over the weekend. From the SQL log, I don't see when it changed. I would like to see Date/Time and client IP. If I can see User ID (windows) that would be great. Where I can find these info in SQL server?
Thank you in advance...
SHJ
If you were not explicitly auditing server logins during that period, you cannot obtain this information later. Also, an authentication mode change will not take effect until the server is restarted. Was your server restarted over the week-end? You should be able to see this from the errorlogs because a new errorlog would be started.
Thanks
Laurentiu
Mixed mode security on XP
Hi,
I am trying to get a demo going on an XP laptop.
To do this I am trying to set Authentication on the server Security tb to
"SQL Server and Windows".
Changing this setting is not sticking. IE I make the change, click OK, check
and the change is gone. If I restart SQL Server, the change is not there.
HELP!
TIA
-TimWhoops. I did not have SP3a in...
"Mercury" <me@.spam.com> wrote in message
news:d3dhcp$i08$1@.lust.ihug.co.nz...
> Hi,
> I am trying to get a demo going on an XP laptop.
> To do this I am trying to set Authentication on the server Security tb to
> "SQL Server and Windows".
> Changing this setting is not sticking. IE I make the change, click OK,
> check and the change is gone. If I restart SQL Server, the change is not
> there.
> HELP!
> TIA
> -Tim
>
I am trying to get a demo going on an XP laptop.
To do this I am trying to set Authentication on the server Security tb to
"SQL Server and Windows".
Changing this setting is not sticking. IE I make the change, click OK, check
and the change is gone. If I restart SQL Server, the change is not there.
HELP!
TIA
-TimWhoops. I did not have SP3a in...
"Mercury" <me@.spam.com> wrote in message
news:d3dhcp$i08$1@.lust.ihug.co.nz...
> Hi,
> I am trying to get a demo going on an XP laptop.
> To do this I am trying to set Authentication on the server Security tb to
> "SQL Server and Windows".
> Changing this setting is not sticking. IE I make the change, click OK,
> check and the change is gone. If I restart SQL Server, the change is not
> there.
> HELP!
> TIA
> -Tim
>
Mixed mode security
Hello all,
I'm trying to modify the security setting for a local install to m ake
it mixed mode, but in the SQL Server properties window I select SQL
Server and Windows then press OK, but the window doesn't close and it
won't let me save the settings. Why is this? Can anyone help?
Thanks,
JonIt would help if you specify the version and editions
"Jon" <JonMYates@.gmail.com> wrote in message
news:1191402457.786282.106960@.57g2000hsv.googlegroups.com...
> Hello all,
> I'm trying to modify the security setting for a local install to m ake
> it mixed mode, but in the SQL Server properties window I select SQL
> Server and Windows then press OK, but the window doesn't close and it
> won't let me save the settings. Why is this? Can anyone help?
> Thanks,
> Jon
>sql
I'm trying to modify the security setting for a local install to m ake
it mixed mode, but in the SQL Server properties window I select SQL
Server and Windows then press OK, but the window doesn't close and it
won't let me save the settings. Why is this? Can anyone help?
Thanks,
JonIt would help if you specify the version and editions
"Jon" <JonMYates@.gmail.com> wrote in message
news:1191402457.786282.106960@.57g2000hsv.googlegroups.com...
> Hello all,
> I'm trying to modify the security setting for a local install to m ake
> it mixed mode, but in the SQL Server properties window I select SQL
> Server and Windows then press OK, but the window doesn't close and it
> won't let me save the settings. Why is this? Can anyone help?
> Thanks,
> Jon
>sql
Mixed mode in the NT Domain World
does anyone have a Microsoft Documented process map of how the security mode
l
works for a SQL Server 7 and/or 2000 in a NT Domain Security?I think this will answer your question.
http://www.microsoft.com/technet/pr...n/sp3sec01.mspx
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Actually, it is not clear as to what I am looking for. We are performing an
IT Audit for SOX.
The sql box is part of a NT Domain. We ran a select statement from the sql
box from sys logins where password is null. It produced a list of Domain ID
s
with null passwords. So the questions is, could I use a domain id from a
non-trusted connection to attach to the database?
Does this make sense?
Thanks
Rob
"Kevin McDonnell [MSFT]" wrote:
> I think this will answer your question.
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec01.mspx[/ur
l]
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||So the questions is, could I use a domain id from a
non-trusted connection to attach to the database?
Yes. If the same username and password is duplicated on the non-trusted
domain.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
l
works for a SQL Server 7 and/or 2000 in a NT Domain Security?I think this will answer your question.
http://www.microsoft.com/technet/pr...n/sp3sec01.mspx
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Actually, it is not clear as to what I am looking for. We are performing an
IT Audit for SOX.
The sql box is part of a NT Domain. We ran a select statement from the sql
box from sys logins where password is null. It produced a list of Domain ID
s
with null passwords. So the questions is, could I use a domain id from a
non-trusted connection to attach to the database?
Does this make sense?
Thanks
Rob
"Kevin McDonnell [MSFT]" wrote:
> I think this will answer your question.
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec01.mspx[/ur
l]
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||So the questions is, could I use a domain id from a
non-trusted connection to attach to the database?
Yes. If the same username and password is duplicated on the non-trusted
domain.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
mixed mode does not work
I have recently set the security mode to Mixed mode for SQL2005 running on
Win XP Pro SP-2. I want to be able to access the database from other
machines using the sa password. This I can do but I am no longer able to
use the WinNT authen. for local access. What gives?
ThanksLarry - I have only seen this when the user's windows password has
expiredbut they are still logged on in windows and try to access sql
server - any chance this is the case?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||I don't think that is it. But you may be on the right track. I often use a
cached profile, I.e. I am not connected to my domain but still use a Domain
login. If that is the case, SQL server would not be able to validate my
authentication while I am not connected to the server. Of course, I can
test this when I am in the office or possible while I have a VPN open to the
Domain server.
Thanks,
Larry
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ODg6C67OHHA.4172@.TK2MSFTNGP03.phx.gbl...
> Larry - I have only seen this when the user's windows password has
> expiredbut they are still logged on in windows and try to access sql
> server - any chance this is the case?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
Win XP Pro SP-2. I want to be able to access the database from other
machines using the sa password. This I can do but I am no longer able to
use the WinNT authen. for local access. What gives?
ThanksLarry - I have only seen this when the user's windows password has
expiredbut they are still logged on in windows and try to access sql
server - any chance this is the case?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||I don't think that is it. But you may be on the right track. I often use a
cached profile, I.e. I am not connected to my domain but still use a Domain
login. If that is the case, SQL server would not be able to validate my
authentication while I am not connected to the server. Of course, I can
test this when I am in the office or possible while I have a VPN open to the
Domain server.
Thanks,
Larry
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ODg6C67OHHA.4172@.TK2MSFTNGP03.phx.gbl...
> Larry - I have only seen this when the user's windows password has
> expiredbut they are still logged on in windows and try to access sql
> server - any chance this is the case?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
mixed mode does not work
I have recently set the security mode to Mixed mode for SQL2005 running on
Win XP Pro SP-2. I want to be able to access the database from other
machines using the sa password. This I can do but I am no longer able to
use the WinNT authen. for local access. What gives?
ThanksLarry - I have only seen this when the user's windows password has
expiredbut they are still logged on in windows and try to access sql
server - any chance this is the case?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||I don't think that is it. But you may be on the right track. I often use a
cached profile, I.e. I am not connected to my domain but still use a Domain
login. If that is the case, SQL server would not be able to validate my
authentication while I am not connected to the server. Of course, I can
test this when I am in the office or possible while I have a VPN open to the
Domain server.
Thanks,
Larry
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ODg6C67OHHA.4172@.TK2MSFTNGP03.phx.gbl...
> Larry - I have only seen this when the user's windows password has
> expiredbut they are still logged on in windows and try to access sql
> server - any chance this is the case?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
Win XP Pro SP-2. I want to be able to access the database from other
machines using the sa password. This I can do but I am no longer able to
use the WinNT authen. for local access. What gives?
ThanksLarry - I have only seen this when the user's windows password has
expiredbut they are still logged on in windows and try to access sql
server - any chance this is the case?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||I don't think that is it. But you may be on the right track. I often use a
cached profile, I.e. I am not connected to my domain but still use a Domain
login. If that is the case, SQL server would not be able to validate my
authentication while I am not connected to the server. Of course, I can
test this when I am in the office or possible while I have a VPN open to the
Domain server.
Thanks,
Larry
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ODg6C67OHHA.4172@.TK2MSFTNGP03.phx.gbl...
> Larry - I have only seen this when the user's windows password has
> expiredbut they are still logged on in windows and try to access sql
> server - any chance this is the case?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
mixed mode does not work
I have recently set the security mode to Mixed mode for SQL2005 running on
Win XP Pro SP-2. I want to be able to access the database from other
machines using the sa password. This I can do but I am no longer able to
use the WinNT authen. for local access. What gives?
Thanks
Larry - I have only seen this when the user's windows password has
expiredbut they are still logged on in windows and try to access sql
server - any chance this is the case?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I don't think that is it. But you may be on the right track. I often use a
cached profile, I.e. I am not connected to my domain but still use a Domain
login. If that is the case, SQL server would not be able to validate my
authentication while I am not connected to the server. Of course, I can
test this when I am in the office or possible while I have a VPN open to the
Domain server.
Thanks,
Larry
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ODg6C67OHHA.4172@.TK2MSFTNGP03.phx.gbl...
> Larry - I have only seen this when the user's windows password has
> expiredbut they are still logged on in windows and try to access sql
> server - any chance this is the case?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
Win XP Pro SP-2. I want to be able to access the database from other
machines using the sa password. This I can do but I am no longer able to
use the WinNT authen. for local access. What gives?
Thanks
Larry - I have only seen this when the user's windows password has
expiredbut they are still logged on in windows and try to access sql
server - any chance this is the case?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I don't think that is it. But you may be on the right track. I often use a
cached profile, I.e. I am not connected to my domain but still use a Domain
login. If that is the case, SQL server would not be able to validate my
authentication while I am not connected to the server. Of course, I can
test this when I am in the office or possible while I have a VPN open to the
Domain server.
Thanks,
Larry
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ODg6C67OHHA.4172@.TK2MSFTNGP03.phx.gbl...
> Larry - I have only seen this when the user's windows password has
> expiredbut they are still logged on in windows and try to access sql
> server - any chance this is the case?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
Mixed mode cluster?
Does any one have experiences with Mixed mode cluster?
I am trying to add a windows 2003 node as primary node to an existing
window 2000 active passive cluster.
Here is what i did:
From WINDOWS 2000 Active/Passive SQL 2000 cluster, Evicted the PRimary node.
Loaded WINDOWS 2003 onto the primary node.
It is a new intstall of WINDOWS 2003 not upgrade from 2000 to 2003.
NOw i am trying to join this node to the cluster but it is not able to find
the cluster service on the primary node which has windows 2003.
And i get the error 0x87000b.
Thanks
Anand
Primary and Secondary nodes are a concept from SQL 7.0 and do not apply to
this situation. You need to run the cluster wizard on the Windows 2003 node
and add it to the existing cluster. This is assuming the new node has
proper access to the shared storage system.
I am not sure if it will work. The only time I have run a mixed mode
cluster was while I was upgrading the hosts. Once I upgraded, I went back
and rebuilt each node from scratch, just so I would have a clean install of
Windows 2003.
Good luck.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Anand Musunur" <AnandMusunur@.discussions.microsoft.com> wrote in message
news:33E8488F-86D5-46DD-AF7B-09E6BA5645EA@.microsoft.com...
> Does any one have experiences with Mixed mode cluster?
> I am trying to add a windows 2003 node as primary node to an existing
> window 2000 active passive cluster.
> Here is what i did:
> From WINDOWS 2000 Active/Passive SQL 2000 cluster, Evicted the PRimary
node.
> Loaded WINDOWS 2003 onto the primary node.
> It is a new intstall of WINDOWS 2003 not upgrade from 2000 to 2003.
> NOw i am trying to join this node to the cluster but it is not able to
find
> the cluster service on the primary node which has windows 2003.
> And i get the error 0x87000b.
> Thanks
> Anand
sql
I am trying to add a windows 2003 node as primary node to an existing
window 2000 active passive cluster.
Here is what i did:
From WINDOWS 2000 Active/Passive SQL 2000 cluster, Evicted the PRimary node.
Loaded WINDOWS 2003 onto the primary node.
It is a new intstall of WINDOWS 2003 not upgrade from 2000 to 2003.
NOw i am trying to join this node to the cluster but it is not able to find
the cluster service on the primary node which has windows 2003.
And i get the error 0x87000b.
Thanks
Anand
Primary and Secondary nodes are a concept from SQL 7.0 and do not apply to
this situation. You need to run the cluster wizard on the Windows 2003 node
and add it to the existing cluster. This is assuming the new node has
proper access to the shared storage system.
I am not sure if it will work. The only time I have run a mixed mode
cluster was while I was upgrading the hosts. Once I upgraded, I went back
and rebuilt each node from scratch, just so I would have a clean install of
Windows 2003.
Good luck.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Anand Musunur" <AnandMusunur@.discussions.microsoft.com> wrote in message
news:33E8488F-86D5-46DD-AF7B-09E6BA5645EA@.microsoft.com...
> Does any one have experiences with Mixed mode cluster?
> I am trying to add a windows 2003 node as primary node to an existing
> window 2000 active passive cluster.
> Here is what i did:
> From WINDOWS 2000 Active/Passive SQL 2000 cluster, Evicted the PRimary
node.
> Loaded WINDOWS 2003 onto the primary node.
> It is a new intstall of WINDOWS 2003 not upgrade from 2000 to 2003.
> NOw i am trying to join this node to the cluster but it is not able to
find
> the cluster service on the primary node which has windows 2003.
> And i get the error 0x87000b.
> Thanks
> Anand
sql
Mixed Mode Authentication Conversion-Post Setup
I need help changing the authentication mode from Windows Authentication to Mixed Mode (for Project Server 2003). I am unable to find the Enterprise Management area. Evidently in this area, I can make this change. Is this the place to make these changes, or is there a better place? I am a novice, only days into this process. I need to setup a Project Server, and it needs Sql to breathe. Please help me!!
Kristoff, what SKU of SQL Server 2005 are you using? Standard, eval, etc? You should be able to go to the start menu and launch /SQL Server Management Studio from there. Are you seeing it there?
Thanks,
Sam Lester (MSFT)
Mixed Mode Authentication
What do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>
No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx.gbl...[vbcol=seagreen]
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> Server on my network, I
> tells me that my
> installation.
> with "Windows Only" will
> services and still no
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>
No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx.gbl...[vbcol=seagreen]
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> Server on my network, I
> tells me that my
> installation.
> with "Windows Only" will
> services and still no
Mixed Mode Authentication
What do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx
.gbl...[vbcol=seagreen]
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> Server on my network, I
> tells me that my
> installation.
> with "Windows Only" will
> services and still no
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx
.gbl...[vbcol=seagreen]
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> Server on my network, I
> tells me that my
> installation.
> with "Windows Only" will
> services and still no
Mixed Mode Authentication
Hi folks,
I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
am trying to install project server 2003. Project server tells me that my
SQL server must be in Mixed mode to complete the installation.
The problem is that the server which was installed with "Windows Only" will
not switch to "Windows and SQL". I have restarted the services and still no
joy, what else can I do to change to mixed mode?
thanks
DaveDavid,
Is SQL Server a local administrator on the machine? Does it have access
to the registry? This state is stored in the registry, and if SQL Server
doesn't have write permission to the registry it could fail.
The registry key is
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft
SQLServer\<instance_name>\MSSQLServer\LoginMode
The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
may still see 0 for SQL Server only (servers upgraded from 6.5).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Hi folks,
> I have a microsoft SQL server 2000 on a Windows 2003 Server on my network,
I
> am trying to install project server 2003. Project server tells me that my
> SQL server must be in Mixed mode to complete the installation.
> The problem is that the server which was installed with "Windows Only" wil
l
> not switch to "Windows and SQL". I have restarted the services and still n
o
> joy, what else can I do to change to mixed mode?
> thanks
> Dave
>|||Hi Mark,
thanks for that, your correct, the currently logged on user which I thought
was part of the local administrators group isn't.
oh the joys
thanks
Dave
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
network, I[vbcol=seagreen]
my[vbcol=seagreen]
will[vbcol=seagreen]
no[vbcol=seagreen]|||Just thought of something there, what do you mean is the "SQL Server" a
local administrator on the machine?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
network, I[vbcol=seagreen]
my[vbcol=seagreen]
will[vbcol=seagreen]
no[vbcol=seagreen]|||David,
What I meant was, is the Windows Domain Account that the MSSQLServer
service logs on under, a member of the Local Administrators group on the
server.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Just thought of something there, what do you mean is the "SQL Server" a
> local administrator on the machine?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
>
> network, I
>
> my
>
> will
>
> no
>
>
>|||No but it is part of the "domain admins" group which is part of the "local
admins" group so permissions look ok.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23gMxADDaEHA.2892@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> David,
> What I meant was, is the Windows Domain Account that the MSSQLServer
> service logs on under, a member of the Local Administrators group on the
> server.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
still[vbcol=seagreen]
I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
am trying to install project server 2003. Project server tells me that my
SQL server must be in Mixed mode to complete the installation.
The problem is that the server which was installed with "Windows Only" will
not switch to "Windows and SQL". I have restarted the services and still no
joy, what else can I do to change to mixed mode?
thanks
DaveDavid,
Is SQL Server a local administrator on the machine? Does it have access
to the registry? This state is stored in the registry, and if SQL Server
doesn't have write permission to the registry it could fail.
The registry key is
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft
SQLServer\<instance_name>\MSSQLServer\LoginMode
The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
may still see 0 for SQL Server only (servers upgraded from 6.5).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Hi folks,
> I have a microsoft SQL server 2000 on a Windows 2003 Server on my network,
I
> am trying to install project server 2003. Project server tells me that my
> SQL server must be in Mixed mode to complete the installation.
> The problem is that the server which was installed with "Windows Only" wil
l
> not switch to "Windows and SQL". I have restarted the services and still n
o
> joy, what else can I do to change to mixed mode?
> thanks
> Dave
>|||Hi Mark,
thanks for that, your correct, the currently logged on user which I thought
was part of the local administrators group isn't.
oh the joys
thanks
Dave
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
network, I[vbcol=seagreen]
my[vbcol=seagreen]
will[vbcol=seagreen]
no[vbcol=seagreen]|||Just thought of something there, what do you mean is the "SQL Server" a
local administrator on the machine?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
network, I[vbcol=seagreen]
my[vbcol=seagreen]
will[vbcol=seagreen]
no[vbcol=seagreen]|||David,
What I meant was, is the Windows Domain Account that the MSSQLServer
service logs on under, a member of the Local Administrators group on the
server.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Just thought of something there, what do you mean is the "SQL Server" a
> local administrator on the machine?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
>
> network, I
>
> my
>
> will
>
> no
>
>
>|||No but it is part of the "domain admins" group which is part of the "local
admins" group so permissions look ok.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23gMxADDaEHA.2892@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> David,
> What I meant was, is the Windows Domain Account that the MSSQLServer
> service logs on under, a member of the Local Administrators group on the
> server.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
still[vbcol=seagreen]
Mixed Mode Authentication
Hi folks,
I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
am trying to install project server 2003. Project server tells me that my
SQL server must be in Mixed mode to complete the installation.
The problem is that the server which was installed with "Windows Only" will
not switch to "Windows and SQL". I have restarted the services and still no
joy, what else can I do to change to mixed mode?
thanks
DaveWhat do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>|||David,
Is SQL Server a local administrator on the machine? Does it have access
to the registry? This state is stored in the registry, and if SQL Server
doesn't have write permission to the registry it could fail.
The registry key is
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQLServer\<instance_name>\MSSQLServer\LoginMode
The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
may still see 0 for SQL Server only (servers upgraded from 6.5).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Hi folks,
> I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
> am trying to install project server 2003. Project server tells me that my
> SQL server must be in Mixed mode to complete the installation.
> The problem is that the server which was installed with "Windows Only" will
> not switch to "Windows and SQL". I have restarted the services and still no
> joy, what else can I do to change to mixed mode?
> thanks
> Dave
>|||No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle :)
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx.gbl...
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> >--Original Message--
> >Hi folks,
> >
> >I have a microsoft SQL server 2000 on a Windows 2003
> Server on my network, I
> >am trying to install project server 2003. Project server
> tells me that my
> >SQL server must be in Mixed mode to complete the
> installation.
> >
> >The problem is that the server which was installed
> with "Windows Only" will
> >not switch to "Windows and SQL". I have restarted the
> services and still no
> >joy, what else can I do to change to mixed mode?
> >
> >thanks
> >Dave
> >
> >
> >.
> >|||Hi Mark,
thanks for that, your correct, the currently logged on user which I thought
was part of the local administrators group isn't.
oh the joys
thanks
Dave
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||Just thought of something there, what do you mean is the "SQL Server" a
local administrator on the machine?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||David,
What I meant was, is the Windows Domain Account that the MSSQLServer
service logs on under, a member of the Local Administrators group on the
server.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Just thought of something there, what do you mean is the "SQL Server" a
> local administrator on the machine?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
>>David,
>>Is SQL Server a local administrator on the machine? Does it have access
>>to the registry? This state is stored in the registry, and if SQL Server
>>doesn't have write permission to the registry it could fail.
>>The registry key is
>>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
>>SQLServer\<instance_name>\MSSQLServer\LoginMode
>>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
>>may still see 0 for SQL Server only (servers upgraded from 6.5).
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>David Hodgson wrote:
>>Hi folks,
>>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> network, I
>>am trying to install project server 2003. Project server tells me that
> my
>>SQL server must be in Mixed mode to complete the installation.
>>The problem is that the server which was installed with "Windows Only"
> will
>>not switch to "Windows and SQL". I have restarted the services and still
> no
>>joy, what else can I do to change to mixed mode?
>>thanks
>>Dave
>>
>
>|||No but it is part of the "domain admins" group which is part of the "local
admins" group so permissions look ok.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23gMxADDaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> David,
> What I meant was, is the Windows Domain Account that the MSSQLServer
> service logs on under, a member of the Local Administrators group on the
> server.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Just thought of something there, what do you mean is the "SQL Server" a
> > local administrator on the machine?
> >
> >
> > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> >
> >>David,
> >>
> >>Is SQL Server a local administrator on the machine? Does it have access
> >>to the registry? This state is stored in the registry, and if SQL Server
> >>doesn't have write permission to the registry it could fail.
> >>
> >>The registry key is
> >>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> >>SQLServer\<instance_name>\MSSQLServer\LoginMode
> >>
> >>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> >>may still see 0 for SQL Server only (servers upgraded from 6.5).
> >>
> >>--
> >>Mark Allison, SQL Server MVP
> >>http://www.markallison.co.uk
> >>
> >>Looking for a SQL Server replication book?
> >>http://www.nwsu.com/0974973602.html
> >>
> >>
> >>
> >>David Hodgson wrote:
> >>
> >>Hi folks,
> >>
> >>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> >
> > network, I
> >
> >>am trying to install project server 2003. Project server tells me that
> >
> > my
> >
> >>SQL server must be in Mixed mode to complete the installation.
> >>
> >>The problem is that the server which was installed with "Windows Only"
> >
> > will
> >
> >>not switch to "Windows and SQL". I have restarted the services and
still
> >
> > no
> >
> >>joy, what else can I do to change to mixed mode?
> >>
> >>thanks
> >>Dave
> >>
> >>
> >
> >
> >sql
I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
am trying to install project server 2003. Project server tells me that my
SQL server must be in Mixed mode to complete the installation.
The problem is that the server which was installed with "Windows Only" will
not switch to "Windows and SQL". I have restarted the services and still no
joy, what else can I do to change to mixed mode?
thanks
DaveWhat do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>|||David,
Is SQL Server a local administrator on the machine? Does it have access
to the registry? This state is stored in the registry, and if SQL Server
doesn't have write permission to the registry it could fail.
The registry key is
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQLServer\<instance_name>\MSSQLServer\LoginMode
The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
may still see 0 for SQL Server only (servers upgraded from 6.5).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Hi folks,
> I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
> am trying to install project server 2003. Project server tells me that my
> SQL server must be in Mixed mode to complete the installation.
> The problem is that the server which was installed with "Windows Only" will
> not switch to "Windows and SQL". I have restarted the services and still no
> joy, what else can I do to change to mixed mode?
> thanks
> Dave
>|||No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle :)
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx.gbl...
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> >--Original Message--
> >Hi folks,
> >
> >I have a microsoft SQL server 2000 on a Windows 2003
> Server on my network, I
> >am trying to install project server 2003. Project server
> tells me that my
> >SQL server must be in Mixed mode to complete the
> installation.
> >
> >The problem is that the server which was installed
> with "Windows Only" will
> >not switch to "Windows and SQL". I have restarted the
> services and still no
> >joy, what else can I do to change to mixed mode?
> >
> >thanks
> >Dave
> >
> >
> >.
> >|||Hi Mark,
thanks for that, your correct, the currently logged on user which I thought
was part of the local administrators group isn't.
oh the joys
thanks
Dave
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||Just thought of something there, what do you mean is the "SQL Server" a
local administrator on the machine?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||David,
What I meant was, is the Windows Domain Account that the MSSQLServer
service logs on under, a member of the Local Administrators group on the
server.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Just thought of something there, what do you mean is the "SQL Server" a
> local administrator on the machine?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
>>David,
>>Is SQL Server a local administrator on the machine? Does it have access
>>to the registry? This state is stored in the registry, and if SQL Server
>>doesn't have write permission to the registry it could fail.
>>The registry key is
>>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
>>SQLServer\<instance_name>\MSSQLServer\LoginMode
>>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
>>may still see 0 for SQL Server only (servers upgraded from 6.5).
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>David Hodgson wrote:
>>Hi folks,
>>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> network, I
>>am trying to install project server 2003. Project server tells me that
> my
>>SQL server must be in Mixed mode to complete the installation.
>>The problem is that the server which was installed with "Windows Only"
> will
>>not switch to "Windows and SQL". I have restarted the services and still
> no
>>joy, what else can I do to change to mixed mode?
>>thanks
>>Dave
>>
>
>|||No but it is part of the "domain admins" group which is part of the "local
admins" group so permissions look ok.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23gMxADDaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> David,
> What I meant was, is the Windows Domain Account that the MSSQLServer
> service logs on under, a member of the Local Administrators group on the
> server.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Just thought of something there, what do you mean is the "SQL Server" a
> > local administrator on the machine?
> >
> >
> > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> >
> >>David,
> >>
> >>Is SQL Server a local administrator on the machine? Does it have access
> >>to the registry? This state is stored in the registry, and if SQL Server
> >>doesn't have write permission to the registry it could fail.
> >>
> >>The registry key is
> >>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> >>SQLServer\<instance_name>\MSSQLServer\LoginMode
> >>
> >>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> >>may still see 0 for SQL Server only (servers upgraded from 6.5).
> >>
> >>--
> >>Mark Allison, SQL Server MVP
> >>http://www.markallison.co.uk
> >>
> >>Looking for a SQL Server replication book?
> >>http://www.nwsu.com/0974973602.html
> >>
> >>
> >>
> >>David Hodgson wrote:
> >>
> >>Hi folks,
> >>
> >>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> >
> > network, I
> >
> >>am trying to install project server 2003. Project server tells me that
> >
> > my
> >
> >>SQL server must be in Mixed mode to complete the installation.
> >>
> >>The problem is that the server which was installed with "Windows Only"
> >
> > will
> >
> >>not switch to "Windows and SQL". I have restarted the services and
still
> >
> > no
> >
> >>joy, what else can I do to change to mixed mode?
> >>
> >>thanks
> >>Dave
> >>
> >>
> >
> >
> >sql
Subscribe to:
Posts (Atom)