Login failed for user NT AUTHORITY\NETWORK SERVICE.

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

I've just installed Windows Server 2003 and can't get past this.
I've changed the <processModel> userName to SYSTEM, I've added ASPNET to the Admin group, other tweaks with reboot but still can get it to work.
I'm not sure what the NT AUTHORITY domain is.

Anyone experience this?
Thanksok, looks like I figured it out. It works anyhow.
In the IIS Manager, I right clicked the Application Pools/DefaultAppPool node and hit properties.
I went to the Identity tab and for Predefined I selected Local System.|||Rex,

you saved me from near insanity....
I had installed tweeked...and gone over everything I could think of without any luck. Your one click solution did it. I guess I was trying to outsmart it all and fell on my face...

thanks a million,
Marc|||Thanks for this message, i can stop pulling my hair out now :-)|||This saved me alot of headaches too. But it also introduced one. You get a message that you are exposing IIS to attack and compromising sercurity.

Can someone explain how it should be done? I would like to be able to configure IIS to run with the minimal security needed to support ASP.NET pages and SQL Server access; but I do not have a clue what privilages and permissions would be needed.

Bill|||We were just chatting about this recently:view post 475172

(You can avoid the specific advice I gave because it wasn't particularly good :-) )

Terri|||The CGN IT article was exactly what I was looking for. Thanks.|||

tmorton:

We were just chatting about this recently: 475172 (You can avoid the specific advice I gave because it wasn't particularly good :-) ) Terri

This link is now dead, makes sinces since its from 2004. Anyone know where I can find the article now?

Thanks

|||

john.lieurance@.flhosp.org:

tmorton:

We were just chatting about this recently: 475172 (You can avoid the specific advice I gave because it wasn't particularly good :-) ) Terri

This link is now dead, makes sinces since its from 2004. Anyone know where I can find the article now?

Thanks

You can use the post ID from that link and surmise the new link:http://forums.asp.net/thread/475172.aspx

Login failed for user NT AUTHORITY\LOCAL SERVICE

I just installed the Issue Tracker using .net 1.1 (on my computer). When I try to log in via the login page, I get:

Login failed for user 'NT AUTHORITY\LOCAL SERVICE'

Here is my stack trace info:

SqlException: Login failed for user 'NT AUTHORITY\LOCAL SERVICE'.]
System.Data.SqlClient.ConnectionPool.CreateConnection() +402
System.Data.SqlClient.ConnectionPool.UserCreateRequest() +151
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +386
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASPNET.StarterKit.IssueTracker.DataAccessLayer.SQLDataAccessLayer.ExecuteScalarCmd(SqlCommand sqlCmd) +129
ASPNET.StarterKit.IssueTracker.DataAccessLayer.SQLDataAccessLayer.Authenticate(String username, String password) +184
ASPNET.StarterKit.IssueTracker.BusinessLogicLayer.ITUser.Authenticate(String username, String password) +44
ASPNET.StarterKit.IssueTracker.DesktopDefault.Login(Object s, EventArgs e) +84
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

I have added everyone, asp.net, local service, network service - all full control on the entire folder. Restarted IIS - still can't log in. Please help.

Hi, look at the exception you'll find it is from SQL. So you have to add proper permissions in SQL for the account rather than give control on the folder. Please open SQL Server Management Studio (Enterprise Manager) and go to the SQL instance which you're trying to connect, and explore Security->Logins->right click choose 'New Login'-> choose Windows Authentication and type the Windows account name. Remember to give sufficient permissions to the new added login.|||Thanks for the info. That fixed my issue.|||

What exactly should those permissions be, Read-only, owner, read/write.. what?

Thanks

|||

thelane:

What exactly should those permissions be, Read-only, owner, read/write.. what?

Thanks

The permissions I mean here is permissions in SQL, such as SELECT/INSERT/UPDATE on tables, CREATE DATABASES, EXECUTE stored procedures, and so on You can take a look at this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_94dv.asp

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Hello,
First let me describe the situation.
I have win2003 server (name: SRV) where I have SQL 2000 Reporting Services
installed, win2003 server with SQL2000 server (name: DBSRV) where I have a
database and a workstation where I create reports in Visual Studio.
When I am creating reports, everything is OK - I can connect to database,
get the data etc.
When I publish the report to http://SRV/ReportServer and try to access it
from with web browser from my workstation, it throws this message:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Database'.
(rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Of course that user doesn't have access to database.
But how to tell Repoting Services to get MY user name I am using to log on
to windows?
Thanks,
Armands BrantsThe funiest thing is that I can open the report from my workstation if I do
that way:
* open the report from server http://localhost...
* write the same address (http://localhost...) in my workstation's internet
explorer - page can not be displayed, of course
* replace localhost with srv and everything works fine!
Can't understand why...
Armands
"Armands Brants" <armands.brants@.navigator.lv> wrote in message
news:uRNDlSmxEHA.1204@.TK2MSFTNGP10.phx.gbl...
> Hello,
> First let me describe the situation.
> I have win2003 server (name: SRV) where I have SQL 2000 Reporting Services
> installed, win2003 server with SQL2000 server (name: DBSRV) where I have a
> database and a workstation where I create reports in Visual Studio.
> When I am creating reports, everything is OK - I can connect to database,
> get the data etc.
> When I publish the report to http://SRV/ReportServer and try to access it
> from with web browser from my workstation, it throws this message:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'Database'.
> (rsErrorOpeningConnection)
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> Of course that user doesn't have access to database.
> But how to tell Repoting Services to get MY user name I am using to log on
> to windows?
> Thanks,
> Armands Brants
>|||If you are trying to authenticate in a scenerio which involves more than two
endpoints eg: client connects to remote RS web service which connects to a
remote database (3 endpoints) NTLM authentication will not work, you will
have to use delegation using kerberos authentication which supports more than
one network hop. Look here for help about setting up a asp.net app for
delegation.
http://support.microsoft.com/default.aspx?scid=kb;en-us;810572
To test that this is your problem first access the report from the reporting
services console, this seems to cache your credential locally, now try from
your remote client try the same report, it should work until you log off the
rs server.
HTH,
Dan
"Armands Brants" wrote:
> The funiest thing is that I can open the report from my workstation if I do
> that way:
> * open the report from server http://localhost...
> * write the same address (http://localhost...) in my workstation's internet
> explorer - page can not be displayed, of course
> * replace localhost with srv and everything works fine!
> Can't understand why...
> Armands
> "Armands Brants" <armands.brants@.navigator.lv> wrote in message
> news:uRNDlSmxEHA.1204@.TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > First let me describe the situation.
> >
> > I have win2003 server (name: SRV) where I have SQL 2000 Reporting Services
> > installed, win2003 server with SQL2000 server (name: DBSRV) where I have a
> > database and a workstation where I create reports in Visual Studio.
> >
> > When I am creating reports, everything is OK - I can connect to database,
> > get the data etc.
> >
> > When I publish the report to http://SRV/ReportServer and try to access it
> > from with web browser from my workstation, it throws this message:
> >
> > An error has occurred during report processing. (rsProcessingAborted)
> > Cannot create a connection to data source 'Database'.
> > (rsErrorOpeningConnection)
> > Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> >
> > Of course that user doesn't have access to database.
> > But how to tell Repoting Services to get MY user name I am using to log on
> > to windows?
> >
> > Thanks,
> >
> > Armands Brants
> >
>
>

Login failed for user domain\domcontroller$ - 18456

I am running several instances of SQL Server 2005 sp2 on a W2k3 sp2 box (member server).

This morning, I installed reporting services to one of my instances and shortly after noticed I was getting the following two messages in my SQL Server log file:-

08/08/2007 11:05:03,Logon,Unknown,Login failed for user 'DOMAIN\DOMCONTROLLER$'. [CLIENT: xxx.xxx.xxx.xxx]
08/08/2007 11:05:03,Logon,Unknown,Error: 18456, Severity: 14, State: 16.

The above entries were each repeated 6 times every 15 minutes but with State 11. I created a logon for the above, and now get the above messages (state 16) repeated 3 times every 15 minutes!

Any ideas why?

Regards

Ian

It seems like a service in DOMCONTROLLER machine is trying to connect to SQL Server, it must be running under network service or local system account.

I recommend reading the following post, hopefully it will help you find the solution:

http://forums.microsoft.com/msdn/showpost.aspx?postid=66265&siteid=1

-Raul Garcia

SDE/T

SQL Server Engine

Login failed for user ''. The user is not associated with a trusted SQL Server connectio

My machine has Win XP and IIS 5.1.
I installed Visual Studio 2005 without SQL Express 2005. SQL Server
2005 is installed on another machine with Win 2003.
I created a Web Site in .NET VB. I created a connection with my SQL
server database, I can retrieve/ change data in SERVER EXPLORER. When I
try to create a gridview with data fron one table and to run the web
page in Internet Explorer I receive the following error.
Login failed for user ''. The user is not associated with a trusted SQL
Server connection.
Can you please help me ?
Which connection string are you using to connect to the database, I
guess you are using SQL Server authentication which isn=B4t setup
properly on your computer.
So switch to mixed authentication, or use a Windows account to connect
to the database-
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Which connection string are you using to connect to the database, I
guess you are using SQL Server authentication which isn=B4t setup
properly on your computer.
So switch to mixed authentication, or use a Windows account to connect
to the database-
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
How do you set up your database? A Windows Authenication or Mixed?
<CLarkou@.gmail.com> wrote in message
news:1142862649.046140.21050@.z34g2000cwc.googlegro ups.com...
> My machine has Win XP and IIS 5.1.
> I installed Visual Studio 2005 without SQL Express 2005. SQL Server
> 2005 is installed on another machine with Win 2003.
> I created a Web Site in .NET VB. I created a connection with my SQL
> server database, I can retrieve/ change data in SERVER EXPLORER. When I
> try to create a gridview with data fron one table and to run the web
> page in Internet Explorer I receive the following error.
> Login failed for user ''. The user is not associated with a trusted SQL
> Server connection.
> Can you please help me ?
>
|||I am using the following:
<remove name="LocalSqlServer" />
<add name="SubDispConnectionString1" connectionString="Data
Source=CYNICSQL1;Initial Catalog=SubDisp;Integrated Security=True"
providerName="System.Data.SqlClient" />
|||Hi, I set it as "Integrated Security=True"
|||No, this is just the connection string, not themode SQL Server is set
to. The one (COnnectionString) is the client, the authentication mode
(mixed) is the server side.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||The reason people keep asking about authentication modes is that this error
message usually means you are trying to connect with a SQL Server login to a
SQL Server instance that only supports Windows authentication. It sounds
like this is not your issue because you are connecting with Integrated
Security and not supplying a user name or password. The other possible
cause is that the Windows user has no right to authenticate a Windows
connection on the server where SQL Server is running. This can be a "double
hop" error if you are using Windows authentication on the Web site. It
could also be a case that ASPUSER has no rights to connect to the SQL Server
machine.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<CLarkou@.gmail.com> wrote in message
news:1142867073.546213.317310@.t31g2000cwb.googlegr oups.com...
> Hi, I set it as "Integrated Security=True"
>
|||I tried creating a website with FILE SYSTEM, not HTTP, and I was able
to open the web page in IE with SQL server data. ASPUSER is used for
connecting to the SQL SERVER machine with FILE SYSTEM web site ?
|||The server authentication is "Windows Authentication Mode".

Login failed for user '(null)'

My development environment consists of 2 separate servers (sql 2000 server
and iis6 server).
SQL 2000 Server has everything installed on it per the Microsoft
documentation.
IIS6 Web Server has everything installed on it per the Micorosoft
documentation.
My workstation has VS 2003 with reporting services install in it.
I followed an example in the Wrox SQL Server Reporting Services book.
Everything was easy to follow and managed to deploy the report to the web
server.
I tried to access the report:
http://192.168.1.4/reportserver?%2fMy+First+Report+Project%2fEmployee_List&rs:Command=Render
Got the following in return:
Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'AdventureWorks2000'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
----
Microsoft Reporting Services
I clicked on the links provided for help and got:
Currently there are no Microsoft Knowledge Base articles available for this
specific error or event message.
I viewed my datasourcedefinition:
--
- <DataSourceDefinition>
<Extension>SQL</Extension>
<ConnectString>data source=DEV-SRV03;initial
catalog=AdventureWorks2000</ConnectString>
<CredentialRetrieval>Integrated</CredentialRetrieval>
<Enabled>True</Enabled>
</DataSourceDefinition>
--
What do I need to do? Can someone please help me resolve this problem?
Thanks,
WillsWell here is what I did to resolve the problem.
1. Deleted the 1st attempt.
2. Create a SQL account and gave it access to the 3 dbs: AdventureWorks2000,
ReportServer and ReportServerTempDB (role: sys admin; db access with dbowner).
3. Redid the tutorial and instead of Integrated security, I went with the
sql login account.
4. Next, I had to set OverwriteDataSources to True so that it would
overwrite my existing version.
5.
http://192.168.1.4/reportserver?%2fMy+First+Report+Project%2fEmployee_List&rs:Command=Render
Gave me the report I was looking for.
Now my question is on the sql login account. What permissions and security
does my login in account need at a min to do what I just did? I'm sure that I
gave it more than what was needed, but wanted to make sure that it worked.
Thanks,
Wills
"wills" wrote:
> My development environment consists of 2 separate servers (sql 2000 server
> and iis6 server).
> SQL 2000 Server has everything installed on it per the Microsoft
> documentation.
> IIS6 Web Server has everything installed on it per the Micorosoft
> documentation.
> My workstation has VS 2003 with reporting services install in it.
> I followed an example in the Wrox SQL Server Reporting Services book.
> Everything was easy to follow and managed to deploy the report to the web
> server.
> I tried to access the report:
> http://192.168.1.4/reportserver?%2fMy+First+Report+Project%2fEmployee_List&rs:Command=Render
> Got the following in return:
> Reporting Services Error
> ----
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'AdventureWorks2000'.
> (rsErrorOpeningConnection) Get Online Help
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> ----
> Microsoft Reporting Services
> I clicked on the links provided for help and got:
> Currently there are no Microsoft Knowledge Base articles available for this
> specific error or event message.
> I viewed my datasourcedefinition:
> --
> - <DataSourceDefinition>
> <Extension>SQL</Extension>
> <ConnectString>data source=DEV-SRV03;initial
> catalog=AdventureWorks2000</ConnectString>
> <CredentialRetrieval>Integrated</CredentialRetrieval>
> <Enabled>True</Enabled>
> </DataSourceDefinition>
> --
> What do I need to do? Can someone please help me resolve this problem?
> Thanks,
> Wills

Login failed for user '(null)'

I have SQL Server 2000 Enterprise Manager installed on XP box. I want to
connect to SQL Server 2000, using trusted connection. I have required
permisiions, but I receive this error message:
Connection failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
Has anyone any idea?
Thanks in advance.
Best Reagrds,
Bil
Hi Bil,
Here is a link to an article on troubleshooting connectivity:
http://support.microsoft.com/default...&Product=sql2k
In addition, I archived an email from another individual that received a
similar error (slightly different circumstances), I'm reposting it in case
it helps you -- let us know?
~~~~~~~
There are two ways to fix this problem: to remove TCP/IP protocol from SQL
server or to impersonate users.
Remove TCP/IP
1. Go to SQL Server properties, then to General tab - Network configuration.
Remove TCP/IP protocol there.
This worked for me. However, since TCP/IP is required for replication, I had
to add it back.
Impersonate SQL Server users.
Usually you can impersonate users by going to the Local security policy in
Administrative Tools, then to Impersonate a client after authentication.
However, if you deal with the Domain controller, most of the controls there
are disabled. So:
1. Go to the Active Directory, right-click on Domain Controllers and select
Properties
2. Go to the Group Policy tab and highlight Default Domain Controller
Policy, click Edit
3. Go to Windows Settings - Security Settings - Local Policies - User Rights
Assignment
4. Double-click Impersonate a client after authentication
Then Microsoft suggested to uncheck the box Define these policy settings,
then go to the Local security policy and add users there. It worked.
However, I think it would be better just add the users right there, without
going to the Local security policy.
Either way, this solved my problem.
~~~~~~~
Steve
"Bil" <biljanat@.nbrm.gov.mk> wrote in message
news:%23oR4wygpEHA.2304@.TK2MSFTNGP14.phx.gbl...
> I have SQL Server 2000 Enterprise Manager installed on XP box. I want to
> connect to SQL Server 2000, using trusted connection. I have required
> permisiions, but I receive this error message:
> Connection failed:
> SQLState: '28000'
> SQL Server Error: 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
> Has anyone any idea?
> Thanks in advance.
> Best Reagrds,
> Bil
>
|||Steve, thank you very much. I will reply to group about the results.
Best Regards,
Bil
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:#tre8LipEHA.3728@.TK2MSFTNGP09.phx.gbl...
> Hi Bil,
> Here is a link to an article on troubleshooting connectivity:
>
http://support.microsoft.com/default...&Product=sql2k
> In addition, I archived an email from another individual that received a
> similar error (slightly different circumstances), I'm reposting it in case
> it helps you -- let us know?
> ~~~~~~~
> There are two ways to fix this problem: to remove TCP/IP protocol from SQL
> server or to impersonate users.
> Remove TCP/IP
> 1. Go to SQL Server properties, then to General tab - Network
configuration.
> Remove TCP/IP protocol there.
> This worked for me. However, since TCP/IP is required for replication, I
had
> to add it back.
> Impersonate SQL Server users.
> Usually you can impersonate users by going to the Local security policy in
> Administrative Tools, then to Impersonate a client after authentication.
> However, if you deal with the Domain controller, most of the controls
there
> are disabled. So:
> 1. Go to the Active Directory, right-click on Domain Controllers and
select
> Properties
> 2. Go to the Group Policy tab and highlight Default Domain Controller
> Policy, click Edit
> 3. Go to Windows Settings - Security Settings - Local Policies - User
Rights
> Assignment
> 4. Double-click Impersonate a client after authentication
> Then Microsoft suggested to uncheck the box Define these policy settings,
> then go to the Local security policy and add users there. It worked.
> However, I think it would be better just add the users right there,
without
> going to the Local security policy.
> Either way, this solved my problem.
> ~~~~~~~
> Steve
> "Bil" <biljanat@.nbrm.gov.mk> wrote in message
> news:%23oR4wygpEHA.2304@.TK2MSFTNGP14.phx.gbl...
>
|||I removed TCP/IP protocol on client machine and this resolved the problem.
Thank you again for your help.
Best Regards,
Bil
"Bil" <biljanat@.nbrm.gov.mk> wrote in message
news:OCh98PipEHA.324@.TK2MSFTNGP11.phx.gbl...
> Steve, thank you very much. I will reply to group about the results.
> Best Regards,
> Bil
>
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:#tre8LipEHA.3728@.TK2MSFTNGP09.phx.gbl...
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
case[vbcol=seagreen]
SQL[vbcol=seagreen]
> configuration.
> had
in[vbcol=seagreen]
> there
> select
> Rights
settings,[vbcol=seagreen]
> without
to
>
|||Excellent -- thanks for replying with the resolution.
Steve
"Bil" <biljanat@.nbrm.gov.mk> wrote in message
news:eK194YipEHA.2104@.TK2MSFTNGP10.phx.gbl...
> I removed TCP/IP protocol on client machine and this resolved the problem.
> Thank you again for your help.
> Best Regards,
> Bil
>
> "Bil" <biljanat@.nbrm.gov.mk> wrote in message
> news:OCh98PipEHA.324@.TK2MSFTNGP11.phx.gbl...
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
a[vbcol=seagreen]
> case
> SQL
I[vbcol=seagreen]
policy[vbcol=seagreen]
> in
authentication.[vbcol=seagreen]
> settings,
want[vbcol=seagreen]
> to
required[vbcol=seagreen]
user[vbcol=seagreen]
connection.
>
|||Hi,
I tried with TCP/IP and messed up something, had to install SQL server all
over again. Also i can not afford to do that, as it has to run on the client
machines. guys please have a look at the problem, probably you could help me
out.
I have a windows setup program (framework 1.1), this setup program calls
one util.exe with parameters. util.exe opens the connection (SQL Server
2000, windows authentication only) and does some db updations. when i run
thru setup exe fails throwing "Login failed for user ''(null)'. Reason: Not
associated with a trusted SQL Server connection" error. if i run the exe
separately thru command line argument, it executes properly.
I can give little more insight, while running thru the setup.exe, util.exe
runs under system account and if I run util.exe in stand alone mode it runs
under logged in user account, first case it always fails with the error as
mentioned.
How could I impersonate or what else could I do?
Thanks in advance
Prashant
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:Of3DXAjpEHA.3424@.TK2MSFTNGP12.phx.gbl...
[vbcol=seagreen]
> Excellent -- thanks for replying with the resolution.
> Steve
> "Bil" <biljanat@.nbrm.gov.mk> wrote in message
> news:eK194YipEHA.2104@.TK2MSFTNGP10.phx.gbl...
problem.
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
received[vbcol=seagreen]
> a
in[vbcol=seagreen]
from[vbcol=seagreen]
replication,[vbcol=seagreen]
> I
> policy
> authentication.
controls[vbcol=seagreen]
Controller[vbcol=seagreen]
User
> want
> required
> user
> connection.
>
|||Could you elaborate on "I tried with TCP/IP and messed up something, had to
install SQL server"?
If you remove TCP/IP from the SQL Server library utility (following the
instructions in the attached email), you should not have had to re-install
SQL Server!
Have you tried the impersonation suggestion?
Steve
"Prashant" <barnwal_p@.hotmail.com> wrote in message
news:uEvP1o5qEHA.3172@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I tried with TCP/IP and messed up something, had to install SQL server all
> over again. Also i can not afford to do that, as it has to run on the
client
> machines. guys please have a look at the problem, probably you could help
me
> out.
> I have a windows setup program (framework 1.1), this setup program calls
> one util.exe with parameters. util.exe opens the connection (SQL Server
> 2000, windows authentication only) and does some db updations. when i run
> thru setup exe fails throwing "Login failed for user ''(null)'. Reason:
Not
> associated with a trusted SQL Server connection" error. if i run the exe
> separately thru command line argument, it executes properly.
> I can give little more insight, while running thru the setup.exe, util.exe
> runs under system account and if I run util.exe in stand alone mode it
runs
> under logged in user account, first case it always fails with the error as
> mentioned.
> How could I impersonate or what else could I do?
> Thanks in advance
> Prashant
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:Of3DXAjpEHA.3424@.TK2MSFTNGP12.phx.gbl...
> problem.
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
> received
> in
> from
> replication,
> controls
and[vbcol=seagreen]
> Controller
> User
worked.[vbcol=seagreen]
there,
>
|||Hi Steve,
Thanks for giving ears, i posted multiple places to get the results, i will
continue with this group. I removed TCP/IP, protocol from server, and
restarted the services then none of SQL client were able to connect to the
server. I added back but in vain, it was a test bed, so i installed again.
I have gone thru articles and solutions listed here, nothing seems to
work-around for me.
my all computers are in lamboDomain, its small farm setup where IIS is on
one server and DB is on separate one. i have two small farm, on one farm
everthing works fine but second farm problem occurs.
If it is working for one farm do i still need to look into the
impersonation? i am asking this because then i'll have to take permission
from network authority to make changes in the active diorectory and i might
not be allowed.
please do the needful.
thanks,
Prashant
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:OJK7In7qEHA.376@.TK2MSFTNGP14.phx.gbl...
> Could you elaborate on "I tried with TCP/IP and messed up something, had
to[vbcol=seagreen]
> install SQL server"?
> If you remove TCP/IP from the SQL Server library utility (following the
> instructions in the attached email), you should not have had to re-install
> SQL Server!
> Have you tried the impersonation suggestion?
> Steve
> "Prashant" <barnwal_p@.hotmail.com> wrote in message
> news:uEvP1o5qEHA.3172@.TK2MSFTNGP10.phx.gbl...
all[vbcol=seagreen]
> client
help[vbcol=seagreen]
> me
calls[vbcol=seagreen]
run[vbcol=seagreen]
> Not
util.exe[vbcol=seagreen]
> runs
as[vbcol=seagreen]
results.
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
it[vbcol=seagreen]
protocol[vbcol=seagreen]
> and
> worked.
> there,
I[vbcol=seagreen]
for
>
|||Hi Prashant,
Replies in-line
"Prashant" <barnwal_p@.hotmail.com> wrote in message
news:eJkYaDJrEHA.736@.tk2msftngp13.phx.gbl...
> Hi Steve,
> Thanks for giving ears, i posted multiple places to get the results, i
will
> continue with this group. I removed TCP/IP, protocol from server, and
> restarted the services then none of SQL client were able to connect to the
> server.
If I understand you correctly, you should NOT remove TCP/IP protocol from
the server, this is effectively like unplugging your server network cable!
This would also explain the clients being unable to connect...
What was suggested was:
" ... remove TCP/IP from the SQL Server library utility"
This is done by navigating to:
Start>Program Files>Microsoft SQL Server>Server Network Uitlity
Ensure (for this test) that only Named Pipes is enabled as THE primary SQL
Server protocol.

>I added back but in vain, it was a test bed, so i installed again.
> I have gone thru articles and solutions listed here, nothing seems to
> work-around for me.
> my all computers are in lamboDomain, its small farm setup where IIS is on
> one server and DB is on separate one. i have two small farm, on one farm
> everthing works fine but second farm problem occurs.
> If it is working for one farm do i still need to look into the
> impersonation?
Try the above suggestion, first, then we'll take it from there. Do check the
SQL Server Client Network Utility (same path as before) that Named Pipes is
enabled as THE primary SQL Server protocol.

>i am asking this because then i'll have to take permission
> from network authority to make changes in the active diorectory and i
might[vbcol=seagreen]
> not be allowed.
> please do the needful.
> thanks,
> Prashant
> "Steve Thompson" <stevethompson@.nomail.please> wrote in message
> news:OJK7In7qEHA.376@.TK2MSFTNGP14.phx.gbl...
> to
re-install[vbcol=seagreen]
> all
> help
> calls
Server[vbcol=seagreen]
> run
Reason:[vbcol=seagreen]
exe[vbcol=seagreen]
> util.exe
error
> as
> results.
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
reposting[vbcol=seagreen]
> it
> protocol
security[vbcol=seagreen]
Controllers[vbcol=seagreen]
Policies -[vbcol=seagreen]
policy[vbcol=seagreen]
box.
> I
> for
>

Login failed for user <null>

Hello,
I have RS (client and server components) installed on a test machine
(Win2k), with the SQL-Server database on a remote machine. I'm able to create
reports, preview them with data, and deploy them with no issues. However,
when I try to execute any of them from the Report Manager, I get: "Login
failed for user '(null)'. Reason: Not associated with a trusted SQL Server
connection".
The connection object is set up in the Report Manager as a shared data
source, with the credentials stored in the report server, the credentials I'm
using have access to the database, and I have the "Use as windows credentials
when connecting to the datasource" check box checked (the database uses
Windows authentication).
Between all of the logins/security settings in use by IIS, the Windows
Services, the database, aspnet, etc. I'm at a loss as to where the issue
might lie. Any thoughts?
Thanks in advance!
BrianI had similar problems as recently as last week.
Are the SQL Server box and the RS box in the same domain ?
My setup is similar to yours but on Win2003 on both sides. and problem
was due to i dint have them in the same domain.
So i created an SQL Account with admin credentials and then
Checked the "use windows and SQL Auth" in the SQL server and configured
RS to use SQL credentials.
this is NOT the most secure solution, but i am able to move forward.
Hope this helps
Bofo|||Yes, both computers are on the same domain. The strange thing is, when I
change the data source properties (from within Report Manager) to 'Windows NT
Integrated Authority' everything runs fine...unfortunately it doesn't seem
that you can create subscriptions to reports unless you're saving the
credentials.
Doesn't seem like it should be this difficult :)
"Win2003InstallIssues" wrote:
> I had similar problems as recently as last week.
> Are the SQL Server box and the RS box in the same domain ?
> My setup is similar to yours but on Win2003 on both sides. and problem
> was due to i dint have them in the same domain.
> So i created an SQL Account with admin credentials and then
> Checked the "use windows and SQL Auth" in the SQL server and configured
> RS to use SQL credentials.
> this is NOT the most secure solution, but i am able to move forward.
> Hope this helps
> Bofo
>|||I think you found it out by trial and error, though just FYI, stored
credentials are required if you want to support subscriptions.
--
Adrian M.
MCP
"bmcelhany" <bmcelhany@.discussions.microsoft.com> wrote in message
news:E2B8822B-8437-4E7C-878A-0D0A8A011EFD@.microsoft.com...
> Yes, both computers are on the same domain. The strange thing is, when I
> change the data source properties (from within Report Manager) to 'Windows
> NT
> Integrated Authority' everything runs fine...unfortunately it doesn't seem
> that you can create subscriptions to reports unless you're saving the
> credentials.
> Doesn't seem like it should be this difficult :)
> "Win2003InstallIssues" wrote:
>> I had similar problems as recently as last week.
>> Are the SQL Server box and the RS box in the same domain ?
>> My setup is similar to yours but on Win2003 on both sides. and problem
>> was due to i dint have them in the same domain.
>> So i created an SQL Account with admin credentials and then
>> Checked the "use windows and SQL Auth" in the SQL server and configured
>> RS to use SQL credentials.
>> this is NOT the most secure solution, but i am able to move forward.
>> Hope this helps
>> Bofo
>>|||If you are connecting to Report Manager using Win Auth, and the data source
connects to the remote DB using Win Auth, you may need to enable Kerberos.
Depending on how your domain is configured, Windows credentials can be
passed across one computer connection before they expire. A user connection
to a report server counts as the first connection. If the user opens a
report that retrieves data from a remote server, that login counts as a
second connection and will fail if you are using Windows Authentication and
Kerberos is not enabled.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_datasources_v1_87e9.asp
--
Adrian M.
MCP
"bmcelhany" <bmcelhany@.discussions.microsoft.com> wrote in message
news:717CD26C-F4E2-426B-80E7-4E2CB99CA11E@.microsoft.com...
> Hello,
> I have RS (client and server components) installed on a test machine
> (Win2k), with the SQL-Server database on a remote machine. I'm able to
> create
> reports, preview them with data, and deploy them with no issues. However,
> when I try to execute any of them from the Report Manager, I get: "Login
> failed for user '(null)'. Reason: Not associated with a trusted SQL Server
> connection".
> The connection object is set up in the Report Manager as a shared data
> source, with the credentials stored in the report server, the credentials
> I'm
> using have access to the database, and I have the "Use as windows
> credentials
> when connecting to the datasource" check box checked (the database uses
> Windows authentication).
> Between all of the logins/security settings in use by IIS, the Windows
> Services, the database, aspnet, etc. I'm at a loss as to where the issue
> might lie. Any thoughts?
> Thanks in advance!
> Brian|||Right, I definitely need to support schedules/subscriptions, so stored
credentials are my only option...unfortunately I can only get the reports to
work using Windows NT Integrated Security. Here are the various data source
settings I've tried:
Assumptions: all RS components are installed on one machine (no SQL Server)
with the database on another machine within the same domain. The SQL Server
uses Windows authentication. Both the 'Reports' and the 'ReportServer'
virtual directories are using anonymous authentication.
1) Windows NT Integrated Security: the reports run perfectly, however I am
unable to schedule any of them.
2) Credentials stored in the report server: I get a "login failed for user
'bmcelhany'. Reason: not associated with a trusted SQL Server connection"
error.
3) Credentials stored in the report server with the "Use as Windows
credentials when connecting to the data source" check box checked: I get a
"login failed for user 'null'. Reason: not associated with a trusted SQL
Server conenction" error.
Any thoughts?
"Adrian M." wrote:
> I think you found it out by trial and error, though just FYI, stored
> credentials are required if you want to support subscriptions.
> --
> Adrian M.
> MCP
> "bmcelhany" <bmcelhany@.discussions.microsoft.com> wrote in message
> news:E2B8822B-8437-4E7C-878A-0D0A8A011EFD@.microsoft.com...
> > Yes, both computers are on the same domain. The strange thing is, when I
> > change the data source properties (from within Report Manager) to 'Windows
> > NT
> > Integrated Authority' everything runs fine...unfortunately it doesn't seem
> > that you can create subscriptions to reports unless you're saving the
> > credentials.
> >
> > Doesn't seem like it should be this difficult :)
> >
> > "Win2003InstallIssues" wrote:
> >
> >> I had similar problems as recently as last week.
> >>
> >> Are the SQL Server box and the RS box in the same domain ?
> >>
> >> My setup is similar to yours but on Win2003 on both sides. and problem
> >> was due to i dint have them in the same domain.
> >>
> >> So i created an SQL Account with admin credentials and then
> >> Checked the "use windows and SQL Auth" in the SQL server and configured
> >> RS to use SQL credentials.
> >>
> >> this is NOT the most secure solution, but i am able to move forward.
> >> Hope this helps
> >> Bofo
> >>
> >>
>
>|||Have you tried the userid-pw login from the Visual Studio IDE? Also - the
obvious question - is mixed mode security enabled on SQL Server?
"bmcelhany" <bmcelhany@.discussions.microsoft.com> wrote in message
news:8D8CB6D4-8FE2-4E03-99AD-BFAFAB4B9B98@.microsoft.com...
> Right, I definitely need to support schedules/subscriptions, so stored
> credentials are my only option...unfortunately I can only get the reports
to
> work using Windows NT Integrated Security. Here are the various data
source
> settings I've tried:
> Assumptions: all RS components are installed on one machine (no SQL
Server)
> with the database on another machine within the same domain. The SQL
Server
> uses Windows authentication. Both the 'Reports' and the 'ReportServer'
> virtual directories are using anonymous authentication.
> 1) Windows NT Integrated Security: the reports run perfectly, however I am
> unable to schedule any of them.
> 2) Credentials stored in the report server: I get a "login failed for user
> 'bmcelhany'. Reason: not associated with a trusted SQL Server connection"
> error.
> 3) Credentials stored in the report server with the "Use as Windows
> credentials when connecting to the data source" check box checked: I get a
> "login failed for user 'null'. Reason: not associated with a trusted SQL
> Server conenction" error.
> Any thoughts?
> "Adrian M." wrote:
> > I think you found it out by trial and error, though just FYI, stored
> > credentials are required if you want to support subscriptions.
> >
> > --
> > Adrian M.
> > MCP
> >
> > "bmcelhany" <bmcelhany@.discussions.microsoft.com> wrote in message
> > news:E2B8822B-8437-4E7C-878A-0D0A8A011EFD@.microsoft.com...
> > > Yes, both computers are on the same domain. The strange thing is, when
I
> > > change the data source properties (from within Report Manager) to
'Windows
> > > NT
> > > Integrated Authority' everything runs fine...unfortunately it doesn't
seem
> > > that you can create subscriptions to reports unless you're saving the
> > > credentials.
> > >
> > > Doesn't seem like it should be this difficult :)
> > >
> > > "Win2003InstallIssues" wrote:
> > >
> > >> I had similar problems as recently as last week.
> > >>
> > >> Are the SQL Server box and the RS box in the same domain ?
> > >>
> > >> My setup is similar to yours but on Win2003 on both sides. and
problem
> > >> was due to i dint have them in the same domain.
> > >>
> > >> So i created an SQL Account with admin credentials and then
> > >> Checked the "use windows and SQL Auth" in the SQL server and
configured
> > >> RS to use SQL credentials.
> > >>
> > >> this is NOT the most secure solution, but i am able to move forward.
> > >> Hope this helps
> > >> Bofo
> > >>
> > >>
> >
> >
> >

Login failed for user

I recently installed SQL Server 2008 July CTP, and am not able to login using the Windows account. I left everything as default during installation, set the authentication mode to Mixed, set up the sa account password. I can login using the sa account with no problems, but can't login using the windows account.

Anyone have any iseas what I could be missing?

Thanks,

Dhruv

Please add the following information

- When you type GPRESULT from a command prompt window, do you see BUILTIN\Administrators as a group you are a member of?

- Which operating system is this on? If this is Vista, try to spawn a command prompt as administrator (right click on the command prompt icon and choose "Run as Administrator") and test connectivity using sqlcmd. If that works, you will just have to add your windows account explicitly to SQL Server as a sysadmin to get around Vista UAC.

|||

GPRESULT does show BUILTIN\Aministrators, sqlcmd shows the following -

C:\Windows\system32>sqlcmd -S USLAP007;
HResult 0x35, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [53].
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : An error has occurred w
hile establishing a connection to the server. When connecting to SQL Server 2005
or above, this failure may be caused by the fact that under the default setting
s SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

Thanks,

Dhruv

sql

Login failed for user

I installed Sales Logix (a database program) which uses
SQL Server MSDE. When you install Sales Logix, it
installs SQL Server; however, I was having trouble getting
SQL to install so worked with a Microsoft tech and we got
a default instance of SQL Server MSDE installed. Now,
when I try to attach my SLX database using the SalesLogix
Attach Remote utility, I get the following error:
[Microsoft][ODBC SQL Driver][SQL Server Driver][SQL Server]
Login failed for user 'sa'. Reason: Not associated with
a trusted SQL Server connection.
How would I associate this with a trusted SQL Server
connection? Any help would be greatly appreciated!
Leesa
hi Leesa,
"Leesa" <leesaforeman@.fccef.com> ha scritto nel messaggio
news:2f55001c46c41$0fa2ad50$a301280a@.phx.gbl...
> I installed Sales Logix (a database program) which uses
> SQL Server MSDE. When you install Sales Logix, it
> installs SQL Server; however, I was having trouble getting
> SQL to install so worked with a Microsoft tech and we got
> a default instance of SQL Server MSDE installed. Now,
> when I try to attach my SLX database using the SalesLogix
> Attach Remote utility, I get the following error:
> [Microsoft][ODBC SQL Driver][SQL Server Driver][SQL Server]
> Login failed for user 'sa'. Reason: Not associated with
> a trusted SQL Server connection.
> How would I associate this with a trusted SQL Server
> connection? Any help would be greatly appreciated!
> Leesa
MSDE install by default granting only Windows NT trusted connections, so SQL
Server authenticated connections, using "user" + "pwd" credential are not
allowed...
you can change this behaviour both at install time and later, using the
advices provided at
http://support.microsoft.com/default...b;en-us;285097
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

login failed for user

I have XP Pro installed with SQl Server 7.0. I use Visual
Studio.NET for programming ASP.NET(IIS is also
installed).When I run this, I get an error message

"login failed for user VENKY/ASPNET".

I did some search and many poeple seem to have these
errors but not one page says what is to be clearly done
for XP platform. One page said that I have to create a
domain user ASPNET and see to that this user has access
rights to SQL Server. COuld someone please tell the steps
to do this. Thanks a lot in advance.

Gayathri
.Is your sql server and iis running on the same machine ? What is your anonymous login set to under iis ?|||Originally posted by rnealejr
Is your sql server and iis running on the same machine ? What is your anonymous login set to under iis ?

Yes they are running on the same machine. Sorry what do you mean by anonymous login, where do you go and see that. Anyway yesterday we solved the problem somehow, did further research on the web and somehow solved it.

Thanks,

Gayathri|||To check the anonymous account used in iis - go into internet service manager. Right click on 'default web site'. Click on 'directory security' -> click edit under 'anonymous access ...) -> click edit under 'anonymous access'.

The solution may have been adding that username to sql server or the anonymous access login to sql server.

For future reference - the following is a helpful article from ms:

article (http://support.microsoft.com/default.aspx?scid=kb;EN-US;247931)sql

login failed Error 18456 Help needed!

I'm a developer who's used mainly SQL Server 2000. I've installed 2005 at
work and use the client tools with no problem.
I have Vista at home, new machine. I installed Sql 2005. I've tried both
system login and Windows Authen. I am the only user and hence an admin on
this box.
I open 2005 Mgmt Studio. I want to attach databases. But I can't even get my
Database engine to connect, despite that fact my Server shows up in
Registered Servers.
When I choose Connect, I then browse for Server(only one), I use Windows
Auth and get error Login failed for user ....error 18456.
Something this simple, shouldn't be so difficult.
While I've connected at work with no problem, I guess that's the issue,
there was no problem and since I'm not a newbie, I'm kinda pissed off. Can
anyone help me?
Since I'm at home for the next 3 days, and since I'm registered using my
work email address, I'd appreciate a direct email to me at
matthewmark@.verizon.net.
Thanks,
Matthew Mark
What's the error state and error description in the SQL Server log
files? They should give you a more detailed reason why you can't
logon.
Check if this helps:
http://eventid.net/display.asp?eventid=18456&eventno=8175
&source=MSSQLSERVER&phase=1
__________________________________________________ _______
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___
=?Utf-8?B?TWF0dGhldyBNYXJr?=
<MatthewMark@.discussions.microsoft.com> wrote on 11 nov 2007 in
microsoft.public.sqlserver.connect:

> I'm a developer who's used mainly SQL Server 2000. I've
> installed 2005 at work and use the client tools with no problem.
> I have Vista at home, new machine. I installed Sql 2005. I've
> tried both system login and Windows Authen. I am the only user
> and hence an admin on this box.
> I open 2005 Mgmt Studio. I want to attach databases. But I can't
> even get my Database engine to connect, despite that fact my
> Server shows up in Registered Servers.
> When I choose Connect, I then browse for Server(only one), I use
> Windows Auth and get error Login failed for user ....error
> 18456.
> Something this simple, shouldn't be so difficult.
> While I've connected at work with no problem, I guess that's the
> issue, there was no problem and since I'm not a newbie, I'm
> kinda pissed off. Can anyone help me?
> Since I'm at home for the next 3 days, and since I'm registered
> using my work email address, I'd appreciate a direct email to me
> at matthewmark@.verizon.net.
> Thanks,
|||In the server erro log you can fine an entry related to the error.
Check the description of the STATE code here:
http://msdn2.microsoft.com/en-us/library/ms366351.aspx
i hope this help !!!
Claudio Riefolo
MCSE - VCP
"Vera Noest" wrote:

> What's the error state and error description in the SQL Server log
> files? They should give you a more detailed reason why you can't
> logon.
> Check if this helps:
> http://eventid.net/display.asp?eventid=18456&eventno=8175
> &source=MSSQLSERVER&phase=1
> __________________________________________________ _______
> Vera Noest
> MCSE, CCEA, Microsoft MVP - Terminal Server
> SQL troubleshooting: http://sql.veranoest.net
> ___ please respond in newsgroup, NOT by private email ___
> =?Utf-8?B?TWF0dGhldyBNYXJr?=
> <MatthewMark@.discussions.microsoft.com> wrote on 11 nov 2007 in
> microsoft.public.sqlserver.connect:
>
|||I'm not sure I understand, but I think your problem is that you are relying
on your membership in the local administrators group for permission to
connect. Vista doesn't give you that permission automatically. So try the
"Run as Administrator" option when you start Management Studio. After you
connect, add your own login as to the SQL Server. Then in the future you
won't have to run as administrator.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matthew Mark" <MatthewMark@.discussions.microsoft.com> wrote in message
news:0282CF87-7003-4CFB-8C0B-C8BC88BAD87C@.microsoft.com...
> I'm a developer who's used mainly SQL Server 2000. I've installed 2005 at
> work and use the client tools with no problem.
> I have Vista at home, new machine. I installed Sql 2005. I've tried both
> system login and Windows Authen. I am the only user and hence an admin on
> this box.
> I open 2005 Mgmt Studio. I want to attach databases. But I can't even get
> my
> Database engine to connect, despite that fact my Server shows up in
> Registered Servers.
> When I choose Connect, I then browse for Server(only one), I use Windows
> Auth and get error Login failed for user ....error 18456.
> Something this simple, shouldn't be so difficult.
> While I've connected at work with no problem, I guess that's the issue,
> there was no problem and since I'm not a newbie, I'm kinda pissed off. Can
> anyone help me?
> Since I'm at home for the next 3 days, and since I'm registered using my
> work email address, I'd appreciate a direct email to me at
> matthewmark@.verizon.net.
> Thanks,
>
> --
> Matthew Mark
>

login failed Error 18456 Help needed!

I'm a developer who's used mainly SQL Server 2000. I've installed 2005 at
work and use the client tools with no problem.
I have Vista at home, new machine. I installed Sql 2005. I've tried both
system login and Windows Authen. I am the only user and hence an admin on
this box.
I open 2005 Mgmt Studio. I want to attach databases. But I can't even get my
Database engine to connect, despite that fact my Server shows up in
Registered Servers.
When I choose Connect, I then browse for Server(only one), I use Windows
Auth and get error Login failed for user ....error 18456.
Something this simple, shouldn't be so difficult.
While I've connected at work with no problem, I guess that's the issue,
there was no problem and since I'm not a newbie, I'm kinda pissed off. Can
anyone help me?
Since I'm at home for the next 3 days, and since I'm registered using my
work email address, I'd appreciate a direct email to me at
matthewmark@.verizon.net.
Thanks,
Matthew MarkWhat's the error state and error description in the SQL Server log
files? They should give you a more detailed reason why you can't
logon.
Check if this helps:
http://eventid.net/display.asp?even...56&eventno=8175
&source=MSSQLSERVER&phase=1
________________________________________
_________________
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___
examnotes
<MatthewMark@.discussions.microsoft.com> wrote on 11 nov 2007 in
microsoft.public.sqlserver.connect:

> I'm a developer who's used mainly SQL Server 2000. I've
> installed 2005 at work and use the client tools with no problem.
> I have Vista at home, new machine. I installed Sql 2005. I've
> tried both system login and Windows Authen. I am the only user
> and hence an admin on this box.
> I open 2005 Mgmt Studio. I want to attach databases. But I can't
> even get my Database engine to connect, despite that fact my
> Server shows up in Registered Servers.
> When I choose Connect, I then browse for Server(only one), I use
> Windows Auth and get error Login failed for user ....error
> 18456.
> Something this simple, shouldn't be so difficult.
> While I've connected at work with no problem, I guess that's the
> issue, there was no problem and since I'm not a newbie, I'm
> kinda pissed off. Can anyone help me?
> Since I'm at home for the next 3 days, and since I'm registered
> using my work email address, I'd appreciate a direct email to me
> at matthewmark@.verizon.net.
> Thanks,|||In the server erro log you can fine an entry related to the error.
Check the description of the STATE code here:
http://msdn2.microsoft.com/en-us/library/ms366351.aspx
i hope this help !!!
Claudio Riefolo
MCSE - VCP
"Vera Noest" wrote:

> What's the error state and error description in the SQL Server log
> files? They should give you a more detailed reason why you can't
> logon.
> Check if this helps:
> http://eventid.net/display.asp?even...56&eventno=8175
> &source=MSSQLSERVER&phase=1
> ________________________________________
_________________
> Vera Noest
> MCSE, CCEA, Microsoft MVP - Terminal Server
> SQL troubleshooting: http://sql.veranoest.net
> ___ please respond in newsgroup, NOT by private email ___
> examnotes
> <MatthewMark@.discussions.microsoft.com> wrote on 11 nov 2007 in
> microsoft.public.sqlserver.connect:
>
>|||I'm not sure I understand, but I think your problem is that you are relying
on your membership in the local administrators group for permission to
connect. Vista doesn't give you that permission automatically. So try the
"Run as Administrator" option when you start Management Studio. After you
connect, add your own login as to the SQL Server. Then in the future you
won't have to run as administrator.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matthew Mark" <MatthewMark@.discussions.microsoft.com> wrote in message
news:0282CF87-7003-4CFB-8C0B-C8BC88BAD87C@.microsoft.com...
> I'm a developer who's used mainly SQL Server 2000. I've installed 2005 at
> work and use the client tools with no problem.
> I have Vista at home, new machine. I installed Sql 2005. I've tried both
> system login and Windows Authen. I am the only user and hence an admin on
> this box.
> I open 2005 Mgmt Studio. I want to attach databases. But I can't even get
> my
> Database engine to connect, despite that fact my Server shows up in
> Registered Servers.
> When I choose Connect, I then browse for Server(only one), I use Windows
> Auth and get error Login failed for user ....error 18456.
> Something this simple, shouldn't be so difficult.
> While I've connected at work with no problem, I guess that's the issue,
> there was no problem and since I'm not a newbie, I'm kinda pissed off. Can
> anyone help me?
> Since I'm at home for the next 3 days, and since I'm registered using my
> work email address, I'd appreciate a direct email to me at
> matthewmark@.verizon.net.
> Thanks,
>
> --
> Matthew Mark
>

Login failed

I have VS2005 Beta 2

I created a very simple Web Site that has a Login page and a Default Page

I installed MSDE so that I can use a SQL 2000 database

I ran C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\aspnet_regsql.exe
to create a database in the MSSQLSERVER for user info.

My Web.config file looks like:

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=myDataBase;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<compilation debug="false">
<assemblies>
<add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></assemblies></compilation>
<authorization>
<deny users="?"></deny>
</authorization>
<authentication mode="Forms"/>
</system.web>
</configuration>

I have a Global.asax file containing:

void Application_Start(Object sender, EventArgs e) {
// always create bob and alice as users if they are not present
// so you can login and we can avoid dealing with admin
//
MembershipCreateStatus status;
if (Membership.FindUsersByName("bob").Count == 0)
Membership.CreateUser("bob", "pass@.word1", "bob@.wingtip.com", "no question", "no answer", true, out status);
if (Membership.FindUsersByName("alice").Count == 0)
Membership.CreateUser("alice", "pass@.word1", "alice@.wingtip.com", "no question", "no answer", true, out status);
}

When open the web site from the File System in VS2005 everything runs fine.

When I copy the Web site to a virtual directory set up in IIS and the open the web site using Local IIS in VS2005 I get:

Cannot open database "myDataBase" requested by the login. The login failed.
Login failed for user 'BARBARA\ASPNET'.

You use integrated security to connect to the database and when testing local in VS2005 it will use the currently logged on user running VS2005. Most likely that is your user account and it has access to the database.

The error message indicates you are trying to logon to the database with BARBARA\ASPNET user and that is the user setup to run the application in IIS. You could either change this to be another user that has access to the database needed, under directory security in IIS, or give the user BARBARA\ASPNET access to the database.|||Thanks for your reply - I don't have that much experience with this stuff -

Could you please tell me how I can go about giving BARBARA\ASPNET access to the database? I don't know about changing the user that is accessing the database in IIS. BARBARA is the name of the computer and ASPNET is the user that was created on the computer when all this stuff was loaded. Do I have to change the database server to use mixed security?

Is it a user that has to be set up for the server or for the database? In any case, I don't really know how to do this. Any direction would be appreciated.

thanks|||You might want to have a look at 3rd party tools to adminstrate MSDE.

You can do it directly in a query also.

exec sp_grantlogin 'BARBARA\ASPNET'
go
use myDataBase
go
exec sp_grantdbaccess 'BARBARA\ASPNET', 'ASPNET'
go
exec sp_addrolemember 'public', 'ASPNET'

This assumes that the group public has the proper permissions in the database. You could use dbo instead of public then the ASPNET user will be acting as database owner.

|||okay thank you very much - that gives me a direction

Login failed

I have VS2005 Beta 2

I created a very simple Web Site that has a Login page and a Default Page

I installed MSDE so that I can use a SQL 2000 database

I ranC:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\aspnet_regsql.exe
to create a database in the MSSQLSERVER for user info.

My Web.config file looks like:

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=myDataBase;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<compilation debug="false">
<assemblies>
<add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></assemblies></compilation>
<authorization>
<deny users="?"></deny>
</authorization>
<authentication mode="Forms"/>
</system.web>
</configuration>

I have a Global.asax file containing:

void Application_Start(Object sender, EventArgs e) {
// always create bob and alice as users if they are not present
// so you can login and we can avoid dealing with admin
//
MembershipCreateStatus status;
if (Membership.FindUsersByName("bob").Count == 0)
Membership.CreateUser("bob", "pass@.word1", "bob@.wingtip.com", "no question", "no answer", true, out status);
if (Membership.FindUsersByName("alice").Count == 0)
Membership.CreateUser("alice", "pass@.word1", "alice@.wingtip.com", "no question", "no answer", true, out status);
}

When open the web site from the File System in VS2005 everything runs fine.

When I copy the Web site to a virtual directory set up in IIS and the open the web site using Local IIS in VS2005 I get:

Cannot open database "myDataBase" requested by the login. The login failed.
Login failed for user 'BARBARA\ASPNET'.

You use integrated security to connect to the database and when testing local in VS2005 it will use the currently logged on user running VS2005. Most likely that is your user account and it has access to the database.

The error message indicates you are trying to logon to the database with BARBARA\ASPNET user and that is the user setup to run the application in IIS. You could either change this to be another user that has access to the database needed, under directory security in IIS, or give the user BARBARA\ASPNET access to the database.|||Thanks for your reply - I don't have that much experience with this stuff -

Could you please tell me how I can go about giving BARBARA\ASPNET access to the database? I don't know about changing the user that is accessing the database in IIS. BARBARA is the name of the computer and ASPNET is the user that was created on the computer when all this stuff was loaded. Do I have to change the database server to use mixed security?

Is it a user that has to be set up for the server or for the database? In any case, I don't really know how to do this. Any direction would be appreciated.

thanks|||You might want to have a look at 3rd party tools to adminstrate MSDE.

You can do it directly in a query also.

exec sp_grantlogin 'BARBARA\ASPNET'
go
use myDataBase
go
exec sp_grantdbaccess 'BARBARA\ASPNET', 'ASPNET'
go
exec sp_addrolemember 'public', 'ASPNET'

This assumes that the group public has the proper permissions in the database. You could use dbo instead of public then the ASPNET user will be acting as database owner.|||okay thank you very much - that gives me a direction

Login failed

Hi,

I can connect to the SQL server installed in another machine in our network. But when I run the web form I'm having this error.

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Pls help me

your sql server to need to setup account for this paticular machine to access.|||

Hi lakmalvbj,

From your description, I understand you can use SQL client tool to connect the remote SQL Server by window authentication, but Web Form fail. If I have misunderstood your concern, please feel free to let me know.

The error message isLogin failed for user ''. The user is not associated with a trusted SQL Server connection.

I find the user name is null. Is it the intact error message?

If the error message is intact. For the user who login fail is null, I believe you were using Impersonation in web.config with simply section:

<identityimpersonate="true" />

When a client view the page with Windows Authentication, the primary token can be passed only once and cannot be used for connecting remove database. So the null user login fail error occured. this is a design feature of NTLM security. And the solution is set username and password in identity section.

<identityimpersonate ="true"username="Domain\UserName"password="pword"/>

Or change the connect string to use SQL authentication.

|||

Hi,

Thanks for all replies.

I solved the problem by creating new user in sql server and giving l user name and password in Connection String. Work fine.

Dim myconnection As SqlConnection = New SqlConnection("workstation id="Ur Work Station";packet size=4096;user id=XXXX;password=XXXX;data source=Server;initial catalog=Database")

This work fine. I tried Benson Yu's suggestions. It also work fine

Login Failed

I have installed MSDE on a w/s and when logged in as administrator I can
access the server using OSQL -E however if I am logged in as a user and try
to access the server I am denied access.
I have the SQL tools installed on a different machine and would like to
access this server using EM across the LAN, on the machine running EM do I
need to login as administrator in order to connect the MSDE server machine ?
Thanks
Murphy
"Murphy" <Murphy@.murphy.com> wrote in message
news:u3stcLpLEHA.1052@.TK2MSFTNGP12.phx.gbl...
> I have installed MSDE on a w/s and when logged in as administrator I can
> access the server using OSQL -E however if I am logged in as a user and
try
> to access the server I am denied access.
> I have the SQL tools installed on a different machine and would like to
> access this server using EM across the LAN, on the machine running EM do I
> need to login as administrator in order to connect the MSDE server machine
?
> Thanks
> Murphy
>
I have just logged in ad administrator on the machine running EM and tried
to connect to the MSDE server using:
C:\>osql -S MachineA -E
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
C:\>
This command works perfectly when run on the machine runnng MSDE when logged
in as adminsitrator...
What am I missing ?
Thanks
Murphy
|||Is there anything which could be blocking the connection?
Are the machines part of a workgroup or domain?
Some Links:
http://support.microsoft.com/default...&Product=sql2k
http://support.microsoft.com/default...&Product=sql2k
Cheers,
James Goodman
"Murphy" <murphy@.murphy.com> wrote in message
news:evoz1NpLEHA.1388@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> "Murphy" <Murphy@.murphy.com> wrote in message
> news:u3stcLpLEHA.1052@.TK2MSFTNGP12.phx.gbl...
> try
I[vbcol=seagreen]
machine
> ?
> I have just logged in ad administrator on the machine running EM and tried
> to connect to the MSDE server using:
> C:\>osql -S MachineA -E
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
> C:\>
> This command works perfectly when run on the machine runnng MSDE when
logged
> in as adminsitrator...
> What am I missing ?
> Thanks
> Murphy
>
|||There's no local firewall running etc and the machines are part of a domain.
Thanks
Murphy
"James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
news:uqnZ0cpLEHA.556@.tk2msftngp13.phx.gbl...
> Is there anything which could be blocking the connection?
> Are the machines part of a workgroup or domain?
>
> Some Links:
>
http://support.microsoft.com/default...&Product=sql2k
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
>
>
> --
> Cheers,
> James Goodman
> "Murphy" <murphy@.murphy.com> wrote in message
> news:evoz1NpLEHA.1388@.TK2MSFTNGP09.phx.gbl...
can[vbcol=seagreen]
and[vbcol=seagreen]
to[vbcol=seagreen]
do[vbcol=seagreen]
> I
> machine
tried
> logged
>

login error

I have installed SQL Server in a vmware virtual machine and when i try to register the server it fails with this error msg:
login error for user sa. Reason: it is not associated to a trusted relationship connection
any idea? sa is a valid login for the serverLooks like you set up Windows Authentication only.

Login and User Problems

Sorry but i think i was not clear enough..
I have a SQL Server 7.0 Desktop installed in my computer. When i restore a
back up
from a SQL SERVER 7.0 Standart it, restore all tables from the database but
not logins.
When I create the logins in the Standart Edition, I created it one for each
user and sing it
by database default my database.
this users appear in the tree view, in the Database User folder.
When i restore the database all there are not users, asingned in the databas
e...
only, Roles and, in this ones, a Public one, that contain all users that i c
reated.
I can't delete this users, and i can't create a new one with the same name,
because an Error
come's up..
Error 15023: User or role 'REMI'alredy esists in the current database
now i don't know what to do..
any help it will be apreciated..
RemiI am not sure if I understand everything, but let me try. Logins are in
master database, so it is normal they are not restored with a user database.
You can script them on the source and implement the script on the
destination server. I guess we are talking about SQL logins. You cn map them
to db users with sp_change_users_login system SP - check it in Books OnLine.
HTH,
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.|||Thank you that resolve the problem...
Remi
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> escribi
en el mensaje news:e3MIR0$2DHA.3196@.TK2MSFTNGP11.phx.gbl...

quote:

---

> I am not sure if I understand everything, but let me try. Logins are in
> master database, so it is normal they are not restored with a user

---

database.

quote:

---

> You can script them on the source and implement the script on the
> destination server. I guess we are talking about SQL logins. You cn map

---

them

quote:

---

> to db users with sp_change_users_login system SP - check it in Books

---

OnLine.

quote:

---

> HTH,
> --
> Dejan Sarka, SQL Server MVP
> Please reply only to the newsgroups.
>

---

login 101..

What is the difference between 'Windows Authentication' login and 'SQL
login'? I have IIS, MSDE installed on my home computer and I don't log
into windows. So how does 'Windows Authentication' apply in this case?
Thanks,
RABMissouriIt depends on what operating system you are running at home.
In some cases, even though you don't explicitly log in, you
are being logged in when the computer starts up. It's just
transparent to the user.
What OS are you running at home?
-Sue
On 22 May 2006 08:31:41 -0700, "RAB" <rabmissouri@.yahoo.com>
wrote:

>What is the difference between 'Windows Authentication' login and 'SQL
>login'? I have IIS, MSDE installed on my home computer and I don't log
>into windows. So how does 'Windows Authentication' apply in this case?
>
>Thanks,
>RABMissouri|||On 22 May 2006 08:31:41 -0700, RAB wrote:

>What is the difference between 'Windows Authentication' login and 'SQL
>login'?
Hi RABMissouri,
Windows authentication - SQL Server uses a special protocol to ask
Windows for the details of the currently logged-in user. If the Windows
user is in the list of allowed logins, the login succeeds wiithout the
user having to enter anything. If the Windows login is not registered as
a SQL Server login, an error message follows.
Advantages: no extra login prompts for user; SQL Server security
benefits from Windows login policies (such as password aging, etc).
Disadvantages: doesn't lend itself for testing; Windows users with admin
rights are automatically logged in as SQL Server admin.
SQL Server login - SQL Server prompts user for loginname and password,
then compares this to list of loginnames and (encrypted) passwords in
system table master..syslogins. On a match, you are logged in.
Advantages: easy when you have to test seecurity for different roles.
Disadvantages: no password expiration, password complexity checks, etc.

> I have IIS, MSDE installed on my home computer and I don't log
>into windows. So how does 'Windows Authentication' apply in this case?
What version of Windows are yoou using?
Hugo Kornelis, SQL Server MVP|||Windows XP Professional...
Thanks,
RABMissouri|||Just a correction for the SQL Authentication description:
On Windows 2003, SQL Server 2005 can enforce the Windows password complexity
and expiration policy for SQL logins.
Thanks
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
news:bsf472h1m7vuhpjlhfi55eekqe47r7nte3@.
4ax.com...
> On 22 May 2006 08:31:41 -0700, RAB wrote:
>
> Hi RABMissouri,
> Windows authentication - SQL Server uses a special protocol to ask
> Windows for the details of the currently logged-in user. If the Windows
> user is in the list of allowed logins, the login succeeds wiithout the
> user having to enter anything. If the Windows login is not registered as
> a SQL Server login, an error message follows.
> Advantages: no extra login prompts for user; SQL Server security
> benefits from Windows login policies (such as password aging, etc).
> Disadvantages: doesn't lend itself for testing; Windows users with admin
> rights are automatically logged in as SQL Server admin.
> SQL Server login - SQL Server prompts user for loginname and password,
> then compares this to list of loginnames and (encrypted) passwords in
> system table master..syslogins. On a match, you are logged in.
> Advantages: easy when you have to test seecurity for different roles.
> Disadvantages: no password expiration, password complexity checks, etc.
>
> What version of Windows are yoou using?
> --
> Hugo Kornelis, SQL Server MVP|||If you aren't logging in then I would guess you are using
the Welcome screen login option. The user you select is the
user that is logged into windows for you. That is the login
that would access MSDE on your computer if you were using
osql, admin tools, etc. Depending on other settings but
generally if your web site is using Windows Authentication,
it will log into SQL Server using the ComputerName\ASPNET
login.
That's basically how it would work. There is a login
associated with you as well as IIS that can be used as
windows logins in SQL Server.
-Sue
On 22 May 2006 18:40:57 -0700, "RAB" <rabmissouri@.yahoo.com>
wrote:

>Windows XP Professional...
>Thanks,
>RABMissouri