Showing posts with label security. Show all posts
Showing posts with label security. Show all posts

Friday, March 30, 2012

Login failed for user NT AUTHORITY\ANONYMOUS LOGON (but user.identity.name is correct)

I need help. The security principal is the correct Domain\User, but the error message says I am not authenticated.

So here is my error Message:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Me.User.Identity.Name=CompanyDomain\Ryan; System.Security.Principal.WindowsIdentity.GetCurrent=CompanyDomain\Ryan; HttpContext.Current.User.Identity.Name=Company\Ryan

Generated by:

Dim

secPrincAs System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCurrentMe.lblError.Text = ex.Message & vbCrLf & vbCrLf &"Me.User.Identity.Name=" &Me.User.Identity.Name &"; System.Security.Principal.WindowsIdentity.GetCurrent=" & secPrinc.Name &"; HttpContext.Current.User.Identity.Name=" & HttpContext.Current.User.Identity.Name

Here is the Connection String:

Private ConnStringAsString ="Server=10.144.162.111;Database=DNS;Trusted_Connection=True"

IIS has 4 websites hosted on it. The parent level allows anonymous with windows auth off, but the website level has anonymous off with widnows auth and digest.

In IIS, is there a problem with having the parent level anonymous and website level windows auth?

I think i found the error. My web server is a different machine from my data server. When my browser connects to the webserver it uses impersonation and delegation, but the web server is not trusted for delegation on the active directory. So when the webserver tries to pass the credentials to the data server the domain controller will not allow it.

Working on a 3 tier setup here...

Ryan

Wednesday, March 28, 2012

Login failed for user 'NT Authority\Anonymous

I have a Merge Replication configuration in which one Publisher replicates
with 20 subscribers.
Currently, we use Windows Integrated security.
I get the following error when attempting to access tables in a remote
server from the publisher.
In Query Analyzer window, logged into publisher, I type
SELECT * FROM <subscriber1>.<databasename>..<tablename>
And get the following error message:
Login failed for user 'NTAUTHORITY\ANONYMOUS LOGON'
1) From everything I’ve read, including article 827422, it is necessary to
go to Mixed Security in order to overcome this security issue. Is this true?
2) Will changing the security mode on the Publisher and all 20 subscribers
cause any problems with replication?1) That's a major over-generalization to say that changing it to SQL
Authentication (Mixed Mode) will allow you to over come this. It's working
around the issue entirely. You will still have issues with Windows
authentication, and should deal with those.
When you set up the merge subscribers, are they anonymous? Did you specify
for the merge agent to connect to the subscriber (if push) or publisher (if
pull) under the credentials of the SQL Agent account? What is that account?
Can you log onto each server (pub and sub) as their respective SQL Agent
accounts, then try to open Query Analyzer and point to the other server usin
g
windows authentication? Do you get the same "Anonymous error"? Are they th
e
same account? If not, are they in the same domain? Make sure they both have
the correct rights to each other's machine. If not in the same domain, you
need to look at trust issues. If there is no trust, then you will either
have to set one up, or use mixed mode and SQL accounts.
2) No, unless you consider the time to restart SQL an issue.
Donna Lambert
"elpepe" wrote:

> I have a Merge Replication configuration in which one Publisher replicates
> with 20 subscribers.
> Currently, we use Windows Integrated security.
> I get the following error when attempting to access tables in a remote
> server from the publisher.
> In Query Analyzer window, logged into publisher, I type
> SELECT * FROM <subscriber1>.<databasename>..<tablename>
> And get the following error message:
> Login failed for user 'NTAUTHORITY\ANONYMOUS LOGON'
> 1) From everything I’ve read, including article 827422, it is necessary
to
> go to Mixed Security in order to overcome this security issue. Is this tru
e?
> 2) Will changing the security mode on the Publisher and all 20 subscribers
> cause any problems with replication?
>
>

Login failed for user COLDFIRE/ASPNET

i have my SQL server in windows integrated security so my connection string doesnt have to have password and uid stuff.
this is my connection string

data source=COLDFIRE;initial catalog=Northwind;integrated security=SSPI;persist security info=True;workstation id=COLDFIRE;packet size=4096

i tried this in windows form project of .net and work fine, i connected easily but when i tried it in asp project i got this error :

Login failed for user COLDFIRE/ASPNET

whats wrong with it?That's because the ASPNet user account, which was created when you installed ASP.Net, is not set up as a user on the SQL Server.

Login failed for user Admin.


Provider=SQLOLEDB.1;Persist Security Info=False;User ID=Admin;Initial
Catalog=Northwind;Data Source=LocalNet;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Workstation ID=LocalNet;Use Encryption for
Data=False;Tag with column collation when possible=False

Any ideas on how to solve this problem?

Cheersi could find out


Provider=SQLOLEDB.1;Persist Security Info=False;User ID=Admin;password=******;Initial
Catalog=Northwind;Data Source=LocalNet;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Workstation ID=LocalNet;Use Encryption for
Data=False;Tag with column collation when possible=False

Monday, March 26, 2012

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server

We have a problem on a SQL Server 2000 with SP3a and
latest security patch running on Windows 2003.
We have several other SQL-servers aswell but this one
seems to have problems with Windows Authentication. It
worked properly first but then when we changed to Windows
authentication and then back to SQL Server and Windows
authentication it stopped working properly. I have
successfully got this problem in my lab aswell (see
below).
The problem: We're running the SQL Service using a
domainaccount (sql1) which is in the local Administrators
group on the server. If I login using this account I can
open Ent Manager using Windows Authentication. I login to
Windows using another domainaccount (user1) that is also
a member of Administrators on the server, when I open up
Ent Manager I get "Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server
connection.". This is also logged in the Event Log. If I
use SQL Authentication it works. Same goes when I try to
connect remotly to a database with an ODBC-connection.
If I check the permissions I can see that
BUILTIN\Administrators have the System Administrators
role. I also try to att DOMAIN\user1 manually and give
permission. Still doesn't work. The SQL Server is
configured for both SQL Server and Windows Authentication.
I have restarted the server to make sure settings are
changed. I've also looked through MS KB's and found a
registrykey:
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\Lo ginMode
and it's set to 2.
In my lab I installed SQL2000. I could use Ent Manager
with both sql1 and user1. Then I switched to Windows mode
and then back to SQL Server and Windows and restarted the
server. Now I have the problem mentioned above and I can
only use sql1 to open Ent Manager.
I've looked through many posts in this forum but none
have supplied with me with any solution.
This is usually a problem with Kerberos and authentication. You can look at
this article for help:
http://support.microsoft.com/default.aspx?scid=kb;[LN];811889
The error you are getting is different but they are usually caused by the
same thing or similar things.
The article mentions a setspn utility. You can downlod it from here:
http://www.microsoft.com/windows2000...sting/setspn-o
.asp
Rand
This posting is provided "as is" with no warranties and confers no rights.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server

We have a problem on a SQL Server 2000 with SP3a and
latest security patch running on Windows 2003.
We have several other SQL-servers aswell but this one
seems to have problems with Windows Authentication. It
worked properly first but then when we changed to Windows
authentication and then back to SQL Server and Windows
authentication it stopped working properly. I have
successfully got this problem in my lab aswell (see
below).
The problem: We're running the SQL Service using a
domainaccount (sql1) which is in the local Administrators
group on the server. If I login using this account I can
open Ent Manager using Windows Authentication. I login to
Windows using another domainaccount (user1) that is also
a member of Administrators on the server, when I open up
Ent Manager I get "Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server
connection.". This is also logged in the Event Log. If I
use SQL Authentication it works. Same goes when I try to
connect remotly to a database with an ODBC-connection.
If I check the permissions I can see that
BUILTIN\Administrators have the System Administrators
role. I also try to att DOMAIN\user1 manually and give
permission. Still doesn't work. The SQL Server is
configured for both SQL Server and Windows Authentication.
I have restarted the server to make sure settings are
changed. I've also looked through MS KB's and found a
registrykey:
HKLM\Software\Microsoft\MSSQLServer\MSSQ
LServer\LoginMode
and it's set to 2.
In my lab I installed SQL2000. I could use Ent Manager
with both sql1 and user1. Then I switched to Windows mode
and then back to SQL Server and Windows and restarted the
server. Now I have the problem mentioned above and I can
only use sql1 to open Ent Manager.
I've looked through many posts in this forum but none
have supplied with me with any solution.This is usually a problem with Kerberos and authentication. You can look at
this article for help:
http://support.microsoft.com/defaul...scid=kb;[LN];811889
The error you are getting is different but they are usually caused by the
same thing or similar things.
The article mentions a setspn utility. You can downlod it from here:
http://www.microsoft.com/windows200...isting/setspn-o
.asp
Rand
This posting is provided "as is" with no warranties and confers no rights.

Friday, March 23, 2012

login failed for user '(null)'

I have seen this discussed before here, but I guess not quite that way I want to
use it. We would like to use pure Windows NT Integrated Security, therefore
taking advantage of AD groups and existing security in SQL Server. However,
anytime we select the 'Windows NT Integrated Security' option in the data
source, we always get the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server
connection.
Can anybody help? Thanks!Did you switched on Mixed Mode Autentification on Sql Server ?
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
news:OTHMxhbRFHA.3076@.TK2MSFTNGP14.phx.gbl...
>I have seen this discussed before here, but I guess not quite that way I
>want to use it. We would like to use pure Windows NT Integrated Security,
>therefore taking advantage of AD groups and existing security in SQL
>Server. However, anytime we select the 'Windows NT Integrated Security'
>option in the data source, we always get the following error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> Can anybody help? Thanks!|||Yes, this is standard practice when installing new instances of SQL Server
around here.
Jens Süßmeyer wrote:
> Did you switched on Mixed Mode Autentification on Sql Server ?
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
>
> "Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
> news:OTHMxhbRFHA.3076@.TK2MSFTNGP14.phx.gbl...
>>I have seen this discussed before here, but I guess not quite that way I
>>want to use it. We would like to use pure Windows NT Integrated Security,
>>therefore taking advantage of AD groups and existing security in SQL
>>Server. However, anytime we select the 'Windows NT Integrated Security'
>>option in the data source, we always get the following error:
>>Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>>Server connection.
>>Can anybody help? Thanks!
>
>|||Seems taht you did´nt spedify the security settings in the right way. YOu
may have a look here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_datasources_v1_87e9.asp
Make sure that when you redeploy your datasources you select the "Overwrite
datasources" option.
When even then its not working please post the part of your infrastructure
here, so that we can see how you get acces to the datasources (Servers,
ect.)
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
news:eGV9rrdRFHA.3716@.TK2MSFTNGP14.phx.gbl...
> Yes, this is standard practice when installing new instances of SQL Server
> around here.
> Jens Süßmeyer wrote:
>> Did you switched on Mixed Mode Autentification on Sql Server ?
>> HTH, Jens Süßmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>>
>> "Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
>> news:OTHMxhbRFHA.3076@.TK2MSFTNGP14.phx.gbl...
>>I have seen this discussed before here, but I guess not quite that way I
>>want to use it. We would like to use pure Windows NT Integrated Security,
>>therefore taking advantage of AD groups and existing security in SQL
>>Server. However, anytime we select the 'Windows NT Integrated Security'
>>option in the data source, we always get the following error:
>>Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>>Server connection.
>>Can anybody help? Thanks!
>>|||I am modifying the (shared) datasource on the Report Server. Kerberos is enabled
across the board.
Connection type: Microsoft SQL Server
Connection string: data source=MYSERVER;initial catalog=ENTERPRISE
Connect using: Windows NT Integrated Security
Jens Süßmeyer wrote:
> Seems taht you did´nt spedify the security settings in the right way. YOu
> may have a look here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_datasources_v1_87e9.asp
> Make sure that when you redeploy your datasources you select the "Overwrite
> datasources" option.
> When even then its not working please post the part of your infrastructure
> here, so that we can see how you get acces to the datasources (Servers,
> ect.)
> HTH, Jens Süßmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
> news:eGV9rrdRFHA.3716@.TK2MSFTNGP14.phx.gbl...
>>Yes, this is standard practice when installing new instances of SQL Server
>>around here.
>>Jens Süßmeyer wrote:
>>Did you switched on Mixed Mode Autentification on Sql Server ?
>>HTH, Jens Süßmeyer.
>>--
>>http://www.sqlserver2005.de
>>--
>>
>>
>>"Darrell" <Darrell.Wright.nospam@.okc.gov> schrieb im Newsbeitrag
>>news:OTHMxhbRFHA.3076@.TK2MSFTNGP14.phx.gbl...
>>
>>I have seen this discussed before here, but I guess not quite that way I
>>want to use it. We would like to use pure Windows NT Integrated Security,
>>therefore taking advantage of AD groups and existing security in SQL
>>Server. However, anytime we select the 'Windows NT Integrated Security'
>>option in the data source, we always get the following error:
>>Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>>Server connection.
>>Can anybody help? Thanks!
>>
>

Login failed for user '(null)'

Hi,

I am using a Third Party software which depends on my SQL Server 2000 for storing data. When I use Windows Security in my Third Party software, I get the following message in the event viewer of my SQL Server 2000.

Description:

18452:
Login failed for user '(null)'. Reason: Not associated with trusted SQL Server connection.

When I user SA, I do not get the above error.

Any clarifications on the possibilites for getting the error is appreciated.
Also let me know if we can overcome the error without using SA.

I tried the article in http://support.microsoft.com/kb/840219. But it didn't make a difference.

I would check with the third party app. It seems like they are using an account that isn't authorized in SQL Server. It all depends on how they have implemented their connection.|||

Are the application and the SQL Server running on the same machine? If not, are the machines in the same domain?

If you search this forum for the text of the error, you will find additional related threads that may contain hints helpful to you.

Thanks
Laurentiu

|||

check the authentication of your SQL Server. which authentication r u using..

Madhu

|||

Hi Santhosh,

Santhosh Pallikara wrote:

Hi,

I am using a Third Party software which depends on my SQL Server 2000 for storing data. When I use Windows Security in my Third Party software, I get the following message in the event viewer of my SQL Server 2000.

Description:

18452:
Login failed for user '(null)'. Reason: Not associated with trusted SQL Server connection.

When I user SA, I do not get the above error.

Any clarifications on the possibilites for getting the error is appreciated.
Also let me know if we can overcome the error without using SA.

I tried the article in http://support.microsoft.com/kb/840219. But it didn't make a difference.

You have said that when you are using user "SA" you are not getting error, which means application connects using "SQL/Mixed Authentication Mode" , as Madhu said have you check the authentication mode for server , ensure your application connection string uses Windows Authentication based connection string while you are trying with windows users to login in your application refer http://www.connectionstrings.com for connection string and refer http://hemantgirisgoswami.blogspot.com/2006_11_01_hemantgirisgoswami_archive.html to know/change the Authentication Mode of Server.

Hemantgiri S. Goswami

Wednesday, March 21, 2012

Login failed for the user (using windows integrated security)

Hello Everyone,

I am trying to connect SQL database through code but I get this error,I have spent days to solve it but unfortunately I couldn't...Here is my code in VB express(OP:windows 2000 with SP4)I am new to VB,so it makes the situation more difficult for me.

my code is:

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim conn1 As SqlConnection = _

New SqlConnection("Data Source=.\SQLEXPRESS;" & _

"Integrated Security=SSPI;" & _

"database=deneme3_database;")

'Open connection

conn1.Open()

MessageBox.Show("Connection succeeded.")

'Close connection

conn1.Close()

MessageBox.Show("Connection closed.")

End Sub

The error message is,it is in german but it is clear I guess:)

" Die von der Anmeldung angeforderte "deneme3_database"-Datenbank kann nicht ge?ffnet werden. Fehler bei der Anmeldung.
Fehler bei der Anmeldung für den Benutzer 'ADPLAN\atalay'. "

Thank you in advance!

Can

The database mentioned in the connection string under database or Initial catalog is not present on the server or not accessible to the user. So either grant additional rights to the user or choose another database for the initial connection.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hallo,

First of all I'd like to thank you for your reply.

The mentioned database was also created by me ,using new project in VB express and was also saved on the same PC. I don't actually know how to get permission to use it...I am new to VB and SQL so it makes the things a bit difficult for me.I also enable TCP/IP connection and pipes in SQL Express Server and also disabled the firewall but anyway I get the same error...

I have to write a program connecting to an external device and get the data from the device and compare it with the data in SQL database.But I stucked in the beginning...

Regards,

Can

|||

For a quick one, try to add the user to the sysadmin group to let him access the database (if it is based on a security issue)

sp_addsrvrolemember [ @.loginame= ] 'login'
, [ @.rolename = ] 'role'


For granular configuration, use the following procedure to grant him access to the db (not any objects so far)

sp_grantlogin [@.loginame=] 'login'
sp_defaultdb [ @.loginame = ] 'login', [ @.defdb = ] 'database'
sp_grantdbaccess [ @.loginame = ] 'login'
[ , [ @.name_in_db = ] 'name_in_db' [ OUTPUT ] ]

The same can be done within the Managment Studio.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de


|||

Hi Mr. Suessmeyer,

Again thank you for your reply...But I don't know where to enter this code in SSMS...It'd be kind of you you if you could explain it to me a bit more detailed.I am new to SQL and VB...Thank you!

Can

|||

hi Can,

outcast1881 wrote:

Hi Mr. Suessmeyer,

Again thank you for your reply...But I don't know where to enter this code in SSMS...It'd be kind of you you if you could explain it to me a bit more detailed.I am new to SQL and VB...Thank you!

Can

you can execute the statemets Jens provided via any tool able to send command to SQL Server... for your convenience, you can download and use SQL Server Management Studio Express, the free graphical management tool for SQLExpress at http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en..

after connecting to the required SQL Server instance, you can open a "new query" window and execute them...

the very same tool provides a graphical interface to manage Logins, database Users and the like..

regards

Login failed for the user (using windows integrated security)

Hello Everyone,

I am trying to connect SQL database through code but I get this error,I have spent days to solve it but unfortunately I couldn't...Here is my code in VB express(OP:windows 2000 with SP4)I am new to VB,so it makes the situation more difficult for me.

my code is:

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim conn1 As SqlConnection = _

New SqlConnection("Data Source=.\SQLEXPRESS;" & _

"Integrated Security=SSPI;" & _

"database=deneme3_database;")

'Open connection

conn1.Open()

MessageBox.Show("Connection succeeded.")

'Close connection

conn1.Close()

MessageBox.Show("Connection closed.")

End Sub

The error message is,it is in german but it is clear I guess:)

" Die von der Anmeldung angeforderte "deneme3_database"-Datenbank kann nicht ge?ffnet werden. Fehler bei der Anmeldung.
Fehler bei der Anmeldung für den Benutzer 'ADPLAN\atalay'. "

Thank you in advance!

Can

The database mentioned in the connection string under database or Initial catalog is not present on the server or not accessible to the user. So either grant additional rights to the user or choose another database for the initial connection.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hallo,

First of all I'd like to thank you for your reply.

The mentioned database was also created by me ,using new project in VB express and was also saved on the same PC. I don't actually know how to get permission to use it...I am new to VB and SQL so it makes the things a bit difficult for me.I also enable TCP/IP connection and pipes in SQL Express Server and also disabled the firewall but anyway I get the same error...

I have to write a program connecting to an external device and get the data from the device and compare it with the data in SQL database.But I stucked in the beginning...

Regards,

Can

|||

For a quick one, try to add the user to the sysadmin group to let him access the database (if it is based on a security issue)

sp_addsrvrolemember [ @.loginame= ] 'login'
, [ @.rolename = ] 'role'


For granular configuration, use the following procedure to grant him access to the db (not any objects so far)

sp_grantlogin [@.loginame=] 'login'
sp_defaultdb [ @.loginame = ] 'login', [ @.defdb = ] 'database'
sp_grantdbaccess [ @.loginame = ] 'login'
[ , [ @.name_in_db = ] 'name_in_db' [ OUTPUT ] ]

The same can be done within the Managment Studio.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de


|||

Hi Mr. Suessmeyer,

Again thank you for your reply...But I don't know where to enter this code in SSMS...It'd be kind of you you if you could explain it to me a bit more detailed.I am new to SQL and VB...Thank you!

Can

|||

hi Can,

outcast1881 wrote:

Hi Mr. Suessmeyer,

Again thank you for your reply...But I don't know where to enter this code in SSMS...It'd be kind of you you if you could explain it to me a bit more detailed.I am new to SQL and VB...Thank you!

Can

you can execute the statemets Jens provided via any tool able to send command to SQL Server... for your convenience, you can download and use SQL Server Management Studio Express, the free graphical management tool for SQLExpress at http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en..

after connecting to the required SQL Server instance, you can open a "new query" window and execute them...

the very same tool provides a graphical interface to manage Logins, database Users and the like..

regards

Monday, March 12, 2012

Login Confusion

Hi,

I am Just beginning to get to grips with SQL Server v 7 security on a stand
alone win 98 PC.

I have created a login which only has access to the pubs database and when I
try and connect to any other database (while using this login) I am
correctly told that I don't have access. However, Enterprise Manager does
not request a login and therefore the log in seems to grant full access to
every database.

How can I get Enterprise Manager to request a log in?

Thanks.Stevie D (Steve@.127.0.0.1) writes:
> I have created a login which only has access to the pubs database and
> when I try and connect to any other database (while using this login) I
> am correctly told that I don't have access. However, Enterprise Manager
> does not request a login and therefore the log in seems to grant full
> access to every database.
> How can I get Enterprise Manager to request a log in?

Right-click the server and select Edit Registration properties. There
is a checkbox for always being prompted.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks Erland

This worked fine

"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns960F305E4DBEYazorman@.127.0.0.1...
> Stevie D (Steve@.127.0.0.1) writes:
> > I have created a login which only has access to the pubs database and
> > when I try and connect to any other database (while using this login) I
> > am correctly told that I don't have access. However, Enterprise Manager
> > does not request a login and therefore the log in seems to grant full
> > access to every database.
> > How can I get Enterprise Manager to request a log in?
> Right-click the server and select Edit Registration properties. There
> is a checkbox for always being prompted.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp