Showing posts with label acces. Show all posts
Showing posts with label acces. Show all posts

Sunday, 19 February 2012

Confirm password

Hi,
I have a login that has access to a certain database, when
i go to the logins session of EM to give the login acces
to another user, i map the user with the login in a new
database an i give him de db_owner role (Dev Host), when i
do the ok or aply, i'm prompt to confirm the password. For
me this is strange '? The login exists, i just want to
give the user access to another database.
Can anyone explain me this
Thanks in advance
Miguel CorreiaMaybe this will help...
http://support.microsoft.com/default.aspx?kbid=826161
Tim
>--Original Message--
>Hi,
>I have a login that has access to a certain database,
when
>i go to the logins session of EM to give the login acces
>to another user, i map the user with the login in a new
>database an i give him de db_owner role (Dev Host), when
i
>do the ok or aply, i'm prompt to confirm the password.
For
>me this is strange '? The login exists, i just want
to
>give the user access to another database.
>Can anyone explain me this
>Thanks in advance
>Miguel Correia
>.
>

Sunday, 12 February 2012

Configuring client acces to SQL Server

I have just installed on a server, Sql Server 7.0.

I want to acces to that server from a client. When I try to configure on the client the ODBC connection to the databases of my sql server, it says I don't have license.

Have I to configure something on the client or on the server to be able to acces from a client?

Thanks and best regards
:confused:Can you acces the SQL server from EM or QA?|||what license mode have you selected at the time of installation? also, check if licensing service is running on the server and through control panel enter the actual number of licenses that you purchased.