473,831 Members | 2,274 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Published Web Site Issue

On my machine I am developing a .NET site. When I execute it,
everything runs perfectly. When I publish it (to my machine in a
folder so IIS can access it), I get a SQL error:

"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"

I know what the error means, but I don't understand why I'm getting
this on the published site and not when I run/execute the site from
Visual Studio 2005.

Any ideas?

Thanks!
Jeremy
Dec 13 '07 #1
5 1409
The Windows user account used by IIS is not added to the SQL Server. Perhaps,
if you do it, the error should disappear. If you are using IIS 6, make sure
the IIS app pool account is added to the SQL Server.

HTH.

"jr****@cre8ive web.com" wrote:
On my machine I am developing a .NET site. When I execute it,
everything runs perfectly. When I publish it (to my machine in a
folder so IIS can access it), I get a SQL error:

"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"

I know what the error means, but I don't understand why I'm getting
this on the published site and not when I run/execute the site from
Visual Studio 2005.

Any ideas?

Thanks!
Jeremy
Dec 14 '07 #2
I will give that a try. Though, I don't understand why it matters
because I'm using a specific username/password in my connection string
in the code.

On Dec 13, 11:33 pm, Siva M <shiva...@onlin e.excite.comwro te:
The Windows user account used by IIS is not added to the SQL Server. Perhaps,
if you do it, the error should disappear. If you are using IIS 6, make sure
the IIS app pool account is added to the SQL Server.

HTH.

"jrc...@cre8ive web.com" wrote:
On my machine I am developing a .NET site. When I execute it,
everything runs perfectly. When I publish it (to my machine in a
folder so IIS can access it), I get a SQL error:
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I know what the error means, but I don't understand why I'm getting
this on the published site and not when I run/execute the site from
Visual Studio 2005.
Any ideas?
Thanks!
Jeremy- Hide quoted text -

- Show quoted text -
Dec 14 '07 #3
Oh, I forgot to mention that the SQL database is on a separate
development machine. I don't know if that would matter or not.

On Dec 13, 11:33 pm, Siva M <shiva...@onlin e.excite.comwro te:
The Windows user account used by IIS is not added to the SQL Server. Perhaps,
if you do it, the error should disappear. If you are using IIS 6, make sure
the IIS app pool account is added to the SQL Server.

HTH.

"jrc...@cre8ive web.com" wrote:
On my machine I am developing a .NET site. When I execute it,
everything runs perfectly. When I publish it (to my machine in a
folder so IIS can access it), I get a SQL error:
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I know what the error means, but I don't understand why I'm getting
this on the published site and not when I run/execute the site from
Visual Studio 2005.
Any ideas?
Thanks!
Jeremy- Hide quoted text -

- Show quoted text -
Dec 14 '07 #4
Ok, i ended up changing "Integrated Security=True" to "Integrated
Security="False " and it worked. But now I'm having issues where the
Web site appears, but the AJAX controls aren't showing up on the site.
I do have the AJAX Extensions installed on the server.

On Dec 13, 11:33 pm, Siva M <shiva...@onlin e.excite.comwro te:
The Windows user account used by IIS is not added to the SQL Server. Perhaps,
if you do it, the error should disappear. If you are using IIS 6, make sure
the IIS app pool account is added to the SQL Server.

HTH.

"jrc...@cre8ive web.com" wrote:
On my machine I am developing a .NET site. When I execute it,
everything runs perfectly. When I publish it (to my machine in a
folder so IIS can access it), I get a SQL error:
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I know what the error means, but I don't understand why I'm getting
this on the published site and not when I run/execute the site from
Visual Studio 2005.
Any ideas?
Thanks!
Jeremy- Hide quoted text -

- Show quoted text -
Dec 14 '07 #5
Integrated security change has nothing to do with AJAX. I guess the problem
could be with data access/permissioning.

"jr****@cre8ive web.com" wrote:
Ok, i ended up changing "Integrated Security=True" to "Integrated
Security="False " and it worked. But now I'm having issues where the
Web site appears, but the AJAX controls aren't showing up on the site.
I do have the AJAX Extensions installed on the server.

On Dec 13, 11:33 pm, Siva M <shiva...@onlin e.excite.comwro te:
The Windows user account used by IIS is not added to the SQL Server. Perhaps,
if you do it, the error should disappear. If you are using IIS 6, make sure
the IIS app pool account is added to the SQL Server.

HTH.

"jrc...@cre8ive web.com" wrote:
On my machine I am developing a .NET site. When I execute it,
everything runs perfectly. When I publish it (to my machine in a
folder so IIS can access it), I get a SQL error:
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"
I know what the error means, but I don't understand why I'm getting
this on the published site and not when I run/execute the site from
Visual Studio 2005.
Any ideas?
Thanks!
Jeremy- Hide quoted text -
- Show quoted text -

Dec 14 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1163
by: Bennett Haselton | last post by:
When you create a C# Web Application project, you have to specify at project creation time the URL you want to publish the project to. Is there any way in the IDE to change the server that the project is published to at build time? You can go into Project properties -> Common Properties -> Web Settings and under "Web Server Information" it shows the name of the Web server -- but it's greyed out so that you can't edit it. Is that...
5
1700
by: Bendik Engebretsen | last post by:
Developed this personal WEB site with the new ASP.NET 2.0 Beta: http://www.techsoft.no/bendik/ It has got this problem: After a while browsing through pictures on the site, an error occurs: 'Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.'
8
2268
by: VB Programmer | last post by:
I would appreciate your assistance on this ASP.NET 2.0 site.... This is the wierd problem: While accessing the built in .NET functions for 'profiling' or 'membership' an error is generated (see following 2 examples): ---- EXAMPLE 1 -------- OK --> Dim p As New ProfileCommon OK --> p = Profile.GetProfile(Me.ddlRacer.SelectedItem.Text) FAILS --> Me.lblDebug.Text = p.FirstName.ToString
0
1118
by: clickon | last post by:
I am working on a portal web application that is largely modular. I have been working on it on a "development" website. Some sections have been tested and are complete. I decided to set up a Live website on the same server so i could work on the development web site without affecting people using the completed sections. I set up the website and then used VS 2005 to "publish" the site. This seemed to work OK, it precompiled the whole...
3
1771
by: Rahul | last post by:
Hi, Is there a way to get the line numbers to display in the exception when you have published your web site? Thanks Rahul
5
1767
by: John | last post by:
Hi When I try to install a published app using a url like http://www.mydomain.com/publish.htm, it starts the download but then comes up with the eror given at the end below. I am installing the app on an sbs 2003 (windows 2003 + ISA 2000) server. I suspect ISA 2000 is the problem but don't know where and how to give proxy credentials in the whole publishing and installing process. Any help to fix this will be appreciated. Thanks
2
1822
by: =?Utf-8?B?SmF5IE1pbGxlcg==?= | last post by:
I'm having problems with the login control when I publish my site. Everything works fine when I run the application from Visual Studio and when I browse directly to the site where it is being developed. The problem comes when I publish the site to another location on the same computer. The login always fails. The site always works from the development location but not from the published location. I've compared everything I can think of...
2
2064
by: JB | last post by:
I've a site which i have copied over from an old server to a new server and now it doesnt seem to work. I've been looking through the source code and i know *where* the problem is, but i dont know *what* the problem is. Its throwing an exception for some reason, but with debug mode being turned off i dont know why. Is there anyway to view more details on the site running on IIS? I can't rebuild the site unfortunately. I'm sure its a...
4
10328
by: Joe | last post by:
Hello all! I added a Global.asax to my application. I'm using the Application_BeginRequest event. Everything works fine in my development enviorment but when I publish the web site the Global.asax file doesn't get published. If I manually copy it the event doesn't seem to get called. Any idea what's going on here? Thanks,
0
9794
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9642
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10538
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10210
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7750
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5622
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4419
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3967
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3077
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.