Real Time DSS: user

Showing posts with label user. Show all posts

Wednesday, March 28, 2012

Receiving "Error: 18456" when for a specific user who has rights via AD Group

I have a user who is a domain admin and has rights based on a group
policy (OURDOMAIN\Developers) to access the SQL Server. He can access
other Sql Servers, and every other member of the group can access all
boxes. So its a case of a specific users cannot access a specific
box. Below is the error message he is getting:
TITLE: Connect to Server
--
Cannot connect to SQLDEV1.
--
ADDITIONAL INFORMATION:
Login failed for user 'OURDOMAIN\user'. (Microsoft SQL Server, Error:
18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
--
BUTTONS:
OK
--
SQL2005 Ent SP1 on Win03
Any ideas would be appreciated.Hi
"Keeper of the Bits" wrote:
> I have a user who is a domain admin and has rights based on a group
> policy (OURDOMAIN\Developers) to access the SQL Server. He can access
> other Sql Servers, and every other member of the group can access all
> boxes. So its a case of a specific users cannot access a specific
> box. Below is the error message he is getting:
>
> TITLE: Connect to Server
> --
> Cannot connect to SQLDEV1.
> --
> ADDITIONAL INFORMATION:
> Login failed for user 'OURDOMAIN\user'. (Microsoft SQL Server, Error:
> 18456)
> For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
> --
> BUTTONS:
> OK
> --
>
>
> SQL2005 Ent SP1 on Win03
> Any ideas would be appreciated.
>
Maybe you are seeing http://support.microsoft.com/kb/925744/en-us I believe
3152 is the latest version you can download if you want to move past SP2.
John|||You can more details about login failures from the SQL
Server error log on SQL Server 2005. Check the log for the
State - there will be a line similar to:
Logon Error: 18456, Severity: 14, State:18
Then check the corresponding description for that state in
the following article:
http://msdn2.microsoft.com/en-us/library/ms366351.aspx
-Sue
On 13 Apr 2007 12:06:22 -0700, "Keeper of the Bits"
<styree@.creditsolutions.com> wrote:
>I have a user who is a domain admin and has rights based on a group
>policy (OURDOMAIN\Developers) to access the SQL Server. He can access
>other Sql Servers, and every other member of the group can access all
>boxes. So its a case of a specific users cannot access a specific
>box. Below is the error message he is getting:
>
>TITLE: Connect to Server
>--
>Cannot connect to SQLDEV1.
>--
>ADDITIONAL INFORMATION:
>Login failed for user 'OURDOMAIN\user'. (Microsoft SQL Server, Error:
>18456)
>For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
>--
>BUTTONS:
>OK
>--
>
>
>SQL2005 Ent SP1 on Win03
>Any ideas would be appreciated.

receive notification from server in application

Hello, I have an application which is running on multiple computers and is connected with one sql server. I would like to that the user is notified when another user is performing some special action. So I thought that when this action begins, the server is notified either by writing some data in a table or something like this. Then I would like other applications to be notified so is possible that notification service notifies the application? If yes how? ThanksSSNS may be used in instances like this.

If your "special actions" are not recognizable using the built-in event providers (SQL Server Event Provider & File System Event Provider), you'll need to create a custom event provider to gather the event data.

Assuming the criteria by which people want to be notified is fairly static, you can create subscriptions to match upon. SSNS is not a good choice if the criteria changes frequently (for example, I want to notified when the data behind the web page I'm looking at happens to change. People may bounce among web pages frequently so SSNS is not a good choice there.)

You'll definitely need to create a custom delivery protocol (and perhaps a custom content formatter too) to get the notification to the application.

BTW - you may also want to check out Query Notifications. That technology may offer some of the features you are looking for.

HTH...

Joe|||I want the users of the application to be notified when a particular field in particular table changes. How can the server find all the instances of my application that are connected to it and how can it send the information? How can my application receive them? Thanks

receive notification from server in application

You'll definitely need to create a custom delivery protocol (and perhaps a custom content formatter too) to get the notification to the application.

BTW - you may also want to check out Query Notifications. That technology may offer some of the features you are looking for.

HTH...

Receive mail when specific user connects

Hi,
I want to receive a mail when a specific user connects.
How can this be done best? Raise an alert? How?
Btw, the 'Login auditing' is set to 'Failed logins only'.
Suggestions are very welcome!
Cheers,
Eu can scan master..sysprocesses table periodacally to check if that user has connected by matching sid with sid of syslogins table. a job can send u the mail, if not as soon as the user connects (depends on the frequency of the job) ... there might be a better option not sure...

Monday, March 26, 2012

Rebuilt master, what's next?

Hello,
What would be the way to go after rebuilding master database: (1)
restore it from the backup, restore msdb, and then user databases or (2)
restore user databases, restore master, and then msdb.
I mean, is it bad, when the master is restored w/o user databases being
accessible?
--
Many thanks,
PabloHi,
What would be the way to go after rebuilding master database?
This is the correct step:- Restore it from the backup (Master) , Restore
msdb, and then user databases
Have a look into steps (15 - 28) in the attached link.
http://www.dbarecovery.com/restoremasterdb.html
I mean, is it bad, when the master is restored w/o user databases being
accessible?
You have to restore the Master database and then the user databases.
Otherwise Master database restore will
overwrite the existing database entries.
Thanks
Hari
MCDBA
"msnews.microsoft.com" <pablo@.this_isnt_my_mail.aaa> wrote in message
news:OcAE63nREHA.3052@.TK2MSFTNGP12.phx.gbl...
> Hello,
> What would be the way to go after rebuilding master database: (1)
> restore it from the backup, restore msdb, and then user databases or (2)
> restore user databases, restore master, and then msdb.
> I mean, is it bad, when the master is restored w/o user databases being
> accessible?
> --
> Many thanks,
> Pablo|||Thanks, Hari.
Still, one thing remains unclear to me: what will happen when I restore
master then start the server and user databases aren't where they
supposed to be. Will the references to them in master be automatically
erased or will the databases be marked suspect? Will I have to drop the
suspect databases before restoring them or will I have to use WITH
REPLACE clause to force the restore over the existing (suspect) user
database?
--
Thanks,
Pablo
Hari wrote:
> Hi,
> What would be the way to go after rebuilding master database?
> This is the correct step:- Restore it from the backup (Master) , Restore
> msdb, and then user databases
> Have a look into steps (15 - 28) in the attached link.
> http://www.dbarecovery.com/restoremasterdb.html
> I mean, is it bad, when the master is restored w/o user databases being
> accessible?
> You have to restore the Master database and then the user databases.
> Otherwise Master database restore will
> overwrite the existing database entries.
> Thanks
> Hari
> MCDBA
>
> "msnews.microsoft.com" <pablo@.this_isnt_my_mail.aaa> wrote in message
> news:OcAE63nREHA.3052@.TK2MSFTNGP12.phx.gbl...
>>Hello,
>>What would be the way to go after rebuilding master database: (1)
>>restore it from the backup, restore msdb, and then user databases or (2)
>>restore user databases, restore master, and then msdb.
>>I mean, is it bad, when the master is restored w/o user databases being
>>accessible?
>>--
>>Many thanks,
>>Pablo
>
>|||If SQL Server expects a databases's MDF file be in a place, and the file isn't there, you have a suspect
database. Drop it and do a regular restore.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"msnews.microsoft.com" <pablo@.this_isnt_my_mail.aaa> wrote in message
news:uLaYNSvREHA.3628@.TK2MSFTNGP12.phx.gbl...
> Thanks, Hari.
> Still, one thing remains unclear to me: what will happen when I restore
> master then start the server and user databases aren't where they
> supposed to be. Will the references to them in master be automatically
> erased or will the databases be marked suspect? Will I have to drop the
> suspect databases before restoring them or will I have to use WITH
> REPLACE clause to force the restore over the existing (suspect) user
> database?
> --
> Thanks,
> Pablo
> Hari wrote:
> > Hi,
> >
> > What would be the way to go after rebuilding master database?
> >
> > This is the correct step:- Restore it from the backup (Master) , Restore
> > msdb, and then user databases
> >
> > Have a look into steps (15 - 28) in the attached link.
> >
> > http://www.dbarecovery.com/restoremasterdb.html
> >
> > I mean, is it bad, when the master is restored w/o user databases being
> > accessible?
> >
> > You have to restore the Master database and then the user databases.
> > Otherwise Master database restore will
> > overwrite the existing database entries.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> > "msnews.microsoft.com" <pablo@.this_isnt_my_mail.aaa> wrote in message
> > news:OcAE63nREHA.3052@.TK2MSFTNGP12.phx.gbl...
> >
> >>Hello,
> >>
> >>What would be the way to go after rebuilding master database: (1)
> >>restore it from the backup, restore msdb, and then user databases or (2)
> >>restore user databases, restore master, and then msdb.
> >>
> >>I mean, is it bad, when the master is restored w/o user databases being
> >>accessible?
> >>
> >>--
> >>Many thanks,
> >>Pablo
> >
> >
> >

Rebuilt master, what's next?

Friday, March 9, 2012

Re-associate server login with database user?

Hi all, I've had this issue in the past but dealt with it in a way that I don't think is correct:

Let's say I have a database on Server1. On Server1 I create a login and a user on the database. Now I have User1 with a login authorization on Server1 as well as a user within my database. If I detach that database now, and re-attach it on a different server, User1 exists. Of course, on the new Server2 User1 does not have authorization to login. I've deleted the existing user in the database and then re-created a login on the server, cascading through with the GUI setup to re-create the user within the database, too. Of course this gets ugly if the user has objects within the database. If I create a server login with the same name as the database user the login is not associated with the user too, correct?

I'd like to know the way that I can create a server authorization tied to the existing database user without dropping that database user, preferably within Enterprise Manager.

Thanks all,

MCNot sure if this solves your situation, but look into this:

http://blogs.geekdojo.net/ryan/archive/2004/05/04/1849.aspx

re-associate "dbo" user with "sa" login

Once "dbo" user on a particular db has been associated with a specific login
( "Login1") , how to re-associate it with its default login ( "sa" ) ?
My ultimate goal is to add user "User1" to this db and associate it with
login "Login1" . but to do that apparently I need to de-associate "Login1"
login from "dbo" user.It sounds like the user is the database owner. You can
change the owner to sa by executing the following in the
database:
exec sp_changedbowner 'sa'
-Sue
On Thu, 27 Jul 2006 11:15:59 -0700, "John A Grandy"
<johnagrandy-at-yahoo-dot-com> wrote:

>Once "dbo" user on a particular db has been associated with a specific logi
n
>( "Login1") , how to re-associate it with its default login ( "sa" ) ?
>My ultimate goal is to add user "User1" to this db and associate it with
>login "Login1" . but to do that apparently I need to de-associate "Login1"
>login from "dbo" user.
>

Wednesday, March 7, 2012

Realtime/streaming data

Is there a way to update data on a reporting services report without having
the user click the refresh button? I am wanting to show realtime stock
quotes in a reporting services report and update stock quotes as they come in
without having to call the refrsh method in the report viewer or having the
user have to click the refrsh button. I am using the report viewer component
in a C# winforms app.
Thanks in advance!!!Use the timer object in the C# winform and refresh the control. You could
have it refresh every minute or 30 sec - but anything more 'real time' than
that - Reporting Services is probably not a real good solution.
"David" <David@.discussions.microsoft.com> wrote in message
news:A05DA637-32B3-48CE-8972-14135DE7888B@.microsoft.com...
> Is there a way to update data on a reporting services report without
> having
> the user click the refresh button? I am wanting to show realtime stock
> quotes in a reporting services report and update stock quotes as they come
> in
> without having to call the refrsh method in the report viewer or having
> the
> user have to click the refrsh button. I am using the report viewer
> component
> in a C# winforms app.
> Thanks in advance!!!|||If you're using RS 2005 you can set the "Autorefresh" for the report
property to the desired refresh interval. It worked in VS preview and
in the the web browser. So I wouild think if you are using the report
viewer control the autorefresh would work there to.
On Sat, 13 May 2006 15:50:01 -0700, David
<David@.discussions.microsoft.com> wrote:
>Is there a way to update data on a reporting services report without having
>the user click the refresh button? I am wanting to show realtime stock
>quotes in a reporting services report and update stock quotes as they come in
>without having to call the refrsh method in the report viewer or having the
>user have to click the refrsh button. I am using the report viewer component
>in a C# winforms app.
>Thanks in advance!!!|||Thanks for trying guys. As I said in my initial email I want to update
values on the report without the report refreshing as a refresh is annoying
to the user and takes you back to the beginning of a report given you are in
backend pages of the report...
"Mark" wrote:
> If you're using RS 2005 you can set the "Autorefresh" for the report
> property to the desired refresh interval. It worked in VS preview and
> in the the web browser. So I wouild think if you are using the report
> viewer control the autorefresh would work there to.
> On Sat, 13 May 2006 15:50:01 -0700, David
> <David@.discussions.microsoft.com> wrote:
> >Is there a way to update data on a reporting services report without having
> >the user click the refresh button? I am wanting to show realtime stock
> >quotes in a reporting services report and update stock quotes as they come in
> >without having to call the refrsh method in the report viewer or having the
> >user have to click the refrsh button. I am using the report viewer component
> >in a C# winforms app.
> >Thanks in advance!!!
>

Really need urgent help in Insert statement

Hi,

I am creating a event registration system. Right now my program is able to insert user's registered event into the database. This is the code i wrote:

INSERT INTO EventRegistration(eventId,userId,status) VALUES('" + eid + "','" + id + "','" + status + "')

However I notice that same user are able to register the same event when i use this code. How should i improve my code in order to prevent same user from registering the same event. Which means my sql statement will not insert registered event into the database if same user register the same event. I will really appreciate the help all of you offer.

Thank you.

Regards,
ferDepending on your database tool, you probably just need a UNIQUE CONSTRAINT or a UNIQUE INDEX and things should be lovely.

-PatP|||As Pat.P infers good table design should preclude you users entering duplicate data.

What makes an event / entry unique in the real world and how do you represent that in your database?|||if you are providing the user a list of options to register, I assume you are pulling the list of things to register from the database too ?

only show them options to register for, that they have not registered for already.

for instance, if you have 10 time slots available for something and someone picks time slot #3, then the next user will only see 9 time slots to pick from. (#3 is no longer displayed)|||Hi Kropes2001,

Ya you actually get wat i mean. I am providing a list of options for user to register, and options(events) are retrieve from the database. I get wat u mean but i dun realli noe how to implement it as i am new to sql. Can you provide me a sample coding of wat u mean?

Thank you.

ferlina|||If you define the primary key, or alternatively a unique key correctly there can't be any duplicates.

If you handle any eror thrown by the db engine then you can gracefully handle the situation where a single user has tried to make more than one booking for the same event.
HTH|||Sorry... but
why "handle an error" when you can prevent it from happening to begin with ?
i see too many programmers that do that. let the user enter whatever they want and then try to deal with all the errors it generates.
the more logical design is to simply provide the necessary information in a way that prevents the user form making any errors like that to begin with. and its usually a lot easier too.

an ounce of prevention vs. a pound of cure.

ferlina,
i would really need to see your table designs to give you an absolute answer.

i am assuming that you have 1 table with all of the events that are available. plossible fields :
EventID
Description
StartDate
StartTime
Active
etc....
etc....

i assume that you then use a SELECT statement to build a recordset of all of the availalbe events. something like :
SELECT EventID, Description, StartDate, StartTime from EventList WHERE Active=true

i also assume that by the time you hit this page, you already know who your user is, or at least what their ID is ? (they already are defined in the database somelace, yes ?)

if so, then combine the SELECT of available events with an outer join. you want to retrieve a list of all events that are active in teh database, except for the ones that are already scheduled by this UserID.

take a look at this article

http://www.dev-archive.com/dbzone/Article/17403/0/page/4

instead of selecting all of the registered events that match the user's ID, you are selecting all of the ones that they did not register for.|||In a multi user environment you have to trap for errors and handle them gracefully. After a user has booked an event then you can exclude them from appearing in future combo select boxes, but untll they have booked you are running the risk of an error. Granted you could set a flag on the user to say they are in process of making a booking - but that doesn;t stp clients that have already loaded available users from attempting to make a duplicate booking.

It is always theoretically possible for a user to be booking an event from more than one session at the same time (either through user error or deliberate attempt to subvert the system.

Saturday, February 25, 2012

Really basic question...

I have bumbled along and managed to install a SQL server
on my machine... and with the install I have created a
user "Admin" along with a password ( yay )
Anyways... what I would like to know now is how to create
other users and allow them access to the DB.
Thanks
MeHi,
SQL Server supports 2 types of authentications,
1. SQL Server
2. OS Level
If it is SQL Server , Login to server using Enterprise manager then select
the security tab.
1. Right click on logins and add a new login.
2. Provide the user name and select SQL server authentication
3. Give a password and select the required servide wide roles
4. Give the database that user need access.
If it is OS Level , you have to create the user at OS level and use the same
security tab to give the roles and access to databases.
Thanks
Hari
MCDBA
"me" <anonymous@.discussions.microsoft.com> wrote in message
news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...
> I have bumbled along and managed to install a SQL server
> on my machine... and with the install I have created a
> user "Admin" along with a password ( yay )
> Anyways... what I would like to know now is how to create
> other users and allow them access to the DB.
> Thanks
> Me|||Use a tool like Enterprise Manager to create users. You need to create
logins in SQL Server and then map these logins to databases.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"me" <anonymous@.discussions.microsoft.com> wrote in message
news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...
> I have bumbled along and managed to install a SQL server
> on my machine... and with the install I have created a
> user "Admin" along with a password ( yay )
> Anyways... what I would like to know now is how to create
> other users and allow them access to the DB.
> Thanks
> Me|||Click the folder Security and expand
Right Click the folder Logins and select "New User"
The rest you will need to read up on.
If you need a bit more advise then email me. In reverse
order(to stop autospammers) my email is
moc.liamtoh.em_yrewolf_elttil
J
PS Never give your Admin password out to anyone - Keep it
safe, Keep it Secret.
>--Original Message--
>I have bumbled along and managed to install a SQL server
>on my machine... and with the install I have created a
>user "Admin" along with a password ( yay )
>Anyways... what I would like to know now is how to create
>other users and allow them access to the DB.
>Thanks
>Me
>.
>|||Which should be the prefferred way to add users?
SQL Server or OS level
>--Original Message--
>Hi,
>SQL Server supports 2 types of authentications,
>1. SQL Server
>2. OS Level
>If it is SQL Server , Login to server using Enterprise
manager then select
>the security tab.
>1. Right click on logins and add a new login.
>2. Provide the user name and select SQL server
authentication
>3. Give a password and select the required servide wide
roles
>4. Give the database that user need access.
>If it is OS Level , you have to create the user at OS
level and use the same
>security tab to give the roles and access to databases.
>Thanks
>Hari
>MCDBA
>"me" <anonymous@.discussions.microsoft.com> wrote in
message
>news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...
>> I have bumbled along and managed to install a SQL
server
>> on my machine... and with the install I have created a
>> user "Admin" along with a password ( yay )
>> Anyways... what I would like to know now is how to
create
>> other users and allow them access to the DB.
>> Thanks
>> Me
>
>.
>|||Thanks for all of the great help... Is there a way to do
this programmatically ?
Thanks
Me
>--Original Message--
>I have bumbled along and managed to install a SQL server
>on my machine... and with the install I have created a
>user "Admin" along with a password ( yay )
>Anyways... what I would like to know now is how to
create
>other users and allow them access to the DB.
>Thanks
>Me
>.
>

Monday, February 20, 2012

Ready Only Access

Hello,
How do I create a user in a DB and have them Read Only? Is there a QA
script maybe?
TIA
J
You can try adding them to the datareader and denydatawriter roles.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"J Ewing" <nonprivateaddress@.hotmail.com> wrote in message
news:Op7hYSsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hello,
> How do I create a user in a DB and have them Read Only? Is there a QA
> script maybe?
> TIA
> J
>

Ready Only Access

Hello,
How do I create a user in a DB and have them Read Only? Is there a QA
script maybe?
TIA
JYou can try adding them to the datareader and denydatawriter roles.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"J Ewing" <nonprivateaddress@.hotmail.com> wrote in message
news:Op7hYSsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hello,
> How do I create a user in a DB and have them Read Only? Is there a QA
> script maybe?
> TIA
> J
>

Ready Only Access

Hello,
How do I create a user in a DB and have them Read Only? Is there a QA
script maybe?
TIA
JYou can try adding them to the datareader and denydatawriter roles.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"J Ewing" <nonprivateaddress@.hotmail.com> wrote in message
news:Op7hYSsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hello,
> How do I create a user in a DB and have them Read Only? Is there a QA
> script maybe?
> TIA
> J
>

Wednesday, March 28, 2012

Receiving "Error: 18456" when for a specific user who has rights via AD Group

receive notification from server in application

receive notification from server in application

Receive mail when specific user connects

Monday, March 26, 2012

Rebuilt master, what's next?

Rebuilt master, what's next?

Rebuilt master, what's next?

Friday, March 9, 2012

Re-associate server login with database user?

re-associate "dbo" user with "sa" login

Wednesday, March 7, 2012

Realtime/streaming data

Really need urgent help in Insert statement

Saturday, February 25, 2012

Really basic question...

Monday, February 20, 2012

Ready Only Access

Ready Only Access

Ready Only Access

Real Time DSS

Blog Archive

About Me