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.

Rebort Builder Access

Hi,

Hope someone can assist

Does Report Server allow access to Report Builder in an extranet setup? We intend to use the report builder functionality to prove basic report creation for users over the internet, these users would be outside or corporate network.

Is this possible? security issues?

many thanks

Simon.

Should work.

See here for further information on installing on non-domain users machines.

http://blogs.msdn.com/bobmeyers/archive/2006/09/28/775584.aspx

and more info on troubleshooting

http://blogs.msdn.com/bimusings/archive/2005/11/07/489968.aspx

Note that it requires .net 2.0 framework on client PC. Have a look at other 3rd-party report building apps for RS if a no-footprint web client is required.

cheers,

Andrew

Real time access to iSeries

I have a database maintained on an iSeries. I have an application that uses
MS SQL. I need to pull data down from the iSeries to my MS SQL server in real
time or just once a week, doesn't matter. Is this easily doable and are there
any "gotcha's" to be aware of?
Thanks!
Mbrewer.
You should be able to create a linked server to an iSeries. In fact, the
Books Online has an example of defining the link in the sp_addlinkedserver
topic.
http://technet.microsoft.com/en-us/library/ms190479.aspx
Once you have a linked server, then you can create a schedule job to do the
updates from the iSeries database into SQL Server.
For more hits, do a Technet search: "sql server" DB2 "linked server"
Also, on Technet I searched: "sql server" iseries "linked server"
http://www.experts-exchange.com/Database/DB2/Q_22592124.html
There is also a BizTalk connector, but you probably are not using that
solution: http://technet.microsoft.com/en-us/library/aa770734.aspx
RLF
"Mbrewer22" <Mbrewer22@.discussions.microsoft.com> wrote in message
news:D26B76E1-A79C-4AE4-A4C9-F123C8B683F3@.microsoft.com...
>I have a database maintained on an iSeries. I have an application that uses
> MS SQL. I need to pull data down from the iSeries to my MS SQL server in
> real
> time or just once a week, doesn't matter. Is this easily doable and are
> there
> any "gotcha's" to be aware of?
> Thanks!

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
>