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

Hi ,
I am using IIS 6.0 and have an ASP.NET where get the following error when
trying to connect from a .NET assembly.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
So I read some info from other forums and understand that I must add
the 'NT AUTHORITY\NETWORK SERVICE' as a user on my SQL Server 2005 database.
My problem is when I try to add this user by browsing for "Objects" in
Windows Server 2003, I don see this object. What am I missing?
Any ideas?By the way, my connection string is
"data source=NDS2214;Initial Catalog=UATP;Integrated Security=true"
"Opa" wrote:

> Hi ,
> I am using IIS 6.0 and have an ASP.NET where get the following error when
> trying to connect from a .NET assembly.
> Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
> So I read some info from other forums and understand that I must add
> the 'NT AUTHORITY\NETWORK SERVICE' as a user on my SQL Server 2005 databas
e.
> My problem is when I try to add this user by browsing for "Objects" in
> Windows Server 2003, I don see this object. What am I missing?
> Any ideas?

Login failed for user NT AUTHORITY\NETWORK SERVICE

Hi All,
I've done some searching around but can't find an answer to this problem.
I've recently noticed an error in the event logs relating to the Network
Service account trying to connect to my SQL 2005 server. The logs give me
the following information :-
12/06/2007 23:30:01,Logon,Unknown,Login failed for user 'NT
AUTHORITY\NETWORK SERVICE'. [CLIENT: 10.0.0.4]
12/06/2007 23:30:01,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 1
6.
This is all the info I have to go on. Can anyone provide me with some
assistance with trying to troubleshoot?Well, it seems that some process working in Network Service user context is
trying to connect your instance and Network Service has no permission to
connect the target database in SQL Server. Run SQL Server Profiler and catch
failed login attempts (catch Audit Login Failed event with ApplicationName
and DatabaseName columns selected to trace).
Regards
Pawel Potasinski
[http://www.potasinski.pl]
Uytkownik "Matt" <Matt@.discussions.microsoft.com> napisa w wiadomoci
news:AB02D9C1-DF84-4A43-BCA5-4A84B8323525@.microsoft.com...
> Hi All,
> I've done some searching around but can't find an answer to this problem.
> I've recently noticed an error in the event logs relating to the Network
> Service account trying to connect to my SQL 2005 server. The logs give me
> the following information :-
> 12/06/2007 23:30:01,Logon,Unknown,Login failed for user 'NT
> AUTHORITY\NETWORK SERVICE'. [CLIENT: 10.0.0.4]
> 12/06/2007 23:30:01,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State:
> 16.
> This is all the info I have to go on. Can anyone provide me with some
> assistance with trying to troubleshoot?|||Thanks Pawel,
The only way I am able to force the netork login failure is by restarting
the MSSQL server process. Of course, when I do this with the Profiler
running, I end up with a Trace error in the log as soon as the server goes
online and the logging stops. Any idea how I can make the Profiler keep
running even when the server gets restarted? Or is there a way that I can
make the profiler start when the server starts before loading anything else?
Matt
"Pawel Potasinski" wrote:

> Well, it seems that some process working in Network Service user context i
s
> trying to connect your instance and Network Service has no permission to
> connect the target database in SQL Server. Run SQL Server Profiler and cat
ch
> failed login attempts (catch Audit Login Failed event with ApplicationName
> and DatabaseName columns selected to trace).
> --
> Regards
> Pawel Potasinski
> [http://www.potasinski.pl]
>
> U?ytkownik "Matt" <Matt@.discussions.microsoft.com> napisa3 w wiadomo?ci
> news:AB02D9C1-DF84-4A43-BCA5-4A84B8323525@.microsoft.com...
>
>|||I ment to say "I end up with a Trace error in the log as soon as the server
goes
OFFLINE and the logging stops".
Just to be clear, I see the Failed Audit login message in the SQL log only
when I start the start the server. It doesnn't continuely happen, therefore
the only time I can try and trace the cause of the issue is as the server
starts up
"Matt" wrote:
[vbcol=seagreen]
> Thanks Pawel,
> The only way I am able to force the netork login failure is by restarting
> the MSSQL server process. Of course, when I do this with the Profiler
> running, I end up with a Trace error in the log as soon as the server goes
> online and the logging stops. Any idea how I can make the Profiler keep
> running even when the server gets restarted? Or is there a way that I can
> make the profiler start when the server starts before loading anything els
e?
> Matt
> "Pawel Potasinski" wrote:
>|||OK, with a bit of luck, patience and timing, I managed to get a trace of the
Audit Login Failed notice. It looks like our CRM application is having a ba
d
day and isn't able to logon to something. However, even though I enabled al
l
columns in the Profiler and made sure DatabaseName column was selected, I
only get columns ApplicationName - TextData listed. The all-important info
aon what table the service is trying to access is still missing.
Any thoughts?
"Matt" wrote:
[vbcol=seagreen]
> I ment to say "I end up with a Trace error in the log as soon as the serve
r
> goes
> OFFLINE and the logging stops".
> Just to be clear, I see the Failed Audit login message in the SQL log only
> when I start the start the server. It doesnn't continuely happen, therefo
re
> the only time I can try and trace the cause of the issue is as the server
> starts up
> "Matt" wrote:
>|||Matt (Matt@.discussions.microsoft.com) writes:
> OK, with a bit of luck, patience and timing, I managed to get a trace of
> the Audit Login Failed notice. It looks like our CRM application is
> having a bad day and isn't able to logon to something. However, even
> though I enabled all columns in the Profiler and made sure DatabaseName
> column was selected, I only get columns ApplicationName - TextData
> listed. The all-important info aon what table the service is trying to
> access is still missing.
It's seems difficult to find out which table the CRM app is trying to
access, when it does not comes as far as connecting...
Then again, if you get a single login failure when you start SQL Server,
and the CRM application does not produce an error, maybe this is not
really an issue to lose sleep over?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Matt,
Is this a standalone server or a cluster? have you recently upgraded to W2K3
SP2? We now see this when we patch or failover our clustered SQL2005 server.
Chris
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:8AEE2C89-5A8C-4005-A241-862CAE01CE38@.microsoft.com...[vbcol=seagreen]
>I ment to say "I end up with a Trace error in the log as soon as the server
> goes
> OFFLINE and the logging stops".
> Just to be clear, I see the Failed Audit login message in the SQL log only
> when I start the start the server. It doesnn't continuely happen,
> therefore
> the only time I can try and trace the cause of the issue is as the server
> starts up
> "Matt" wrote:
>

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>

HI all ,
i am getting the following error message. <Message>Login failed for user
'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
my database is on server1 and report database on server2. I am getting this
error when rendering. I am using default credentials
Please Help me.
<detail>
<ErrorCode
xmlns="http://www.microsoft.com/sql/reportingservices">rsProc
essingAborted</ErrorCode>
<HttpStatus
xmlns="http://www.microsoft.com/sql/reportingservices">400</
HttpStatus>
<Message xmlns="http://www.microsoft.com/sql/reportingservices">An
error
has occurred during report processing.</Message>
<HelpLink
xmlns="http://www.microsoft.com/sql/reportingservices">http://
go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Dia
gnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&
amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</H
elpLink>
<ProductName
xmlns="http://www.microsoft.com/sql/reportingservices">Micr
osoft SQL Server Reporting Services</ProductName>
<ProductVersion
xmlns="http://www.microsoft.com/sql/reportingservices">8
.00.743.00</ProductVersion>
<ProductLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">
1033</ProductLocaleId>
<OperatingSystem
xmlns="http://www.microsoft.com/sql/reportingservices">
OsIndependent</OperatingSystem>
<CountryLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">
1033</CountryLocaleId>
<MoreInformation
xmlns="http://www.microsoft.com/sql/reportingservices">
<Source>Microsoft.ReportingServices.Processing</Source>
<Message msrs:ErrorCode="rsProcessingAborted"
msrs:HelpLink="http://go
.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagn
ostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&am
p;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00" xml
ns:msrs="http://www.microsoft.com/sql/reportingservices">An error has
occurred d
uring report processing.</Message>
<MoreInformation>
<Source>Microsoft.ReportingServices.Processing</Source>
<Message msrs:ErrorCode="rsErrorOpeningConnection"
msrs:HelpLink="ht
tp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingService
s.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorOpeningC
onnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdV
er=8.00" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Cannot
crea
te a connection to data source 'HMIS_Interface'.</Message>
<MoreInformation>
<Source>.Net SqlClient Data Provider</Source>
<Message>Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.</Me
ssage>
</MoreInformation>
</MoreInformation>
</MoreInformation>
<Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />
</detail>It looks like you are using Anoymous Authentication on your IIS Virtual
Directory. You can change the authentication to Basic or NTLM to pass in
user credentials.
--
| Thread-Topic: Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.</Message>
| thread-index: AcS8DqlvxtkWDhbwR8+PqdeSKelavg==| X-WBNR-Posting-Host: 202.56.199.242
| From: "=?Utf-8?B?bW9oYW4=?=" <mohan@.discussions.microsoft.com>
| Subject: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
| Date: Wed, 27 Oct 2004 03:21:03 -0700
| Lines: 134
| Message-ID: <CBEB19F8-B211-468C-B282-BD1ECC6087E9@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33264
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| HI all ,
| i am getting the following error message. <Message>Login failed for user
| 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
|
| my database is on server1 and report database on server2. I am getting
this
| error when rendering. I am using default credentials
| Please Help me.
|
|
|
| <detail>
| <ErrorCode
| xmlns="rsProc">http://www.microsoft.com/sql/reportingservices">rsProc
| essingAborted</ErrorCode>
| <HttpStatus
| xmlns="400</">http://www.microsoft.com/sql/reportingservices">400</
| HttpStatus>
| <Message
xmlns="An">http://www.microsoft.com/sql/reportingservices">An
| error
| has occurred during report processing.</Message>
| <HelpLink
| xmlns="http://">http://www.microsoft.com/sql/reportingservices">http://
|
go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Dia
|
gnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&
|
amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</H
| elpLink>
| <ProductName
| xmlns="Micr">http://www.microsoft.com/sql/reportingservices">Micr
| osoft SQL Server Reporting Services</ProductName>
| <ProductVersion
| xmlns="8">http://www.microsoft.com/sql/reportingservices">8
| .00.743.00</ProductVersion>
| <ProductLocaleId
| xmlns="">http://www.microsoft.com/sql/reportingservices">
| 1033</ProductLocaleId>
| <OperatingSystem
| xmlns="">http://www.microsoft.com/sql/reportingservices">
| OsIndependent</OperatingSystem>
| <CountryLocaleId
| xmlns="">http://www.microsoft.com/sql/reportingservices">
| 1033</CountryLocaleId>
| <MoreInformation
| xmlns="">http://www.microsoft.com/sql/reportingservices">
|
| <Source>Microsoft.ReportingServices.Processing</Source>
| <Message msrs:ErrorCode="rsProcessingAborted"
| msrs:HelpLink="http://go
|
microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagn
|
ostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&am
| p;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
xml
| ns:msrs="An">http://www.microsoft.com/sql/reportingservices">An error has
| occurred d
| uring report processing.</Message>
| <MoreInformation>
| <Source>Microsoft.ReportingServices.Processing</Source>
| <Message msrs:ErrorCode="rsErrorOpeningConnection"
| msrs:HelpLink="ht
|
tp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingService
|
s.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorOpeningC
| onnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdV
| er=8.00"
xmlns:msrs="Cannot">http://www.microsoft.com/sql/reportingservices">Cannot
| crea
| te a connection to data source 'HMIS_Interface'.</Message>
| <MoreInformation>
| <Source>.Net SqlClient Data Provider</Source>
| <Message>Login failed for user 'NT AUTHORITY\ANONYMOUS
| LOGON'.</Me
| ssage>
| </MoreInformation>
| </MoreInformation>
| </MoreInformation>
| <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"
/>
| </detail>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||I am having the same problem as mohan.
I do not have Anonymous Authentication on the IIS Virtual Directory enabled.
Both the Reports and ReportServer folders are using windows integrated
security.
I have done a fresh install of Windows 2000 Server along with SQL Server
2000 Standard Editon and SQL Reporting Services Standard Edition. I have
also updated these to the relevant service packs.
From what I can gather the report server has no problems recognising
different domain users (with my folders enabled - a new folder is created for
the user that just navigated to the report server). Where it is having the
problem is then sending on those credentials to a SQL database on a different
server always get the 'NT AUTHORITY\ANONYMOUS LOGON' error message.
""Brad Syputa - MS"" wrote:
> It looks like you are using Anoymous Authentication on your IIS Virtual
> Directory. You can change the authentication to Basic or NTLM to pass in
> user credentials.
> --
> | Thread-Topic: Login failed for user 'NT AUTHORITY\ANONYMOUS
> LOGON'.</Message>
> | thread-index: AcS8DqlvxtkWDhbwR8+PqdeSKelavg==> | X-WBNR-Posting-Host: 202.56.199.242
> | From: "=?Utf-8?B?bW9oYW4=?=" <mohan@.discussions.microsoft.com>
> | Subject: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
> | Date: Wed, 27 Oct 2004 03:21:03 -0700
> | Lines: 134
> | Message-ID: <CBEB19F8-B211-468C-B282-BD1ECC6087E9@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33264
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | HI all ,
> | i am getting the following error message. <Message>Login failed for user
> | 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
> |
> | my database is on server1 and report database on server2. I am getting
> this
> | error when rendering. I am using default credentials
> | Please Help me.
> |
> |
> |
> | <detail>
> | <ErrorCode
> | xmlns="rsProc">http://www.microsoft.com/sql/reportingservices">rsProc
> | essingAborted</ErrorCode>
> | <HttpStatus
> | xmlns="400</">http://www.microsoft.com/sql/reportingservices">400</
> | HttpStatus>
> | <Message
> xmlns="An">http://www.microsoft.com/sql/reportingservices">An
> | error
> | has occurred during report processing.</Message>
> | <HelpLink
> | xmlns="http://">http://www.microsoft.com/sql/reportingservices">http://
> |
> go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Dia
> |
> gnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&
> |
> amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</H
> | elpLink>
> | <ProductName
> | xmlns="Micr">http://www.microsoft.com/sql/reportingservices">Micr
> | osoft SQL Server Reporting Services</ProductName>
> | <ProductVersion
> | xmlns="8">http://www.microsoft.com/sql/reportingservices">8
> | .00.743.00</ProductVersion>
> | <ProductLocaleId
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> | 1033</ProductLocaleId>
> | <OperatingSystem
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> | OsIndependent</OperatingSystem>
> | <CountryLocaleId
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> | 1033</CountryLocaleId>
> | <MoreInformation
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> |
> | <Source>Microsoft.ReportingServices.Processing</Source>
> | <Message msrs:ErrorCode="rsProcessingAborted"
> | msrs:HelpLink="http://go
> |
> .microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagn
> |
> ostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&am
> | p;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
> xml
> | ns:msrs="An">http://www.microsoft.com/sql/reportingservices">An error has
> | occurred d
> | uring report processing.</Message>
> | <MoreInformation>
> | <Source>Microsoft.ReportingServices.Processing</Source>
> | <Message msrs:ErrorCode="rsErrorOpeningConnection"
> | msrs:HelpLink="ht
> |
> tp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingService
> |
> s.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorOpeningC
> | onnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdV
> | er=8.00"
> xmlns:msrs="Cannot">http://www.microsoft.com/sql/reportingservices">Cannot
> | crea
> | te a connection to data source 'HMIS_Interface'.</Message>
> | <MoreInformation>
> | <Source>.Net SqlClient Data Provider</Source>
> | <Message>Login failed for user 'NT AUTHORITY\ANONYMOUS
> | LOGON'.</Me
> | ssage>
> | </MoreInformation>
> | </MoreInformation>
> | </MoreInformation>
> | <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"
> />
> | </detail>
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
>

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

When I try to open my report in reporting services I get an error:
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'Flyers'.
(rsErrorOpeningConnection) Get Online Help
a.. Cannot open database requested in login 'CRMElements_RealEstate'.
Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
----
My report is set to use NT Authentication and Works OK in VS.Net report
designer.
Reporting services is installed on a web server separate from SQL Server.
The SQL Server house both the reporting services databases and the database
I am trying to report against. Both server or Windows 2003. The SQL server
is also my AD controller.
I can get the report to work if I change the report to use SQL Server login
/ password, but then I have to supply it each time.
If I go into the report properties, data sources and try to change the way
the report authenticates I get an error:
Object reference not set to an instance of an object.
when I click apply.
The only way I can change the settings is to change them in report designer
and re-upload my report file. I am uploading the file through report
manager. I do not have any data sources configures on the report server. I
am embedding this information in the report (I think that is how it works).
IIS Security is set as Integrated Windows Authentication.
Any help as to where to look or how to troubleshoot is appreciated.I think it doesn't work because you need to activate delegation, which i am
not knowledgeable about.
As far as i know, windows credential are never retransmitted from one server
to another. Here is a little attempt at explaining what i mean
client(ie) -> reporting services(iis) -> SQL DB (sql server)
suppose these 3 elements are on distinct servers. ie will transmit your
windows authentication to IIS, but IIS will not push it to the sql server.
For this to work, i've read you need to activate delegation in active
directory, but i am not knowledgeable enough to help you on this topic. So
right now, we're just specifying sql server accounts in our report data
sources.
You can use shared data sources to make life easier.
Hope this helps
"Joe" wrote:
> When I try to open my report in reporting services I get an error:
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'Flyers'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> ----
> My report is set to use NT Authentication and Works OK in VS.Net report
> designer.
> Reporting services is installed on a web server separate from SQL Server.
> The SQL Server house both the reporting services databases and the database
> I am trying to report against. Both server or Windows 2003. The SQL server
> is also my AD controller.
> I can get the report to work if I change the report to use SQL Server login
> / password, but then I have to supply it each time.
> If I go into the report properties, data sources and try to change the way
> the report authenticates I get an error:
> Object reference not set to an instance of an object.
> when I click apply.
> The only way I can change the settings is to change them in report designer
> and re-upload my report file. I am uploading the file through report
> manager. I do not have any data sources configures on the report server. I
> am embedding this information in the report (I think that is how it works).
> IIS Security is set as Integrated Windows Authentication.
> Any help as to where to look or how to troubleshoot is appreciated.
>
>
>|||Do a google search for the "double hop problem."
You need to enable Server Principal Names (SPNs) which can be a daunting
task to setup properly.
-Joel
"Joe" <noemail@.noemail.com> wrote in message
news:OpPELIUaFHA.2664@.TK2MSFTNGP15.phx.gbl...
> When I try to open my report in reporting services I get an error:
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'Flyers'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> ----
> My report is set to use NT Authentication and Works OK in VS.Net report
> designer.
> Reporting services is installed on a web server separate from SQL Server.
> The SQL Server house both the reporting services databases and the
> database I am trying to report against. Both server or Windows 2003. The
> SQL server is also my AD controller.
> I can get the report to work if I change the report to use SQL Server
> login / password, but then I have to supply it each time.
> If I go into the report properties, data sources and try to change the way
> the report authenticates I get an error:
> Object reference not set to an instance of an object.
> when I click apply.
> The only way I can change the settings is to change them in report
> designer and re-upload my report file. I am uploading the file through
> report manager. I do not have any data sources configures on the report
> server. I am embedding this information in the report (I think that is
> how it works).
> IIS Security is set as Integrated Windows Authentication.
> Any help as to where to look or how to troubleshoot is appreciated.
>
>
>|||Please excuse my ignorance, but could you specify exactly how you do the
"specifying sql server accounts in our report data sources"
Is it on the "Credentials stored securely in the report server" on the report?
How and where would you setup the user? In Report Server?
or in SQL server. It's been a while since I setup users on a database
in SQL 6.5 or 7.0... can you just use sa '
I've got what you described in your post of 2 connections
between 3 computers and connot get it to work.
Big Thanks for the Help!
--
Robert Hansen
"/dev/null" wrote:
> I think it doesn't work because you need to activate delegation, which i am
> not knowledgeable about.
> As far as i know, windows credential are never retransmitted from one server
> to another. Here is a little attempt at explaining what i mean
> client(ie) -> reporting services(iis) -> SQL DB (sql server)
> suppose these 3 elements are on distinct servers. ie will transmit your
> windows authentication to IIS, but IIS will not push it to the sql server.
> For this to work, i've read you need to activate delegation in active
> directory, but i am not knowledgeable enough to help you on this topic. So
> right now, we're just specifying sql server accounts in our report data
> sources.
> You can use shared data sources to make life easier.
> Hope this helps
> "Joe" wrote:
> > When I try to open my report in reporting services I get an error:
> > a.. An error has occurred during report processing. (rsProcessingAborted)
> > Get Online Help
> > a.. Cannot create a connection to data source 'Flyers'.
> > (rsErrorOpeningConnection) Get Online Help
> > a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> > Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> >
> > ----
> >
> > My report is set to use NT Authentication and Works OK in VS.Net report
> > designer.
> >
> > Reporting services is installed on a web server separate from SQL Server.
> > The SQL Server house both the reporting services databases and the database
> > I am trying to report against. Both server or Windows 2003. The SQL server
> > is also my AD controller.
> >
> > I can get the report to work if I change the report to use SQL Server login
> > / password, but then I have to supply it each time.
> >
> > If I go into the report properties, data sources and try to change the way
> > the report authenticates I get an error:
> > Object reference not set to an instance of an object.
> > when I click apply.
> >
> > The only way I can change the settings is to change them in report designer
> > and re-upload my report file. I am uploading the file through report
> > manager. I do not have any data sources configures on the report server. I
> > am embedding this information in the report (I think that is how it works).
> >
> > IIS Security is set as Integrated Windows Authentication.
> >
> > Any help as to where to look or how to troubleshoot is appreciated.
> >
> >
> >
> >
> >
> >|||Well with some resource digging... I've gotten my self up
out of the ignoreance hole I was in. I figured out how to
setup a SQL User Account, under Security/Logins "New Login"
and then in Reporting Services for each report under Properties-
Data Sources I checked "Credentials stored securely in the report server"
and entered <new> UserName and Password.
and it worked.!!!!! Yeah ME!!!!
I also changed it in Report Designer on on the Data Source Credentials Tab,
Saved and redeployed, but that didn't seem to do it. Looks like it has to
be done
in Report Server.
Thanks!!! Bob
To
--
Robert Hansen
"Bob Hansen" wrote:
> Please excuse my ignorance, but could you specify exactly how you do the
> "specifying sql server accounts in our report data sources"
> Is it on the "Credentials stored securely in the report server" on the report?
> How and where would you setup the user? In Report Server?
> or in SQL server. It's been a while since I setup users on a database
> in SQL 6.5 or 7.0... can you just use sa '
> I've got what you described in your post of 2 connections
> between 3 computers and connot get it to work.
> Big Thanks for the Help!
> --
> Robert Hansen
>
> "/dev/null" wrote:
> > I think it doesn't work because you need to activate delegation, which i am
> > not knowledgeable about.
> >
> > As far as i know, windows credential are never retransmitted from one server
> > to another. Here is a little attempt at explaining what i mean
> >
> > client(ie) -> reporting services(iis) -> SQL DB (sql server)
> >
> > suppose these 3 elements are on distinct servers. ie will transmit your
> > windows authentication to IIS, but IIS will not push it to the sql server.
> > For this to work, i've read you need to activate delegation in active
> > directory, but i am not knowledgeable enough to help you on this topic. So
> > right now, we're just specifying sql server accounts in our report data
> > sources.
> >
> > You can use shared data sources to make life easier.
> >
> > Hope this helps
> >
> > "Joe" wrote:
> >
> > > When I try to open my report in reporting services I get an error:
> > > a.. An error has occurred during report processing. (rsProcessingAborted)
> > > Get Online Help
> > > a.. Cannot create a connection to data source 'Flyers'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> > > Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> > >
> > > ----
> > >
> > > My report is set to use NT Authentication and Works OK in VS.Net report
> > > designer.
> > >
> > > Reporting services is installed on a web server separate from SQL Server.
> > > The SQL Server house both the reporting services databases and the database
> > > I am trying to report against. Both server or Windows 2003. The SQL server
> > > is also my AD controller.
> > >
> > > I can get the report to work if I change the report to use SQL Server login
> > > / password, but then I have to supply it each time.
> > >
> > > If I go into the report properties, data sources and try to change the way
> > > the report authenticates I get an error:
> > > Object reference not set to an instance of an object.
> > > when I click apply.
> > >
> > > The only way I can change the settings is to change them in report designer
> > > and re-upload my report file. I am uploading the file through report
> > > manager. I do not have any data sources configures on the report server. I
> > > am embedding this information in the report (I think that is how it works).
> > >
> > > IIS Security is set as Integrated Windows Authentication.
> > >
> > > Any help as to where to look or how to troubleshoot is appreciated.
> > >
> > >
> > >
> > >
> > >
> > >

Login failed for user NT AUTHORITY\ANONYMOUS LOGON.

get the following error when a user tries to logon from work station.
The website is hosted on IIS on the same server as sql server 2005
website is asp.net 2.0

SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734883
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehaviorrunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)+1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionString connectionOptions, Object providerInfo,String newPassword, SqlConnection owningObject, BooleanredirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(Stringusername, Boolean updateLastLoginActivityDate, Int32& status,String& password, Int32& passwordFormat, String&passwordSalt, Int32& failedPasswordAttemptCount, Int32&failedPasswordAnswerAttemptCount, Boolean& isApproved,DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(Stringusername, String password, Boolean updateLastLoginActivityDate, BooleanfailIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Hi,

i think you have allowed ANONYMOUS Access to your website in the IIS Admin. The ASP.NET worker process using the ANONYMOUS user account and the process-user will connect to your SQL Database. Is that realy what you want? I think you have a special sql user account, or? So you must impersonate your asp.net worker process. See this MSDN Article for more information about impersonation:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconImpersonation.asp

Regards
Marc André

|||

thanks for the reply, I want to be able to use the NetworkService account.

"In Internet Information Services (IIS) 6, the default identity is the NetworkService account."

How do I go about setting this up so the website and sql server 2005 allow the NetworkService user?

|||

ghw123:

thanks for the reply, I want to be able to use the NetworkService account.

"In Internet Information Services (IIS) 6, the default identity is the NetworkService account."

How do I go about setting this up so the website and sql server 2005 allow the NetworkService user?

Try the link below for how to use T-SQL to grant the Networkservice account permissions in SQL Server to run Asp.net. Hope this helps.

http://www.thedatafarm.com/blog/PermaLink.aspx?guid=2bd8f8c8-1b16-46ee-91f6-d8d3080e562b

|||

Thanks for the reply I tried the

sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' on the master database

but no luck still get the same error msg.

|||

ghw123:

Thanks for the reply I tried the

sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' on the master database

but no luck still get the same error msg.

The first thing to do is verify in the Master database that the account was created and if yes then your only option is to use basic autthentication which could leave your application passwords in plain text. Hope this helps.

|||

Add the aspnet account to the SQL server 2005

Please have a look at thishttp://ambarishganguly.blogspot.com/2007/01/aspnet-account-and-sql-server.html. .

To add a user in SQL Server 2005, you can follow the following steps as outlined in

http://ambarishganguly.blogspot.com/2006/12/sql-server-2005-adding-user.html

In this way, you can easily use the website along with SQL Server 2005

Thanks

Ambarish.

|||

thanks for the replies,

this site was originally on a different server. I moved both the site and the database to the new server.

The problem was in one of the connection strings used on the site.
I had changed all but one of the strings to reflect the change of server name.
Once this string was changed as well then everything worked ok.

Login failed for user NT AUTHORITY\ANONYMOUS LOGON (but user.identity.name is correct)

I need help. The security principal is the correct Domain\User, but the error message says I am not authenticated.

So here is my error Message:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Me.User.Identity.Name=CompanyDomain\Ryan; System.Security.Principal.WindowsIdentity.GetCurrent=CompanyDomain\Ryan; HttpContext.Current.User.Identity.Name=Company\Ryan

Generated by:

Dim

secPrincAs System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCurrentMe.lblError.Text = ex.Message & vbCrLf & vbCrLf &"Me.User.Identity.Name=" &Me.User.Identity.Name &"; System.Security.Principal.WindowsIdentity.GetCurrent=" & secPrinc.Name &"; HttpContext.Current.User.Identity.Name=" & HttpContext.Current.User.Identity.Name

Here is the Connection String:

Private ConnStringAsString ="Server=10.144.162.111;Database=DNS;Trusted_Connection=True"

IIS has 4 websites hosted on it. The parent level allows anonymous with windows auth off, but the website level has anonymous off with widnows auth and digest.

In IIS, is there a problem with having the parent level anonymous and website level windows auth?

I think i found the error. My web server is a different machine from my data server. When my browser connects to the webserver it uses impersonation and delegation, but the web server is not trusted for delegation on the active directory. So when the webserver tries to pass the credentials to the data server the domain controller will not allow it.

Working on a 3 tier setup here...

Ryan

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I get the following error message when I select a report:

An error has occurred during report processing.

Cannot create a connection to data source 'PSS5'.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

My Data source is set to Windows Integrated Security when I get this error message. If I change my data source to be "Credential supplied by the user running the report", the report generates fine. I am running SQL 2005 SP2. I have SQL reporting services installed on different server than my database services. Both servers are W2K3 R2 x64.

My IIS website and virtual directories are set up for Integrated Windows Authentication. My IIS application pool is set up to use an AD service account. I have followed the step/procedures outlined at: http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerbdel.mspx

http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

but to no avail. I am sure that I am missing something, but I can't figure out what. I would like to use Integrated Authentication, any ideas?

You are using allow anonymous in IIS. This means that your ReportViewer control is not passing the users credentials to the report server. If you want to use "allow anonymous" you will need to pass valid credentials to the report server. This can be done in your code that calls the Report Viewer control/Report Server.|||

Hi,

see more information about passing credentials programmatically here:

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I don't think that the problem is related to ReportViewer or IIS configuration (Since the credantial information is passed to the datasource and denied). When u select Windows Intedrated Security for report options, the credantials of the user that initiates the Reporting Services at every start up (by default this user is: 'NT AUTHORITY\ANONYMOUS LOGON') are sent to the datasource (And if this user is not authorized in the target database you get the following error).

You can authorize the Reporting Services user in the target database ('NT AUTHORITY\ANONYMOUS LOGON' exists within your SQL Server Machines Users.

or

You can change the Reporting Services' user to a domain user that both computers can authanticate.

Administrative Tools -> Services. (Find 'SQL Server Reporting Services (MSSQLSERVER)' change user from LOG ON tab.)

I hope this helps.

|||Thanks for the replies, but they didn't seem to help. To clear up a few questions, this report was developed in Visual Studio 2005 and it works fine in it. The report renders ok if I launch in on the server, but not anywhere else. My Reporting Services' user is an AD account that both my servers can authenicate against, and this user does have access to the DB. My Website and virtual directories have "allow anonymous access" unchecked.|||I decided to try one more thing. I went into the web.config file and changed the <identity impersonate="false"/> and that fixed it for me. Thanks for all the replies.|||

Note:

The above fix will force IIS to use the Application pool account to connect to SQL on the remote server.

This is still not the permanent solution that I am looking for, I believe my problem is a kerberos issue at this point. Any tips/hints/suggestions on troubleshooting this problem would be helpful.

sql

Login failed for user NT AUTHORITY\ANONYMOUS LOGON

Hello everyone,

I am receiving the above error when using a workstation to connect to my webfiles.

I am using windows authentication (whcih I have selected as my only option on the IIS).
Impersonate is set to true in the webconfig file, with authentication set to Windows.

My connection string is: SQLConnection1 = "initial catalog=SIMS;data source=spacesql;integrated security=SSPI"

It runs no problem when I use the localhost.
It allows me to use other aspx pages that do not connect to the SQL server.
It only gives me this error when I am using a page that tries to connect to the SQL server.

The SQL files reside on a separate server to the IIS and I would like it to remain this way.

Can anyone help me wit this please

Thank you,

RebeccaOk, stupid question.

How is an SQL Server on Computer B supposed to authorize users according to a user account on computer A? Without domain, without using a domain account et al.

Answer: it can not.

An this is your problem.|||Hi,
I suggest you look for information on 'Accessing SQL Server using a Mapped Windows Domain Server'. That may have the solution you are looking for. Try msdn.microsoft.com, and look for this and other authentication and authorization info for web based applications.
Good luck with your project.|||Both computers are on a domain using a domain account et al.
I am not that stupid.

Login failed for user MCTSERVER01\ASPNET.

Hi,

Hope someone can help me to solve the error message.

I am using Visual Studio 2005 and MS SQL Server 2005. When I tried to run the aspx, I encountered the error listed below.

Server Error in '/webtime' Application.
------------------------

Login failed for user 'MCTSERVER01\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'MCTSERVER01\ASPNET'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Login failed for user 'MCTSERVER01\ASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734947
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, ...

Siew Hin

As the error message states, looks like the user does not have enough permissions. Check under the Database -> Security -> Logins and see what permissions the user has.sql

login failed for user error

This summary is not available. Please click here to view the post.

login failed for user error

This summary is not available. Please click here to view the post.

Login failed for user computername\ASPNET

Hi all,
I get the error message Login failed for user 'computername\ASPNET'
when trying to log to MSDE 2000 SP 3 with .NET application.
My computer is Windows 2000 + SP4 with latest security patches.
I have tried to set the permissions to the database I am connecting
(mydatabase) with script:
sp_grantlogin 'mycomputer\ASPNET'
go
use mydatabase
go
sp_grantdbaccess 'mycomputer\ASPNET'
go
sp_addrolemember 'db_owner', 'mycomputer\ASPNET'
go
Still the error comes.
Does anybody have ideas what to try next.
PS. Software reinstall has been tried (.NET framework 1.1, MSDE).
Regards
Jarmo
Hi,
Did you logged into your machine using 'mycomputer\ASPNET' ? If not login to
the machine using 'mycomputer\ASPNET' and try
connecting using OSQL and confirm.
Thanks
Hari
MCDBA
"jarmopy" <jarmo.pyorny@.luukku.com> wrote in message
news:5d70b654.0408152138.6ca4d0d8@.posting.google.c om...
> Hi all,
> I get the error message Login failed for user 'computername\ASPNET'
> when trying to log to MSDE 2000 SP 3 with .NET application.
> My computer is Windows 2000 + SP4 with latest security patches.
> I have tried to set the permissions to the database I am connecting
> (mydatabase) with script:
>
> sp_grantlogin 'mycomputer\ASPNET'
> go
> use mydatabase
> go
> sp_grantdbaccess 'mycomputer\ASPNET'
> go
> sp_addrolemember 'db_owner', 'mycomputer\ASPNET'
> go
> Still the error comes.
> Does anybody have ideas what to try next.
> PS. Software reinstall has been tried (.NET framework 1.1, MSDE).
> Regards
> Jarmo
|||Hi Hari,
Local policy does not allow to log in as aspnet:
"The local policy of this system does not permit you to logon interactively."
It is only permitted to log on as a batch job.
Regards
Jarmo
"Hari Prasad" wrote:

> Hi,
> Did you logged into your machine using 'mycomputer\ASPNET' ? If not login to
> the machine using 'mycomputer\ASPNET' and try
> connecting using OSQL and confirm.
> Thanks
> Hari
> MCDBA
>
|||Hi again,
I changed the policy to be able to log in.
When giving the command as mycomputer\aspnet user
osql -E -S mycomputer\myinstance
I get the same error message:
Login failed.
Regards
Jarmo
|||There is no need to log in as ASPNET account
Go to MSDN site and look in SQL SERVER 2000 SDK Documentation (it is valid
for MSDE)
There is explanation how to use ASP .NET applications with SQL Server
"jarmopy" <jarmo.pyorny@.luukku.com> wrote in message
news:5d70b654.0408152138.6ca4d0d8@.posting.google.c om...
> Hi all,
> I get the error message Login failed for user 'computername\ASPNET'
> when trying to log to MSDE 2000 SP 3 with .NET application.
> My computer is Windows 2000 + SP4 with latest security patches.
> I have tried to set the permissions to the database I am connecting
> (mydatabase) with script:
>
> sp_grantlogin 'mycomputer\ASPNET'
> go
> use mydatabase
> go
> sp_grantdbaccess 'mycomputer\ASPNET'
> go
> sp_addrolemember 'db_owner', 'mycomputer\ASPNET'
> go
> Still the error comes.
> Does anybody have ideas what to try next.
> PS. Software reinstall has been tried (.NET framework 1.1, MSDE).
> Regards
> Jarmo
|||Hi,
thanks for the answers.
This seems to be a problem only in one computer.
In other machines this is working OK.

Login failed for user ASPNET

Hello,
I am getting following error when I tried to connect to the database.

Login failed for user 'SHALINI\ASPNET'

I am new to this and don't know how to fix it. I am runningSQL Server Desktop engine 2000. I could connect through Server Explorer window, but not through ADO.NET
Here's my connection string:

sConnectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyStore;Data Source=SHALINI;Workstation ID=SHALINI"

I have IIS and SQL Server running on the same machine.
Please please help me.
Thanks in Advance

If you are just developing on your local machine, be sure the database has the proper permissions.
Also, you may want to try this conn string...

sql = "Initial Catalog=MyStore;Data Source=localhost;Integrated Security=SSPI;"
But once the database is moved to a production server, you would want to change the string to something like...

sql = "Server=isp.com;Database=MyStore;UID=****;PWD=****;"
But this sounds like a permission problem, one in sql server db and in the folder.
You may also want to check the permissions on you folder where you are developing the app, the one in wwwroot.

Hope this helps,
Zath

sql

login failed for user after moving app to web server

My app works fine in development server. After moving to web server, error occured as bellow. Can someone help me? I use vs 2005 and SQL server is windows authentication mode.

Login failed for user 'domain_name\REPORT$'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Login failed for user 'domain_name\REPORT$'.

Source Error:

Line 348:Line 349: If MyTable = Nothing ThenLine 350: MySQLDataAdapter.Fill(MyDataSet)Line 351: ElseLine 352: MySQLDataAdapter.Fill(MyDataSet, MyTable)

Hi,

Are you running your application (web server) on a windows 2003 server ? If yes then you have to add a login withdomain_name\<machine_name>$ and you have to grant access to the operative database to this login. This login weill be a windows account (domain not machine).

Hope it Helps!

Bhaskar!

Login failed for user 'abc'

When we get the error message stated in the subject , does it mean that the
password was incorrect ?
Trying to find out other possible reasons when you may get that message.
I do not believe one would get that message if the server is unavailable
right ? I believe the error in that case is more of a General Network Error
Please let me know
Thanks
> When we get the error message stated in the subject , does it mean that
the
> password was incorrect
Or Login's name. Or Authentication issue.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> When we get the error message stated in the subject , does it mean that
the
> password was incorrect ?
> Trying to find out other possible reasons when you may get that message.
> I do not believe one would get that message if the server is unavailable
> right ? I believe the error in that case is more of a General Network
Error
> Please let me know
> Thanks
>
|||what do u mean authentication issue ? Login name is right..
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
> the
> Or Login's name. Or Authentication issue.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> the
> Error
>
|||Hassan
You can set up an authenication to Windows ONLY or Mixed (Windows/SQL
Server). If you have Windows Only and try to connect by using a login who
does not exist or exists only in SQL Server you will get an error.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23LN%231L8hFHA.3912@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> what do u mean authentication issue ? Login name is right..
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
that[vbcol=seagreen]
that[vbcol=seagreen]
message.[vbcol=seagreen]
unavailable
>

Login failed for user 'abc'

When we get the error message stated in the subject , does it mean that the
password was incorrect ?
Trying to find out other possible reasons when you may get that message.
I do not believe one would get that message if the server is unavailable
right ? I believe the error in that case is more of a General Network Error
Please let me know
Thanks> When we get the error message stated in the subject , does it mean that
the
> password was incorrect
Or Login's name. Or Authentication issue.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> When we get the error message stated in the subject , does it mean that
the
> password was incorrect ?
> Trying to find out other possible reasons when you may get that message.
> I do not believe one would get that message if the server is unavailable
> right ? I believe the error in that case is more of a General Network
Error
> Please let me know
> Thanks
>|||what do u mean authentication issue ? Login name is right..
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
> > When we get the error message stated in the subject , does it mean that
> the
> > password was incorrect
> Or Login's name. Or Authentication issue.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> > When we get the error message stated in the subject , does it mean that
> the
> > password was incorrect ?
> >
> > Trying to find out other possible reasons when you may get that message.
> >
> > I do not believe one would get that message if the server is unavailable
> > right ? I believe the error in that case is more of a General Network
> Error
> >
> > Please let me know
> >
> > Thanks
> >
> >
>|||Hassan
You can set up an authenication to Windows ONLY or Mixed (Windows/SQL
Server). If you have Windows Only and try to connect by using a login who
does not exist or exists only in SQL Server you will get an error.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23LN%231L8hFHA.3912@.tk2msftngp13.phx.gbl...
> what do u mean authentication issue ? Login name is right..
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
> > > When we get the error message stated in the subject , does it mean
that
> > the
> > > password was incorrect
> >
> > Or Login's name. Or Authentication issue.
> >
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> > > When we get the error message stated in the subject , does it mean
that
> > the
> > > password was incorrect ?
> > >
> > > Trying to find out other possible reasons when you may get that
message.
> > >
> > > I do not believe one would get that message if the server is
unavailable
> > > right ? I believe the error in that case is more of a General Network
> > Error
> > >
> > > Please let me know
> > >
> > > Thanks
> > >
> > >
> >
> >
>

Login failed for user 'abc'

When we get the error message stated in the subject , does it mean that the
password was incorrect ?
Trying to find out other possible reasons when you may get that message.
I do not believe one would get that message if the server is unavailable
right ? I believe the error in that case is more of a General Network Error
Please let me know
Thanks> When we get the error message stated in the subject , does it mean that
the
> password was incorrect
Or Login's name. Or Authentication issue.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> When we get the error message stated in the subject , does it mean that
the
> password was incorrect ?
> Trying to find out other possible reasons when you may get that message.
> I do not believe one would get that message if the server is unavailable
> right ? I believe the error in that case is more of a General Network
Error
> Please let me know
> Thanks
>|||what do u mean authentication issue ? Login name is right..
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
> the
> Or Login's name. Or Authentication issue.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> the
> Error
>|||Hassan
You can set up an authenication to Windows ONLY or Mixed (Windows/SQL
Server). If you have Windows Only and try to connect by using a login who
does not exist or exists only in SQL Server you will get an error.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23LN%231L8hFHA.3912@.tk2msftngp13.phx.gbl...
> what do u mean authentication issue ? Login name is right..
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
that[vbcol=seagreen]
that[vbcol=seagreen]
message.[vbcol=seagreen]
unavailable[vbcol=seagreen]
>sql

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

Hi all,

Can someone explain it to me why I am getting the following error when I try to connect SQL server express with .NET 2.0?

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Here is my code and i am using windows authentication:

<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>

<%

Dim connAkaki As SqlConnection
Dim cmdSelectAuthers As SqlCommand
Dim dtrAuthers As SqlDataReader

connAkaki = New SqlConnection("Server=.\SQLEXPRESS;database=akaki")

connAkaki.Open()

cmdSelectAuthers = New SqlCommand("select Firstname from UserTableTest", connAkaki)
dtrAuthers= cmdSelectAuthers.ExecuteReader()

While dtrAuthers.Read()
Response.Write("<li>")
Response.Write(dtrAuthers("Firstname"))

End While

dtrAuthers.Close()
connAkaki.Close()

%>

Have you added the ASP.Net service account as a user in SQL Server? The error message is saying that the current user that is trying to connect has not been registered as a login in SQL Server.|||Hi there,

I was going to reply to your earlier post on the same/similar topic but since this one's newer I will post here.

The username with which the ASP.NET web application runs is different to the username you used to log into the computer with so chances are that the user is not defined in SQL Server's list of logins and so you get problems when using Windows Authentication.

A way around this is to use SQL Server authentication when trying to access your SQL Server. If you do this, your connection string will be:

connAkai = new System.Data.SqlClient.SqlConnection("Server=.\\NATHAN;database=Northwind; User ID=<SQL Server Login>; Password=<Password For Login>");

In a production system you would probably do more to secure that password (i.e. don't place it plain-text in the code) like putting it in the registry or some other methods but as an example I think it will do.

Hope that helps a bit, but sorry if it doesn't

|||

The SQL Server system by default is set to use only Windows Accounts and not SQL Server authentication, you can turn it on but I would leave it as is and use the windows accounts.

With ASP.Net generally the asp.net system by default runs under the Network Service account, to use it in the database you will need to make sure that the Network Service account has permissions for the database that you are using.

Another option is to make the asp.net application that you are working use a different account, this will help to secure your application. One way to do this is to reconfigure the application pool for the asp.net application that you have and make it run under the new account.

|||

Hi All!

How can add the ASP.Net service account as a user in SQL Server 2005?

|||

Huh? An MS Knowledge base article (http://support.microsoft.com/kb/555332) says just the opposite:

RESOLUTION

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

|||

Steps to change SQLExpress to "SQL Server and Windows Authentication Mode"

If you are lucky to have Microsoft SQL server Management Studio installed, then can browse to the SQL server Instance and right-click to bring up the Server Property. Server Property -> Security -> check "SQL Server and Windows Authentication Mode" option under "Server Authentication" section, and then restart the SQLExpress.

If you don't have Microsoft SQL server Management Studio installed, the if you are running on XP Professional, following SQL statements will do the same:

You have to first login to SQLExpress using osql utility.

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

GO

Hope that will help.

Derek

|||

Hey Glen, I have the same problem only I can't get sqlexpress to allow me to logon in SQL Server Auth mode. I can't even logon using my server (in my house). It will let me log on in Windows Authentication but not SQL Server Authentication? I have nothing on this machine and I reininstalled SQL Express twice. I am the sole admin .

All I want to do is create a blank database (which I did) and log onto it. I watched video 7 on microsoft and opened my fireall udp and added me as doadmin. I added sqlbrowser.exe,sqlserver.exe and udp port 1434 for sql via web in windows firewall. I also opened port 1434 on my hardlinksys router which only has port 80 and 1434 udp opened. (Public Webserver not hacked yet). Eventually, I added all permissions for my self (admin). I right clicked on my new database ("WebWizforums") IE not real database name. I added permissions under my user name and granted all permissions.It's only my user name in permissions noone else. I'll tighten ship perms after I see that she works...

Forum software is what I want to try http://www.webwizguide.com/webwizforums/kb/sql_server_install.asp seems real easy but I can't figure it out? MS Access I knew inside and out but now ...no more MSDE or MSJet on Longhorn OS.

Can anyone explain this simple task "Clearly?" Pretend I have no idea what I'm doing .... Thanks Gates for forcing my higher "edgeamycashun."

SQL Express for dummies!

Learning SQL is like filing tax returns...put it off to the last minute!

Mike C

|||

Ok, I triple checked everything then I rebooted....now it works? I guess start and stop will be learned as stupid sql tricks.

ok, I added the database tables with no problems however, I get this message when I log into the (ADMIN.asp) page

Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute

I searched for Common.asp and right clicked it. It has READ at min. So next is connection String?

I got yarn? but no connection.

Getting closer Watson.

Mike

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

Hi all,

Can someone explain it to me why I am getting the following error when I try to connect SQL server express with .NET 2.0?

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Here is my code and i am using windows authentication:

<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>

<%

Dim connAkaki As SqlConnection
Dim cmdSelectAuthers As SqlCommand
Dim dtrAuthers As SqlDataReader

connAkaki = New SqlConnection("Server=.\SQLEXPRESS;database=akaki")

connAkaki.Open()

cmdSelectAuthers = New SqlCommand("select Firstname from UserTableTest", connAkaki)
dtrAuthers= cmdSelectAuthers.ExecuteReader()

While dtrAuthers.Read()
Response.Write("<li>")
Response.Write(dtrAuthers("Firstname"))

End While

dtrAuthers.Close()
connAkaki.Close()

%>

Have you added the ASP.Net service account as a user in SQL Server? The error message is saying that the current user that is trying to connect has not been registered as a login in SQL Server.|||Hi there,

I was going to reply to your earlier post on the same/similar topic but since this one's newer I will post here.

The username with which the ASP.NET web application runs is different to the username you used to log into the computer with so chances are that the user is not defined in SQL Server's list of logins and so you get problems when using Windows Authentication.

A way around this is to use SQL Server authentication when trying to access your SQL Server. If you do this, your connection string will be:

connAkai = new System.Data.SqlClient.SqlConnection("Server=.\\NATHAN;database=Northwind; User ID=<SQL Server Login>; Password=<Password For Login>");

In a production system you would probably do more to secure that password (i.e. don't place it plain-text in the code) like putting it in the registry or some other methods but as an example I think it will do.

Hope that helps a bit, but sorry if it doesn't

|||

The SQL Server system by default is set to use only Windows Accounts and not SQL Server authentication, you can turn it on but I would leave it as is and use the windows accounts.

With ASP.Net generally the asp.net system by default runs under the Network Service account, to use it in the database you will need to make sure that the Network Service account has permissions for the database that you are using.

Another option is to make the asp.net application that you are working use a different account, this will help to secure your application. One way to do this is to reconfigure the application pool for the asp.net application that you have and make it run under the new account.

|||

Hi All!

How can add the ASP.Net service account as a user in SQL Server 2005?

|||

Huh? An MS Knowledge base article (http://support.microsoft.com/kb/555332) says just the opposite:

RESOLUTION

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

|||

Steps to change SQLExpress to "SQL Server and Windows Authentication Mode"

If you are lucky to have Microsoft SQL server Management Studio installed, then can browse to the SQL server Instance and right-click to bring up the Server Property. Server Property -> Security -> check "SQL Server and Windows Authentication Mode" option under "Server Authentication" section, and then restart the SQLExpress.

If you don't have Microsoft SQL server Management Studio installed, the if you are running on XP Professional, following SQL statements will do the same:

You have to first login to SQLExpress using osql utility.

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

GO

Hope that will help.

Derek

|||

Hey Glen, I have the same problem only I can't get sqlexpress to allow me to logon in SQL Server Auth mode. I can't even logon using my server (in my house). It will let me log on in Windows Authentication but not SQL Server Authentication? I have nothing on this machine and I reininstalled SQL Express twice. I am the sole admin .

All I want to do is create a blank database (which I did) and log onto it. I watched video 7 on microsoft and opened my fireall udp and added me as doadmin. I added sqlbrowser.exe,sqlserver.exe and udp port 1434 for sql via web in windows firewall. I also opened port 1434 on my hardlinksys router which only has port 80 and 1434 udp opened. (Public Webserver not hacked yet). Eventually, I added all permissions for my self (admin). I right clicked on my new database ("WebWizforums") IE not real database name. I added permissions under my user name and granted all permissions.It's only my user name in permissions noone else. I'll tighten ship perms after I see that she works...

Forum software is what I want to try http://www.webwizguide.com/webwizforums/kb/sql_server_install.asp seems real easy but I can't figure it out? MS Access I knew inside and out but now ...no more MSDE or MSJet on Longhorn OS.

Can anyone explain this simple task "Clearly?" Pretend I have no idea what I'm doing .... Thanks Gates for forcing my higher "edgeamycashun."

SQL Express for dummies!

Learning SQL is like filing tax returns...put it off to the last minute!

Mike C

|||

Ok, I triple checked everything then I rebooted....now it works? I guess start and stop will be learned as stupid sql tricks.

ok, I added the database tables with no problems however, I get this message when I log into the (ADMIN.asp) page

Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute

I searched for Common.asp and right clicked it. It has READ at min. So next is connection String?

I got yarn? but no connection.

Getting closer Watson.

Mike

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

Hi all,

Can someone explain it to me why I am getting the following error when I try to connect SQL server express with .NET 2.0?

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Here is my code and i am using windows authentication:

<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>

<%

Dim connAkaki As SqlConnection
Dim cmdSelectAuthers As SqlCommand
Dim dtrAuthers As SqlDataReader

connAkaki = New SqlConnection("Server=.\SQLEXPRESS;database=akaki")

connAkaki.Open()

cmdSelectAuthers = New SqlCommand("select Firstname from UserTableTest", connAkaki)
dtrAuthers= cmdSelectAuthers.ExecuteReader()

While dtrAuthers.Read()
Response.Write("<li>")
Response.Write(dtrAuthers("Firstname"))

End While

dtrAuthers.Close()
connAkaki.Close()

%>

Have you added the ASP.Net service account as a user in SQL Server? The error message is saying that the current user that is trying to connect has not been registered as a login in SQL Server.|||Hi there,

I was going to reply to your earlier post on the same/similar topic but since this one's newer I will post here.

The username with which the ASP.NET web application runs is different to the username you used to log into the computer with so chances are that the user is not defined in SQL Server's list of logins and so you get problems when using Windows Authentication.

A way around this is to use SQL Server authentication when trying to access your SQL Server. If you do this, your connection string will be:

connAkai = new System.Data.SqlClient.SqlConnection("Server=.\\NATHAN;database=Northwind; User ID=<SQL Server Login>; Password=<Password For Login>");

In a production system you would probably do more to secure that password (i.e. don't place it plain-text in the code) like putting it in the registry or some other methods but as an example I think it will do.

Hope that helps a bit, but sorry if it doesn't

|||

The SQL Server system by default is set to use only Windows Accounts and not SQL Server authentication, you can turn it on but I would leave it as is and use the windows accounts.

With ASP.Net generally the asp.net system by default runs under the Network Service account, to use it in the database you will need to make sure that the Network Service account has permissions for the database that you are using.

Another option is to make the asp.net application that you are working use a different account, this will help to secure your application. One way to do this is to reconfigure the application pool for the asp.net application that you have and make it run under the new account.

|||

Hi All!

How can add the ASP.Net service account as a user in SQL Server 2005?

|||

Huh? An MS Knowledge base article (http://support.microsoft.com/kb/555332) says just the opposite:

RESOLUTION

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

|||

Steps to change SQLExpress to "SQL Server and Windows Authentication Mode"

If you are lucky to have Microsoft SQL server Management Studio installed, then can browse to the SQL server Instance and right-click to bring up the Server Property. Server Property -> Security -> check "SQL Server and Windows Authentication Mode" option under "Server Authentication" section, and then restart the SQLExpress.

If you don't have Microsoft SQL server Management Studio installed, the if you are running on XP Professional, following SQL statements will do the same:

You have to first login to SQLExpress using osql utility.

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

GO

Hope that will help.

Derek

|||

Hey Glen, I have the same problem only I can't get sqlexpress to allow me to logon in SQL Server Auth mode. I can't even logon using my server (in my house). It will let me log on in Windows Authentication but not SQL Server Authentication? I have nothing on this machine and I reininstalled SQL Express twice. I am the sole admin .

All I want to do is create a blank database (which I did) and log onto it. I watched video 7 on microsoft and opened my fireall udp and added me as doadmin. I added sqlbrowser.exe,sqlserver.exe and udp port 1434 for sql via web in windows firewall. I also opened port 1434 on my hardlinksys router which only has port 80 and 1434 udp opened. (Public Webserver not hacked yet). Eventually, I added all permissions for my self (admin). I right clicked on my new database ("WebWizforums") IE not real database name. I added permissions under my user name and granted all permissions.It's only my user name in permissions noone else. I'll tighten ship perms after I see that she works...

Forum software is what I want to try http://www.webwizguide.com/webwizforums/kb/sql_server_install.asp seems real easy but I can't figure it out? MS Access I knew inside and out but now ...no more MSDE or MSJet on Longhorn OS.

Can anyone explain this simple task "Clearly?" Pretend I have no idea what I'm doing .... Thanks Gates for forcing my higher "edgeamycashun."

SQL Express for dummies!

Learning SQL is like filing tax returns...put it off to the last minute!

Mike C

|||

Ok, I triple checked everything then I rebooted....now it works? I guess start and stop will be learned as stupid sql tricks.

ok, I added the database tables with no problems however, I get this message when I log into the (ADMIN.asp) page

Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute

I searched for Common.asp and right clicked it. It has READ at min. So next is connection String?

I got yarn? but no connection.

Getting closer Watson.

Mike