install MSDE200A

Hi can you help me with this problem with msde
I have installed MSDE200A and i didn’t gave any password(setup BLANKSAPWD=1).
My configuration code for the connection with msde is:
<appSettings>
<add key="DSN" value="Initial Catalog=dyt_mac;Data
Source=localhost;Integrated Security=SSPI;"/>
</appSettings>
When i try to connect with the database this error occurs:
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied.
Thank you!
Hi,
the DataSource value should be '(local)' including the brackets.

Install database on existing MSDE server with unknown SA password?

Question regarding the MSDE SP3a install process...
What happens if I attempt to install MSDE on a server that already has MSDE
installed and the SA password has been changed to an unknown password? Can
I still install an instance for my database without knowing the SA password?
If not, how can I get around this issue?
I can see my app/database being installed at a customers site that already
has a version of MSDE for a different application they have already
installed and are using.
Thanks,
Jim K.
You should be able to install using Windows authentication, assuming you
know the password for an administrator on the box.
With that, you can also reset the sa password for an existing instance using
sp_password.
http://www.aspfaq.com/
(Reverse address to reply.)
"Jim K" <krusej@.megsinet.net> wrote in message
news:u$W9756gEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Question regarding the MSDE SP3a install process...
> What happens if I attempt to install MSDE on a server that already has
MSDE
> installed and the SA password has been changed to an unknown password?
Can
> I still install an instance for my database without knowing the SA
password?
> If not, how can I get around this issue?
> I can see my app/database being installed at a customers site that already
> has a version of MSDE for a different application they have already
> installed and are using.
> Thanks,
> Jim K.
>

Install Database Components SP3a

Hi,
Do I need to know the sa password when I install Database Components for
SP3a? The extracted service pack files is in the directory of the local
computer.
Thanks.Only if you're installing on the SQL Server/MSDE, not for the clients.
"Samuel Yap" <yaphcs@.yahoo.com> wrote in message
news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> Do I need to know the sa password when I install Database Components for
> SP3a? The extracted service pack files is in the directory of the local
> computer.
> Thanks.
>|||Yes, preferably. But any account that has system administrator privileges to
SQL Server should suffice I suppose. "sa" account is safe and sure to have
all the access to the database files for sure.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"Samuel Yap" <yaphcs@.yahoo.com> wrote in message
news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> Do I need to know the sa password when I install Database Components for
> SP3a? The extracted service pack files is in the directory of the local
> computer.
> Thanks.
>|||Noted. Thanks.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:eqSUIi0dDHA.3992@.TK2MSFTNGP11.phx.gbl...
> Yes, preferably. But any account that has system administrator privileges
to
> SQL Server should suffice I suppose. "sa" account is safe and sure to have
> all the access to the database files for sure.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD
> http://www.extremeexperts.com
>
> "Samuel Yap" <yaphcs@.yahoo.com> wrote in message
> news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Do I need to know the sa password when I install Database Components for
> > SP3a? The extracted service pack files is in the directory of the local
> > computer.
> >
> > Thanks.
> >
> >
>

insisting on a password policy for sql

Is it possible to force users with sql accounts to use secure passwords say
6 plus characters long with numbers and letters. Is it also possible to have
sql insist that the passwords be changed every X days.
I am of course talking about when sql server 2000 uses sql authentication.
Please advise
AndreHi
SQL Server 2005 introduces this functionality.
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre|||The short answer for SQL 2000 is No.
A much longer answer is that one could 'roll their own' and create some
overly complex custom functionality that most likely would still be
incomplete and fraught with problems.
Waiting for SQL 2005 -and lobbying for its' adoption, is the answer.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre

insisting on a password policy for sql

Hi
SQL Server 2005 introduces this functionality.
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> AndreThe short answer for SQL 2000 is No.
A much longer answer is that one could 'roll their own' and create some
overly complex custom functionality that most likely would still be
incomplete and fraught with problems.
Waiting for SQL 2005 -and lobbying for its' adoption, is the answer.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre|||Is it possible to force users with sql accounts to use secure passwords say
6 plus characters long with numbers and letters. Is it also possible to have
sql insist that the passwords be changed every X days.
I am of course talking about when sql server 2000 uses sql authentication.
Please advise
Andre|||Hi
SQL Server 2005 introduces this functionality.
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre|||The short answer for SQL 2000 is No.
A much longer answer is that one could 'roll their own' and create some
overly complex custom functionality that most likely would still be
incomplete and fraught with problems.
Waiting for SQL 2005 -and lobbying for its' adoption, is the answer.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Andre Gibson" <AndreGibson@.discussions.microsoft.com> wrote in message
news:8B9326C5-CF63-4609-A84D-4A596363A8EF@.microsoft.com...
> Is it possible to force users with sql accounts to use secure passwords
> say
> 6 plus characters long with numbers and letters. Is it also possible to
> have
> sql insist that the passwords be changed every X days.
> I am of course talking about when sql server 2000 uses sql authentication.
> Please advise
> Andre