Hi Karen.
Yes it is possible to have Access subscribers:
see http://msdn.microsoft.com/library/en...lctem_0815.asp
And the Access DBs should be subscribers and the SQL server would be the
Publisher.
And YES switch to the MSDE instead of Access, for a lot of reasons.
(Compatibility, flexibility, openness in regard to debugging and error
logging, stability)
HTH
JorgenD.
"Karen Middleton" wrote:
> Hello All
> We have a computer based application running on trucks and they
> capture the transaction into a Access database we need to collect the
> data from multiple trucks into a SQL Server database centrally.
> Can somebody please explain whether Access can replicate to SQL Server
> with Access as publisher and SQL Server as the subscriber. Also, I am
> wondering is it worthwhile to replace Access by MSDE since MSDE is
> free I would appreciate your feedback on this count.
> Also, any books, web sites, white papers and how to setup a
> replication from Access to SQL Server. Also, can somebody please
> explain how the replication works from Access to SQL Server and is it
> lot of coding to get this working and what kind of replication is it
> full table or delta replication.
> Also, some of our trucks will be in far off places is there a nice way
> in which Access can be made to replicate from these remote sites to
> the central site what kind of comms do we need.
>
> Many thanks in advance for your inputs
> Thanks
> Karen
>
Karen,
I agree with Jorgen that MSDE would be preferable long-term. However, your
original question was about having Access as a publisher and SQL Server as a
subscriber, which is not available out of the box using Jet. If you have sql
server as a merge publisher and access as a subscriber, in many senses
datawise it will be functionally equivalent, but care will need taking with
administrtion and conflict resolution where the role of the publisher is
indeed distinct to the subscriber.
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]
sql
Showing posts with label msde. Show all posts
Showing posts with label msde. Show all posts
Friday, March 23, 2012
How to setup replication between access to SQL Server , MSDE inste
Hi Karen.
Yes it is possible to have Access subscribers:
see http://msdn.microsoft.com/library/en...lctem_0815.asp
And the Access DBs should be subscribers and the SQL server would be the
Publisher.
And YES switch to the MSDE instead of Access, for a lot of reasons.
(Compatibility, flexibility, openness in regard to debugging and error
logging, stability)
HTH
JorgenD.
"Karen Middleton" wrote:
> Hello All
> We have a computer based application running on trucks and they
> capture the transaction into a Access database we need to collect the
> data from multiple trucks into a SQL Server database centrally.
> Can somebody please explain whether Access can replicate to SQL Server
> with Access as publisher and SQL Server as the subscriber. Also, I am
> wondering is it worthwhile to replace Access by MSDE since MSDE is
> free I would appreciate your feedback on this count.
> Also, any books, web sites, white papers and how to setup a
> replication from Access to SQL Server. Also, can somebody please
> explain how the replication works from Access to SQL Server and is it
> lot of coding to get this working and what kind of replication is it
> full table or delta replication.
> Also, some of our trucks will be in far off places is there a nice way
> in which Access can be made to replicate from these remote sites to
> the central site what kind of comms do we need.
>
> Many thanks in advance for your inputs
> Thanks
> Karen
>
Karen,
I agree with Jorgen that MSDE would be preferable long-term. However, your
original question was about having Access as a publisher and SQL Server as a
subscriber, which is not available out of the box using Jet. If you have sql
server as a merge publisher and access as a subscriber, in many senses
datawise it will be functionally equivalent, but care will need taking with
administrtion and conflict resolution where the role of the publisher is
indeed distinct to the subscriber.
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]
Yes it is possible to have Access subscribers:
see http://msdn.microsoft.com/library/en...lctem_0815.asp
And the Access DBs should be subscribers and the SQL server would be the
Publisher.
And YES switch to the MSDE instead of Access, for a lot of reasons.
(Compatibility, flexibility, openness in regard to debugging and error
logging, stability)
HTH
JorgenD.
"Karen Middleton" wrote:
> Hello All
> We have a computer based application running on trucks and they
> capture the transaction into a Access database we need to collect the
> data from multiple trucks into a SQL Server database centrally.
> Can somebody please explain whether Access can replicate to SQL Server
> with Access as publisher and SQL Server as the subscriber. Also, I am
> wondering is it worthwhile to replace Access by MSDE since MSDE is
> free I would appreciate your feedback on this count.
> Also, any books, web sites, white papers and how to setup a
> replication from Access to SQL Server. Also, can somebody please
> explain how the replication works from Access to SQL Server and is it
> lot of coding to get this working and what kind of replication is it
> full table or delta replication.
> Also, some of our trucks will be in far off places is there a nice way
> in which Access can be made to replicate from these remote sites to
> the central site what kind of comms do we need.
>
> Many thanks in advance for your inputs
> Thanks
> Karen
>
Karen,
I agree with Jorgen that MSDE would be preferable long-term. However, your
original question was about having Access as a publisher and SQL Server as a
subscriber, which is not available out of the box using Jet. If you have sql
server as a merge publisher and access as a subscriber, in many senses
datawise it will be functionally equivalent, but care will need taking with
administrtion and conflict resolution where the role of the publisher is
indeed distinct to the subscriber.
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]
Monday, March 19, 2012
How to set up a username and password for MSDE
Hi,
I have installed MSDE using the following parameter:
commandline> setup SAPWD="MySAPwd"
now all was set up... when i opened the osql utility..i wasnt able to login... it kept asking me the login name ans password...
i entered my windows login name which is 'home' and entered 'kham00s' as the password... it didnt work... then i entered my windows login name again which is 'home' and entered 'OTHERPASSWORD' as the password which is my system password...but did not work either...
then i logged in using :
commandline> osql -E
It successfully logged in... and i was able to create databases and tables...
can someone tell me how to set a username and password for MSDE please... so that i can connect to MSDE using WebMatrix...
i m coming from a PHP/MySQL background so i know SQL and stuff... but dont know how to handle and configure MSSQL...
waiting for the response..
thanks in advance...
Bye.
Kamran.The SAPWD option sets the sa users password, and so you need to use a username of sa and the password you supplied.
I edited your message so that your passwaords are not visible...|||thanks douglas! :)
But can you plz tell me what is my sa username? i read the term 'sa' a lot in the msdn library but couldnt figure out what it means... it wud be gr8 if i get to know what is 'sa'...
btw thanks for editing...but the passwords i entered were not the real ones. ;)
looking forward to replies.. thanks...|||The sa password is 'sa' (without the quotes).|||thanks again...
but that isnt working either...
after installation.. i do this:
commandline> osql -U sa -P "mypwd"
also tried this:
commandline> osql -U sa -P mypwd
and this:
commandline> osql -U sa
enter password: (keyboard hits)
but doesnt connect either... tells me that 'sa' is an unknown user... etc...
plz help me... i can connect using the -E parameter...but i need to connect to MSDE using ASP.net Web Matrix... so plz help... many thanks...
regards,
Kamran.|||Here is the procedure for adding a user to a database (from the "Microsoft ASP.NET Programming C# .NET" book):
When you installed your .NET IDE, it should have set up an ASPNET Windows user account. ASP.NET is configured by default to use the unprivileged ASPNET account to run ASP.NET worker processes.
1)
comline: osql -E
2)
grant login access to the ASPNET account. <domain> is your local machine name.
1> sp_grantlogin '<domain>\ASPNET'
2> go
3)
call the sp_defaultdb system stored procedure to change the default database to the database you want ASPNET to use.
1> sp_defaultdb '<domain>\ASPNET', '<yourdatabasename>'
2> go
4)
add the ASPNET account to the db_datareader role.
1> sp_adduser '<domain>\ASPNET', 'ASPNET', 'db_datareader'
2> go
5)
to add ASPNET to the db_datawriter role, do:
1> sp_addrolemember 'db_datawriter', 'ASPNET'
2> go|||thanks everyone...
all is working fine now... thanks to douglas and dran001...
i m able to ger web matrix connect to the database...
btw i m unable to connect through web data administrator... thankx anyways...
i hav no probs 'inserting' using OSQL...
regards,
Kamran.
Monday, March 12, 2012
how to set sort order for MSDE 2000 A
I'm trying to make MSDE 2000A sort order case-insensitive accent-insensitive.
I have this in my setup.ini file:
[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
DATADIR="D:\"
AutoStart=255
[DlgCpSortUnicode-0]
SortId=54
LCID=1033
CompStyle=196611
It installs but sp_helpsort still says:
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page
1252 for non-Unicode Data
Is this supported? What do I have to do?
TIA
hi Evan,
evan[at]irtech[dot]com wrote:
> I'm trying to make MSDE 2000A sort order case-insensitive
> accent-insensitive.
> I have this in my setup.ini file:
> [Options]
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> DATADIR="D:\"
> AutoStart=255
> [DlgCpSortUnicode-0]
> SortId=54
> LCID=1033
> CompStyle=196611
> It installs but sp_helpsort still says:
> Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive, width-insensitive for Unicode Data, SQL Server
> Sort Order 52 on Code Page 1252 for non-Unicode Data
> Is this supported? What do I have to do?
> TIA
try using the SQL Server collation instead of Windows codes, like
setup.exe .... COLLATION="Latin1_General_CI_AI_KS_WS"
= Latin1-General, case-insensitive, accent-insensitive, kanatype-sensitive,
width-sensitive
you can inspect all available LatinXX collations executing
select * from ::fn_helpcollations()
where name like 'Latin%'
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks! I didn't know you could do that. I will give that a try later on
today.
Evan
"Andrea Montanari" wrote:
> hi Evan,
> evan[at]irtech[dot]com wrote:
> try using the SQL Server collation instead of Windows codes, like
> setup.exe .... COLLATION="Latin1_General_CI_AI_KS_WS"
> = Latin1-General, case-insensitive, accent-insensitive, kanatype-sensitive,
> width-sensitive
> you can inspect all available LatinXX collations executing
> select * from ::fn_helpcollations()
> where name like 'Latin%'
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||thanks Andrea. You rock! This worked.
Is there a list of collations somewhere?
When I try:
setup.exe .... COLLATION="Latin1_General_CI_AI_KI_WI"
which would match my SQL Server 2000 setup, the MSDE setup blows up during
cnfgsvr.
This is not a problem for me, but might be useful for future reference.
Thanks again!
"Andrea Montanari" wrote:
> hi Evan,
> evan[at]irtech[dot]com wrote:
> try using the SQL Server collation instead of Windows codes, like
> setup.exe .... COLLATION="Latin1_General_CI_AI_KS_WS"
> = Latin1-General, case-insensitive, accent-insensitive, kanatype-sensitive,
> width-sensitive
> you can inspect all available LatinXX collations executing
> select * from ::fn_helpcollations()
> where name like 'Latin%'
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Evan,
evan[at]irtech[dot]com wrote:
> thanks Andrea. You rock! This worked.
> Is there a list of collations somewhere?
> When I try:
> setup.exe .... COLLATION="Latin1_General_CI_AI_KI_WI"
> which would match my SQL Server 2000 setup, the MSDE setup blows up
> during cnfgsvr.
> This is not a problem for me, but might be useful for future
> reference.
http://msdn.microsoft.com/library/de...ation_6gfn.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I read the msdn article but im a little bit confused about the counting.
For instance if i login and transmit a batch of sql statements and log off
i use 3 operations ? or only 1 ? At the moment i use some like this : m_pRs-
>Open((LPCTSTR) strSQL, (LPCTSTR)strConnection, adOpenStatic,
adLockPessimistic , adCmdUnknown);
where m_pRs is a RecordSet.
Message posted via http://www.sqlmonster.com
|||Ups sorry wrong section ,(
Message posted via http://www.sqlmonster.com
|||What do AUTOSTART=255 ? I didnt find it in "Customizing Desktop Engine
Setup.exe"
Message posted via http://www.sqlmonster.com
|||hi Alexander,
Alexander Baumgart via SQLMonster.com wrote:
> What do AUTOSTART=255 ? I didnt find it in "Customizing Desktop Engine
> Setup.exe"
where did you find that parameter?
AFAIK, AutoStart is part of the [DlgServices-0] for unattend installation fo
SQL Server 2000, feature not available for MSDE...
and it refers to autostart services..
http://msdn.microsoft.com/library/de...setup_6nz9.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||1st posting:
AutoStart=255
[DlgCpSortUnicode-0]
thx for the link.
Message posted via http://www.sqlmonster.com
I have this in my setup.ini file:
[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
DATADIR="D:\"
AutoStart=255
[DlgCpSortUnicode-0]
SortId=54
LCID=1033
CompStyle=196611
It installs but sp_helpsort still says:
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page
1252 for non-Unicode Data
Is this supported? What do I have to do?
TIA
hi Evan,
evan[at]irtech[dot]com wrote:
> I'm trying to make MSDE 2000A sort order case-insensitive
> accent-insensitive.
> I have this in my setup.ini file:
> [Options]
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> DATADIR="D:\"
> AutoStart=255
> [DlgCpSortUnicode-0]
> SortId=54
> LCID=1033
> CompStyle=196611
> It installs but sp_helpsort still says:
> Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive, width-insensitive for Unicode Data, SQL Server
> Sort Order 52 on Code Page 1252 for non-Unicode Data
> Is this supported? What do I have to do?
> TIA
try using the SQL Server collation instead of Windows codes, like
setup.exe .... COLLATION="Latin1_General_CI_AI_KS_WS"
= Latin1-General, case-insensitive, accent-insensitive, kanatype-sensitive,
width-sensitive
you can inspect all available LatinXX collations executing
select * from ::fn_helpcollations()
where name like 'Latin%'
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks! I didn't know you could do that. I will give that a try later on
today.
Evan
"Andrea Montanari" wrote:
> hi Evan,
> evan[at]irtech[dot]com wrote:
> try using the SQL Server collation instead of Windows codes, like
> setup.exe .... COLLATION="Latin1_General_CI_AI_KS_WS"
> = Latin1-General, case-insensitive, accent-insensitive, kanatype-sensitive,
> width-sensitive
> you can inspect all available LatinXX collations executing
> select * from ::fn_helpcollations()
> where name like 'Latin%'
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||thanks Andrea. You rock! This worked.
Is there a list of collations somewhere?
When I try:
setup.exe .... COLLATION="Latin1_General_CI_AI_KI_WI"
which would match my SQL Server 2000 setup, the MSDE setup blows up during
cnfgsvr.
This is not a problem for me, but might be useful for future reference.
Thanks again!
"Andrea Montanari" wrote:
> hi Evan,
> evan[at]irtech[dot]com wrote:
> try using the SQL Server collation instead of Windows codes, like
> setup.exe .... COLLATION="Latin1_General_CI_AI_KS_WS"
> = Latin1-General, case-insensitive, accent-insensitive, kanatype-sensitive,
> width-sensitive
> you can inspect all available LatinXX collations executing
> select * from ::fn_helpcollations()
> where name like 'Latin%'
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Evan,
evan[at]irtech[dot]com wrote:
> thanks Andrea. You rock! This worked.
> Is there a list of collations somewhere?
> When I try:
> setup.exe .... COLLATION="Latin1_General_CI_AI_KI_WI"
> which would match my SQL Server 2000 setup, the MSDE setup blows up
> during cnfgsvr.
> This is not a problem for me, but might be useful for future
> reference.
http://msdn.microsoft.com/library/de...ation_6gfn.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I read the msdn article but im a little bit confused about the counting.
For instance if i login and transmit a batch of sql statements and log off
i use 3 operations ? or only 1 ? At the moment i use some like this : m_pRs-
>Open((LPCTSTR) strSQL, (LPCTSTR)strConnection, adOpenStatic,
adLockPessimistic , adCmdUnknown);
where m_pRs is a RecordSet.
Message posted via http://www.sqlmonster.com
|||Ups sorry wrong section ,(
Message posted via http://www.sqlmonster.com
|||What do AUTOSTART=255 ? I didnt find it in "Customizing Desktop Engine
Setup.exe"
Message posted via http://www.sqlmonster.com
|||hi Alexander,
Alexander Baumgart via SQLMonster.com wrote:
> What do AUTOSTART=255 ? I didnt find it in "Customizing Desktop Engine
> Setup.exe"
where did you find that parameter?
AFAIK, AutoStart is part of the [DlgServices-0] for unattend installation fo
SQL Server 2000, feature not available for MSDE...
and it refers to autostart services..
http://msdn.microsoft.com/library/de...setup_6nz9.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||1st posting:
AutoStart=255
[DlgCpSortUnicode-0]
thx for the link.
Message posted via http://www.sqlmonster.com
Friday, March 9, 2012
how to set password when installing MSDE (was "Newbie to SQL")
Hi Guys,
I am Access user of both BE and FE. I would like to set my BE with SQL
Therefore, as trial I just downloaded MSDE2000A.Exe a Desktop SQL Engine from Microsoft. I need to install it. But due to some technical aspect (which I might not understand) I could not install it. Bcz whenever I am trying to install its setup file, it ask me a strong password. How to set it ? or how to supply it I dont know...
Any help.
Regards,
AshfaqueThis (http://support.microsoft.com/default.aspx?scid=kb;en-us;814463) is what you need (in English).
-PatP|||Thanks Pat,
I installed it successfully. The information page is good. Thanks.
Do you have any other referece web page that would show me how to transfer my Access table data over to this installed SQL server and allow my FE to be still in MS ACCESS.bcz I desined my beautiful forms and its code after a lot of excesize. What are the initial steps I must follow?
With kind regards,
Ashfafque|||I'd suggest using the Access Upsizing Wizard as a start. It isn't a complete solution, but it gives you one heck of a head start! Microsoft has a great "How to (http://support.microsoft.com/default.aspx?scid=kb;en-us;237980)", and there are versions for 2000 (http://support.microsoft.com/default.aspx?scid=kb;en-us;325017) and 2002 (http://support.microsoft.com/default.aspx?scid=kb;en-us;330468).
-PatP|||Again thanks Pat,
Article is very usefule. I will be back if face any problem.
With kind regards,
Ashfaque
I am Access user of both BE and FE. I would like to set my BE with SQL
Therefore, as trial I just downloaded MSDE2000A.Exe a Desktop SQL Engine from Microsoft. I need to install it. But due to some technical aspect (which I might not understand) I could not install it. Bcz whenever I am trying to install its setup file, it ask me a strong password. How to set it ? or how to supply it I dont know...
Any help.
Regards,
AshfaqueThis (http://support.microsoft.com/default.aspx?scid=kb;en-us;814463) is what you need (in English).
-PatP|||Thanks Pat,
I installed it successfully. The information page is good. Thanks.
Do you have any other referece web page that would show me how to transfer my Access table data over to this installed SQL server and allow my FE to be still in MS ACCESS.bcz I desined my beautiful forms and its code after a lot of excesize. What are the initial steps I must follow?
With kind regards,
Ashfafque|||I'd suggest using the Access Upsizing Wizard as a start. It isn't a complete solution, but it gives you one heck of a head start! Microsoft has a great "How to (http://support.microsoft.com/default.aspx?scid=kb;en-us;237980)", and there are versions for 2000 (http://support.microsoft.com/default.aspx?scid=kb;en-us;325017) and 2002 (http://support.microsoft.com/default.aspx?scid=kb;en-us;330468).
-PatP|||Again thanks Pat,
Article is very usefule. I will be back if face any problem.
With kind regards,
Ashfaque
Friday, February 24, 2012
HOW to set Authentication Using OSQL
I would like to change the authentication method for an MSDE instance. How
do I do it via OSQL ?
This I need when there is no EM installed. I would like to turn the default
authentication from Windows to Mixed mode.
I searched BOL but it talked about using EM.
Thanks in advance for your input.
MacYou can switch MSDE to mixed mode during installation and after that.
Here it is
http://support.microsoft.com/default.aspx?scid=kb;en-us;319930&Product=sql#5
Regards
---
All information provided above AS IS.
"Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
news:bnu8sh$20ag$1@.si05.rsvl.unisys.com...
> I would like to change the authentication method for an MSDE instance.
How
> do I do it via OSQL ?
> This I need when there is no EM installed. I would like to turn the
default
> authentication from Windows to Mixed mode.
> I searched BOL but it talked about using EM.
> Thanks in advance for your input.
> Mac
>|||Thanks for the quick response!! That worked.
"SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
news:%23o1rkv9nDHA.372@.TK2MSFTNGP11.phx.gbl...
> You can switch MSDE to mixed mode during installation and after that.
> Here it is
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;319930&Product=sql#5
>
> Regards
> ---
> All information provided above AS IS.
>
> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
> news:bnu8sh$20ag$1@.si05.rsvl.unisys.com...
> > I would like to change the authentication method for an MSDE instance.
> How
> > do I do it via OSQL ?
> > This I need when there is no EM installed. I would like to turn the
> default
> > authentication from Windows to Mixed mode.
> > I searched BOL but it talked about using EM.
> >
> > Thanks in advance for your input.
> > Mac
> >
> >
>
do I do it via OSQL ?
This I need when there is no EM installed. I would like to turn the default
authentication from Windows to Mixed mode.
I searched BOL but it talked about using EM.
Thanks in advance for your input.
MacYou can switch MSDE to mixed mode during installation and after that.
Here it is
http://support.microsoft.com/default.aspx?scid=kb;en-us;319930&Product=sql#5
Regards
---
All information provided above AS IS.
"Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
news:bnu8sh$20ag$1@.si05.rsvl.unisys.com...
> I would like to change the authentication method for an MSDE instance.
How
> do I do it via OSQL ?
> This I need when there is no EM installed. I would like to turn the
default
> authentication from Windows to Mixed mode.
> I searched BOL but it talked about using EM.
> Thanks in advance for your input.
> Mac
>|||Thanks for the quick response!! That worked.
"SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
news:%23o1rkv9nDHA.372@.TK2MSFTNGP11.phx.gbl...
> You can switch MSDE to mixed mode during installation and after that.
> Here it is
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;319930&Product=sql#5
>
> Regards
> ---
> All information provided above AS IS.
>
> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
> news:bnu8sh$20ag$1@.si05.rsvl.unisys.com...
> > I would like to change the authentication method for an MSDE instance.
> How
> > do I do it via OSQL ?
> > This I need when there is no EM installed. I would like to turn the
> default
> > authentication from Windows to Mixed mode.
> > I searched BOL but it talked about using EM.
> >
> > Thanks in advance for your input.
> > Mac
> >
> >
>
Subscribe to:
Posts (Atom)