Another Login after restoring database

Hello all,
I have created a backup of a database and Restored as a new database in another machine.
Primary login of the database was X , now after restoring as a new database I dont want X as the login name i want it to be Y ...
how to do that ?

I can create other login as y and Give necessary premissions...but the Problem is i have to manually issue all the permissions to the new user which i feel is a time taking process.

Please let me know about it..

Thanks and Regards
saiI am not sure but u can try this :
script the login and user for the database in question,after generating the script for the user X,delete the the user X from the database ,Replace the user/login name X from the script with Y and run the script on the database.
I think this should work after some enhancements in the script.|||Use roles!

Or sp_change_users_login SP

Another 17055 error problem

After applying some updates (root certificate,jet4.0 SP8
and security updates 810217,828749and 824145), I now get
the following error:
18454 :
Login succeeded for user '<user name>_SQL'. Connection:
Non-Trusted.
Where <user name> is the login name.
We are running SQL2000. Permissions are set for Windows
and SQL.
Any thoughts?That just looks like you have Auditing set to either Success or All. You can
check this by looking at the Security Tab on the Server Properies dialog.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Bob" <anonymous@.discussions.microsoft.com> wrote in message
news:955c01c3ea8c$b7036580$a001280a@.phx.gbl...

quote:

---

> After applying some updates (root certificate,jet4.0 SP8
> and security updates 810217,828749and 824145), I now get
> the following error:
> 18454 :
> Login succeeded for user '<user name>_SQL'. Connection:
> Non-Trusted.
> Where <user name> is the login name.
> We are running SQL2000. Permissions are set for Windows
> and SQL.
> Any thoughts?

---

|||Those are now off and it made no change. I have turned
off the information also and that stops the log from
filling up. But it does not stop the problem.
Thanks

quote:

---

>--Original Message--
>That just looks like you have Auditing set to either

---

Success or All. You can

quote:

---

>check this by looking at the Security Tab on the Server

---

Properies dialog.

quote:

---

>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Bob" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:955c01c3ea8c$b7036580$a001280a@.phx.gbl...
>
>.
>

---

|||I'm not quite sure what you mean by "I have turned off the information also"
?
Changing the audit setting requires a restart of the service I think to take
effect
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:932701c3eac2$bc05d640$a301280a@.phx.gbl...[QUOTE]
> Those are now off and it made no change. I have turned
> off the information also and that stops the log from
> filling up. But it does not stop the problem.
> Thanks
>
> Success or All. You can
> Properies dialog.
> message|||I meant in the filter settings is where I turned those
off.

quote:

---

>--Original Message--
>I'm not quite sure what you mean by "I have turned off

---

the information also"

quote:

---

>?
>Changing the audit setting requires a restart of the

---

service I think to take

quote:

---

>effect
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:932701c3eac2$bc05d640$a301280a@.phx.gbl...
SP8[QUOTE]
get[QUOTE]
Connection:[QUOTE]
Windows[QUOTE]
>
>.
>

---

Anonymous Logon error since SP4

Since SP4 my application and SQL log are filling with "Login failed for user
"NT Authority\Anonymous Logon". Where can I find more information
concerning this?
I've seen one or two references to this error showing up with SQL
replication but this is a single server install.
-trevor
Trevor,
Check that SQL Server is running under a domain account - this error
commonly occurs when running as LocalSystem and you try to access network
resources.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Trevor Miller" wrote:

> Since SP4 my application and SQL log are filling with "Login failed for user
> "NT Authority\Anonymous Logon". Where can I find more information
> concerning this?
> I've seen one or two references to this error showing up with SQL
> replication but this is a single server install.
> -trevor
>
>
|||SQL server indeed runs as LocalSystem but it's always been configured this
way, is the error msg a result of SP4 or a change in behavior? What network
resources would SQL be trying to access? I've tried putting the computer
account into domain admins but the error persists.
Additional advise?
-trevor
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:30AAB157-EB94-4680-B088-44689F364AF9@.microsoft.com...[vbcol=seagreen]
> Trevor,
> Check that SQL Server is running under a domain account - this error
> commonly occurs when running as LocalSystem and you try to access network
> resources.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Trevor Miller" wrote:

Anonymous Logon error since SP4

Since SP4 my application and SQL log are filling with "Login failed for user
"NT Authority\Anonymous Logon". Where can I find more information
concerning this?
I've seen one or two references to this error showing up with SQL
replication but this is a single server install.
-trevorTrevor,
Check that SQL Server is running under a domain account - this error
commonly occurs when running as LocalSystem and you try to access network
resources.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Trevor Miller" wrote:

> Since SP4 my application and SQL log are filling with "Login failed for us
er
> "NT Authority\Anonymous Logon". Where can I find more information
> concerning this?
> I've seen one or two references to this error showing up with SQL
> replication but this is a single server install.
> -trevor
>
>|||SQL server indeed runs as LocalSystem but it's always been configured this
way, is the error msg a result of SP4 or a change in behavior? What network
resources would SQL be trying to access? I've tried putting the computer
account into domain admins but the error persists.
Additional advise?
-trevor
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:30AAB157-EB94-4680-B088-44689F364AF9@.microsoft.com...[vbcol=seagreen]
> Trevor,
> Check that SQL Server is running under a domain account - this error
> commonly occurs when running as LocalSystem and you try to access network
> resources.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Trevor Miller" wrote:
>

Anonymous Logon error since SP4

Since SP4 my application and SQL log are filling with "Login failed for user
"NT Authority\Anonymous Logon". Where can I find more information
concerning this?
I've seen one or two references to this error showing up with SQL
replication but this is a single server install.
-trevorTrevor,
Check that SQL Server is running under a domain account - this error
commonly occurs when running as LocalSystem and you try to access network
resources.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Trevor Miller" wrote:
> Since SP4 my application and SQL log are filling with "Login failed for user
> "NT Authority\Anonymous Logon". Where can I find more information
> concerning this?
> I've seen one or two references to this error showing up with SQL
> replication but this is a single server install.
> -trevor
>
>|||SQL server indeed runs as LocalSystem but it's always been configured this
way, is the error msg a result of SP4 or a change in behavior? What network
resources would SQL be trying to access? I've tried putting the computer
account into domain admins but the error persists.
Additional advise?
-trevor
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:30AAB157-EB94-4680-B088-44689F364AF9@.microsoft.com...
> Trevor,
> Check that SQL Server is running under a domain account - this error
> commonly occurs when running as LocalSystem and you try to access network
> resources.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Trevor Miller" wrote:
>> Since SP4 my application and SQL log are filling with "Login failed for
>> user
>> "NT Authority\Anonymous Logon". Where can I find more information
>> concerning this?
>> I've seen one or two references to this error showing up with SQL
>> replication but this is a single server install.
>> -trevor
>>

Analysis Services and Proclarity

We have following environment setup: SQL Server 2005, SSAS 2005 and Proclarity working together to provide some business intelligence.

I have login problems with Proclarity Dashboar server.

What happens is after user logs in into the dashboard server and leaves the browser (IE6) idle for some period of time, the user gets logged out (due to session time out). Once logged out, the user can't log back in as themselves. Now if the user logins with some other userid and logs out properly, then he/she can log back in again as themselves.

Dashboard uses the windows userid/password for logins.

Anybodys help would be greatly appriciated.

Thanks

Giri

Looks like you are using basic authentication for the ProClarity Dashboard server? You have the option to use windows integrated security!

My advice is to contact http://www.proclarity.com/services/support.asp about this issue. You will need a valid account for this. As a customer you will also have access to information on two ProClarity communities. I have seen a lot of discussions and recommendations of how to set up windows integrated security(Active Directory) with ProClarity Dashboard Server 6.2

It is impossible to write all the details you will have to know here.

HTH

Thomas Ivarsson