Database Mirroring and Login Transfer

Hi All:
I am running SQL 2005 EE SP1 and have implemented database mirroring and
have a mix of SQL accounts and Windows accounts. . Is there a way to
automatically synchronize logins between the servers...including additions,
deletions, roles, passwords, permissions and SIDs. I know Mirroring has
nothing built in for this but am hoping someone has figured something out.For additions, I use sp_help_revlogin to synchronize logins between servers,
the procedure is described in the following article:
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
"Jim Norton" wrote:

> Hi All:
> I am running SQL 2005 EE SP1 and have implemented database mirroring and
> have a mix of SQL accounts and Windows accounts. . Is there a way to
> automatically synchronize logins between the servers...including additions
,
> deletions, roles, passwords, permissions and SIDs. I know Mirroring has
> nothing built in for this but am hoping someone has figured something out.
>
>
>|||Check my post about this. I had the same problem some days ago ...
8e803" target="_blank">http://groups.google.com/group/micr...38
8e803
Let me know.
My 2 cents: do not use the script, its easier with SSIS...
Edgardo wrote:[vbcol=seagreen]
> For additions, I use sp_help_revlogin to synchronize logins between server
s,
> the procedure is described in the following article:
> How to transfer logins and passwords between instances of SQL Server
> http://support.microsoft.com/kb/246133
>
> "Jim Norton" wrote:
>sql

Database Mirroring and Login Transfer

Hi All:
I am running SQL 2005 EE SP1 and have implemented database mirroring and
have a mix of SQL accounts and Windows accounts. . Is there a way to
automatically synchronize logins between the servers...including additions,
deletions, roles, passwords, permissions and SIDs. I know Mirroring has
nothing built in for this but am hoping someone has figured something out.For additions, I use sp_help_revlogin to synchronize logins between servers,
the procedure is described in the following article:
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
"Jim Norton" wrote:
> Hi All:
> I am running SQL 2005 EE SP1 and have implemented database mirroring and
> have a mix of SQL accounts and Windows accounts. . Is there a way to
> automatically synchronize logins between the servers...including additions,
> deletions, roles, passwords, permissions and SIDs. I know Mirroring has
> nothing built in for this but am hoping someone has figured something out.
>
>
>|||Check my post about this. I had the same problem some days ago ...
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/306b27dfc6f8f8ce/a691c85fe388e803?lnk=st&q=jocamp3%40gmail.com&rnum=1#a691c85fe388e803
Let me know.
My 2 cents: do not use the script, its easier with SSIS...
Edgardo wrote:
> For additions, I use sp_help_revlogin to synchronize logins between servers,
> the procedure is described in the following article:
> How to transfer logins and passwords between instances of SQL Server
> http://support.microsoft.com/kb/246133
>
> "Jim Norton" wrote:
> > Hi All:
> >
> > I am running SQL 2005 EE SP1 and have implemented database mirroring and
> > have a mix of SQL accounts and Windows accounts. . Is there a way to
> > automatically synchronize logins between the servers...including additions,
> > deletions, roles, passwords, permissions and SIDs. I know Mirroring has
> > nothing built in for this but am hoping someone has figured something out.
> >
> >
> >
> >
> >
> >

Database Mirroring and Login Transfer

Hi All:
I am running SQL 2005 EE SP1 and have implemented database mirroring and
have a mix of SQL accounts and Windows accounts. . Is there a way to
automatically synchronize logins between the servers...including additions,
deletions, roles, passwords, permissions and SIDs. I know Mirroring has
nothing built in for this but am hoping someone has figured something out.
For additions, I use sp_help_revlogin to synchronize logins between servers,
the procedure is described in the following article:
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
"Jim Norton" wrote:

> Hi All:
> I am running SQL 2005 EE SP1 and have implemented database mirroring and
> have a mix of SQL accounts and Windows accounts. . Is there a way to
> automatically synchronize logins between the servers...including additions,
> deletions, roles, passwords, permissions and SIDs. I know Mirroring has
> nothing built in for this but am hoping someone has figured something out.
>
>
>
|||Check my post about this. I had the same problem some days ago ...
[url]http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/306b27dfc6f8f8ce/a691c85fe388e803?lnk=st&q=jocamp3%40gmail.com&rnum =1#a691c85fe388e803[/url]
Let me know.
My 2 cents: do not use the script, its easier with SSIS...
Edgardo wrote:[vbcol=seagreen]
> For additions, I use sp_help_revlogin to synchronize logins between servers,
> the procedure is described in the following article:
> How to transfer logins and passwords between instances of SQL Server
> http://support.microsoft.com/kb/246133
>
> "Jim Norton" wrote:

Database Mail is not working for me on 64 bit SQL 2005

hmm..what login is the mail service running under? Are you sure that user
has permissions to read the msdb system database?
"John D." <JohnD@.discussions.microsoft.com> wrote in message
news:28596E29-6110-4A44-806F-6E82C2A86983@.microsoft.com...
>I am trying to get Database mail working on our win 2003 EE 64 bit SQL 2005
> SP 1 EE 64bit server. I have done a ton of searching around other posts &
> have checked everything that people have said would work. Nothing has
> worked
> so far with me. The mail service is enabled, broker service is enabled &
> relay permission is allowed for the service. Here is the error message I
> am
> getting: Could not retrieve items from the queue. If I look at the
> queue,
> it does have several test messages in there waiting to be sent. Any ideas
> on
> what else I could try to get this to work?
> Thanks!
> John
>I am trying to get Database mail working on our win 2003 EE 64 bit SQL 2005
SP 1 EE 64bit server. I have done a ton of searching around other posts &
have checked everything that people have said would work. Nothing has worke
d
so far with me. The mail service is enabled, broker service is enabled &
relay permission is allowed for the service. Here is the error message I am
getting: Could not retrieve items from the queue. If I look at the queue,
it does have several test messages in there waiting to be sent. Any ideas o
n
what else I could try to get this to work?
Thanks!
John|||hmm..what login is the mail service running under? Are you sure that user
has permissions to read the msdb system database?
"John D." <JohnD@.discussions.microsoft.com> wrote in message
news:28596E29-6110-4A44-806F-6E82C2A86983@.microsoft.com...
>I am trying to get Database mail working on our win 2003 EE 64 bit SQL 2005
> SP 1 EE 64bit server. I have done a ton of searching around other posts &
> have checked everything that people have said would work. Nothing has
> worked
> so far with me. The mail service is enabled, broker service is enabled &
> relay permission is allowed for the service. Here is the error message I
> am
> getting: Could not retrieve items from the queue. If I look at the
> queue,
> it does have several test messages in there waiting to be sent. Any ideas
> on
> what else I could try to get this to work?
> Thanks!
> John
>|||Pardon my ignorance but how where do you set what login the mail service is
running under? Does it use the login that SQL Agent is running under? I
enabled it in the surface area configuration tool.
"Tim Greenwood" wrote:

> hmm..what login is the mail service running under? Are you sure that user
> has permissions to read the msdb system database?
>
> "John D." <JohnD@.discussions.microsoft.com> wrote in message
> news:28596E29-6110-4A44-806F-6E82C2A86983@.microsoft.com...
>
>|||Pardon my ignorance but how where do you set what login the mail service is
running under? Does it use the login that SQL Agent is running under? I
enabled it in the surface area configuration tool.
"Tim Greenwood" wrote:

> hmm..what login is the mail service running under? Are you sure that user
> has permissions to read the msdb system database?
>
> "John D." <JohnD@.discussions.microsoft.com> wrote in message
> news:28596E29-6110-4A44-806F-6E82C2A86983@.microsoft.com...
>
>

Database Login fails

Hi

I can logon to my Sql server using the SSMS management tool, I am using Windows Authentication to logon to SSMS. Create a database OK, with all the necessary tables.

However when I start a VB Express app and try to connect to this database I get an error that login filed for user AMD\Larry, AMD is my PC name and my login (Larry) is the computer Administrator logon. The PC is a standalone ie not part of a domain etc.

Can anyone help?

Regards.

Larry.

Hi Larry,

to solve you problem: in SSMS, connect to your database, go to Security, Logins, New Login, Add new login as AMD\Larry and give it right to access your database.

good luck

mario

|||Are you also using integrated Authentication in VB Express. Make sure that you don′t really *type* in the user as this will be recognized as a SQL Server login. Integrated login is done in the background and don′t have be typed in somewhere (I also mention that becasue many people are always confused about that)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks for these I wil try them and get back.

Database login

I have a web based application that could have many clients/users.
Should I create a user account for each client browsing the web site.
They can only access certain data after they have been verified from a
user table. They use a common database login to access the data. This
is planned to be a public free site. So hopefully the client count
will be high.create login that the application uses to get to the DB... instead of
creating a login for each user.|||Ok thats they wey I'm approaching it now.|||Are you using an ODBC or DSN less, either way assuming the users should
have the same permissions then 1 user is created in the db with a certain
level of permissions. You may also have an admin section , therfore the
admin user may have a different set of permissions
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"nathan001" <nathan@.thelosthorizon.com> wrote in message
news:1143477924.849156.7120@.z34g2000cwc.googlegroups.com...
> Ok thats they wey I'm approaching it now.
>|||From what you describe, it sounds like you need ASP.NET Forms
Authentication. At a minimum, you will need to implement a table with one
row for each subscriber.
ASP.NET Forms Authentication Overview
http://msdn2.microsoft.com/en-us/library/7t6b43z4.aspx
As for database (server) logins, you will need to implement one login for
each type of user (admin, subscriber, guest, etc.) and then use SQL Server
role based permissions to restrict each user's access to specific database
objects.
SQL Server 2000 Administrator's Pocket Consultant - Chapter 5: SQL Server
2000 Security
http://www.microsoft.com/technet/pr...s/c05ppcsq.mspx
SQL Server 2000 Operations Guide: Security Administration
http://www.microsoft.com/technet/pr...in/sqlops3.mspx
SQL Server 2000 Resource Kit - Chapter 10: Implementing Security
http://www.microsoft.com/technet/pr...fr=true

If this database is hosted by a 3rd party internet service provider, then
you will need to coordinate with the server administrator to setup the
logins and permissions, becuase these configurations require server admin
rights. If your ISP provides this functionality through their website
management tool, then that's great, but that would be exceptional.
"nathan001" <nathan@.thelosthorizon.com> wrote in message
news:1143473709.083112.37370@.i40g2000cwc.googlegroups.com...
>I have a web based application that could have many clients/users.
> Should I create a user account for each client browsing the web site.
> They can only access certain data after they have been verified from a
> user table. They use a common database login to access the data. This
> is planned to be a public free site. So hopefully the client count
> will be high.
>

Database Level Security Doubt in SQL6.5

In our SQL Server6.5, I drop a user from in one database using ‘sp_dropuse
r’
command, still with that specific login; I could able to access the database
.
It’s working fine in other database, but its not working only in one datab
ase.
For this login, there is no entries in Sysusers table of the respective
database.
Please help usWhat does 'SELECT USER' return? It may be that the login is mapped to a
different user in that database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dineshkumar" <Dineshkumar@.discussions.microsoft.com> wrote in message
news:0B35489E-175D-439D-8DF1-295B0B51AEE1@.microsoft.com...
> In our SQL Server6.5, I drop a user from in one database using
> 'sp_dropuser'
> command, still with that specific login; I could able to access the
> database.
> It's working fine in other database, but its not working only in one
> database.
> For this login, there is no entries in Sysusers table of the respective
> database.
> Please help us