Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 User getting security login dialog...

Author  Topic 

cidr2
Starting Member

28 Posts

Posted - 2008-12-09 : 04:56:16
Hi there,

I've developed a database and have had it deployed onto the server. i don't have server scope permissions, only permissions to the databases that I've developed.

I thought creating a new user in the database security folder and giving the appropriate permissions would be enough, however, when the user tries to access the db from the frontend form they're asked to login to the server.

Do I have to create a "Login" for that user from the Server security before I can give them access?

Hope someone can help.

Thanks

teewatts
Starting Member

1 Post

Posted - 2008-12-09 : 15:30:40
Are you using SQL or Windows authenication?
Go to Top of Page
   

- Advertisement -