Showing posts with label password. Show all posts
Showing posts with label password. Show all posts

Sunday, March 25, 2012

Access Connection

I have a linked server connection from sql server 2000 to access...once
someone puts a password on an access database does anyone know what the
default username is. I have tried Admin and Administrator with no luck while
using the correct password of course
thanks
Sammy
Did you try 'sa'. If no one else on this discussion alias replies with
other suggestions, perhaps you would get one from the Microsoft Access
alias.
| Thread-Topic: Access Connection
| thread-index: AcWpgVenySe/YO83T+K2XLbswonlNQ==
| X-WBNR-Posting-Host: 212.56.83.30
| From: "=?Utf-8?B?U2FtbXk=?=" <Sammy@.discussions.microsoft.com>
| Subject: Access Connection
| Date: Thu, 25 Aug 2005 07:29:03 -0700
| Lines: 9
| Message-ID: <D3D44E5D-E5B1-474B-8288-CB7436020643@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2615
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
|
| I have a linked server connection from sql server 2000 to access...once
| someone puts a password on an access database does anyone know what the
| default username is. I have tried Admin and Administrator with no luck
while
| using the correct password of course
|
| thanks
|
| Sammy
|

Access Connection

I have a linked server connection from sql server 2000 to access...once
someone puts a password on an access database does anyone know what the
default username is. I have tried Admin and Administrator with no luck while
using the correct password of course
thanks
SammyDid you try 'sa'. If no one else on this discussion alias replies with
other suggestions, perhaps you would get one from the Microsoft Access
alias.
--
| Thread-Topic: Access Connection
| thread-index: AcWpgVenySe/YO83T+K2XLbswonlNQ==
| X-WBNR-Posting-Host: 212.56.83.30
| From: "examnotes" <Sammy@.discussions.microsoft.com>
| Subject: Access Connection
| Date: Thu, 25 Aug 2005 07:29:03 -0700
| Lines: 9
| Message-ID: <D3D44E5D-E5B1-474B-8288-CB7436020643@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2615
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
|
| I have a linked server connection from sql server 2000 to access...once
| someone puts a password on an access database does anyone know what the
| default username is. I have tried Admin and Administrator with no luck
while
| using the correct password of course
|
| thanks
|
| Sammy
|

Sunday, March 11, 2012

Accesing a database with password

Hello, I have a database and I need to copy and attach it in a customer SQL
server. But I don't want them to be able to see the tables structures or my
company's stored procedures. Is this possible to have the database in their
sql server and not allow them to see the data or tables. Or only with a
password be able to access the database. Like in Microsoft Access that you
can assign a password to the database and everytime I open the file it
prompts for the password.
Thanks in advance
JennyferdYou can "encrypt" the stored procedures (see BOL, Create Procedure "With
Encryption"), but there are tools out there that pretty handily defeat such
encryption. It's pretty much just enough to keep unmotivated honest people
honest. You could use Views to prevent people from accessing the underlying
tables directly, but on their box they will presumably have sa/administrator
access and will be able to view your table structures... I'm not sure of
any methods to hide that info... Although someone else here may know.
To be honest, to me it's a little counter-intuitive - I usually supply full
documentation on the database tables and structures to clients, since they
invariably try to generate reports, etc., on their own... to me it makes
more sense to give them the tools to access it the right way, set up
read-only views, etc., so they don't trash the system...
"Jennyfer J Barco" <pdwhitt@.nospam.wdsinc.com> wrote in message
news:uTp4scxLFHA.3420@.tk2msftngp13.phx.gbl...
> Hello, I have a database and I need to copy and attach it in a customer
> SQL
> server. But I don't want them to be able to see the tables structures or
> my
> company's stored procedures. Is this possible to have the database in
> their
> sql server and not allow them to see the data or tables. Or only with a
> password be able to access the database. Like in Microsoft Access that you
> can assign a password to the database and everytime I open the file it
> prompts for the password.
> Thanks in advance
> Jennyferd
>

Acces 2000

Hi. I am trying to set up da db with access 2000.
Somewhere I read that I should not use password on my db if I intend to replicate the db.
I don't really understand what "replication" means..Originally posted by david2000
Hi. I am trying to set up da db with access 2000.
Somewhere I read that I should not use password on my db if I intend to replicate the db.
I don't really understand what "replication" means..

FROM BOL:

Replication is a set of technologies that allows you to keep copies of the same data on multiple sites
Replication uses a publish-subscribe model for distributing data:

A Publisher is a server that is the source of data to be replicated. The Publisher defines an article for each table or other database object to be used as a replication source. One or more related articles from the same database are organized into a publication. Publications are convenient ways to group related data and objects that you want to replicate together.

A Subscriber is a server that receives the data replicated by the publisher. The Subscriber defines a subscription to a particular publication. The subscription specifies when the Subscriber receives the publication from the Publisher, and maps the articles to tables and other database objects in the Subscriber.

A Distributor is a server that performs various tasks when moving articles from Publishers to Subscribers. The actual tasks performed depend on the type of replication performed.

Sunday, February 19, 2012

about security of SQL Server

hi;
i have install an sql-server desktop edition on winXP
how can change my "sa" password
thank you...Hi,
From command prompt execute OSQL to login to sql server MSDE:-
OSQL -Usa -Ppassword -S Server_name (enter Key)
1>sp_password null,'newpassword','sa'
2>go
THis will change the password of sa.
--
Thanks
Hari
MCDBA
"Ferhat" <Ferhat@.discussions.microsoft.com> wrote in message
news:9C3D68D6-B2D5-499E-91B4-3CE70E4D44E6@.microsoft.com...
> hi;
> i have install an sql-server desktop edition on winXP
> how can change my "sa" password
> thank you...|||hi Hari;
i'm from Turkey
Thank you very much...:)
"Hari" wrote:
> Hi,
> From command prompt execute OSQL to login to sql server MSDE:-
> OSQL -Usa -Ppassword -S Server_name (enter Key)
> 1>sp_password null,'newpassword','sa'
> 2>go
> THis will change the password of sa.
> --
> Thanks
> Hari
> MCDBA
> "Ferhat" <Ferhat@.discussions.microsoft.com> wrote in message
> news:9C3D68D6-B2D5-499E-91B4-3CE70E4D44E6@.microsoft.com...
> > hi;
> > i have install an sql-server desktop edition on winXP
> > how can change my "sa" password
> > thank you...
>
>

Monday, February 13, 2012

About lost sa password when rebuild master database

Hi Guys,
I rebuild master database in order to change collation setting, but I lost
sa password After rebuild. I couldn't logon into database with sa. Why is it
like this, can I re-get sa password? Thanks.
Jerry MuNot sure what could have happen but ... have you tried to log in as a member
of the BUILTIN\Administrators group?
Ben Nevarez, MCDBA, OCP
Database Administrator
"Iter" wrote:
> Hi Guys,
> I rebuild master database in order to change collation setting, but I lost
> sa password After rebuild. I couldn't logon into database with sa. Why is it
> like this, can I re-get sa password? Thanks.
> Jerry Mu
>|||login with a Windows NT account that is part of sysadmin
(builtin\administrator) and reset the password.
e.g.
exec sp_password null,'new password', 'sa'
-oj
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A02122C4-8006-4D6E-99B1-A2D0DD016362@.microsoft.com...
> Hi Guys,
> I rebuild master database in order to change collation setting, but I lost
> sa password After rebuild. I couldn't logon into database with sa. Why is
> it
> like this, can I re-get sa password? Thanks.
> Jerry Mu
>

About lost sa password when rebuild master database

Hi Guys,
I rebuild master database in order to change collation setting, but I lost
sa password After rebuild. I couldn't logon into database with sa. Why is it
like this, can I re-get sa password? Thanks.
Jerry MuNot sure what could have happen but ... have you tried to log in as a member
of the BUILTIN\Administrators group?
Ben Nevarez, MCDBA, OCP
Database Administrator
"Iter" wrote:

> Hi Guys,
> I rebuild master database in order to change collation setting, but I lost
> sa password After rebuild. I couldn't logon into database with sa. Why is
it
> like this, can I re-get sa password? Thanks.
> Jerry Mu
>|||login with a Windows NT account that is part of sysadmin
(builtin\administrator) and reset the password.
e.g.
exec sp_password null,'new password', 'sa'
-oj
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A02122C4-8006-4D6E-99B1-A2D0DD016362@.microsoft.com...
> Hi Guys,
> I rebuild master database in order to change collation setting, but I lost
> sa password After rebuild. I couldn't logon into database with sa. Why is
> it
> like this, can I re-get sa password? Thanks.
> Jerry Mu
>

About login into sql server via asp.net

I want to design a form with C# that will able me to log in to my sql server with my sql login name and password.This should be the entry point, which is like the "SqlWebAdmin", Where i login first then have a view of databases that i have permission. The problem first is how to login into the sql server via ASP .net without knowing prior which database is mine?Any help plz?Most apps put their connect information in web.config, and read it out at run time.

Saturday, February 11, 2012

About E-mail delivery Settings, where can I set E-mail account and password

Hello, everyone,
During RS setup, we can only set two values about E-mail delivery, one is
SMTP server address or name, the other is Sender E-mail address.
My question is , now the popular SMTP server all require Authentication,
where can I set E-mail account and password?
Thanks in advance.
EdwardRS only supports anonymous and NTLM authentication. If you need to use basic
auth your best option is to set RS to use the local smtp server to relay the
messages. In the RSReportServer.config file, set the smtppickupdirectory to
you local smtp pickup directory and then set SendUsing to 1.
You will then need to configure the local smtp server to do the actual
relaying.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Haitian" <xinhaitian@.126.com> wrote in message
news:%23WZRXrPWFHA.3076@.TK2MSFTNGP12.phx.gbl...
> Hello, everyone,
> During RS setup, we can only set two values about E-mail delivery, one
> is
> SMTP server address or name, the other is Sender E-mail address.
> My question is , now the popular SMTP server all require Authentication,
> where can I set E-mail account and password?
> Thanks in advance.
> Edward
>|||Thanks, Daniel.
BTW, do you mean to use the SMTP service built in IIS ?
> RS only supports anonymous and NTLM authentication. If you need to use
basic
> auth your best option is to set RS to use the local smtp server to relay
the
> messages. In the RSReportServer.config file, set the smtppickupdirectory
to
> you local smtp pickup directory and then set SendUsing to 1.
> You will then need to configure the local smtp server to do the actual
> relaying.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Haitian" <xinhaitian@.126.com> wrote in message
> news:%23WZRXrPWFHA.3076@.TK2MSFTNGP12.phx.gbl...
> > Hello, everyone,
> >
> > During RS setup, we can only set two values about E-mail delivery, one
> > is
> > SMTP server address or name, the other is Sender E-mail address.
> >
> > My question is , now the popular SMTP server all require
Authentication,
> > where can I set E-mail account and password?
> >
> > Thanks in advance.
> >
> > Edward
> >
> >
>|||Yes, that is what I was referring to.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Haitian" <xinhaitian@.126.com> wrote in message
news:OfK9IDfWFHA.3188@.TK2MSFTNGP09.phx.gbl...
> Thanks, Daniel.
> BTW, do you mean to use the SMTP service built in IIS ?
>
>> RS only supports anonymous and NTLM authentication. If you need to use
> basic
>> auth your best option is to set RS to use the local smtp server to relay
> the
>> messages. In the RSReportServer.config file, set the smtppickupdirectory
> to
>> you local smtp pickup directory and then set SendUsing to 1.
>> You will then need to configure the local smtp server to do the actual
>> relaying.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Haitian" <xinhaitian@.126.com> wrote in message
>> news:%23WZRXrPWFHA.3076@.TK2MSFTNGP12.phx.gbl...
>> > Hello, everyone,
>> >
>> > During RS setup, we can only set two values about E-mail delivery,
>> > one
>> > is
>> > SMTP server address or name, the other is Sender E-mail address.
>> >
>> > My question is , now the popular SMTP server all require
> Authentication,
>> > where can I set E-mail account and password?
>> >
>> > Thanks in advance.
>> >
>> > Edward
>> >
>> >
>>
>