can we change the file size that c2 creates a new trc file at ?

hello there
I want to know if I can have sql server C2 login log to a file till it
reaches 10 megs and switch to another one.
the reason is that I want to ship the logs to a log aggregation software
every hour or so ?
any ideas ?
Hi,
As far as I know we cant change the trace file size after enabling C2 audit.
Thanks
Hari
SQL Server MVP
"Simo Sentissi" <msentissi@.rightnow.com> wrote in message
news:eSKK8R3dFHA.688@.TK2MSFTNGP14.phx.gbl...
> hello there
> I want to know if I can have sql server C2 login log to a file till it
> reaches 10 megs and switch to another one.
> the reason is that I want to ship the logs to a log aggregation software
> every hour or so ?
> any ideas ?
>

can we change the file size that c2 creates a new trc file at ?

hello there
I want to know if I can have sql server C2 login log to a file till it
reaches 10 megs and switch to another one.
the reason is that I want to ship the logs to a log aggregation software
every hour or so ?
any ideas ?Hi,
As far as I know we cant change the trace file size after enabling C2 audit.
Thanks
Hari
SQL Server MVP
"Simo Sentissi" <msentissi@.rightnow.com> wrote in message
news:eSKK8R3dFHA.688@.TK2MSFTNGP14.phx.gbl...
> hello there
> I want to know if I can have sql server C2 login log to a file till it
> reaches 10 megs and switch to another one.
> the reason is that I want to ship the logs to a log aggregation software
> every hour or so ?
> any ideas ?
>

can we change the file size that c2 creates a new trc file at ?

hello there
I want to know if I can have sql server C2 login log to a file till it
reaches 10 megs and switch to another one.
the reason is that I want to ship the logs to a log aggregation software
every hour or so ?
any ideas ?Hi,
As far as I know we cant change the trace file size after enabling C2 audit.
Thanks
Hari
SQL Server MVP
"Simo Sentissi" <msentissi@.rightnow.com> wrote in message
news:eSKK8R3dFHA.688@.TK2MSFTNGP14.phx.gbl...
> hello there
> I want to know if I can have sql server C2 login log to a file till it
> reaches 10 megs and switch to another one.
> the reason is that I want to ship the logs to a log aggregation software
> every hour or so ?
> any ideas ?
>sql

Can SQL 2000 restore database and user login on another server?

Can SQL 2000 restore user login and database to another
domain and computer name? If it can't, how to export user
login to another computer?
You can migrate logins from one server to another server by generating a
script using a routine called sp_help_revlogin. Here is an article I wrote
about it:
http://databasejournal.com/features/...le.php/2228611
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Mesak" <anonymous@.discussions.microsoft.com> wrote in message
news:481301c49fe2$d7215e10$a401280a@.phx.gbl...
> Can SQL 2000 restore user login and database to another
> domain and computer name? If it can't, how to export user
> login to another computer?

Can SQL 2000 restore database and user login on another server?

Can SQL 2000 restore user login and database to another
domain and computer name? If it can't, how to export user
login to another computer?You can migrate logins from one server to another server by generating a
script using a routine called sp_help_revlogin. Here is an article I wrote
about it:
http://databasejournal.com/features/mssql/article.php/2228611
--
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Mesak" <anonymous@.discussions.microsoft.com> wrote in message
news:481301c49fe2$d7215e10$a401280a@.phx.gbl...
> Can SQL 2000 restore user login and database to another
> domain and computer name? If it can't, how to export user
> login to another computer?

Can someone show me how.....

I'm beginner in asp.net. Can someone show me how to create coding for this page..

i have to create my own login page and database. I'm using sql sever 2005 for database. can someone show me how to make connection with my login button and my database? please...i'm really need help from you all guys.

Hi

Simple User Account Login demonstration of managing user account information on a server in traditional way using ASP.NET 1.1.

If you prefer asp.net 2.0 refer toHow to implement Two basics uses for the Asp.net Login control 2.0 (login and RememberMe).

Hope this helps.

|||hi yyy8347, i will try it now. thanks yeah!

can someone login as "NT AUTHORITY\SYSTEM "

Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
one of our servers. I log both the failed and successful logins and both of
the above logins were used recently. Do they have passwords that can be set?
What would be the implications if I removed both of them from
"security/logins"? I'm running both the server service and agent service with
a different login so it wouldn't affect the jobs.
Thanks,
Dan D.
Hi Dan
These are the name of the accounts when you specify local system or network
service as the accounts in which a service runs under see
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
John
"Dan D." wrote:

> Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
> AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
> one of our servers. I log both the failed and successful logins and both of
> the above logins were used recently. Do they have passwords that can be set?
> What would be the implications if I removed both of them from
> "security/logins"? I'm running both the server service and agent service with
> a different login so it wouldn't affect the jobs.
> Thanks,
> --
> Dan D.
|||I came across an article today about how someone could log in as NT AUTHORITY
through the cmd window using the task scheduler and I got a little concerned.
Thanks for the article.
Dan D.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Dan
> These are the name of the accounts when you specify local system or network
> service as the accounts in which a service runs under see
> http://msdn2.microsoft.com/en-us/library/ms191543.aspx
> John
> "Dan D." wrote:
|||Hi Dan
Could you can post a link to the article?
John
"Dan D." wrote:
[vbcol=seagreen]
> I came across an article today about how someone could log in as NT AUTHORITY
> through the cmd window using the task scheduler and I got a little concerned.
> Thanks for the article.
> --
> Dan D.
>
> "John Bell" wrote:
|||Sometimes the page doesn't render correctly. You may have to scroll down to
see the beginning of the article.
http://www.ozzu.com/ftopic1337.html
Dan D.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Dan
> Could you can post a link to the article?
> John
> "Dan D." wrote:
|||Hi Dan
The article is talking about a vunerability highlighted in
http://support.microsoft.com/?kbid=823980 that can be exploited by a specific
worm, rather than something actually logging in a the account. You should
make sure that your system is patched to a level which does not have this
issue. Tools like Microsoft Baseline Security Advisor will help you configure
your systems check out http://msdn2.microsoft.com/en-us/library/aa302360.aspx
John
"Dan D." wrote:
[vbcol=seagreen]
> Sometimes the page doesn't render correctly. You may have to scroll down to
> see the beginning of the article.
> http://www.ozzu.com/ftopic1337.html
> --
> Dan D.
>
> "John Bell" wrote:
|||Thanks. I do run the Baseline Security Analyzer.
Dan D.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Dan
> The article is talking about a vunerability highlighted in
> http://support.microsoft.com/?kbid=823980 that can be exploited by a specific
> worm, rather than something actually logging in a the account. You should
> make sure that your system is patched to a level which does not have this
> issue. Tools like Microsoft Baseline Security Advisor will help you configure
> your systems check out http://msdn2.microsoft.com/en-us/library/aa302360.aspx
> John
> "Dan D." wrote:
|||Hi Dan
Hopefully you have patched this, make sure that you keep your MBSA up to date.
John
"Dan D." wrote:
[vbcol=seagreen]
> Thanks. I do run the Baseline Security Analyzer.
> --
> Dan D.
>
> "John Bell" wrote:

can someone login as "NT AUTHORITY\SYSTEM "

Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
one of our servers. I log both the failed and successful logins and both of
the above logins were used recently. Do they have passwords that can be set?
What would be the implications if I removed both of them from
"security/logins"? I'm running both the server service and agent service with
a different login so it wouldn't affect the jobs.
Thanks,
--
Dan D.Hi Dan
These are the name of the accounts when you specify local system or network
service as the accounts in which a service runs under see
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
John
"Dan D." wrote:
> Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
> AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
> one of our servers. I log both the failed and successful logins and both of
> the above logins were used recently. Do they have passwords that can be set?
> What would be the implications if I removed both of them from
> "security/logins"? I'm running both the server service and agent service with
> a different login so it wouldn't affect the jobs.
> Thanks,
> --
> Dan D.|||I came across an article today about how someone could log in as NT AUTHORITY
through the cmd window using the task scheduler and I got a little concerned.
Thanks for the article.
--
Dan D.
"John Bell" wrote:
> Hi Dan
> These are the name of the accounts when you specify local system or network
> service as the accounts in which a service runs under see
> http://msdn2.microsoft.com/en-us/library/ms191543.aspx
> John
> "Dan D." wrote:
> > Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
> > AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
> > one of our servers. I log both the failed and successful logins and both of
> > the above logins were used recently. Do they have passwords that can be set?
> >
> > What would be the implications if I removed both of them from
> > "security/logins"? I'm running both the server service and agent service with
> > a different login so it wouldn't affect the jobs.
> >
> > Thanks,
> > --
> > Dan D.|||Hi Dan
Could you can post a link to the article?
John
"Dan D." wrote:
> I came across an article today about how someone could log in as NT AUTHORITY
> through the cmd window using the task scheduler and I got a little concerned.
> Thanks for the article.
> --
> Dan D.
>
> "John Bell" wrote:
> > Hi Dan
> >
> > These are the name of the accounts when you specify local system or network
> > service as the accounts in which a service runs under see
> > http://msdn2.microsoft.com/en-us/library/ms191543.aspx
> >
> > John
> >
> > "Dan D." wrote:
> >
> > > Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
> > > AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
> > > one of our servers. I log both the failed and successful logins and both of
> > > the above logins were used recently. Do they have passwords that can be set?
> > >
> > > What would be the implications if I removed both of them from
> > > "security/logins"? I'm running both the server service and agent service with
> > > a different login so it wouldn't affect the jobs.
> > >
> > > Thanks,
> > > --
> > > Dan D.|||Sometimes the page doesn't render correctly. You may have to scroll down to
see the beginning of the article.
http://www.ozzu.com/ftopic1337.html
--
Dan D.
"John Bell" wrote:
> Hi Dan
> Could you can post a link to the article?
> John
> "Dan D." wrote:
> > I came across an article today about how someone could log in as NT AUTHORITY
> > through the cmd window using the task scheduler and I got a little concerned.
> > Thanks for the article.
> > --
> > Dan D.
> >
> >
> > "John Bell" wrote:
> >
> > > Hi Dan
> > >
> > > These are the name of the accounts when you specify local system or network
> > > service as the accounts in which a service runs under see
> > > http://msdn2.microsoft.com/en-us/library/ms191543.aspx
> > >
> > > John
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
> > > > AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
> > > > one of our servers. I log both the failed and successful logins and both of
> > > > the above logins were used recently. Do they have passwords that can be set?
> > > >
> > > > What would be the implications if I removed both of them from
> > > > "security/logins"? I'm running both the server service and agent service with
> > > > a different login so it wouldn't affect the jobs.
> > > >
> > > > Thanks,
> > > > --
> > > > Dan D.|||Hi Dan
The article is talking about a vunerability highlighted in
http://support.microsoft.com/?kbid=823980 that can be exploited by a specific
worm, rather than something actually logging in a the account. You should
make sure that your system is patched to a level which does not have this
issue. Tools like Microsoft Baseline Security Advisor will help you configure
your systems check out http://msdn2.microsoft.com/en-us/library/aa302360.aspx
John
"Dan D." wrote:
> Sometimes the page doesn't render correctly. You may have to scroll down to
> see the beginning of the article.
> http://www.ozzu.com/ftopic1337.html
> --
> Dan D.
>
> "John Bell" wrote:
> > Hi Dan
> >
> > Could you can post a link to the article?
> >
> > John
> >
> > "Dan D." wrote:
> >
> > > I came across an article today about how someone could log in as NT AUTHORITY
> > > through the cmd window using the task scheduler and I got a little concerned.
> > > Thanks for the article.
> > > --
> > > Dan D.
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi Dan
> > > >
> > > > These are the name of the accounts when you specify local system or network
> > > > service as the accounts in which a service runs under see
> > > > http://msdn2.microsoft.com/en-us/library/ms191543.aspx
> > > >
> > > > John
> > > >
> > > > "Dan D." wrote:
> > > >
> > > > > Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
> > > > > AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
> > > > > one of our servers. I log both the failed and successful logins and both of
> > > > > the above logins were used recently. Do they have passwords that can be set?
> > > > >
> > > > > What would be the implications if I removed both of them from
> > > > > "security/logins"? I'm running both the server service and agent service with
> > > > > a different login so it wouldn't affect the jobs.
> > > > >
> > > > > Thanks,
> > > > > --
> > > > > Dan D.|||Thanks. I do run the Baseline Security Analyzer.
--
Dan D.
"John Bell" wrote:
> Hi Dan
> The article is talking about a vunerability highlighted in
> http://support.microsoft.com/?kbid=823980 that can be exploited by a specific
> worm, rather than something actually logging in a the account. You should
> make sure that your system is patched to a level which does not have this
> issue. Tools like Microsoft Baseline Security Advisor will help you configure
> your systems check out http://msdn2.microsoft.com/en-us/library/aa302360.aspx
> John
> "Dan D." wrote:
> > Sometimes the page doesn't render correctly. You may have to scroll down to
> > see the beginning of the article.
> >
> > http://www.ozzu.com/ftopic1337.html
> >
> > --
> > Dan D.
> >
> >
> > "John Bell" wrote:
> >
> > > Hi Dan
> > >
> > > Could you can post a link to the article?
> > >
> > > John
> > >
> > > "Dan D." wrote:
> > >
> > > > I came across an article today about how someone could log in as NT AUTHORITY
> > > > through the cmd window using the task scheduler and I got a little concerned.
> > > > Thanks for the article.
> > > > --
> > > > Dan D.
> > > >
> > > >
> > > > "John Bell" wrote:
> > > >
> > > > > Hi Dan
> > > > >
> > > > > These are the name of the accounts when you specify local system or network
> > > > > service as the accounts in which a service runs under see
> > > > > http://msdn2.microsoft.com/en-us/library/ms191543.aspx
> > > > >
> > > > > John
> > > > >
> > > > > "Dan D." wrote:
> > > > >
> > > > > > Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
> > > > > > AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
> > > > > > one of our servers. I log both the failed and successful logins and both of
> > > > > > the above logins were used recently. Do they have passwords that can be set?
> > > > > >
> > > > > > What would be the implications if I removed both of them from
> > > > > > "security/logins"? I'm running both the server service and agent service with
> > > > > > a different login so it wouldn't affect the jobs.
> > > > > >
> > > > > > Thanks,
> > > > > > --
> > > > > > Dan D.|||Hi Dan
Hopefully you have patched this, make sure that you keep your MBSA up to date.
John
"Dan D." wrote:
> Thanks. I do run the Baseline Security Analyzer.
> --
> Dan D.
>
> "John Bell" wrote:
> > Hi Dan
> >
> > The article is talking about a vunerability highlighted in
> > http://support.microsoft.com/?kbid=823980 that can be exploited by a specific
> > worm, rather than something actually logging in a the account. You should
> > make sure that your system is patched to a level which does not have this
> > issue. Tools like Microsoft Baseline Security Advisor will help you configure
> > your systems check out http://msdn2.microsoft.com/en-us/library/aa302360.aspx
> >
> > John
> >
> > "Dan D." wrote:
> >
> > > Sometimes the page doesn't render correctly. You may have to scroll down to
> > > see the beginning of the article.
> > >
> > > http://www.ozzu.com/ftopic1337.html
> > >
> > > --
> > > Dan D.
> > >
> > >
> > > "John Bell" wrote:
> > >
> > > > Hi Dan
> > > >
> > > > Could you can post a link to the article?
> > > >
> > > > John
> > > >
> > > > "Dan D." wrote:
> > > >
> > > > > I came across an article today about how someone could log in as NT AUTHORITY
> > > > > through the cmd window using the task scheduler and I got a little concerned.
> > > > > Thanks for the article.
> > > > > --
> > > > > Dan D.
> > > > >
> > > > >
> > > > > "John Bell" wrote:
> > > > >
> > > > > > Hi Dan
> > > > > >
> > > > > > These are the name of the accounts when you specify local system or network
> > > > > > service as the accounts in which a service runs under see
> > > > > > http://msdn2.microsoft.com/en-us/library/ms191543.aspx
> > > > > >
> > > > > > John
> > > > > >
> > > > > > "Dan D." wrote:
> > > > > >
> > > > > > > Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
> > > > > > > AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access to
> > > > > > > one of our servers. I log both the failed and successful logins and both of
> > > > > > > the above logins were used recently. Do they have passwords that can be set?
> > > > > > >
> > > > > > > What would be the implications if I removed both of them from
> > > > > > > "security/logins"? I'm running both the server service and agent service with
> > > > > > > a different login so it wouldn't affect the jobs.
> > > > > > >
> > > > > > > Thanks,
> > > > > > > --
> > > > > > > Dan D.

can someone login as "NT AUTHORITY\SYSTEM "

Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access t
o
one of our servers. I log both the failed and successful logins and both of
the above logins were used recently. Do they have passwords that can be set?
What would be the implications if I removed both of them from
"security/logins"? I'm running both the server service and agent service wit
h
a different login so it wouldn't affect the jobs.
Thanks,
--
Dan D.Hi Dan
These are the name of the accounts when you specify local system or network
service as the accounts in which a service runs under see
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
John
"Dan D." wrote:

> Using SS2000 SP4. Can someone login as either NT AUTHORITY\SYSTEM or NT
> AUTHORITY\NETWORK SERVICE? I'm trying to figure out how someone got access
to
> one of our servers. I log both the failed and successful logins and both o
f
> the above logins were used recently. Do they have passwords that can be se
t?
> What would be the implications if I removed both of them from
> "security/logins"? I'm running both the server service and agent service w
ith
> a different login so it wouldn't affect the jobs.
> Thanks,
> --
> Dan D.|||I came across an article today about how someone could log in as NT AUTHORIT
Y
through the cmd window using the task scheduler and I got a little concerned
.
Thanks for the article.
--
Dan D.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Dan
> These are the name of the accounts when you specify local system or networ
k
> service as the accounts in which a service runs under see
> http://msdn2.microsoft.com/en-us/library/ms191543.aspx
> John
> "Dan D." wrote:
>|||Hi Dan
Could you can post a link to the article?
John
"Dan D." wrote:
[vbcol=seagreen]
> I came across an article today about how someone could log in as NT AUTHOR
ITY
> through the cmd window using the task scheduler and I got a little concern
ed.
> Thanks for the article.
> --
> Dan D.
>
> "John Bell" wrote:
>|||Sometimes the page doesn't render correctly. You may have to scroll down to
see the beginning of the article.
http://www.ozzu.com/ftopic1337.html
Dan D.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Dan
> Could you can post a link to the article?
> John
> "Dan D." wrote:
>|||Hi Dan
The article is talking about a vunerability highlighted in
http://support.microsoft.com/?kbid=823980 that can be exploited by a specifi
c
worm, rather than something actually logging in a the account. You should
make sure that your system is patched to a level which does not have this
issue. Tools like Microsoft Baseline Security Advisor will help you configur
e
your systems check out [url]http://msdn2.microsoft.com/en-us/library/aa302360.aspx[/url
]
John
"Dan D." wrote:
[vbcol=seagreen]
> Sometimes the page doesn't render correctly. You may have to scroll down t
o
> see the beginning of the article.
> http://www.ozzu.com/ftopic1337.html
> --
> Dan D.
>
> "John Bell" wrote:
>|||Thanks. I do run the Baseline Security Analyzer.
--
Dan D.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Dan
> The article is talking about a vunerability highlighted in
> http://support.microsoft.com/?kbid=823980 that can be exploited by a speci
fic
> worm, rather than something actually logging in a the account. You should
> make sure that your system is patched to a level which does not have this
> issue. Tools like Microsoft Baseline Security Advisor will help you config
ure
> your systems check out [url]http://msdn2.microsoft.com/en-us/library/aa302360.aspx[/u
rl]
> John
> "Dan D." wrote:
>|||Hi Dan
Hopefully you have patched this, make sure that you keep your MBSA up to dat
e.
John
"Dan D." wrote:
[vbcol=seagreen]
> Thanks. I do run the Baseline Security Analyzer.
> --
> Dan D.
>
> "John Bell" wrote:
>

Can see Service Broker queue with SQL Server Login

I have an application that is reading a message from a Service Broker Queue. When I use integrated security with an NT account it works fine. When I use a SQL Server User through Management Studio I can select from the Queue however, when I use this same account through the web app with the SQL Server User, I cannot see the Queue. Is there a grant that I must do to this account to get it to see the Service Broker Objects?

Gary

Service broker doesn't use any special security/access checks other than the normal SQL Server security/ access restrictions. If the queue is visible from the SSMS, but not from the Web app, it means that the Web app it connects with different settings/credentials than the SSMS.

Can SA be dropped

Is it possible at all to remove the SA login or deny "System Administrator" from it by loggin as another user who has sa previledges
thanksno

Set a password like

asdf09asdgjlag70agraeur

Save it and put it in a safe...

and use the other id that's set as sysadmin

Can report results be filtered by Windows user login?

Good morning,

I'm in the process of creating a report to show employees and managers holiday and absence information. Is there a way of filtering the results of the report based on who is running the report, so that employees could only see their own information and managers could only see theirs and their subordinates information?

What I was hoping to do was create a lookup table which cross-references Windows logins with employee numbers and then use this information to pass a parameter to the SQL query, but I don't know how to retrieve the login from the machine being used to view the report.

I've heard about row level security and it seems ideal in theory but I fear the implimentation of row level security would be far beyond my meagre knowledge.

Any constructive suggestions welcomed.

Thanks,

Paul

Hello Paul,

Whenever you create an expression, take a look under the Globals node. One your options is User!UserID, this will give you the Windows login of the user running the report.

Hope this helps.

Jarret

|||

Jarret,

I came across the same solution a little earlier, works a treat.

Thanks,

Paul

Can Report Manager be accessed as an Internet application?

Is Report Manager designed to be accessed over the Internet, and if so, is
there a forms based login that can be enabled?
-- Chris, SSSIhttp://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
"Chris G." wrote:
> Is Report Manager designed to be accessed over the Internet, and if so, is
> there a forms based login that can be enabled?
> -- Chris, SSSI|||Mark,
Will that sample run against 2005 Reporting Services with little or no
modification?
-- Chris, SSSI
"Mark" wrote:
> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> "Chris G." wrote:
> > Is Report Manager designed to be accessed over the Internet, and if so, is
> > there a forms based login that can be enabled?
> >
> > -- Chris, SSSI|||I couldn't say, to be honest. I was never even able to get it working with
2000, although that doesn't mean you'd have the same luck (or lack thereof).
If this doesn't work with 2005, then I'm pretty sure there must be resources
online--by Microsoft or somebody else--for implementing the forms
authentication custom extension.
Hope this helps,
Mark
"Chris G." wrote:
> Mark,
> Will that sample run against 2005 Reporting Services with little or no
> modification?
> -- Chris, SSSI
>
> "Mark" wrote:
> > http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> >
> > "Chris G." wrote:
> >
> > > Is Report Manager designed to be accessed over the Internet, and if so, is
> > > there a forms based login that can be enabled?
> > >
> > > -- Chris, SSSI|||Hi Chris,
Thank you for you post and thanks Marks' help.
In the SQL Server 2005 Books online, there is a section about the Forms
Authentication in Reporting Services 2005.
Authentication in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms152899.aspx
Also there is a sample in the SQL Server if you install the samples.
Security Extension Sample
http://msdn2.microsoft.com/en-us/library/ms160724.aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

can objects in sql server change your nt login password

hi guys,
i was wondering if there is a bug in sql server 2000 that upon changing settings in the sqlserver agent or sqlserver services that it will actually change your nt user password.
a strange occurence happened to me i switched the sqlmail to a different outlook profile that is MAPI compliant i had to stop and start the sql server agent upon restart it said it could not log me in b/c my nt logon failed (i guess you can figure out by now that i have authentication as NT in my set up of sql server agent). well me knowing microsoft products i was like ah i will just reboot the machine) well upon reboot my administrator password which is empty "null value"no longer is valid.
now noone in the company said that they changed the administrator password and it is not logged into a domain so the machine is not on our companys network. we log in local to the machine as the administrator. the last things that i played around in with sql server was replication setting it up as a publisher and deleteing it and changing a mapi profile. is there anywhere in sql 2000 that messing with any setting that it will actually affect your windows nt user login?? i know i cant be loosing my mind here and i hope someone at my company wouldnt sabotage my machine. right now i have two options i can reinstall win 2000 and choose repair hoping that i will not lose my sql 2000 info or i can try a password cracker. any suggestions that might of cause this to happen?
regards,
Robertof course Microsoft is always providing use with new features, but I doubt this unlikely. What you described sounds exactly as if the user password had been changed at the OS level. The password could have been changed by mistake.

Can not remove user from SQL database....

Hello,
I have a Db that has user name of 'dbo' and login name of 'sa'. For
security reasons, I want this gone.
This user was the owner, but I changed the owner to another user and verified.
After doing this, I still cannot remove the dbo - sa user from the DB. I
get errors:
"Selected user cannot be dropped because the user owns objects"
I cannot remove the public or owner roles from this user either.
Any Ideas?
Thanks much,
MarkThe new owner *is* dbo, so you can't remove that.
You cannot remove the sa login either, since this is a special login. In 2005, you can disable it
and rename it (see ALTER LOGIN).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mrpush" <Mrpush@.discussions.microsoft.com> wrote in message
news:A8C854BD-4307-4557-8479-4EC9CE34353B@.microsoft.com...
> Hello,
> I have a Db that has user name of 'dbo' and login name of 'sa'. For
> security reasons, I want this gone.
> This user was the owner, but I changed the owner to another user and verified.
> After doing this, I still cannot remove the dbo - sa user from the DB. I
> get errors:
> "Selected user cannot be dropped because the user owns objects"
> I cannot remove the public or owner roles from this user either.
> Any Ideas?
> Thanks much,
> Mark|||Tibor,
I'm not sure I understand.
I have many DB's and most of them do not have a "DBO" user attached to them
(especially dbo with sa login name).
I added another user to the DB, SQLADMIN, and made that user the owner.
I now want to remove the dbo user with login name of "sa". Or, I at least I
want to change the "sa" on the dbo user to "SQLADMIN" user login name. I get
the errors when I try to remove the dbo-sa user/login name.
I'm doing this from the DB USERS folder, I am not trying to remove the SA
LOGIN from the logins folder.
How to do it?
Thanks much,
Mark
"Tibor Karaszi" wrote:
> The new owner *is* dbo, so you can't remove that.
> You cannot remove the sa login either, since this is a special login. In 2005, you can disable it
> and rename it (see ALTER LOGIN).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mrpush" <Mrpush@.discussions.microsoft.com> wrote in message
> news:A8C854BD-4307-4557-8479-4EC9CE34353B@.microsoft.com...
> > Hello,
> >
> > I have a Db that has user name of 'dbo' and login name of 'sa'. For
> > security reasons, I want this gone.
> >
> > This user was the owner, but I changed the owner to another user and verified.
> >
> > After doing this, I still cannot remove the dbo - sa user from the DB. I
> > get errors:
> >
> > "Selected user cannot be dropped because the user owns objects"
> >
> > I cannot remove the public or owner roles from this user either.
> >
> > Any Ideas?
> >
> > Thanks much,
> >
> > Mark
>|||> I have many DB's and most of them do not have a "DBO" user attached to them
> (especially dbo with sa login name).
I find the terminology " have a "DBO" user attached to them" confusing. What do you mean by
"attached"? Are you saying that there is no user named dbo in these databases? Note: I'm referring
to the "users" folder! If you have databases in which there is no dbo user, then you have something
strange going on!
> I added another user to the DB, SQLADMIN, and made that user the owner.
Above confuses me even more. You don't add a user to a database. You add a login *as a user in the
database*. Also, how did you make that user the owner of the database? Exactly what steps did you
do, or what commands did you run. If possible please communicate using TSQL commands, as we can run
thses to see whether we get the same result or not.
> I now want to remove the dbo user with login name of "sa".
So you want to change the owner of the database from the login "sa" to some other login? OK, that is
fine, no problems. Use sp_changedbowner for that (you can also use ALTER AUTHORIZATION if you are on
2005).
> Or, I at least I
> want to change the "sa" on the dbo user to "SQLADMIN" user login name.
Again, the terminology used above confuses me. Are you saying that you want to change the owner of
the database from the login "sa" to some other login? If so, see my above comment.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mrpush" <Mrpush@.discussions.microsoft.com> wrote in message
news:510EE746-48E4-4A9C-8D36-84EB0B5F432B@.microsoft.com...
> Tibor,
> I'm not sure I understand.
> I have many DB's and most of them do not have a "DBO" user attached to them
> (especially dbo with sa login name).
> I added another user to the DB, SQLADMIN, and made that user the owner.
> I now want to remove the dbo user with login name of "sa". Or, I at least I
> want to change the "sa" on the dbo user to "SQLADMIN" user login name. I get
> the errors when I try to remove the dbo-sa user/login name.
> I'm doing this from the DB USERS folder, I am not trying to remove the SA
> LOGIN from the logins folder.
> How to do it?
> Thanks much,
> Mark
>
>
> "Tibor Karaszi" wrote:
>> The new owner *is* dbo, so you can't remove that.
>> You cannot remove the sa login either, since this is a special login. In 2005, you can disable it
>> and rename it (see ALTER LOGIN).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Mrpush" <Mrpush@.discussions.microsoft.com> wrote in message
>> news:A8C854BD-4307-4557-8479-4EC9CE34353B@.microsoft.com...
>> > Hello,
>> >
>> > I have a Db that has user name of 'dbo' and login name of 'sa'. For
>> > security reasons, I want this gone.
>> >
>> > This user was the owner, but I changed the owner to another user and verified.
>> >
>> > After doing this, I still cannot remove the dbo - sa user from the DB. I
>> > get errors:
>> >
>> > "Selected user cannot be dropped because the user owns objects"
>> >
>> > I cannot remove the public or owner roles from this user either.
>> >
>> > Any Ideas?
>> >
>> > Thanks much,
>> >
>> > Mark|||Tibor,
Sorry about that, I got a little mixed up. There are dbo users on my DB's.
What I want to do is get rid of the "sa" login name and change it to
something else like my "SQLadmin" user.
I tried the sp_changedbowner to change my DB owner to this other user, and
now the "sa" is gone. I believe there was some delay however as it still
showed "sa" after I ran the sp_changedbowner and that is why I was confused.
All seems well now!
Thanks!
Mark
"Tibor Karaszi" wrote:
> > I have many DB's and most of them do not have a "DBO" user attached to them
> > (especially dbo with sa login name).
> I find the terminology " have a "DBO" user attached to them" confusing. What do you mean by
> "attached"? Are you saying that there is no user named dbo in these databases? Note: I'm referring
> to the "users" folder! If you have databases in which there is no dbo user, then you have something
> strange going on!
>
> > I added another user to the DB, SQLADMIN, and made that user the owner.
> Above confuses me even more. You don't add a user to a database. You add a login *as a user in the
> database*. Also, how did you make that user the owner of the database? Exactly what steps did you
> do, or what commands did you run. If possible please communicate using TSQL commands, as we can run
> thses to see whether we get the same result or not.
>
> > I now want to remove the dbo user with login name of "sa".
> So you want to change the owner of the database from the login "sa" to some other login? OK, that is
> fine, no problems. Use sp_changedbowner for that (you can also use ALTER AUTHORIZATION if you are on
> 2005).
>
> > Or, I at least I
> > want to change the "sa" on the dbo user to "SQLADMIN" user login name.
> Again, the terminology used above confuses me. Are you saying that you want to change the owner of
> the database from the login "sa" to some other login? If so, see my above comment.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mrpush" <Mrpush@.discussions.microsoft.com> wrote in message
> news:510EE746-48E4-4A9C-8D36-84EB0B5F432B@.microsoft.com...
> > Tibor,
> >
> > I'm not sure I understand.
> >
> > I have many DB's and most of them do not have a "DBO" user attached to them
> > (especially dbo with sa login name).
> >
> > I added another user to the DB, SQLADMIN, and made that user the owner.
> >
> > I now want to remove the dbo user with login name of "sa". Or, I at least I
> > want to change the "sa" on the dbo user to "SQLADMIN" user login name. I get
> > the errors when I try to remove the dbo-sa user/login name.
> >
> > I'm doing this from the DB USERS folder, I am not trying to remove the SA
> > LOGIN from the logins folder.
> >
> > How to do it?
> >
> > Thanks much,
> >
> > Mark
> >
> >
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> The new owner *is* dbo, so you can't remove that.
> >>
> >> You cannot remove the sa login either, since this is a special login. In 2005, you can disable it
> >> and rename it (see ALTER LOGIN).
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "Mrpush" <Mrpush@.discussions.microsoft.com> wrote in message
> >> news:A8C854BD-4307-4557-8479-4EC9CE34353B@.microsoft.com...
> >> > Hello,
> >> >
> >> > I have a Db that has user name of 'dbo' and login name of 'sa'. For
> >> > security reasons, I want this gone.
> >> >
> >> > This user was the owner, but I changed the owner to another user and verified.
> >> >
> >> > After doing this, I still cannot remove the dbo - sa user from the DB. I
> >> > get errors:
> >> >
> >> > "Selected user cannot be dropped because the user owns objects"
> >> >
> >> > I cannot remove the public or owner roles from this user either.
> >> >
> >> > Any Ideas?
> >> >
> >> > Thanks much,
> >> >
> >> > Mark
> >>
>
>

Can not remote login to MSDE

I installed MSDE at my server at home, and that works fine.
On the server I can access my MSDE perfectly.
But, from a remote computer it seems impossible to connect.

Some (maybe) important information:

To create a user at my msde I used:

sp_addlogin (@. the MASTER DB)
sp_adduser (@. My DB)
sp_addrolemember (@. My DB)

Then I runned SVRNETCN.exe and enabled TCP/IP.

btw: I don't have a firewall running and both computers are on the same local network.is it trying to use windows integrated auth to connect, or mixed mode?|||It's configured for Mixed Mode...
I want to use sql-authentication and not windows authentication.
(it works localy, but not from an other computer)|||if it's running on a remote computer and U R using a firewall (XP...)
then try to open some port (1433) for the SQL Server DTS with the IP of the server...|||Nope, I don't have a firewall running...
I tried to telnet to 1433 to the MSDE, but even on the computer where my MSDE is running on, I can't get a telnet connection to 1433.
SQLServer uses tcp/ip, doesn't it?
I can't connect with VS.NET, Query Analyser, ... to my MSDE from an computer diferent than the computer that is running MSDE.|||I found out than my MSDE isn't 'registered' in my 'Data Sources (ODBC)'.
I registered it but...
It still doesn't work, but I think I am on the right spot :-)|||Ok, totaly wrong...
It has nothing to do with 'Data Sources (ODBC)'.
I tried everything!
It seems like MSDE isn't capable of listening at tcp/ip 1433.
Is this disabled in MSDE?|||try to check this:
on SQL Server configuration properties -> Connections
make sure the number is 0 (unlimited) or set it to 10 (for the test)
+
I did not hear U say U don't have a firewall on the server...|||I found it!!
I guess it's a bug in the install.
There is a key in the registry that contains no value:
..\MSSQLServer\SuperSocketNetLib\Tcp\tcpPort
The value has to be: 1433

But what if you have more than one instance?
You can't bind them all to the same port...
..\MSSQLServer\SuperSocketNetLib\Tcp\TcpDynamicPorts
It also doesn't contain a value...

Can not open database requested. Login fails

Hallo:
Trying to connect to database using OLE DB. Gave the
following code:
con.ConnectionString="Provider=sqloledb;"&_
"Data Source=ServerName;Initial Catalog=DatabaseName;"&_
"Integrated Security=sspi;Trusted_Connection=yes;"
con.Open
Getting error message:
Microsoft OLEDB Povider for SQL Server(0x80004005).Can not
open database requested in login 'user'.Login fails.
Any solution please.
Thanks.
tinku
Tinku,
May be the database has been deleted.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"tinku" <ritadi2002@.yahoo.com> wrote in message
news:1d3ab01c42351$efa2bf00$a301280a@.phx.gbl...
> Hallo:
> Trying to connect to database using OLE DB. Gave the
> following code:
> con.ConnectionString="Provider=sqloledb;"&_
> "Data Source=ServerName;Initial Catalog=DatabaseName;"&_
> "Integrated Security=sspi;Trusted_Connection=yes;"
> con.Open
> Getting error message:
> Microsoft OLEDB Povider for SQL Server(0x80004005).Can not
> open database requested in login 'user'.Login fails.
> Any solution please.
> Thanks.
> tinku
>
|||Dinesh,
It is an existing database and after adding user to the database the
problem got solved. Thank you for your e-mail.
Tinku
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Can not open database requested. Login fails

Hallo:
Trying to connect to database using OLE DB. Gave the
following code:
con.ConnectionString="Provider=sqloledb;"&_
"Data Source=ServerName;Initial Catalog=DatabaseName;"&_
"Integrated Security=sspi;Trusted_Connection=yes;"
con.Open
Getting error message:
Microsoft OLEDB Povider for SQL Server(0x80004005).Can not
open database requested in login 'user'.Login fails.
Any solution please.
Thanks.
tinkuTinku,
May be the database has been deleted.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"tinku" <ritadi2002@.yahoo.com> wrote in message
news:1d3ab01c42351$efa2bf00$a301280a@.phx
.gbl...
> Hallo:
> Trying to connect to database using OLE DB. Gave the
> following code:
> con.ConnectionString="Provider=sqloledb;"&_
> "Data Source=ServerName;Initial Catalog=DatabaseName;"&_
> "Integrated Security=sspi;Trusted_Connection=yes;"
> con.Open
> Getting error message:
> Microsoft OLEDB Povider for SQL Server(0x80004005).Can not
> open database requested in login 'user'.Login fails.
> Any solution please.
> Thanks.
> tinku
>|||Dinesh,
It is an existing database and after adding user to the database the
problem got solved. Thank you for your e-mail.
Tinku
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Can not login to MSDE

I have a windows 2000 server with Veritas Backup Exec 9.1 and when you
install veritas it installs MSDE version 8.00.760. When i try to connect to
the msde using enterprise manager i get an error mesage stating that Reason:
SQL Server does not exist or access denied. I was told that the sa password
is blank. I tried logging in to the machine using Administrator account and
same error. Any suggestions on how to get around this.
I also ran svrnetcn.exe and made sure that tcp/ip is enabled.
Hope this Helps
Dan V
This posting is provided "AS IS" with no warranties, and confers no rights
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:ue1EIliIEHA.2244@.TK2MSFTNGP09.phx.gbl...
> I have a windows 2000 server with Veritas Backup Exec 9.1 and when you
> install veritas it installs MSDE version 8.00.760. When i try to connect
to
> the msde using enterprise manager i get an error mesage stating that
Reason:
> SQL Server does not exist or access denied. I was told that the sa
password
> is blank. I tried logging in to the machine using Administrator account
and
> same error. Any suggestions on how to get around this.
>
|||hey Dan,
I'm having the same problems without using Veritas. When i try to connect it says the server does not exist or access is denied. When i installed SQL it did not set up my server name as local or localhost like a lot of these manuals i have says it will do
. It set it up as (myname)\NETSDK. Is your server set up as local or something else?

can not login sql server

Hello,
We have a Win 2003 server with SQL 2000 installed. When we upgrade Win 2003
server to Active Directory, then the SQL 2000 can not work any more.
We try to uninstall and install again, window mode or mixed mode.
The error message alwsays say "xxx/administrator is not associated with
trusted SQL server connection" or "login failed for user sa"
ThanksSo you promoted the Server to a domain controller ? The local Administrator
is deactivated with promoting the Server. Although the domain administrators
group is still working and should be associated with the
SystemAdministrators group. I wonder what security Account you typed in for
starting the sql Service ? Did you put in the system account or the
Administrators account ? If you put in the local admin account change it to
start up the server. When do you get thios messages ?
HTH, Jens Smeyer.
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:1FA3AC6A-C62A-4570-8242-BE4EBA273DA1@.microsoft.com...
> Hello,
> We have a Win 2003 server with SQL 2000 installed. When we upgrade Win
> 2003
> server to Active Directory, then the SQL 2000 can not work any more.
> We try to uninstall and install again, window mode or mixed mode.
> The error message alwsays say "xxx/administrator is not associated with
> trusted SQL server connection" or "login failed for user sa"
> Thanks|||So you promoted the Server to a domain controller ?
Yes.
The local Administrator is deactivated with promoting the Server. Although
the domain administrators group is still working and should be associated
with the SystemAdministrators group.
I wonder what security Account you typed in for starting the sql Service ?
Did you put in the system account or the Administrators account ?
If you put in the local admin account change it to start up the server. When
do you get this messages ?
I tried administrator first, the error message is "xxx/administrator is not
associated with trusted SQL server connection"
Then I installed again with mixed mode, the error message is "login failed
for user sa"
Thanks