"The request failed with HTTP status 401: Unauthorized."

Hi,
I'm having a few problems with getting SQL RS running and wondered
whether anyone could give me some help.
I have just installed RS and have never got into the Report Manager
yet. I think it is basically an IIS permissions problem as I am
getting a page that says "The request failed with HTTP status 401:
Unauthorized." whenever I try to get to
http://reporting.[domain].com/Reports, even if I add myself to the
domain Administrators group. I have all of the IIS settings as they
are specified in documentation.
My setup: Reporting Services SP2, IIS6, Windows 2003 Server, SQL Server
2000, installed on a non-default website following instructions on
SQLJunkies.com by Trent Miesner(although I'm pretty sure this isn't the
problem).
Thanks in advance,
SamJust check if this helps
http://support.microsoft.com/kb/896861/en-us
Sam wrote:
>Hi,
>I'm having a few problems with getting SQL RS running and wondered
>whether anyone could give me some help.
>I have just installed RS and have never got into the Report Manager
>yet. I think it is basically an IIS permissions problem as I am
>getting a page that says "The request failed with HTTP status 401:
>Unauthorized." whenever I try to get to
>http://reporting.[domain].com/Reports, even if I add myself to the
>domain Administrators group. I have all of the IIS settings as they
>are specified in documentation.
>My setup: Reporting Services SP2, IIS6, Windows 2003 Server, SQL Server
>2000, installed on a non-default website following instructions on
>SQLJunkies.com by Trent Miesner(although I'm pretty sure this isn't the
>problem).
>Thanks in advance,
>Sam
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1|||As a few others have mentioned, the article(method 1) did fix my problem. I
had everything working but started getting this error when I required SSL in
the RS configuration/report server virtual directory configuration.
http://support.microsoft.com/kb/896861 I rebooted after doing it.
I'm using SQL2005 SP1 on Win2k3 SP1.
--Forrest
"BALAJI K via SQLMonster.com" wrote:
> Just check if this helps
> http://support.microsoft.com/kb/896861/en-us
>
>
> Sam wrote:
> >Hi,
> >
> >I'm having a few problems with getting SQL RS running and wondered
> >whether anyone could give me some help.
> >
> >I have just installed RS and have never got into the Report Manager
> >yet. I think it is basically an IIS permissions problem as I am
> >getting a page that says "The request failed with HTTP status 401:
> >Unauthorized." whenever I try to get to
> >http://reporting.[domain].com/Reports, even if I add myself to the
> >domain Administrators group. I have all of the IIS settings as they
> >are specified in documentation.
> >
> >My setup: Reporting Services SP2, IIS6, Windows 2003 Server, SQL Server
> >2000, installed on a non-default website following instructions on
> >SQLJunkies.com by Trent Miesner(although I'm pretty sure this isn't the
> >problem).
> >
> >Thanks in advance,
> >
> >Sam
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200602/1
>

"SQLServerAgent service hung on starting"

Since I installed sp4 for sql7 on 3 NT-machines last week, I get this message from Service Control Manager on every reboot of those PC's. After checking in the NT EventViewer, the SQLServerAgent service is really started but about 15-20 seconds after the error message.

EventID 7022
SERVICE CONTROL MANAGER
"SQLServerAgent service hung on starting"

Any idea how to solve this or what causes this?Take a look at your SQL Error log. SQL Server Agent will not be able to start unless the error log shows 'Recovery Complete'.|||Check your odbc administrator -> tracing -> check to see if it is enabled (if it is, stop the tracing).|||Thanks for your replies. Problem solved, the error message was caused because I also disabled the Messenger service (for security reasons). Now I enabled it again & the SQGAgent Service starts on reboot without the error warning. I still wonder why because I don't like leaving the Messenger service running.

"SQL Server does not exist or access denied." after installing XP SP2

Hi!

I just installed Windows XP Service Pack 2 on my pc and I cannot make my asp.net applications access any database any more.

I tried starting the application up from the debugger in vs.net, but I got the same behaviour: I can open the login page but as soon as the application tries to connect to SQLServer I get the "SQL Server does not exist or access denied." error message.

I'm trying to connect with trusted_connection.

Can you guys help me out?Try this Microsoft KB article:

http://support.microsoft.com/default.aspx?kbid=839269|||Hi TechMickey,

Did you find a solution to the problem? As you remember I have the same problem and it is still not working.|||Hi bws,

no, I just removed sp2 :-(|||So you took the drastic step. I disabled the firewall but without improvement. I will do like you, get rid of the whole sp2-thing. until I see a solution.

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
Kapila
Where is the Server Explorer installed? Is it on a different machine or
different network? Based on the error message, it looks like the Server
Explorer is unable to find your SQL Server on the network. A network issue
is more likey to be the case. Can you ping the SQL Server computer from the
Server Explorer box?
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila
|||The server explorer is installed on the same system. I am not on a network.
The services are running.
Thanks
Kapila
"Narayana Vyas Kondreddi" wrote:

> Where is the Server Explorer installed? Is it on a different machine or
> different network? Based on the error message, it looks like the Server
> Explorer is unable to find your SQL Server on the network. A network issue
> is more likey to be the case. Can you ping the SQL Server computer from the
> Server Explorer box?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> solve
>
>

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
Kapila
Is the SQL Server running?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:61B0D79D-A657-4D25-AC9C-69349C3286B3@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
> solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila
|||Yes, it does. It is shown on the status bar and also in Services. However, it
is not appearing in the computer management console of MS Server 2003.
Best wishes.
Kapila
"Kalen Delaney" wrote:

> Is the SQL Server running?
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:61B0D79D-A657-4D25-AC9C-69349C3286B3@.microsoft.com...
>
>
|||It is possible for the SQL Enterprise or iSQL applications to see and work
with SQL server instances while other non-SQL tools such as VS.Net may not
see your SQL servers at all. (based on your problem description)
1. Check to see how the SQL Security is configured on the server. The best
practice is to configure it with Windows Integrated.
2. I always configure SQL Server with Mixed modes (W and Sql). Reason: My
developer PC may not always log on to the Windows Server/Domain where my SQL
Instance is hosted. If such condition exists, then SQL Authentication mode
kicks in to allow me to log on to it.
3. Another suggestion is that if your server is not in the DNS system, then
it is safe to put it in your Windows/HOSTS file. This way everybody
(applications) on your PC can see it.
John Webb

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
KapilaIs the SQL Server running?
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:61B0D79D-A657-4D25-AC9C-69349C3286B3@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
> solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila|||Yes, it does. It is shown on the status bar and also in Services. However, i
t
is not appearing in the computer management console of MS Server 2003.
Best wishes.
Kapila
"Kalen Delaney" wrote:

> Is the SQL Server running?
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:61B0D79D-A657-4D25-AC9C-69349C3286B3@.microsoft.com...
>
>|||It is possible for the SQL Enterprise or iSQL applications to see and work
with SQL server instances while other non-SQL tools such as VS.Net may not
see your SQL servers at all. (based on your problem description)
1. Check to see how the SQL Security is configured on the server. The best
practice is to configure it with Windows Integrated.
2. I always configure SQL Server with Mixed modes (W and Sql). Reason: My
developer PC may not always log on to the Windows Server/Domain where my SQL
Instance is hosted. If such condition exists, then SQL Authentication mode
kicks in to allow me to log on to it.
3. Another suggestion is that if your server is not in the DNS system, then
it is safe to put it in your Windows/HOSTS file. This way everybody
(applications) on your PC can see it.
John Webb

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
KapilaWhere is the Server Explorer installed? Is it on a different machine or
different network? Based on the error message, it looks like the Server
Explorer is unable to find your SQL Server on the network. A network issue
is more likey to be the case. Can you ping the SQL Server computer from the
Server Explorer box?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila|||The server explorer is installed on the same system. I am not on a network.
The services are running.
Thanks
Kapila
"Narayana Vyas Kondreddi" wrote:

> Where is the Server Explorer installed? Is it on a different machine or
> different network? Based on the error message, it looks like the Server
> Explorer is unable to find your SQL Server on the network. A network issue
> is more likey to be the case. Can you ping the SQL Server computer from th
e
> Server Explorer box?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> solve
>
>

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
KapilaWhere is the Server Explorer installed? Is it on a different machine or
different network? Based on the error message, it looks like the Server
Explorer is unable to find your SQL Server on the network. A network issue
is more likey to be the case. Can you ping the SQL Server computer from the
Server Explorer box?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila|||The server explorer is installed on the same system. I am not on a network.
The services are running.
Thanks
Kapila
"Narayana Vyas Kondreddi" wrote:
> Where is the Server Explorer installed? Is it on a different machine or
> different network? Based on the error message, it looks like the Server
> Explorer is unable to find your SQL Server on the network. A network issue
> is more likey to be the case. Can you ping the SQL Server computer from the
> Server Explorer box?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> > Hi,
> >
> > I am trying to connect a web service to an SQL Server 2000 database. SQL
> > Server is installed and started and the database appears on the Enterprise
> > MAnager window but it does not appear in the Server Explorer in VS2003.NET
> > IDE window.It gives the error "Server does not exist or access is denied".
> >
> > I have re-installed both SQL server and VS but have not being able to
> solve
> > this problem.
> >
> > Can someone help me out ? A prompt reply will be highly appreciated.
> >
> > Regards
> >
> > Kapila
>
>

"Report Manager Virtual Directory" link greyed out in config. tool

I've just installed SQL Server 2005 Reporting Services on our development
servers and the "Report Manager Virtual Directory" link is disabled in the
configuration tool. Does anyone know why it is disabled, and how do I enable
it?
Also, the Web Service Identity link displays the following error message
when I click on it:
"There was an error while switching panels. The most likely cause is an
error retrieving WMI properties. The exception details are:
Object reference not set to an instance of an object."
I've verified that the "Windows Management Instrumentation" service is
running.
Background/current configuration:
- OS: Windows Server 2003 (Enterprise) SP1
- Web server separate from database server
- Reporting Svcs 2000 installed and working correctly
- Side-by-side installation of Reporting Svcs 2005 with 2000.
Any help would be greatly appreciated!
Thank you,
SanjayI am having the same issues on Server 2003 with SQL 2005.

"Overflow!" error when Upsizing from Access

Hi
I've just installed MSDE 2000 Release A on WinXP Pro. All seems okay, but when I try to upsize an Access Database, I get a message box saying "Overflow!".
Any ideas on what I'm doing wrong? I'm new to SQL Server
Cheers
Dan
It depends on which version of Access you are using -- see
http://support.microsoft.com/default...;en-us;q294407 for
the Access 2002 upsizing whitepaper -- there's a link to the A2000 one
if you're using that.
--Mary
On Sun, 1 Aug 2004 08:37:02 -0700, "Dan Nash" <dan@.musoswire.co.uk>
wrote:

>Hi
>I've just installed MSDE 2000 Release A on WinXP Pro. All seems okay, but when I try to upsize an Access Database, I get a message box saying "Overflow!".
>Any ideas on what I'm doing wrong? I'm new to SQL Server
>Cheers
>
>Dan
|||Mary,
Thanks, am downloading that now. Forgot to mention I'm using Access 2000.
One question though.. when you install, what's the default login you would use? I used the SAPWD switch to create my password, but what's the Login ID for a default instance? May seem like a silly question, but it might be what's causing my problems!
Cheers
Dan
"Mary Chipman" wrote:

> It depends on which version of Access you are using -- see
> http://support.microsoft.com/default...;en-us;q294407 for
> the Access 2002 upsizing whitepaper -- there's a link to the A2000 one
> if you're using that.
> --Mary
> On Sun, 1 Aug 2004 08:37:02 -0700, "Dan Nash" <dan@.musoswire.co.uk>
> wrote:
>
>
|||I'm a little rusty on A2k, but as I recall you have to use a SQL login
and password with the upwiz, not integrated security (the whitepaper
should discuss this). It's a valid login that you create. FWIW,
upgrading to Access 2003 is highly recommended if you're going to keep
an Access FE to a SQLS BE. A2k was released *before* SQLS 2k, and
there have been many improvements and bug fixes since then.
--Mary
On Sun, 1 Aug 2004 13:49:03 -0700, "Dan Nash" <dan@.musoswire.co.uk>
wrote:
[vbcol=seagreen]
>Mary,
>Thanks, am downloading that now. Forgot to mention I'm using Access 2000.
>One question though.. when you install, what's the default login you would use? I used the SAPWD switch to create my password, but what's the Login ID for a default instance? May seem like a silly question, but it might be what's causing my problems!
>Cheers
>
>Dan
>"Mary Chipman" wrote:

"Open Table Window" is read-only under SQL Query Analyzer

I have installed SQL Server 2000 with option "Client Tools Only"
I try to edit data using SQL Query Analyzer with Trusted Connection. I click on 'Open' of right-click on table objects. A "Open Table Window" is opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit data.
I am trying to edit data using Server Explorer under Microsoft .NET with Trusted Connection. It works!!!
Help, Help!
Maybe the table does not have a Primary Key, check this first.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Happy Programmer" <anonymous@.discussions.microsoft.com> wrote in message
news:9D59D138-BFAE-4CAB-A2C1-FF535B42F2C7@.microsoft.com...
> I have installed SQL Server 2000 with option "Client Tools Only"
> I try to edit data using SQL Query Analyzer with Trusted Connection. I
click on 'Open' of right-click on table objects. A "Open Table Window" is
opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit
data.
> I am trying to edit data using Server Explorer under Microsoft .NET with
Trusted Connection. It works!!!
> Help, Help!
|||I believe that you will only be able to modify data from the Open Table
function in Query Analyzer if the table has a primary key or unique
constraint or a unique index.
Steve Kass
Drew University
Happy Programmer wrote:

>I have installed SQL Server 2000 with option "Client Tools Only"
>I try to edit data using SQL Query Analyzer with Trusted Connection. I click on 'Open' of right-click on table objects. A "Open Table Window" is opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit data.
>I am trying to edit data using Server Explorer under Microsoft .NET with Trusted Connection. It works!!!
>Help, Help!
>
|||I've tried it. It is able to modify if the table has primary key or unique index.
But is able to edit data using Server Explorer under Microsoft .NET with Trusted Connection even it has not any key or index.
Anyway, thanks a lot~!

"NT Authority/NetworkService" not available as a login

Just installed Server 2003 and then SQL server 2000 followed by sp3a and I'm trying to use an ASP.NET program called DNN which wants "NT Authority / NetworkService" user for access to the database. However, "NT Authority / NetworkService" is not showing
up in the database after installation.
Why is this?
How can I fix it?
Thanks
OK...finally, out of frustration, I just pasted in the name 'NT Authority/NetWorkService'
Start at:
SQL Server Enterprise Manager,
Security node,
Logins node (right click and select New Login),
SQL Server Login properties - New Login,
Paste 'NT Authority/NetWorkService' into the 'name field'
The 'NT Authority/NetWorkService' user was created and it also appears to work properly.
|||You did the correct thing, and Dot Net Nuke should now be happy.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oloooooo" <anonymous@.discussions.microsoft.com> wrote in message
news:531707DF-C146-4ED0-A845-978CECF9845C@.microsoft.com...
> Just installed Server 2003 and then SQL server 2000 followed by sp3a and
I'm trying to use an ASP.NET program called DNN which wants "NT Authority /
NetworkService" user for access to the database. However, "NT Authority /
NetworkService" is not showing up in the database after installation.
> Why is this?
> How can I fix it?
> Thanks
>

"NT Authority/NetworkService" not available as a login

Just installed Server 2003 and then SQL server 2000 followed by sp3a and I'm
trying to use an ASP.NET program called DNN which wants "NT Authority / Net
workService" user for access to the database. However, "NT Authority / Netw
orkService" is not showing
up in the database after installation.
Why is this?
How can I fix it?
ThanksOK...finally, out of frustration, I just pasted in the name 'NT Authority/Ne
tWorkService'
Start at:
SQL Server Enterprise Manager,
Security node,
Logins node (right click and select New Login),
SQL Server Login properties - New Login,
Paste 'NT Authority/NetWorkService' into the 'name field'
The 'NT Authority/NetWorkService' user was created and it also appears to wo
rk properly.|||You did the correct thing, and Dot Net Nuke should now be happy.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oloooooo" <anonymous@.discussions.microsoft.com> wrote in message
news:531707DF-C146-4ED0-A845-978CECF9845C@.microsoft.com...
> Just installed Server 2003 and then SQL server 2000 followed by sp3a and
I'm trying to use an ASP.NET program called DNN which wants "NT Authority /
NetworkService" user for access to the database. However, "NT Authority /
NetworkService" is not showing up in the database after installation.
> Why is this?
> How can I fix it?
> Thanks
>

"NT Authority/NetworkService" not available as a login

Just installed Server 2003 and then SQL server 2000 followed by sp3a and I'm trying to use an ASP.NET program called DNN which wants "NT Authority / NetworkService" user for access to the database. However, "NT Authority / NetworkService" is not showing up in the database after installation
Why is this
How can I fix it
ThankOK...finally, out of frustration, I just pasted in the name 'NT Authority/NetWorkService
Start at
SQL Server Enterprise Manager
Security node
Logins node (right click and select New Login)
SQL Server Login properties - New Login
Paste 'NT Authority/NetWorkService' into the 'name field
The 'NT Authority/NetWorkService' user was created and it also appears to work properly.|||You did the correct thing, and Dot Net Nuke should now be happy.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oloooooo" <anonymous@.discussions.microsoft.com> wrote in message
news:531707DF-C146-4ED0-A845-978CECF9845C@.microsoft.com...
> Just installed Server 2003 and then SQL server 2000 followed by sp3a and
I'm trying to use an ASP.NET program called DNN which wants "NT Authority /
NetworkService" user for access to the database. However, "NT Authority /
NetworkService" is not showing up in the database after installation.
> Why is this?
> How can I fix it?
> Thanks
>

"Login failed for user" error

Hi

I have installed sql server on my standalone PC.

I used "window and sql mix authentication" for the sql server in the enterprise manager set up.
when I try to use the sql server login name for the startup service account, I have this error. "No Mapping between names and security IDs ".
So Even though I use mix authentication, I am still using window login name.

Then I create the DSN file.

But when I run the ASP program, I have this error "login fail for user-("user name that I used for dsn file configuration").

I try to configure the dsn file set up with both authentications, windows and sql login names.

But I got the error again.

I am really lost here.
Please help me. thanks...What's your connection string?|||when I try to use the sql server login name for the startup service account, I have this error. "No Mapping between names and security IDs ".

You cannot use a sql server login for the service accounts, these need to be windows accounts (domain or local user, or system account). The mixed authentication only applies to logins to the server.

"Full-Text Index Table" is disabled?

I'm trying to do some local development so I installed Full-Text Indexing as
part of the SQL 2000 Developer Edition on my Windows XP machine.
The MS Search Service is running but the option is still disabled in EM when
I right-click on a table.
Thanks, Dave.
http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BE6EABAB-0F45-40B2-9C9C-1A29A1A8746B@.microsoft.com...
> I'm trying to do some local development so I installed Full-Text Indexing
> as
> part of the SQL 2000 Developer Edition on my Windows XP machine.
> The MS Search Service is running but the option is still disabled in EM
> when
> I right-click on a table.
> Thanks, Dave.

"Full Text Catalogs" Option

Hello, I have SQL Server 2K Developer Edition installed on Win2K Pro. I am trying to prep a DB for Full text Search and, I can't find the option for "Full Text Catalogs" for that or any Database.
Is this option only available for SQL Server 2K Enterprise Edition which - BTW - cannot be installed on Win2K Pro - only Server?
Can some help and Advice as to how can I do this. TIA.
Hi,
Full text search (MS Serach service) is avilable for SQL2000 developer
edition.Usually, in SQL2000, it gets installed by default for even a minimum
installation.Iam not sure why it is missing in your case.Check the
sqlstp.log file. To install FT you can pop in the SQL2000 setup CD and check
the relevant option.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"JSN" <anonymous@.discussions.microsoft.com> wrote in message
news:DFDAF597-EAF9-47CC-99A2-03A579E2E156@.microsoft.com...
> Hello, I have SQL Server 2K Developer Edition installed on Win2K Pro. I
am trying to prep a DB for Full text Search and, I can't find the option for
"Full Text Catalogs" for that or any Database.
> Is this option only available for SQL Server 2K Enterprise Edition which -
BTW - cannot be installed on Win2K Pro - only Server?
> Can some help and Advice as to how can I do this. TIA.
|||Oops..didnt notice the OS. MS Search service will not run on Win2K Pro.
Dinesh
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:#JUo6rgSEHA.808@.tk2msftngp13.phx.gbl...
> Hi,
> Full text search (MS Serach service) is avilable for SQL2000 developer
> edition.Usually, in SQL2000, it gets installed by default for even a
minimum
> installation.Iam not sure why it is missing in your case.Check the
> sqlstp.log file. To install FT you can pop in the SQL2000 setup CD and
check
> the relevant option.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "JSN" <anonymous@.discussions.microsoft.com> wrote in message
> news:DFDAF597-EAF9-47CC-99A2-03A579E2E156@.microsoft.com...
> am trying to prep a DB for Full text Search and, I can't find the option
for[vbcol=seagreen]
> "Full Text Catalogs" for that or any Database.
which -
> BTW - cannot be installed on Win2K Pro - only Server?
>

"Full Text Catalogs" Option

Hello, I have SQL Server 2K Developer Edition installed on Win2K Pro. I am
trying to prep a DB for Full text Search and, I can't find the option for "F
ull Text Catalogs" for that or any Database.
Is this option only available for SQL Server 2K Enterprise Edition which - B
TW - cannot be installed on Win2K Pro - only Server?
Can some help and Advice as to how can I do this. TIA.Hi,
Full text search (MS Serach service) is avilable for SQL2000 developer
edition.Usually, in SQL2000, it gets installed by default for even a minimum
installation.Iam not sure why it is missing in your case.Check the
sqlstp.log file. To install FT you can pop in the SQL2000 setup CD and check
the relevant option.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"JSN" <anonymous@.discussions.microsoft.com> wrote in message
news:DFDAF597-EAF9-47CC-99A2-03A579E2E156@.microsoft.com...
> Hello, I have SQL Server 2K Developer Edition installed on Win2K Pro. I
am trying to prep a DB for Full text Search and, I can't find the option for
"Full Text Catalogs" for that or any Database.
> Is this option only available for SQL Server 2K Enterprise Edition which -
BTW - cannot be installed on Win2K Pro - only Server?
> Can some help and Advice as to how can I do this. TIA.|||Oops..didnt notice the OS. MS Search service will not run on Win2K Pro.
Dinesh
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:#JUo6rgSEHA.808@.tk2msftngp13.phx.gbl...
> Hi,
> Full text search (MS Serach service) is avilable for SQL2000 developer
> edition.Usually, in SQL2000, it gets installed by default for even a
minimum
> installation.Iam not sure why it is missing in your case.Check the
> sqlstp.log file. To install FT you can pop in the SQL2000 setup CD and
check
> the relevant option.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "JSN" <anonymous@.discussions.microsoft.com> wrote in message
> news:DFDAF597-EAF9-47CC-99A2-03A579E2E156@.microsoft.com...
> am trying to prep a DB for Full text Search and, I can't find the option
for
> "Full Text Catalogs" for that or any Database.
which -[vbcol=seagreen]
> BTW - cannot be installed on Win2K Pro - only Server?
>

"Full Text Catalogs" Option

Hello, I have SQL Server 2K Developer Edition installed on Win2K Pro. I am trying to prep a DB for Full text Search and, I can't find the option for "Full Text Catalogs" for that or any Database
Is this option only available for SQL Server 2K Enterprise Edition which - BTW - cannot be installed on Win2K Pro - only Server
Can some help and Advice as to how can I do this. TIA.Hi,
Full text search (MS Serach service) is avilable for SQL2000 developer
edition.Usually, in SQL2000, it gets installed by default for even a minimum
installation.Iam not sure why it is missing in your case.Check the
sqlstp.log file. To install FT you can pop in the SQL2000 setup CD and check
the relevant option.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"JSN" <anonymous@.discussions.microsoft.com> wrote in message
news:DFDAF597-EAF9-47CC-99A2-03A579E2E156@.microsoft.com...
> Hello, I have SQL Server 2K Developer Edition installed on Win2K Pro. I
am trying to prep a DB for Full text Search and, I can't find the option for
"Full Text Catalogs" for that or any Database.
> Is this option only available for SQL Server 2K Enterprise Edition which -
BTW - cannot be installed on Win2K Pro - only Server?
> Can some help and Advice as to how can I do this. TIA.|||Oops..didnt notice the OS. MS Search service will not run on Win2K Pro.
--
Dinesh
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:#JUo6rgSEHA.808@.tk2msftngp13.phx.gbl...
> Hi,
> Full text search (MS Serach service) is avilable for SQL2000 developer
> edition.Usually, in SQL2000, it gets installed by default for even a
minimum
> installation.Iam not sure why it is missing in your case.Check the
> sqlstp.log file. To install FT you can pop in the SQL2000 setup CD and
check
> the relevant option.
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "JSN" <anonymous@.discussions.microsoft.com> wrote in message
> news:DFDAF597-EAF9-47CC-99A2-03A579E2E156@.microsoft.com...
> > Hello, I have SQL Server 2K Developer Edition installed on Win2K Pro. I
> am trying to prep a DB for Full text Search and, I can't find the option
for
> "Full Text Catalogs" for that or any Database.
> >
> > Is this option only available for SQL Server 2K Enterprise Edition
which -
> BTW - cannot be installed on Win2K Pro - only Server?
> >
> > Can some help and Advice as to how can I do this. TIA.
>

"Failed to generate a user instance of SQL Server" - Redux

I have SQL Server 2005 SP1 Dev Edition installed on my laptop along with Visual Web Developer 2005. I installed SQL Server Express 2005 SP1. I then created a new web site using the Club Web Site template.

I did the recommended initial build to get the Membership database installed and got an error page (http://localhost:1667/WebSitesVB2/):

SQLExpress database file auto-creation error:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

There were 4 recomme4ndations from the error page. I have met three of them: (1) the AppDaa folder that was created when I used the Club Web Site template; (2) my machine's ASPNET user set up with full control permissions on the APP Data Folder; (3) SQL Server Express successfully installed on my machine.

The 4th recommendation from the error page is "The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts. ". I have no idea of how to do this or how/where to find the elusive the "readme" file.

I am at a loss as to what to do next. I have spent the day going over forums on this error and none seem to provide consistent or relevant answers.

Try to remove User Instance=true from your connection string, if you don't need to generate a user instance at runtime. For more information about the user instance attribute, you can refer to:

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(VS.80).aspx|||

Changed userinstance = TRUE to userinstance=FALSE. Same result - failure to generate userinstance.

Is it possible that there is some setting in VWD that provides a connection string for the ASPNET db that is to be created? The only connection string in the WebConfig from the original template is the one for the ClubSite DB. There is none for the ASPNET db (because the template does not provide the ASPNET DB.

After 2 tries, I still get this error and when I look at the database explorer, there is only one DB file: Club.MDF.

Anyone else have any answers?

|||

I probably should have included this stack trace:

Stack Trace:

[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +115 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +56 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +1084 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +272 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +355 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +91 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +115 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +122 System.Data.SqlClient.SqlConnection.Open() +229 System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +110[HttpException (0x80004005): Unable to connect to SQL Server database.] System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +181 System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +167 System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +46 System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +681

---

|||Sorry I forgot to mention: there is a connection string named LocalSqlServer, which is used by .NET 2.0 built-in providers (Profile, Membership, RoleManager, etc.). You can override it and try again, for details you can refer to:
Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005