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 .
>
Showing posts with label sql2005. Show all posts
Showing posts with label sql2005. Show all posts
Wednesday, March 21, 2012
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 .
>
Monday, March 19, 2012
Mixed environment x64 and x86 (compatibility)
I have all sql servers running 32bit. We need another SQL cluster and I would
like to install SQL2005 x64. My concerns are the compatibility between
SQL2000 32bit, SQL2005 32bit and the new one:
questions:
can I restore a x64 database to a 32bit SQL Server?
Anyone has had compatibility issues using a mixed environment?
If there is no difference, why there are different AdventureWorks versions
(x64 and x86) to download?
http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
Microsoft says there is no problem, but I would like to hear some real
experience ..
thanks
Julio M
Hi
"Julio Mattos" wrote:
> I have all sql servers running 32bit. We need another SQL cluster and I would
> like to install SQL2005 x64. My concerns are the compatibility between
> SQL2000 32bit, SQL2005 32bit and the new one:
> questions:
> can I restore a x64 database to a 32bit SQL Server?
The backup file format is the same on both machines. The database file
format has not changed either, therefore you can move these from one platform
to the next without issues.
> Anyone has had compatibility issues using a mixed environment?
> If there is no difference, why there are different AdventureWorks versions
> (x64 and x86) to download?
> http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
This is probably because of the samples being deployed on different platforms.
> Microsoft says there is no problem, but I would like to hear some real
> experience ..
You should deploy this because you need a platform that is better suited for
the 64 bit environment i.e. better memory usage, better processors etc.
> thanks
> Julio M
>
John
like to install SQL2005 x64. My concerns are the compatibility between
SQL2000 32bit, SQL2005 32bit and the new one:
questions:
can I restore a x64 database to a 32bit SQL Server?
Anyone has had compatibility issues using a mixed environment?
If there is no difference, why there are different AdventureWorks versions
(x64 and x86) to download?
http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
Microsoft says there is no problem, but I would like to hear some real
experience ..
thanks
Julio M
Hi
"Julio Mattos" wrote:
> I have all sql servers running 32bit. We need another SQL cluster and I would
> like to install SQL2005 x64. My concerns are the compatibility between
> SQL2000 32bit, SQL2005 32bit and the new one:
> questions:
> can I restore a x64 database to a 32bit SQL Server?
The backup file format is the same on both machines. The database file
format has not changed either, therefore you can move these from one platform
to the next without issues.
> Anyone has had compatibility issues using a mixed environment?
> If there is no difference, why there are different AdventureWorks versions
> (x64 and x86) to download?
> http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
This is probably because of the samples being deployed on different platforms.
> Microsoft says there is no problem, but I would like to hear some real
> experience ..
You should deploy this because you need a platform that is better suited for
the 64 bit environment i.e. better memory usage, better processors etc.
> thanks
> Julio M
>
John
Mixed environment x64 and x86 (compatibility)
I have all sql servers running 32bit. We need another SQL cluster and I would
like to install SQL2005 x64. My concerns are the compatibility between
SQL2000 32bit, SQL2005 32bit and the new one:
questions:
can I restore a x64 database to a 32bit SQL Server?
Anyone has had compatibility issues using a mixed environment?
If there is no difference, why there are different AdventureWorks versions
(x64 and x86) to download?
http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
Microsoft says there is no problem, but I would like to hear some real
experience ..
thanks
Julio MHi
"Julio Mattos" wrote:
> I have all sql servers running 32bit. We need another SQL cluster and I would
> like to install SQL2005 x64. My concerns are the compatibility between
> SQL2000 32bit, SQL2005 32bit and the new one:
> questions:
> can I restore a x64 database to a 32bit SQL Server?
The backup file format is the same on both machines. The database file
format has not changed either, therefore you can move these from one platform
to the next without issues.
> Anyone has had compatibility issues using a mixed environment?
> If there is no difference, why there are different AdventureWorks versions
> (x64 and x86) to download?
> http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
This is probably because of the samples being deployed on different platforms.
> Microsoft says there is no problem, but I would like to hear some real
> experience ..
You should deploy this because you need a platform that is better suited for
the 64 bit environment i.e. better memory usage, better processors etc.
> thanks
> Julio M
>
John
like to install SQL2005 x64. My concerns are the compatibility between
SQL2000 32bit, SQL2005 32bit and the new one:
questions:
can I restore a x64 database to a 32bit SQL Server?
Anyone has had compatibility issues using a mixed environment?
If there is no difference, why there are different AdventureWorks versions
(x64 and x86) to download?
http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
Microsoft says there is no problem, but I would like to hear some real
experience ..
thanks
Julio MHi
"Julio Mattos" wrote:
> I have all sql servers running 32bit. We need another SQL cluster and I would
> like to install SQL2005 x64. My concerns are the compatibility between
> SQL2000 32bit, SQL2005 32bit and the new one:
> questions:
> can I restore a x64 database to a 32bit SQL Server?
The backup file format is the same on both machines. The database file
format has not changed either, therefore you can move these from one platform
to the next without issues.
> Anyone has had compatibility issues using a mixed environment?
> If there is no difference, why there are different AdventureWorks versions
> (x64 and x86) to download?
> http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
This is probably because of the samples being deployed on different platforms.
> Microsoft says there is no problem, but I would like to hear some real
> experience ..
You should deploy this because you need a platform that is better suited for
the 64 bit environment i.e. better memory usage, better processors etc.
> thanks
> Julio M
>
John
Mixed environment x64 and x86 (compatibility)
I have all sql servers running 32bit. We need another SQL cluster and I woul
d
like to install SQL2005 x64. My concerns are the compatibility between
SQL2000 32bit, SQL2005 32bit and the new one:
questions:
can I restore a x64 database to a 32bit SQL Server?
Anyone has had compatibility issues using a mixed environment?
If there is no difference, why there are different AdventureWorks versions
(x64 and x86) to download?
http://www.microsoft.com/downloads/...&displaylang=en
Microsoft says there is no problem, but I would like to hear some real
experience ..
thanks
Julio MHi
"Julio Mattos" wrote:
> I have all sql servers running 32bit. We need another SQL cluster and I wo
uld
> like to install SQL2005 x64. My concerns are the compatibility between
> SQL2000 32bit, SQL2005 32bit and the new one:
> questions:
> can I restore a x64 database to a 32bit SQL Server?
The backup file format is the same on both machines. The database file
format has not changed either, therefore you can move these from one platfor
m
to the next without issues.
> Anyone has had compatibility issues using a mixed environment?
> If there is no difference, why there are different AdventureWorks versions
> (x64 and x86) to download?
> http://www.microsoft.com/downloads/...&displaylang=en
This is probably because of the samples being deployed on different platform
s.
> Microsoft says there is no problem, but I would like to hear some real
> experience ..
You should deploy this because you need a platform that is better suited for
the 64 bit environment i.e. better memory usage, better processors etc.
> thanks
> Julio M
>
John
d
like to install SQL2005 x64. My concerns are the compatibility between
SQL2000 32bit, SQL2005 32bit and the new one:
questions:
can I restore a x64 database to a 32bit SQL Server?
Anyone has had compatibility issues using a mixed environment?
If there is no difference, why there are different AdventureWorks versions
(x64 and x86) to download?
http://www.microsoft.com/downloads/...&displaylang=en
Microsoft says there is no problem, but I would like to hear some real
experience ..
thanks
Julio MHi
"Julio Mattos" wrote:
> I have all sql servers running 32bit. We need another SQL cluster and I wo
uld
> like to install SQL2005 x64. My concerns are the compatibility between
> SQL2000 32bit, SQL2005 32bit and the new one:
> questions:
> can I restore a x64 database to a 32bit SQL Server?
The backup file format is the same on both machines. The database file
format has not changed either, therefore you can move these from one platfor
m
to the next without issues.
> Anyone has had compatibility issues using a mixed environment?
> If there is no difference, why there are different AdventureWorks versions
> (x64 and x86) to download?
> http://www.microsoft.com/downloads/...&displaylang=en
This is probably because of the samples being deployed on different platform
s.
> Microsoft says there is no problem, but I would like to hear some real
> experience ..
You should deploy this because you need a platform that is better suited for
the 64 bit environment i.e. better memory usage, better processors etc.
> thanks
> Julio M
>
John
Subscribe to:
Posts (Atom)