Problem in giving Database Access to a new user

I create a new user and give them a password and hten confirm as
normal. When I subsequently try to give this user access to the
database then I am prompted to 'Confirm Password' jus as I was when I
created the user. I've not seen thi before. Can anyone shed some light
please?
John
Hi,
(Information taken from old post from Kevin Micosoft)
This was a bug with the security rollup for SQL. You need to install build
819. Have a look into the below link:-
http://support.microsoft.com/default.aspx?kbid=826161
Thanks
Hari
MCDBA
"John Lundrigan" <jonel@.glenavon1.demon.co.uk> wrote in message
news:s1ldc01o9nnrsoil1cmep2j23p49eaiise@.4ax.com...
> I create a new user and give them a password and hten confirm as
> normal. When I subsequently try to give this user access to the
> database then I am prompted to 'Confirm Password' jus as I was when I
> created the user. I've not seen thi before. Can anyone shed some light
> please?
> John

Problem in giving Database Access to a new user

I create a new user and give them a password and hten confirm as
normal. When I subsequently try to give this user access to the
database then I am prompted to 'Confirm Password' jus as I was when I
created the user. I've not seen thi before. Can anyone shed some light
please?
JohnHi,
(Information taken from old post from Kevin Micosoft)
This was a bug with the security rollup for SQL. You need to install build
819. Have a look into the below link:-
http://support.microsoft.com/default.aspx?kbid=826161
Thanks
Hari
MCDBA
"John Lundrigan" <jonel@.glenavon1.demon.co.uk> wrote in message
news:s1ldc01o9nnrsoil1cmep2j23p49eaiise@.4ax.com...
> I create a new user and give them a password and hten confirm as
> normal. When I subsequently try to give this user access to the
> database then I am prompted to 'Confirm Password' jus as I was when I
> created the user. I've not seen thi before. Can anyone shed some light
> please?
> Johnsql

Problem in giving Database Access to a new user

I create a new user and give them a password and hten confirm as
normal. When I subsequently try to give this user access to the
database then I am prompted to 'Confirm Password' jus as I was when I
created the user. I've not seen thi before. Can anyone shed some light
please?
JohnHi,
(Information taken from old post from Kevin Micosoft)
This was a bug with the security rollup for SQL. You need to install build
819. Have a look into the below link:-
http://support.microsoft.com/default.aspx?kbid=826161
Thanks
Hari
MCDBA
"John Lundrigan" <jonel@.glenavon1.demon.co.uk> wrote in message
news:s1ldc01o9nnrsoil1cmep2j23p49eaiise@.
4ax.com...
> I create a new user and give them a password and hten confirm as
> normal. When I subsequently try to give this user access to the
> database then I am prompted to 'Confirm Password' jus as I was when I
> created the user. I've not seen thi before. Can anyone shed some light
> please?
> John

Problem in changing Account Name, Password

Hi

I installed SQL Server 2005 Express Edition. When I try changing the account name, password in the SQL Server Configuration Manager, i.e. by clicking on Apply, the SQLEXPRESS restarts and the password gets replaced by a longer password. Also the user name gets prefixed with "./". Any help on this will be highly appreciated.

Another query: Do we have the query analyser (gui or command line) kind of thing in Express Edition? Also where can I get a proper documentation of doing elementary things in setting up a database, like creating a database, adding a user, etc)

Thanks and Regards
Roopesh

For the pasword thing, the field is obfuscated with more chars than you entered, thats as planned.

There is a query edit built into express, just select file new query from the menu.

In terms of docs I recomend SQL Server Books On Line, which can be downloaded from the same place as you downloaded express.

|||

A few additional notes, if you've only downloaded Express Edition (not Advanced Services) you can get Management Studio Express separately from http://msdn.microsoft.com/vstudio/express/sql/download/.

You can find some videos to help you understand some of the basics of database usage at http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx. If you're interested in learning about a programming language, I'd recomend the Absolute Beginners series as well as some of the other learning resources that are language specific. (VB.NET C#)

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

sql

problem for Security in Sql 2005 Express.

hi
i am using vc# 2005 and sql 2005 express.
my problem is does exist any way to set password on sql2005 database ?
(because i don't want to end users access to sql server's tables and datas and ...)
how to solve my problem ?
thanks

Hi Hamed

You can download Microsoft SQL Server Management Studio Express and you can create users there for your database.

Regards,

Pradeep

|||

Hi,

You don′t set password on databases. You create logins on the server level (server principals) which relate to either a Windows Account (Windows Authentication) or a SQL Server account (SQL Server authewntication). These principals can be either in a overall server role and / or be granted access to individual databases with database principals. these database principals can be granted individual right on the objects within the database (securables) or can be assigned to database roles.

So, first create a server login for an indivudal user or a Windows groups, then grant the appropiates right either individually or through the role membership within the database.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de